Bird
0
0

Which MS Excel function is used to calculate the total of values present in cells D1 to D6?

easy Q1 of 15
Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function is used to calculate the total of values present in cells D1 to D6?
ASUM(D1:D6)
BAVERAGE(D1:D6)
CCOUNT(D1:D6)
DMAX(D1:D6)
Step-by-Step Solution

  1. Step 1: Identify the requirement

    The question asks for the total of values.

  2. Step 2: Match with Excel function

    SUM() adds all numeric values in a range.

  3. Final Answer:

    SUM(D1:D6) → Option A.

  4. Quick Check:

    SUM always returns the total of selected cells ✅
Quick Trick: Total of values = SUM().
Common Mistakes:
MISTAKES
  • Using AVERAGE instead of SUM.
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) - Cross-Application Integration (Office Suite Awareness) - Quiz 7medium Microsoft Office (Basics + Functions) - MS PowerPoint — Design & View Options - Quiz 1easy Microsoft Office (Basics + Functions) - Purpose & Application Identification (Word / Excel / PowerPoint) - Quiz 14medium Microsoft Office (Basics + Functions) - MS Excel — Logical & Conditional Functions - Quiz 11easy Microsoft Office (Basics + Functions) - MS Word — Advanced Features - Quiz 7medium Microsoft Office (Basics + Functions) - MS Excel — Logical & Conditional Functions - Quiz 1easy Microsoft Office (Basics + Functions) - Common Office File Extensions & Compatibility - Quiz 7medium Microsoft Office (Basics + Functions) - MS Word — Advanced Features - Quiz 5medium Microsoft Office (Basics + Functions) - MS Word — Basic Formatting & Editing Tools - Quiz 2easy Microsoft Office (Basics + Functions) - Cross-Application Integration (Office Suite Awareness) - Quiz 9hard