Beginner Essentials · Exercise 2
🌙 What’s the Average Order Value?
Maya has five lunchtime orders and wants to know the average amount each customer spent.
Your task
Click B8 and type =AVERAGE(, then drag from B2 down to B6. Type ), then press Enter.
This time you want a typical value, not the total of all five orders.
Selected: none
Spreadsheet ready
| A | B | |
|---|---|---|
| 1 | Order | Order Value |
| 2 | MM-1041 | £8.70 |
| 3 | MM-1042 | £12.40 |
| 4 | MM-1043 | £6.80 |
| 5 | MM-1044 | £15.60 |
| 6 | MM-1045 | £10.50 |
| 7 | ||
| 8 | Average Order | Click here to enter a formula |
Why would I use this at work?
AVERAGE is useful when you want a typical value — for example average order value, average score, average handling time or average monthly spend.
Want to practise more Excel skills? Return to the Excel Practice Lab.