Bird
0
0

Which MS Excel function is used to find the mean of values stored in cells E1 to E5?

easy Q2 of 15
Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function is used to find the mean of values stored in cells E1 to E5?
ASUM(E1:E5)
BAVERAGE(E1:E5)
CMAX(E1:E5)
DCOUNT(E1:E5)
Step-by-Step Solution

  1. Step 1: Understand the term mean

    Mean refers to average value.

  2. Step 2: Recall Excel function

    AVERAGE() calculates the mean.

  3. Final Answer:

    AVERAGE(E1:E5) → Option B.

  4. Quick Check:

    AVERAGE adds values and divides by count automatically ✅
Quick Trick: Mean = AVERAGE().
Common Mistakes:
  • Choosing SUM instead of mean calculation.
Master "Microsoft Office (Basics + Functions)" in Computer Aptitude

Start learning the concept with an interactive lesson.

Learn

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Computer Aptitude Quizzes
Microsoft Office (Basics + Functions) - MS Word — Basic Formatting & Editing Tools - Quiz 7medium Microsoft Office (Basics + Functions) - Purpose & Application Identification (Word / Excel / PowerPoint) - Quiz 14medium Microsoft Office (Basics + Functions) - MS PowerPoint — Design & View Options - Quiz 11easy Microsoft Office (Basics + Functions) - MS PowerPoint — Slides & Presentation Tools - Quiz 4medium Microsoft Office (Basics + Functions) - Purpose & Application Identification (Word / Excel / PowerPoint) - Quiz 9hard Microsoft Office (Basics + Functions) - Purpose & Application Identification (Word / Excel / PowerPoint) - Quiz 5medium Microsoft Office (Basics + Functions) - Common Office File Extensions & Compatibility - Quiz 13easy Microsoft Office (Basics + Functions) - MS PowerPoint — Slides & Presentation Tools - Quiz 3easy Microsoft Office (Basics + Functions) - Common Office File Extensions & Compatibility - Quiz 2easy Microsoft Office (Basics + Functions) - MS PowerPoint — Slides & Presentation Tools - Quiz 6medium