/en-tutor-prep-s2-ict-spreadsheet-formulas-practice-1/
/en-tutor-prep-s2-ict-spreadsheet-formulas-practice-1/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

S2 ICT spreadsheet formulas practice 1: SUM, AVERAGE, MAX and MIN

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)

  1. FoundationCells B2:B9 hold 72, 65, 88, 54, 91, 77, 83 and 69. What does =SUM(B2:B9) return?
  2. FoundationWith the same data, what does =AVERAGE(B2:B9) return?
  3. FoundationWith the same data, what are =MAX(B2:B9) and =MIN(B2:B9)?
  4. FoundationWith the same data, what is =COUNT(B2:B9) and how does it differ from the 599 of SUM?
  5. IntermediateB2 is 72 and B3 is 65. What does =B2+B3 return?
  6. IntermediateIs =SUM(B2:B9)/COUNT(B2:B9) the same as =AVERAGE(B2:B9), and why?
  7. ChallengeWhat does =MAX(B2:B9)-MIN(B2:B9) return, and what is that quantity called?
  8. ChallengeWhat does =ROUND(AVERAGE(B2:B9),1) return, and how does it differ from merely formatting to one decimal?
  9. Error redoA student writes =SUM(B2:B8) instead of B2:B9. What is the answer and what went wrong?
  10. 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.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →