Excel AVERAGE Practice Question: Order values for the day are in B2:B9. Find the average order value, rounded…
The question
Order values for the day are in B2:B9. Find the average order value, rounded to 2 decimals. Put it in D2.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Value | Result | |
| 2 | 1 | 1250 | ? | |
| 3 | 2 | 980 | ||
| 4 | 3 | 2300 | ||
| 5 | 4 | 1475 | ||
| 6 | 5 | 615 | ||
| 7 | 6 | 3090 | ||
| 8 | 7 | 1820 | ||
| 9 | 8 | 745 |
The yellow cell is where your answer goes.
Show answer
Answer in D2: 1534.38
How it works
Explanation: AVERAGE adds the numbers and divides by how many there are. ROUND keeps the result to 2 decimals.
Syntax: =ROUND(AVERAGE(B2:B9),2)
Total 12275 divided by 8 orders = 1534.38.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →AVERAGE syntax
=AVERAGE(number1, [number2], ...)
Finds the mean of a set of numbers. AVERAGE is used in financial models and engineering-style calculations where precise numeric work is needed. Full AVERAGE guide.
More AVERAGE practice questions
- Using AVERAGE, find the average daily footfall for the five weekdays and put it in B7.
- Using AVERAGE, find each student's average marks across the three tests and put them in…
- Two students were absent, so their marks are blank. Using AVERAGE, find the average of…
- Customer ratings are on a 5-point scale. Using ROUND with AVERAGE, find the average…
- Store A and Store B report monthly sales in separate columns. Using one AVERAGE with…
- The store was closed one day, so that day shows 0. Using AVERAGE, find the average daily…
- Using AVERAGE, find the average sales of the last three months only (Apr to Jun) and put…
- Build a 3-month moving average. Using AVERAGE, fill C4 to C7 so each cell averages that…
All practice questions · Excel exercises · Interview prep · Cheat sheet