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 rank a sales total (highest first), rank a race time (fastest first), rank a test score among classmates.
3 of 10 free · no sign-up needed · graded on the formula you write
A2 holds one salesperson's total, A1:A4 holds everyone's totals. Write a formula in B2 that returns A2's rank, highest first, using RANK.
| A | B | |
|---|---|---|
| 1 | 5000 | |
| 2 | 8000 | ? |
| 3 | 6000 | |
| 4 | 4000 |
Use =RANK(A2,A1:A4).
Right — RANK with no third argument (or 0) ranks highest value as 1.
Expected result in B2: 1
A2 holds one runner's time, A1:A4 holds everyone's times. Write a formula in B2 that returns A2's rank, fastest (lowest) first, using RANK.
| A | B | |
|---|---|---|
| 1 | 22 | |
| 2 | 19 | ? |
| 3 | 25 | |
| 4 | 21 |
Use =RANK(A2,A1:A4,1) — the 1 means ascending order.
Good — passing 1 as the order argument ranks ascending, so the lowest time gets rank 1.
Expected result in B2: 1
A2 holds one student's score, A1:A5 holds the class's scores. Write a formula in B2 that returns A2's rank, highest first.
| A | B | |
|---|---|---|
| 1 | 78 | |
| 2 | 95 | ? |
| 3 | 82 | |
| 4 | 90 | |
| 5 | 88 |
Use =RANK(A2,A1:A5).
Right — the default RANK order treats the largest value as rank 1, appropriate for test scores.
Expected result in B2: 1
A2 holds one golfer's score, A1:A4 holds everyone's scores. Write a formula in B2 that returns A2's rank, lowest score first (golf scoring), using RANK.
| A | B | |
|---|---|---|
| 1 | 72 | |
| 2 | 68 | ? |
| 3 | 75 | |
| 4 | 70 |
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 →A2 holds one product's units sold, A1:A4 holds all products' units sold. Write a formula in B2 for A2's rank, highest first.
| A | B | |
|---|---|---|
| 1 | 300 | |
| 2 | 450 | ? |
| 3 | 200 | |
| 4 | 500 |
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 →A2 holds one employee's average response time, A1:A4 holds everyone's. Write a formula in B2 for A2's rank, fastest first.
| A | B | |
|---|---|---|
| 1 | 4 | |
| 2 | 2 | ? |
| 3 | 5 | |
| 4 | 3 |
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 →A2 holds one team's total raised, A1:A4 holds all teams' totals. Write a formula in B2 for A2's rank, highest first.
| A | B | |
|---|---|---|
| 1 | 1200 | |
| 2 | 2500 | ? |
| 3 | 1800 | |
| 4 | 900 |
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 →A2 holds one respondent's satisfaction score, A1:A5 holds all scores. Write a formula in B2 for A2's rank, highest first.
| A | B | |
|---|---|---|
| 1 | 3 | |
| 2 | 5 | ? |
| 3 | 4 | |
| 4 | 2 | |
| 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 →A2 holds one runner's finish time, A1:A4 holds all runners' times. Write a formula in B2 for A2's rank, fastest first.
| A | B | |
|---|---|---|
| 1 | 240 | |
| 2 | 195 | ? |
| 3 | 210 | |
| 4 | 220 |
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 →A2 holds one quarter's revenue, A1:A4 holds all quarters. Write a formula in B2 for A2's rank, highest first.
| A | B | |
|---|---|---|
| 1 | 45000 | |
| 2 | 61000 | ? |
| 3 | 52000 | |
| 4 | 38000 |
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 →