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.
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:
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:
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], ...)
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], ...)
If the values are 10, 25, 5, 40, and 15, the result is 40.
6. Comparison of the Four Functions
| Function | Purpose | Example |
|---|---|---|
| SUM | Adds values | =SUM(B2:B10) |
| AVERAGE | Calculates the mean | =AVERAGE(B2:B10) |
| MIN | Finds the smallest number | =MIN(B2:B10) |
| MAX | Finds the largest number | =MAX(B2:B10) |
7. Practical Student Marksheet
Enter the following information in Excel:
| Student | English | Math | Science | Total | Average |
|---|---|---|---|---|---|
| Ali | 70 | 80 | 75 | ||
| Sara | 85 | 90 | 88 | ||
| Ahmed | 60 | 65 | 70 |
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
- Create a new workbook named Excel Functions Practice.xlsx.
- Enter five student names and their marks in three subjects.
- Use SUM to calculate each student's total.
- Use AVERAGE to calculate each student's average.
- Use MIN to find the lowest subject mark.
- Use MAX to find the highest subject mark.
- 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
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
