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 average weekly sales, average test scores, average response times.
3 of 10 free · no sign-up needed · graded on the formula you write
A1:A5 hold sales for five days. Write a formula in A6 that returns the average daily sales.
| A | |
|---|---|
| 1 | 100 |
| 2 | 150 |
| 3 | 120 |
| 4 | 90 |
| 5 | 140 |
| 6 | ? |
Use =AVERAGE(A1:A5).
Right — AVERAGE handles the sum and division in one step.
Expected result in A6: 120
A1:A4 hold four test scores. Write a formula in A5 for the average score.
| A | |
|---|---|
| 1 | 85 |
| 2 | 92 |
| 3 | 78 |
| 4 | 88 |
| 5 | ? |
Use =AVERAGE(A1:A4).
Good — AVERAGE is the standard way to compute a mean across a range.
Expected result in A5: 85.75
A1:A5 hold support ticket response times in hours. Write a formula in A6 for the average response time.
| A | |
|---|---|
| 1 | 2 |
| 2 | 4 |
| 3 | 1 |
| 4 | 5 |
| 5 | 3 |
| 6 | ? |
Use =AVERAGE(A1:A5).
Right — AVERAGE gives you the mean response time across all tickets.
Expected result in A6: 3
A1:A2 and C1:C2 hold two small sets of values. Write a formula in E1 that averages all four values together.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 10 | 30 | ? | ||
| 2 | 20 | 40 |
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 four months of expenses. Write a formula in B5 for the average monthly expense.
| A | B | |
|---|---|---|
| 1 | 500 | |
| 2 | 620 | |
| 3 | 480 | |
| 4 | 550 | |
| 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:A5 hold customer ratings out of 5. Write a formula in A6 for the average rating.
| A | |
|---|---|
| 1 | 4 |
| 2 | 5 |
| 3 | 3 |
| 4 | 5 |
| 5 | 4 |
| 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 days of commute times in minutes. Write a formula in A6 for the average commute.
| A | |
|---|---|
| 1 | 25 |
| 2 | 30 |
| 3 | 22 |
| 4 | 35 |
| 5 | 28 |
| 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 attendance counts across four sessions. Write a formula in A5 for the average attendance.
| A | |
|---|---|
| 1 | 28 |
| 2 | 25 |
| 3 | 30 |
| 4 | 27 |
| 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:A5 hold delivery distances in miles. Write a formula in A6 for the average distance.
| A | |
|---|---|
| 1 | 3.2 |
| 2 | 5.1 |
| 3 | 2.8 |
| 4 | 6.4 |
| 5 | 4 |
| 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 →B1:B4 hold four quarters of revenue. Write a formula in B5 for the average quarterly revenue.
| A | B | |
|---|---|---|
| 1 | 45000 | |
| 2 | 52000 | |
| 3 | 48000 | |
| 4 | 61000 | |
| 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 →