S2 ICT spreadsheet formulas practice 1: SUM, AVERAGE, MAX and MIN
- 2026-11-20
S2 ICT spreadsheet formulas practice 1: SUM, AVERAGE, MAX and MIN
Ten items all built on one column of eight scores: total, mean, largest, smallest and cell count, with SUM kept apart from COUNT and the classic dropped-cell and rounding slips covered.
S2 ICT spreadsheet practice 1: ten basic items B2:B9 holds eight scores, so SUM gives 599, AVERAGE 74.875, MAX 91, MIN 54 and COUNT 8. All ten items derive from that column, each with a one-line note so a tutor can spot COUNT being answered as SUM.
01 Paper details (check answers afterwards)
| Item | Detail |
|---|---|
| Questions | 10 |
| Suggested time | 25 |
| Difficulty mix | Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2 |
| Chapter | Chapter: S2 ICT: Spreadsheet formulas and charts |
| Level | Foundation |
02 Questions (10 items)
- FoundationCells B2:B9 hold 72, 65, 88, 54, 91, 77, 83 and 69. What does =SUM(B2:B9) return?
- FoundationWith the same data, what does =AVERAGE(B2:B9) return?
- FoundationWith the same data, what are =MAX(B2:B9) and =MIN(B2:B9)?
- FoundationWith the same data, what is =COUNT(B2:B9) and how does it differ from the 599 of SUM?
- IntermediateB2 is 72 and B3 is 65. What does =B2+B3 return?
- IntermediateIs =SUM(B2:B9)/COUNT(B2:B9) the same as =AVERAGE(B2:B9), and why?
- ChallengeWhat does =MAX(B2:B9)-MIN(B2:B9) return, and what is that quantity called?
- ChallengeWhat does =ROUND(AVERAGE(B2:B9),1) return, and how does it differ from merely formatting to one decimal?
- Error redoA student writes =SUM(B2:B8) instead of B2:B9. What is the answer and what went wrong?
- Error redoA student answers that COUNT(B2:B9) is 599. What is the root of that error?
03 Answers and one-line notes
| # | Answer | One-line note |
|---|---|---|
| 1 | 599 | SUM adds every number inside the range. |
| 2 | 74.875 (74.9 to one decimal place) | AVERAGE divides the total by the count, 599 divided by 8. |
| 3 | MAX is 91 and MIN is 54 | MAX returns the largest value and MIN the smallest. |
| 4 | It is 8; COUNT counts numeric cells rather than adding them | COUNT reports how many numeric cells there are while SUM adds their values. |
| 5 | 137 | The plus sign adds the two cell values directly. |
| 6 | Yes, both give 74.875 | AVERAGE is total divided by count, so the two formulas are equivalent. |
| 7 | 37, called the range | Largest minus smallest is the range and shows how spread the data is. |
| 8 | 74.9; ROUND changes the stored value while formatting only changes the display | ROUND rewrites the stored number, formatting only the way it appears. |
| 9 | 530, because the 69 in B9 was left out | A range one cell short drops one value, 599 minus 69. |
| 10 | Confusing COUNT with SUM; COUNT answers 8 | Assuming an identical range must give an identical answer is the classic slip. |
04 What to do after marking
- After marking, redo only the wrong items and write down which step went wrong (formula, unit, or misread number).
- Repeat the same item two days later; move to the next paper only when both attempts are correct.
- Parents only need the answer and note columns; there is no need to explain every item.
The commonest spreadsheet failure is a correct formula with a reference one cell off. Book a TutorZone tutor and spend twenty-five minutes checking SUM, AVERAGE, IF and absolute references cell by cell, plus COUNT against COUNTA.Tutor Registration →
Questions and answers are written originally by the TutorZone team and are not taken from any school, publisher or examination authority paper. Every value is checked by computer.



