Your manager asks for a quick monthly sales summary: total revenue, average sale, highest sale, lowest sale and number of orders. You could calculate manually, but functions do it faster and more accurately.
What are Excel functions?
A function is a ready-made formula in Excel. Instead of writing long calculations manually, you use a function name and a range.
Example: =SUM(G4:G11) adds all values from G4 to G11.
Essential functions at a glance
| Function | Purpose | Example | Business Use |
|---|---|---|---|
| SUM | Adds values | =SUM(G4:G11) | Total sales |
| AVERAGE | Finds average | =AVERAGE(G4:G11) | Average order value |
| MAX | Highest value | =MAX(G4:G11) | Highest sale |
| MIN | Lowest value | =MIN(G4:G11) | Lowest sale |
| COUNT | Counts numeric cells | =COUNT(G4:G11) | Number of orders |
SUM function
=SUM(G4:G11) adds all numbers in the selected range. Use it for total sales, total cost, total quantity or total profit.
AVERAGE function
=AVERAGE(G4:G11) calculates the average of the selected numbers. In sales reporting, this is useful for average order value.
MAX and MIN functions
=MAX(G4:G11) gives the highest sale. =MIN(G4:G11) gives the lowest sale. These functions help you quickly spot extremes.
COUNT function
=COUNT(G4:G11) counts numeric cells. It is useful for counting the number of sales records, orders or numeric responses.
Create a sales summary using functions
Download one ZIP file containing the practice workbook, challenge workbook, solution workbook, cheat sheet, quiz and answer key.
Mini practice
- Calculate Total Sales using SUM.
- Calculate Average Sale using AVERAGE.
- Find Highest Sale using MAX.
- Find Lowest Sale using MIN.
- Count number of orders using COUNT.
Quick quiz
- Which function adds values?
- Which function finds average?
- Which function finds highest sale?
- Which function counts numeric cells?
Answers: SUM, AVERAGE, MAX, COUNT.