Excel SUM, AVERAGE, MIN and MAX Functions with Examples - Lesson 39

Social Media Point
FREE COMPUTER DIPLOMA
Module 7 – Lesson 39

SUM, AVERAGE, MIN and MAX Functions

Master Predefined Excel Functions, Range Calculations, Arithmetic Means, Minimums, Maximums, and Student Marksheet Summaries

1. What is an Excel Function?

A function is a predefined formula that performs a particular calculation. Excel provides many functions to save time and reduce manual work.

Most functions use a function name followed by parentheses. The values or cell references inside the parentheses are called arguments.

Example: =SUM(A1:A5) adds the numerical values in cells A1 through A5.

2. What is the SUM Function?

The SUM function adds numbers from individual cells or a range of cells.

Syntax: =SUM(number1, [number2], ...)

Example: If cells A1 to A5 contain 10, 20, 30, 40, and 50, enter:

=SUM(A1:A5)
Result: 150

You can also add separate cells, for example =SUM(A1,C1,E1).

3. What is the AVERAGE Function?

The AVERAGE function calculates the arithmetic mean of numerical values. It adds the numbers and divides their total by the count of numerical values.

Syntax: =AVERAGE(number1, [number2], ...)

Example: If A1:A4 contain 60, 70, 80, and 90:

=AVERAGE(A1:A4)
Result: 75

Blank cells and text in referenced cells are generally ignored by AVERAGE, while numeric zero is included.

4. What is the MIN Function?

The MIN function finds the smallest numerical value in a range.

Syntax: =MIN(number1, [number2], ...)

=MIN(A1:A5)
If the values are 10, 25, 5, 40, and 15, the result is 5.

5. What is the MAX Function?

The MAX function finds the largest numerical value in a range.

Syntax: =MAX(number1, [number2], ...)

=MAX(A1:A5)
If the values are 10, 25, 5, 40, and 15, the result is 40.

6. Comparison of the Four Functions

FunctionPurposeExample
SUMAdds values=SUM(B2:B10)
AVERAGECalculates the mean=AVERAGE(B2:B10)
MINFinds the smallest number=MIN(B2:B10)
MAXFinds the largest number=MAX(B2:B10)

7. Practical Student Marksheet

Enter the following information in Excel:

StudentEnglishMathScienceTotalAverage
Ali708075
Sara859088
Ahmed606570

Assuming the headings are in row 1 and Ali's marks are in B2:D2:

  • In E2, enter =SUM(B2:D2) to calculate the total.
  • In F2, enter =AVERAGE(B2:D2) to calculate the average.
  • Copy both formulas down for the other students.
  • Use =MIN(E2:E4) to find the lowest total.
  • Use =MAX(E2:E4) to find the highest total.

8. Common Mistakes

  • Forgetting the equal sign at the beginning of a formula.
  • Selecting the wrong cell range.
  • Using a text value instead of a number.
  • Including the heading row in a calculation range unnecessarily.
  • Confusing SUM with AVERAGE.

9. Practical Exercise

  1. Create a new workbook named Excel Functions Practice.xlsx.
  2. Enter five student names and their marks in three subjects.
  3. Use SUM to calculate each student's total.
  4. Use AVERAGE to calculate each student's average.
  5. Use MIN to find the lowest subject mark.
  6. Use MAX to find the highest subject mark.
  7. Format the table with headings, borders, and colours.

10. Lesson Summary

  • SUM adds numerical values.
  • AVERAGE calculates the arithmetic mean.
  • MIN finds the smallest numerical value.
  • MAX finds the largest numerical value.
  • Functions save time and make calculations easier.

11. Test Your Knowledge – Interactive MCQs

Enter your name and select your answers. Each answer locks immediately with instant feedback.

SUM, AVERAGE, MIN and MAX Functions – Online MCQ Test

10 Questions | 10 Marks | One-Time Selection

Answered: 0 / 10 Questions Live Score: 0 / 10

Final Test Result

Congratulations! You have completed Lesson 39. Continue to Lesson 40 to advance further in your Excel diploma program.

© Social Media Point | Free Digital Education

Previous Post Next Post