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 count high scores, count orders from one region, count items below a threshold.
3 of 10 free · no sign-up needed · graded on the formula you write
A1:A6 hold test scores. Write a formula in A7 that counts how many are 90 or above.
| A | |
|---|---|
| 1 | 95 |
| 2 | 82 |
| 3 | 91 |
| 4 | 78 |
| 5 | 90 |
| 6 | 88 |
| 7 | ? |
Use =COUNTIF(A1:A6,">=90").
Right — COUNTIF with a comparison criteria counts only the cells meeting the condition.
Expected result in A7: 3
A1:A6 hold region names for six orders. Write a formula in A7 that counts how many are from "West".
| A | |
|---|---|
| 1 | West |
| 2 | East |
| 3 | West |
| 4 | North |
| 5 | West |
| 6 | East |
| 7 | ? |
Use =COUNTIF(A1:A6,"West").
Good — a text criteria in COUNTIF counts exact matches.
Expected result in A7: 3
A1:A5 hold inventory counts. Write a formula in A6 that counts how many are below 20 (low stock).
| A | |
|---|---|
| 1 | 15 |
| 2 | 45 |
| 3 | 8 |
| 4 | 30 |
| 5 | 12 |
| 6 | ? |
Use =COUNTIF(A1:A5,"<20").
Right — the "<20" criteria counts cells strictly less than 20.
Expected result in A6: 3
A1:A6 hold task statuses. Write a formula in A7 that counts how many are exactly "complete".
| A | |
|---|---|
| 1 | complete |
| 2 | pending |
| 3 | complete |
| 4 | complete |
| 5 | pending |
| 6 | in progress |
| 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 adjustment amounts, some of which are zero. Write a formula in A6 that counts how many are not equal to zero.
| A | |
|---|---|
| 1 | 5 |
| 2 | 0 |
| 3 | -3 |
| 4 | 0 |
| 5 | 8 |
| 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 product prices. Write a formula in A7 that counts how many exceed 50.
| A | |
|---|---|
| 1 | 45 |
| 2 | 62 |
| 3 | 78 |
| 4 | 30 |
| 5 | 55 |
| 6 | 20 |
| 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:A6 hold letter grades. Write a formula in A7 that counts how many are exactly "A".
| A | |
|---|---|
| 1 | A |
| 2 | B |
| 3 | A |
| 4 | C |
| 5 | A |
| 6 | B |
| 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 usage amounts against a cap of 100. Write a formula in A6 that counts how many are at or under 100.
| A | |
|---|---|
| 1 | 90 |
| 2 | 110 |
| 3 | 100 |
| 4 | 75 |
| 5 | 120 |
| 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 shipment statuses, some marked "delayed". Write a formula in A6 that counts how many are "delayed".
| A | |
|---|---|
| 1 | delayed |
| 2 | shipped |
| 3 | delayed |
| 4 | shipped |
| 5 | shipped |
| 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 daily temperatures. Write a formula in A7 that counts how many days were above 75 degrees.
| A | |
|---|---|
| 1 | 72 |
| 2 | 80 |
| 3 | 68 |
| 4 | 77 |
| 5 | 82 |
| 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 →