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 up to full boxes, round down available full units, round up a price to the next cent.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a number of items, B1 holds how many fit in a box. Write a formula in C1 that rounds up A1/B1 to the nearest whole number of boxes needed.
| A | B | C | |
|---|---|---|---|
| 1 | 47 | 10 | ? |
Wrap the division in ROUNDUP: =ROUNDUP(A1/B1,0)
Right — ROUNDUP ensures you always get enough boxes, even for a partial box's worth of leftover items.
Expected result in C1: 5
A1 holds total minutes, B1 holds minutes per session. Write a formula in C1 that rounds down A1/B1 to the number of complete sessions that fit.
| A | B | C | |
|---|---|---|---|
| 1 | 100 | 30 | ? |
Wrap the division in ROUNDDOWN: =ROUNDDOWN(A1/B1,0)
Good — ROUNDDOWN gives you only the complete sessions, ignoring a partial leftover one.
Expected result in C1: 3
A1 holds a price with more than 2 decimal places. Write a formula in A2 that rounds it up to 2 decimal places (never under-charging).
| A | |
|---|---|
| 1 | 9.991 |
| 2 | ? |
Use =ROUNDUP(A1,2).
Right — ROUNDUP guarantees the price never rounds down below the actual cost.
Expected result in A2: 10
A1 holds a calculated refund. Write a formula in A2 that rounds it down to 2 decimal places (never over-refunding).
| A | |
|---|---|
| 1 | 24.996 |
| 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 cost. Write a formula in A2 that rounds it up to the nearest 10.
| A | |
|---|---|
| 1 | 462 |
| 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 budget estimate. Write a formula in A2 that rounds it down to the nearest 100.
| A | |
|---|---|
| 1 | 5480 |
| 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 number of items, B1 holds items per page. Write a formula in C1 that rounds up to the number of pages needed to fit them all.
| A | B | C | |
|---|---|---|---|
| 1 | 130 | 25 | ? |
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 change amount. Write a formula in A2 that rounds it down to the nearest whole dollar.
| A | |
|---|---|
| 1 | 7.85 |
| 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 account balance. Write a formula in A2 that rounds it up (toward zero being "up" for ROUNDUP magnitude) to a whole number.
| A | |
|---|---|
| 1 | -14.2 |
| 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 investment amount, B1 holds a price per share. Write a formula in C1 that rounds down A1/B1 to the number of whole shares you can afford.
| A | B | C | |
|---|---|---|---|
| 1 | 1000 | 63 | ? |
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 →