The correct answer is: D. Counts non-empty cells
The COUNTA function counts the number of non-empty cells in a range. It counts all cells that contain text, numbers, dates, or formulas, including cells that contain errors.
The COUNT function counts the number of cells in a range that contain numbers. It does not count cells that contain text, dates, or formulas.
The COUNTBLANK function counts the number of empty cells in a range. It counts cells that do not contain any data, including cells that contain formulas that return a blank value.
The COUNTIF function counts the number of cells in a range that meet a certain criteria. For example, the following formula counts the number of cells in the range A1:A10 that contain the value “1”:
=COUNTIF(A1:A10, “1”)
I hope this helps!