Practice by topic / Excel / Ranking & Statistics
Ranking, percentages and weighted averages answer the questions managers actually ask: who's top, how much did it change, what's the real average. These 10 exercises build up step by step, starting with calculate percent change, calculate what percent one value is of another, calculate a percent decrease.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds last year's value, B1 holds this year's value. Write a formula in C1 for the percent change from A1 to B1.
| A | B | C | |
|---|---|---|---|
| 1 | 200 | 250 | ? |
Use =(B1-A1)/A1.
Right — (new - old) / old gives the percent change as a decimal (multiply by 100 to see it as a percentage).
Expected result in C1: 0.25
A1 holds a part, B1 holds a whole. Write a formula in C1 for what percent A1 is of B1.
| A | B | C | |
|---|---|---|---|
| 1 | 30 | 120 | ? |
Use =A1/B1.
Good — dividing part by whole gives the percentage as a decimal.
Expected result in C1: 0.25
A1 holds an original price, B1 holds a sale price. Write a formula in C1 for the percent decrease from A1 to B1.
| A | B | C | |
|---|---|---|---|
| 1 | 100 | 75 | ? |
Use =(A1-B1)/A1.
Right — this gives the size of the drop as a percentage of the original value.
Expected result in C1: 0.25
A1 holds a base salary, B1 holds a raise percentage as a decimal. Write a formula in C1 for the new salary after the raise.
| A | B | C | |
|---|---|---|---|
| 1 | 50000 | 0.05 | ? |
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, B1 holds a discount rate as a decimal. Write a formula in C1 for the discounted price.
| A | B | C | |
|---|---|---|---|
| 1 | 80 | 0.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 amount spent, B1 holds total budget. Write a formula in C1 for what percent of budget has been spent.
| A | B | C | |
|---|---|---|---|
| 1 | 3200 | 8000 | ? |
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 last year's revenue, B1 holds this year's. Write a formula in C1 for the year-over-year percent growth.
| A | B | C | |
|---|---|---|---|
| 1 | 500000 | 575000 | ? |
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 bill total, B1 holds a tip rate as a decimal. Write a formula in C1 for the tip amount.
| A | B | C | |
|---|---|---|---|
| 1 | 60 | 0.18 | ? |
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 rates as decimals. Write a formula in C1 for the difference between them.
| A | B | C | |
|---|---|---|---|
| 1 | 0.45 | 0.38 | ? |
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 current headcount, B1 holds a planned percent increase as a decimal. Write a formula in C1 for the new headcount.
| A | B | C | |
|---|---|---|---|
| 1 | 40 | 0.1 | ? |
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 →