Computer Science Medium fpsc nts

Which Excel function counts non-empty cells?

  • A COUNT()
  • B COUNTA()
  • C COUNTIF()
  • D SUM()
Correct Answer: Option B — COUNTA()
Explanation: COUNTA counts all non-empty cells including text, numbers, and logical values. It is useful when determining how many cells contain data regardless of data type.
Related MCQs