Lesson 7 – Basic Formulas (SUM, AVERAGE, MAX, MIN)

MS Excel Course • Level 1 – Lesson 7

In this lesson, you will learn the four most important Excel formulas used in daily work: SUM, AVERAGE, MAX, and MIN. These functions help you quickly calculate totals, averages, and find highest/lowest values.

What you will learn

• How formulas work in Excel
• SUM, AVERAGE, MAX, MIN functions
• Cell referencing in formulas
• Using AutoSum

1. Formula Basics

All formulas in Excel start with an = sign.

Example:

=A1 + B1

2. SUM Function

Adds a group of numbers.

=SUM(A1:A5)

AutoSum Shortcut

Press Alt + = to insert SUM instantly.

3. AVERAGE Function

Finds average of values.

=AVERAGE(B1:B10)

4. MAX & MIN

Highest value:

=MAX(C1:C20)

Lowest value:

=MIN(C1:C20)

Formulas update automatically when you change data. This is the true power of Excel.

Practice Task

• Create marks of 10 students
• Use SUM to calculate total marks
• Use AVERAGE to find average marks
• Use MAX and MIN to find highest & lowest

Homework

• Make a small sales table and apply all 4 functions