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 sum weekly sales, sum monthly expenses, sum two separate ranges.
3 of 10 free · no sign-up needed · graded on the formula you write
A1:A5 hold sales for Monday through Friday. Write a formula in A6 that totals the week.
| A | |
|---|---|
| 1 | 120 |
| 2 | 95 |
| 3 | 140 |
| 4 | 88 |
| 5 | 160 |
| 6 | ? |
Use =SUM(A1:A5) to total the range.
Right — SUM handles the whole range in one call instead of chaining plus signs.
Expected result in A6: 603
B1:B4 hold four expense categories. Write a formula in B5 that totals them.
| A | B | |
|---|---|---|
| 1 | 300 | |
| 2 | 450 | |
| 3 | 120 | |
| 4 | 80 | |
| 5 | ? |
Use =SUM(B1:B4).
Good — SUM scales cleanly even if more expense rows get added later.
Expected result in B5: 950
A1:A2 hold one set of values and C1:C2 hold another. Write a formula in E1 that sums both ranges together.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 10 | 5 | ? | ||
| 2 | 20 | 15 |
Pass both ranges as separate arguments: =SUM(A1:A2,C1:C2)
Right — SUM accepts multiple ranges as separate arguments, adding them all together.
Expected result in E1: 50
A1:A6 hold six quiz scores. Write a formula in A7 that totals them.
| A | |
|---|---|
| 1 | 8 |
| 2 | 9 |
| 3 | 7 |
| 4 | 10 |
| 5 | 6 |
| 6 | 9 |
| 7 | ? |
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 →B1:B3 hold inventory counts across three warehouses. Write a formula in B4 for the total inventory.
| A | B | |
|---|---|---|
| 1 | 340 | |
| 2 | 210 | |
| 3 | 175 | |
| 4 | ? |
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:A3 hold a range of values, and B1 holds one more value to include. Write a formula in C1 that sums the range and the extra cell together.
| A | B | C | |
|---|---|---|---|
| 1 | 5 | 20 | ? |
| 2 | 10 | ||
| 3 | 15 |
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:A4 hold four donation amounts. Write a formula in A5 for the total raised.
| A | |
|---|---|
| 1 | 50 |
| 2 | 75 |
| 3 | 100 |
| 4 | 25 |
| 5 | ? |
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 →B1:B5 hold hours worked each day this week. Write a formula in B6 for total hours.
| A | B | |
|---|---|---|
| 1 | 8 | |
| 2 | 7.5 | |
| 3 | 8 | |
| 4 | 6 | |
| 5 | 8 | |
| 6 | ? |
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:A4 hold points scored across four games. Write a formula in A5 for the season total so far.
| A | |
|---|---|
| 1 | 21 |
| 2 | 14 |
| 3 | 28 |
| 4 | 17 |
| 5 | ? |
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 →B1:B4 hold a budget line's spend across four quarters. Write a formula in B5 for the annual total.
| A | B | |
|---|---|---|
| 1 | 1200 | |
| 2 | 1350 | |
| 3 | 980 | |
| 4 | 1100 | |
| 5 | ? |
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 →