Paper 1: Cells, SUM and AVERAGE
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 | Basic |
| # | Answer | One-line note |
|---|---|---|
| 1 | Column B, the second column, row 3. | Columns are lettered from left to right and rows are numbered from top to bottom. |
| 2 | 20 | 12 plus 8 gives 20; a leading equals sign makes the cell a formula. |
| 3 | 30 | A colon marks a continuous range and SUM adds every number in it. |
| 4 | 25 | The total is 100 and dividing by four cells gives 25. |
| 5 | 24 | An asterisk means multiply, so the value of A1 is doubled. |
| 6 | $C$1 stays fixed on C1 when copied, C1 shifts with the position. | Dollar signs lock a column or row, which is an absolute reference. |
| 7 | 15 | 150 divided by ten cells gives 15. |
| 8 | 50 percent, that is 0.5. | The rise of 30 divided by the original 60 gives 0.5. |
| 9 | #DIV/0! | A zero or blank divisor cannot be computed, so the sheet shows an error value. |
| 10 | The text 5+3 is shown and nothing is calculated. | Content without a leading equals sign is treated as plain text. |
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.

