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

If you think there is any confusion in the given MCQs, you can comment below.

Follow us on WhatsApp

docmcqs.com is Pakistan's No.1 online platform for preparing for all types of exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, and for one-paper MCQs. This includes Pedagogy MCQs, general knowledge MCQs, current affairs MCQs, and much more.

Leave a Comment

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

Join Our WhatsApp Channel! ×
Scroll to Top