ROUND practice exercises
Rounds to a number of decimals. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 5501 | East | Omar | 6 | 12 | 72 |
| 3 | 5502 | West | Kofi | 8 | 30 | 240 |
| 4 | 5503 | North | Kofi | 7 | 12 | 84 |
| 5 | 5504 | West | Maya | 2 | 45 | 90 |
| 6 | 5505 | East | Maya | 5 | 60 | 300 |
| 7 | 5506 | East | Maya | 2 | 12 | 24 |
| 8 | 5507 | East | Raj | 3 | 9 | 27 |
| 9 | 5508 | West | Maya | 3 | 45 | 135 |
Average Price, rounded to 1 decimal place.
Show answer
=ROUND(AVERAGE(E2:E9),1)→ 28.1Average Revenue, rounded to a whole number.
Show answer
=ROUND(AVERAGE(F2:F9),0)→ 122
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 6401 | East | Omar | 6 | 15 | 90 |
| 3 | 6402 | East | Kofi | 6 | 18 | 108 |
| 4 | 6403 | North | Omar | 4 | 30 | 120 |
| 5 | 6404 | South | Lena | 8 | 9 | 72 |
| 6 | 6405 | North | Kofi | 7 | 9 | 63 |
| 7 | 6406 | North | Omar | 1 | 9 | 9 |
| 8 | 6407 | South | Theo | 8 | 30 | 240 |
| 9 | 6408 | North | Lena | 5 | 15 | 75 |
Average Revenue, rounded to a whole number.
Show answer
=ROUND(AVERAGE(F2:F9),0)→ 97Average Price, rounded to 1 decimal place.
Show answer
=ROUND(AVERAGE(E2:E9),1)→ 16.9
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 6301 | West | Omar | 6 | 9 | 54 |
| 3 | 6302 | North | Ana | 1 | 24 | 24 |
| 4 | 6303 | North | Omar | 2 | 12 | 24 |
| 5 | 6304 | North | Ines | 4 | 60 | 240 |
| 6 | 6305 | East | Lena | 8 | 9 | 72 |
| 7 | 6306 | West | Omar | 3 | 15 | 45 |
| 8 | 6307 | South | Ana | 2 | 45 | 90 |
| 9 | 6308 | South | Lena | 8 | 24 | 192 |
Average Price, rounded to 1 decimal place.
Show answer
=ROUND(AVERAGE(E2:E9),1)→ 24.8Average Revenue, rounded to a whole number.
Show answer
=ROUND(AVERAGE(F2:F9),0)→ 93
New to ROUND? Read the ROUND guide first: syntax, a worked example and common mistakes.