Paper 3: Multi-step calculations
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: Spreadsheet basics: formulas and charts |
| Level | Challenge |
| # | Answer | One-line note |
|---|---|---|
| 1 | 2,550 dollars | 12.5 times 240 gives 3,000, and 3,000 times 0.85 gives 2,550. |
| 2 | 840 | The absolute reference keeps B1 fixed, and 800 times 1.05 gives 840. |
| 3 | 1,350 dollars | The total of 4,050 divided by three gives 1,350. |
| 4 | 12.5 percent | The rise of 450 divided by the original 3,600 gives 0.125. |
| 5 | fail | 58 is below 60, so the test fails and IF returns the second result. |
| 6 | 90 degrees | 360 degrees times 0.25 gives 90 degrees. |
| 7 | 8 percent | The extra 320 divided by 4,000 gives 0.08. |
| 8 | 24 marks | 68 times 6 is 408 and 72 times 6 is 432, a gap of 24. |
| 9 | 65.2 percent | 163 hidden rows divided by 250 rows is about 0.652. |
| 10 | The chart is redrawn from the new range. | A chart is linked to its range, so edits show up immediately. |
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.

