/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-1/
/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-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: Cells, SUM and AVERAGE

Paper 1: Cells, SUM and AVERAGE

  • 2026-11-21

Paper 1: Cells, SUM and AVERAGE

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: Spreadsheet basics: formulas and charts
Level Basic

02 Questions (10 items)

  1. FoundationWhat position does the cell reference B3 mean in a spreadsheet?
  2. FoundationIf A1 holds 12 and A2 holds 8, what does =A1+A2 show?
  3. FoundationB2 to B6 hold 5, 8, 10, 4 and 3. What does =SUM(B2:B6) return?
  4. FoundationC2 to C5 hold 10, 20, 30 and 40. What does =AVERAGE(C2:C5) return?
  5. IntermediateA1 holds 12. What does the formula =A1*2 return?
  6. IntermediateWhat is the difference between $C$1 and C1?
  7. ChallengeThe formula =SUM(A1:A10) returns 150. What is the average of those ten cells?
  8. ChallengeA value rises from 60 to 90. What is the percentage increase?
  9. Error redoWhat appears when =1/0 is entered in a cell?
  10. Error redoA cell holds 5+3 with no equals sign. What happens?

03 Answers and one-line notes

# Answer One-line note
1 Column B, the second column, row 3. Columns are lettered from left to right and rows are numbered from top to bottom.
2 20 12 plus 8 gives 20; a leading equals sign makes the cell a formula.
3 30 A colon marks a continuous range and SUM adds every number in it.
4 25 The total is 100 and dividing by four cells gives 25.
5 24 An asterisk means multiply, so the value of A1 is doubled.
6 $C$1 stays fixed on C1 when copied, C1 shifts with the position. Dollar signs lock a column or row, which is an absolute reference.
7 15 150 divided by ten cells gives 15.
8 50 percent, that is 0.5. The rise of 30 divided by the original 60 gives 0.5.
9 #DIV/0! A zero or blank divisor cannot be computed, so the sheet shows an error value.
10 The text 5+3 is shown and nothing is calculated. Content without a leading equals sign is treated as plain text.

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 →