Practice by topic / Excel / Counting & Averaging
Counting and averaging are how you summarise a list: how many orders, how many late, what the typical value is. Most reports start here. These 10 exercises build up step by step, starting with find the highest sale, find the lowest price, find the second-highest score.
3 of 10 free · no sign-up needed · graded on the formula you write
A1:A5 hold five sale amounts. Write a formula in A6 that returns the highest.
| A | |
|---|---|
| 1 | 100 |
| 2 | 250 |
| 3 | 180 |
| 4 | 90 |
| 5 | 300 |
| 6 | ? |
Use =MAX(A1:A5).
Right — MAX returns the largest value in the range.
Expected result in A6: 300
A1:A5 hold five product prices. Write a formula in A6 that returns the lowest.
| A | |
|---|---|
| 1 | 20 |
| 2 | 15 |
| 3 | 35 |
| 4 | 12 |
| 5 | 28 |
| 6 | ? |
Use =MIN(A1:A5).
Good — MIN returns the smallest value in the range.
Expected result in A6: 12
A1:A5 hold five test scores. Write a formula in A6 that returns the second-highest score using LARGE.
| A | |
|---|---|
| 1 | 88 |
| 2 | 95 |
| 3 | 72 |
| 4 | 91 |
| 5 | 85 |
| 6 | ? |
Use =LARGE(A1:A5,2).
Right — LARGE(range,2) returns the 2nd largest value, skipping the top one.
Expected result in A6: 91
A1:A5 hold five race times in minutes. Write a formula in A6 that returns the third-fastest (lowest) time using SMALL.
| A | |
|---|---|
| 1 | 22 |
| 2 | 19 |
| 3 | 25 |
| 4 | 18 |
| 5 | 21 |
| 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:A6 hold six days of temperature readings. Write a formula in A7 for the highest.
| A | |
|---|---|
| 1 | 68 |
| 2 | 72 |
| 3 | 75 |
| 4 | 70 |
| 5 | 80 |
| 6 | 74 |
| 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 →A1:A5 hold inventory counts across five warehouses. Write a formula in A6 for the lowest.
| A | |
|---|---|
| 1 | 340 |
| 2 | 210 |
| 3 | 175 |
| 4 | 400 |
| 5 | 90 |
| 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:A5 hold five salaries. Write a formula in A6 for the 3rd-highest using LARGE.
| A | |
|---|---|
| 1 | 65000 |
| 2 | 82000 |
| 3 | 58000 |
| 4 | 91000 |
| 5 | 74000 |
| 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:A5 hold five bid amounts. Write a formula in A6 for the 2nd-lowest bid using SMALL.
| A | |
|---|---|
| 1 | 500 |
| 2 | 420 |
| 3 | 610 |
| 4 | 390 |
| 5 | 480 |
| 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:A6 hold points scored across six games. Write a formula in A7 for the best single-game score.
| A | |
|---|---|
| 1 | 21 |
| 2 | 14 |
| 3 | 28 |
| 4 | 17 |
| 5 | 31 |
| 6 | 19 |
| 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 →A1:A5 hold five speed readings. Write a formula in A6 for the lowest (slowest) speed.
| A | |
|---|---|
| 1 | 55 |
| 2 | 62 |
| 3 | 48 |
| 4 | 70 |
| 5 | 51 |
| 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 →