Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits? MCQ with Answer and Explanation
Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits?
A. COUNT
B. COUNTIF
C. COUNTA
D. COUNTBLANK
Answer: Option C
Solution (By JKSSB Mock Tests)
The COUNTA function counts all non-empty cells within a range, regardless of whether they contain numbers, text, or errors. The COUNT function counts cells with numbers only.
No comments yet. Be the first to start the discussion!