/en-tutor-prep-s3-ict-spreadsheet-formulas-functions-practice-4/
/en-tutor-prep-s3-ict-spreadsheet-formulas-functions-practice-4/
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 4: Retry: correcting ten common slips

Paper 4: Retry: correcting ten common slips

  • 2026-11-21

Paper 4: Retry: correcting ten common slips

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

Paper 4 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 Retry

02 Questions (10 items)

  1. FoundationA pupil types `B2*C2` into D2 without an equals sign. What happens?
  2. FoundationWhat is wrong with `=SUM(B2:B6)*C2`?
  3. FoundationCopying `=B2*C2` from D2 down to D6 makes every cell repeat the first row amount. Why?
  4. FoundationHow do COUNT and COUNTA differ?
  5. IntermediateWhat happens if `=COUNTIF(D2:D6,”>100″)` is written without the quotes?
  6. IntermediateLeaving the quotes off the text results, as in `=IF(B2>=10,Yes,No)`, produces which error?
  7. ChallengeWhat most often causes `#REF!`?
  8. ChallengeTyping `=SUMM(D2:D6)` gives `#NAME?`. Why?
  9. Error redoA formula placed in D2 also refers to D2. What problem appears?
  10. Error redoDoes a two-decimal number format round the value? What does `=ROUND(2.346,2)` give?

03 Answers and one-line notes

# Answer One-line note
1 The entry is stored as text, nothing is calculated and SUM ignores it. A formula must start with an equals sign, otherwise the entry stays plain text.
2 Multiplying a range by a single cell gives `#VALUE!`; multiply row by row or use SUMPRODUCT. SUM has already collapsed five quantities into one number, so the row pairing is lost.
3 The formula uses relative references where a locked cell was intended, so dollars are needed, such as `=$B$2*C2`. Relative references follow the position, so an unlocked cell keeps pointing at the same place.
4 COUNT counts numeric cells only, while COUNTA counts every non-empty cell including text. A column with text headings is undercounted by COUNT but fully counted by COUNTA.
5 The spreadsheet reports a syntax error and refuses the formula. A comparison criterion must be written as text inside double quotes.
6 `#NAME?`, because the words are read as names or functions. Text results need double quotes so they are not treated as names.
7 The column, row or sheet the formula pointed at has been deleted. Paste values first, or refer to a region that will not be deleted.
8 The function name is misspelt; the correct form is `=SUM(D2:D6)`. Only correctly spelt function names are recognised, so one extra letter becomes an unknown name.
9 A circular reference, which cannot settle, so the cell usually shows 0 or a warning. A formula must not refer to its own cell, directly or through a chain.
10 The format only changes the display and the stored value stays exact, while `=ROUND(2.346,2)` gives 2.35. The ROUND function must be used to change the value itself, not the cell format.

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 →