DocMCQs Educational Banner

What does COUNTA() function do in Excel?

Question: 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()).

Related Posts

Leave a Comment

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

Join Our WhatsApp Channel ×
Scroll to Top