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)
- FoundationA pupil types `B2*C2` into D2 without an equals sign. What happens?
- FoundationWhat is wrong with `=SUM(B2:B6)*C2`?
- FoundationCopying `=B2*C2` from D2 down to D6 makes every cell repeat the first row amount. Why?
- FoundationHow do COUNT and COUNTA differ?
- IntermediateWhat happens if `=COUNTIF(D2:D6,”>100″)` is written without the quotes?
- IntermediateLeaving the quotes off the text results, as in `=IF(B2>=10,Yes,No)`, produces which error?
- ChallengeWhat most often causes `#REF!`?
- ChallengeTyping `=SUMM(D2:D6)` gives `#NAME?`. Why?
- Error redoA formula placed in D2 also refers to D2. What problem appears?
- 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.



