If you wanted to determine how many cells in a range are not empty,you would use the ________ function.
A)COUNT
B)COUNTA
C)NOTEMPTY
D)HASVALUE

Question

Quizplus · Accepted Answer

The COUNTA function is used to count the number of cells in a range that are not empty. It counts cells that contain text, numbers, errors, logical values, and empty text (""). The COUNT function, on the other hand, only counts cells that contain numbers. The NOTEMPTY and HASVALUE functions do not exist in Excel.

If You Wanted to Determine How Many Cells in a Range