An example of the function that returns the number of cells in a range of cells that contain data is ____.
A) =NUMBER(B4)
B) =COUNT(B4)
C) =NUMBER(B4:B15)
D) =COUNT(B4:B15)

Question

Quizplus · Accepted Answer

The function that returns the number of cells in a range of cells that contain data is =COUNT(B4:B15). Option A and C are not valid Excel functions, and Option B returns the number of cells in a range of cells that contain numbers only, not all types of data.

An Example of the Function That Returns the Number of Cells