Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function is used to calculate the average but ignores empty cells automatically?
Which MS Excel function is used to calculate the average but ignores empty cells automatically?
hard Q10 of 15
Step-by-Step Solution
Step 1: Understand the condition
The average should ignore blank cells.Step 2: Identify Excel behaviour
AVERAGE() automatically ignores empty cells.Final Answer:
AVERAGE() → Option B.Quick Check:
Only numeric values are used in AVERAGE calculation ✅
Quick Trick: Average ignoring blanks = AVERAGE().
Common Mistakes:
- Assuming blanks are treated as zero.
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