What will be the output of =COUNT B1:B99 in an MS Excel 2010 document?
A
Count is an invalid function.
B
Count the number of cells B1 through B98 that contain numbers.
C
#NULL! appears in the respective cell.
D
Count the number of cells B1 through B99 that contain numbers.
Correct Option:
C
Explanation
The printed expression is =COUNT B1:B99, not the valid function form =COUNT(B1:B99). Under the intended interpretation of the paper, the malformed expression yields the #NULL! error.
