Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function is used to count all non-empty cells (text or numbers) in a range?
Which MS Excel function is used to count all non-empty cells (text or numbers) in a range?
medium Q6 of 15
Step-by-Step Solution
Step 1: Understand what needs to be counted
The question includes both text and numbers.Step 2: Match with Excel function
COUNTA() counts all non-empty cells.Final Answer:
COUNTA() → Option B.Quick Check:
Blank cells are ignored by COUNTA() ✅
Quick Trick: Non-empty cells = COUNTA().
Common Mistakes:
MISTAKES- Using COUNT which ignores text.
Master "Microsoft Office (Basics + Functions)" in Computer Aptitude
Start learning the concept with an interactive lesson.
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Computer Aptitude Quizzes