Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
ROUND. ROUND(value, decimals) rounds a number to the decimal places you ask for. 2 decimals means cents. The value can be a whole calculation, not just a cell.
=ROUND(A2*1.2,1) A2 × 1.2, rounded to 1 decimal
For the April review, your manager wants average order value per region, shown to the cent.
In D2:D5, divide each region’s revenue (B) by its number of orders (C) and round the result to 2 decimal places.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Revenue | Orders | Avg order value | ||||
| 2 | North | 5751.57 | 18 | |||||
| 3 | South | 10555.33 | 31 | |||||
| 4 | East | 6943.63 | 15 | |||||
| 5 | West | 10369.8 | 25 | |||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe