/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-2/
/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-2/
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 2: Functions and references

Paper 2: Functions and references

  • 2026-11-21

Paper 2: Functions and references

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

Paper 2 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: Spreadsheet basics: formulas and charts
Level Advanced

02 Questions (10 items)

  1. FoundationB2 holds 12 and C2 holds 5. What does =B2*C2 return?
  2. FoundationThe formula =A1+B1 sits in D1. What does it become when copied to D2?
  3. FoundationD2 to D6 hold 45, 72, 38, 90 and 55. What does =MAX(D2:D6) return?
  4. FoundationFor the same range D2:D6, what does =MIN(D2:D6) return?
  5. IntermediateE2 to E8 is seven cells, five with numbers and two blank. What does =COUNT(E2:E8) return?
  6. IntermediateB2 to B5 hold 10, 20, 30 and 40. What does =SUM(B2:B5)*2 return?
  7. ChallengeC2 to C4 hold 5, 7 and 9. What does =ROUND(AVERAGE(C2:C4),1) return?
  8. ChallengeA class of 40 students has 25 passes. What is the pass rate?
  9. Error redoWhich chart type best shows the share each part takes of the whole?
  10. Error redoA row is inserted above the range A1:A5. What happens to =SUM(A1:A5)?

03 Answers and one-line notes

# Answer One-line note
1 60 The two cells are multiplied, and 12 times 5 gives 60.
2 =A2+B2 A relative reference shifts down one row along with the copy.
3 90 MAX returns the largest value in the range.
4 38 MIN returns the smallest value in the range.
5 5 COUNT counts numbers only, so blank cells are ignored.
6 200 The total of 100 is multiplied by two.
7 7.0 The average is 7 and one decimal place is kept.
8 62.5 percent 25 divided by 40 gives 0.625, which is 62.5 percent.
9 A pie chart A pie chart splits a total into slices, so proportions are easy to read.
10 The range expands to A1:A6. The sheet adjusts range references automatically when rows are inserted.

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 →