Module 2 · Lesson 5
SUM, AVERAGE, and MAX
Summarise expenses and performance with readable functions.
Functions make common calculations readable
A function has a name followed by brackets. The range inside the brackets tells Excel which cells to use.
=SUM(B2:B6)Match the function to the question
SUM returns a total, AVERAGE returns the arithmetic mean, and MAX returns the largest value.
- Check the range boundaries.
- Do not include the result cell in its own range.
- Use number formatting after the formula is correct.
Key takeaway: Use a continuous range such as B2:B6 and exclude headings and summary rows.