Paper 2: Functions and references
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 | Advanced |
| # | Answer | One-line note |
|---|---|---|
| 1 | 60 | The two cells are multiplied, and 12 times 5 gives 60. |
| 2 | =A2+B2 | A relative reference shifts down one row along with the copy. |
| 3 | 90 | MAX returns the largest value in the range. |
| 4 | 38 | MIN returns the smallest value in the range. |
| 5 | 5 | COUNT counts numbers only, so blank cells are ignored. |
| 6 | 200 | The total of 100 is multiplied by two. |
| 7 | 7.0 | The average is 7 and one decimal place is kept. |
| 8 | 62.5 percent | 25 divided by 40 gives 0.625, which is 62.5 percent. |
| 9 | A pie chart | A pie chart splits a total into slices, so proportions are easy to read. |
| 10 | The range expands to A1:A6. | The sheet adjusts range references automatically when rows are inserted. |
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.

