DocMCQs Educational Banner

What does COUNTA() function do in Excel?

A. Counts cells having alphabets
B. Counts empty cells
C. Counts cells having numbers
D. Counts non-empty cells
Correct Answer: D. Counts non-empty cells
Explanation: Why? The COUNTA() function counts all non-empty cells, including those with numbers, text, logical values, or formulas. It does not count only numeric cells (that is COUNT()).

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top