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 calculate compound growth, find the area of a square, find the side length from an area.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a principal amount, B1 holds a growth multiplier per period, C1 holds the number of periods. Write a formula in D1 that raises B1 to the power of C1, times A1.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 1000 | 1.05 | 3 | ? |
Use POWER for the exponent: =A1*POWER(B1,C1)
Right — POWER(B1,C1) raises the growth factor to the number of periods, giving compound growth.
Expected result in D1: 1157.6250000000002
A1 holds the side length of a square. Write a formula in A2 that returns its area using POWER.
| A | |
|---|---|
| 1 | 7 |
| 2 | ? |
Use =POWER(A1,2).
Good — POWER(A1,2) squares the side length to get the area.
Expected result in A2: 49
A1 holds the area of a square. Write a formula in A2 that returns the side length using SQRT.
| A | |
|---|---|
| 1 | 144 |
| 2 | ? |
Use =SQRT(A1).
Right — SQRT reverses squaring, giving the side length from the area.
Expected result in A2: 12
A1 holds the side length of a cube. Write a formula in A2 for its volume using POWER.
| A | |
|---|---|
| 1 | 4 |
| 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 and B1 hold the two legs of a right triangle. Write a formula in C1 for the hypotenuse using SQRT and POWER.
| A | B | C | |
|---|---|---|---|
| 1 | 3 | 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 holds a starting value, B1 holds the number of times it doubles. Write a formula in C1 that computes A1 times 2 raised to the power of B1.
| A | B | C | |
|---|---|---|---|
| 1 | 5 | 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 holds a sum of squared deviations. Write a formula in A2 that takes the square root of A1 (a simplified step toward standard deviation).
| A | |
|---|---|
| 1 | 81 |
| 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 late-fee base, B1 holds a penalty exponent. Write a formula in C1 that raises A1 to the power of B1.
| A | B | C | |
|---|---|---|---|
| 1 | 2 | 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 →A1 and B1 hold two values whose product needs a square root. Write a formula in C1 for the square root of their product.
| A | B | C | |
|---|---|---|---|
| 1 | 4 | 9 | ? |
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 the side length of a square. Write a formula in A2 for its diagonal length using SQRT and POWER.
| A | |
|---|---|
| 1 | 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 →