_______________ is a function that counts blank cells within a range of cells.

_______________ is a function that counts blank cells within a range of cells.

• A. CountBlank
• B. CountEmpty
• C. BlankCount
• D. EmptyCells

Answer: (A)

COUNTBLANK is the function used to count how many cells in a range are empty. It examines the specified range and returns the number of cells that contain nothing at all. A nuance to keep in mind: a cell that contains a formula that returns an empty string "" isn’t considered blank by COUNTBLANK, so it won’t be counted. If you need to count cells that appear empty (including those with formulas resulting in ""), you’d use a different approach like COUNTIF(range,""). The other options listed aren’t actual Excel functions for counting blank cells.

COUNTBLANK is the function used to count how many cells in a range are empty. It examines the specified range and returns the number of cells that contain nothing at all. A nuance to keep in mind: a cell that contains a formula that returns an empty string "" isn’t considered blank by COUNTBLANK, so it won’t be counted. If you need to count cells that appear empty (including those with formulas resulting in ""), you’d use a different approach like COUNTIF(range,""). The other options listed aren’t actual Excel functions for counting blank cells.