Practice by topic / Excel / Math & Rounding
Totals, rounding and simple maths are the formulas behind every invoice, budget and report. Small mistakes here show up as numbers that don't add up. These 10 exercises build up step by step, starting with round a price to cents, round to the nearest whole number, round to the nearest 10.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a price with extra decimal places. Write a formula in A2 that rounds it to 2 decimal places.
| A | |
|---|---|
| 1 | 19.9846 |
| 2 | ? |
Use =ROUND(A1,2) to round to 2 decimal places.
Right — ROUND(A1,2) rounds to exactly 2 decimal places, which is standard for currency.
Expected result in A2: 19.98
A1 holds a calculated average. Write a formula in A2 that rounds it to the nearest whole number.
| A | |
|---|---|
| 1 | 87.6 |
| 2 | ? |
Use =ROUND(A1,0).
Good — a second argument of 0 rounds to the nearest whole number.
Expected result in A2: 88
A1 holds an estimated cost. Write a formula in A2 that rounds it to the nearest 10 using a negative digits argument.
| A | |
|---|---|
| 1 | 483 |
| 2 | ? |
Use a negative digits argument: =ROUND(A1,-1)
Right — a negative digits argument rounds to the left of the decimal point, so -1 rounds to the nearest 10.
Expected result in A2: 480
A1 holds a raw percentage value. Write a formula in A2 that rounds it to 1 decimal place.
| A | |
|---|---|
| 1 | 42.37 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a value ending in exactly .5. Write a formula in A2 that rounds it to the nearest whole number (Excel rounds .5 away from zero).
| A | |
|---|---|
| 1 | 12.5 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a negative adjustment value. Write a formula in A2 that rounds it to the nearest whole number.
| A | |
|---|---|
| 1 | -7.5 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds an estimated population. Write a formula in A2 that rounds it to the nearest 100.
| A | |
|---|---|
| 1 | 48213 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a measured weight with many decimal places. Write a formula in A2 that rounds it to 2 decimal places.
| A | |
|---|---|
| 1 | 5.28371 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a total, B1 holds a count. Write a formula in C1 that divides A1 by B1 and rounds the result to 2 decimal places.
| A | B | C | |
|---|---|---|---|
| 1 | 100 | 3 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a GPS-calculated distance in miles with several decimal places. Write a formula in A2 that rounds it to 1 decimal place.
| A | |
|---|---|
| 1 | 3.14159 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →