Paper 4: Common mistakes corrected
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 | Retry |
| # | Answer | One-line note |
|---|---|---|
| 1 | It becomes text and nothing is calculated. | The equals sign starts a formula; without it the entry is plain text. |
| 2 | The text 128 | The ampersand joins text, so the two values are glued rather than added. |
| 3 | Relative references shift with the position and point at the wrong cells. | Columns or rows that must stay put need dollar signs. |
| 4 | A pie chart does not show trends. | Trends belong in a line chart; a pie chart only shows shares. |
| 5 | The divisor is zero or blank. | Check that the divisor cell actually holds a number. |
| 6 | 3 | AVERAGE divides by the number of numeric cells, so 90 over 3 gives 30. |
| 7 | 0.5 | Percentage formatting changes the display only, not the stored value. |
| 8 | Rows are broken up and values no longer match their records. | Select the whole table before sorting. |
| 9 | They block sorting and fill operations. | Only the top left cell of a merged block keeps its value. |
| 10 | The chart range does not include the new row. | Reset the chart range or convert the data into a table. |
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.

