Easy-Learn Framework

Mastering Day 9: What, Why & How

Memory Rule Included

Day 9: SUM and AVERAGE Functions Visual Diagram

? WHAT Is It?

Excel's two most essential built-in mathematical functions: =SUM(range) adds all numbers in a group, and =AVERAGE(range) calculates the statistical mean (Total Sum ÷ Count).

! WHY Does It Matter?

Writing =A1+A2+A3...+A100 takes minutes, is exhausting, and breaks if you insert a row. =SUM(A1:A100) takes 2 seconds and automatically expands if you insert rows inside the range.

⚙ HOW Does It Work?

Step 1 Press Alt + = (AutoSum shortcut) directly below or to the right of any numbers for instant summation.

Step 2 Use a colon (:) for continuous ranges (e.g., =SUM(B2:B10) means from cell B2 all the way through B10).

Step 3 Use a comma (,) for non-adjacent cells (e.g., =SUM(B2, D2, F2)).

Memory Hook & Golden Rule (Remember This Forever):

"Alt + = is your magic AutoSum wand! Remember: a colon (:) means 'THROUGH', while a comma (,) means 'AND'."

Learning Objectives

What You Will Master Today

Function anatomy: Function Name + Open Parenthesis + Arguments + Close Parenthesis
=SUM(A1:A10) to aggregate thousands of numbers in a single millisecond
=AVERAGE(A1:A10) to compute arithmetic mean while ignoring blank cells
AutoSum ribbon button and keyboard shortcut Alt + =

Important Keyboard Shortcuts:

Alt + = (AutoSum Shortcut)Ctrl + Shift + Enter (Legacy Array)Shift + Arrow (Expand Range)

Guided Tutorial

Step-by-Step Practical Walkthrough

Step 1

Select the empty cell directly beneath a column of numeric values.

Step 2

Press Alt + = on your keyboard; Excel will automatically insert '=SUM(...)' with the guessed range.

Step 3

Press Enter to confirm.

Step 4

To calculate average, type '=AVERAGE(' and drag your mouse across the data range.

Solved Classroom Example

Digital Skills Academy Haldwani - Monthly Center Utility Expenses

Pre-filled Data & Answers

Study the completed reference worksheet below. Every column illustrates the standard formatting, formula structure, and alignment applied by professional office operators.

Expense Month	Electricity Bill (₹)	High-Speed Internet (₹)	Office Housekeeping (₹)	Total Utilities (₹)
April 2026	4850	1999	3500	10349
May 2026	6200	1999	3500	11699
June 2026	7400	1999	3500	12899
July 2026	6900	1999	3500	12399
August 2026	5800	1999	3500	11299
September 2026	5100	1999	3500	10599

Download Solved Sample Sheet Includes complete working formula cells, proper currency symbols, and clean borders.

Download Solved Sheet (.xlsx)

Student Assignment

Student Academic Term Exam Scorecard

Your Turn to Practice

Exercise Tasks Checklist:

Task 1: In Column G (Total Marks), use '=SUM(C5:F5)' to calculate the aggregate marks for each student.
Task 2: In Column H (Average %), use '=AVERAGE(C5:F5)' to compute the percentage score.
Task 3: At the bottom in row 10, calculate the Class Average for each subject using AutoSum.
Task 4: Format the Average column to show 1 decimal place.

Exercise Data Template Preview: Download the .xlsx file below and execute each task independently.

Roll No	Student Name	Mathematics	Science	English	Computer Apps
101	Aditya Sharma	88	92	79	95
102	Bhavna Joshi	94	89	85	98
103	Chetan Negi	72	68	74	80
104	Deepak Rawat	65	70	68	75
105	Ekta Bisht	91	95	88	96

Download Practice Exercise Sheet Pre-structured practice workbook with raw datasets ready for hands-on classroom lab solving.

Download Practice Sheet (.xlsx)

Mentor Pro Tip from Haldwani Classroom Lab:

=AVERAGE ignores completely empty cells, but it DOES count cells containing zero (0). Ensure unattempted exams are blank or zero according to your policy!

Day 8: Basic Excel Formulas... All 30 Topics Day 10: MIN, MAX, COUNT and CO...

Need 1-on-1 Guidance on Day 9?

Join our hands-on classroom lab sessions at Digital Skills Academy in Haldwani. Every student receives a dedicated PC workstation, live instructor reviews, and interview prep.

Book Free Demo Session Call Instructor

Day 9: SUM and AVERAGE Functions