Paper 2: Advanced: absolute references and conditional counts
Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.
| 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 | Advanced |
| # | Answer | One-line note |
|---|---|---|
| 1 | An absolute reference that still points at B2 wherever it is copied. | The two dollar signs lock both column and row so filling does not shift them. |
| 2 | `=$B$2*C3`. | $B$2 stays locked while C2 moves to C3 because it is relative. |
| 3 | 3. | The values above 100 are 336, 387 and 111, which is three cells. |
| 4 | 146. | The quantities of 10 or more are 12 (66) and 25 (80), which total 146. |
| 5 | Yes. | The first value is used when the test is true and the second when it is false. |
| 6 | 2. | Only the quantities 12 and 25 reach 10. |
| 7 | 111. | Sorted into 66, 80, 111, 336 and 387, the middle value is 111. |
| 8 | It skips the blank and divides the numeric total by four. | AVERAGE does not treat a blank as zero, so the mean is not dragged down. |
| 9 | 0.3949. | The number format only changes how the value looks, not the value itself. |
| 10 | They give the same total now, but the SUM range grows automatically when a row is inserted. | Adding cells one by one does not update on insert, so a row is easily missed. |
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.

