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 find whole hours from minutes, find leftover minutes after whole hours, check if a number is even.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a total number of minutes. Write a formula in A2 that returns the number of whole hours, using INT.
| A | |
|---|---|
| 1 | 155 |
| 2 | ? |
Divide by 60 and wrap in INT: =INT(A1/60)
Right — INT(A1/60) truncates down to the whole number of complete hours.
Expected result in A2: 2
A1 holds a total number of minutes. Write a formula in A2 that returns the leftover minutes after removing whole hours, using MOD.
| A | |
|---|---|
| 1 | 155 |
| 2 | ? |
Use =MOD(A1,60) to get the remainder.
Good — MOD(A1,60) gives exactly the remainder after dividing by 60, i.e. the leftover minutes.
Expected result in A2: 35
A1 holds a number. Write a formula in A2 that returns TRUE if it's even, using MOD.
| A | |
|---|---|
| 1 | 14 |
| 2 | ? |
Check if the remainder when divided by 2 is zero: =MOD(A1,2)=0
Right — a remainder of 0 when dividing by 2 means the number is even.
Expected result in A2: true
A1 holds a total item count, B1 holds items per box. Write a formula in C1 that returns the number of complete boxes, using INT.
| A | B | C | |
|---|---|---|---|
| 1 | 137 | 12 | ? |
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 item count, B1 holds items per box. Write a formula in C1 for the leftover items that don't fill a complete box, using MOD.
| A | B | C | |
|---|---|---|---|
| 1 | 137 | 12 | ? |
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 price with cents. Write a formula in A2 that returns just the whole-dollar part, using INT.
| A | |
|---|---|
| 1 | 47.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 price. Write a formula in A2 that returns just the cents (as a value between 0 and 1) using MOD.
| A | |
|---|---|
| 1 | 47.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 row number. Write a formula in A2 that returns TRUE if A1 is a multiple of 5, using MOD.
| A | |
|---|---|
| 1 | 25 |
| 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 days. Write a formula in A2 for the number of complete weeks, using INT.
| A | |
|---|---|
| 1 | 47 |
| 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 days. Write a formula in A2 for the leftover days after removing complete weeks, using MOD.
| A | |
|---|---|
| 1 | 47 |
| 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 →