In MS Excel 365, which function from the following list is used to tally the quantity of empty cells within a specified cell range?

Correct option is D

The COUNTBLANK() function in MS Excel 365 is used to count the number of empty cells within a specified range. It excludes non-empty cells, making it ideal for identifying blanks in a dataset.
For example: =COUNTBLANK(A1:A10) counts the number of blank cells in the range A1 to A10.
Important Key Points:
1. COUNTBLANK() is specifically designed to tally blank cells in a selected range.
2. It does not count cells with text, numbers, or formulas.
3. Useful in analyzing datasets with missing values.
Knowledge Booster:
· COUNTIF(): Counts cells based on a specified condition or criteria, not limited to blank cells.
· COUNTA(): Counts non-empty cells, including those with text, numbers, or formulas.
· COUNT(): Counts only numeric values in the specified range, ignoring blank cells.