A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20.Which of the following formulas should he use to do so?
A) =COUNT(B1:B20)
B) =COUNTIF(B1:B20)
C) =COUNTA(B1:B20)
D) =DCOUNTA(B1:B20)

Question

Quizplus · Accepted Answer

The formula =COUNTA(B1:B20) counts the number of nonblank cells in the range B1 to B20. Option A would also count the number of cells in the range, including the blank ones, which is not what the task requires. Option B requires a criteria range and criteria, which is not given in the question. Option D is used to count cells in a database that meet specific criteria, which is not required in this case.

A Student Is Given the Task of Counting the Number