Which of the following functions is used in MS Excel to count the number of cells in a range that are non-empty

 

functions is used in MS Excel to count the number of cells in a range

Which of the following functions is used in MS Excel to count the number of cells in a range that are non-empty?

A) COUNTIF
B) COUNTA
C) COUNTIFS
D) COUNTBLANK

✅ Answer: B) COUNTA

Explanation: COUNTA counts all non-empty cells in a range, including cells containing text, numbers, errors, etc.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)