/en-tutor-prep-s3-ict-spreadsheet-formulas-functions-practice-1/
/en-tutor-prep-s3-ict-spreadsheet-formulas-functions-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

Paper 1: Basics: references, totals and averages

Paper 1: Basics: references, totals and averages

  • 2026-11-21

Paper 1: Basics: references, totals and averages

Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.

Paper 1 Ten items on this chapter with answers for immediate marking.

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: S3 ICT: spreadsheet formulas and functions
Level Basic

02 Questions (10 items)

  1. FoundationWhich position does the cell reference B2 point to?
  2. FoundationWhat must the first character of a formula be?
  3. FoundationB2 holds 12 and C2 holds 5.5. What formula in D2 multiplies them, and what is the result?
  4. FoundationD2 to D6 hold 66, 336, 387, 80 and 111. What does `=SUM(D2:D6)` give?
  5. IntermediateWith the same data, what does `=AVERAGE(D2:D6)` give?
  6. IntermediateWith the same data, what do `=MAX(D2:D6)` and `=MIN(D2:D6)` give?
  7. ChallengeWith the same data, what does `=COUNT(D2:D6)` give?
  8. ChallengeD2 holds `=B2*C2`. Dragging the fill handle down to D4 makes D4 hold which formula?
  9. Error redoWhat does `=ROUND(SUM(D2:D6)/3,2)` give?
  10. Error redoWhen D2 is selected, the cell shows 66. What does the formula bar show?

03 Answers and one-line notes

# Answer One-line note
1 The cell where column B meets row 2. Columns use letters and rows use numbers, and the column is written first.
2 An equals sign, `=`. Without it the entry is stored as text and nothing is calculated.
3 `=B2*C2`, which gives 66. The asterisk is the multiplication sign; the letter x would be read as text.
4 980. The colon means the continuous range D2 to D6, and SUM adds all five values.
5 196. AVERAGE divides the total of 980 by the five cells.
6 A maximum of 387 and a minimum of 66. MAX returns the largest value in the range and MIN the smallest.
7 5. COUNT counts cells holding numbers, and all five do.
8 `=B4*C4`. Relative references follow the row, so row 4 replaces row 2.
9 326.67. 980 divided by 3 is 326.666…, and ROUND keeps two decimals.
10 The formula `=B2*C2`. The cell shows the result, while the formula bar shows the formula actually stored.

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.

Want the whole chapter? See all four difficulty papers on the chapter page.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 →