Paper 1: Basics: references, totals and averages
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 | Basic |
| # | Answer | One-line note |
|---|---|---|
| 1 | The cell where column B meets row 2. | Columns use letters and rows use numbers, and the column is written first. |
| 2 | An equals sign, `=`. | Without it the entry is stored as text and nothing is calculated. |
| 3 | `=B2*C2`, which gives 66. | The asterisk is the multiplication sign; the letter x would be read as text. |
| 4 | 980. | The colon means the continuous range D2 to D6, and SUM adds all five values. |
| 5 | 196. | AVERAGE divides the total of 980 by the five cells. |
| 6 | A maximum of 387 and a minimum of 66. | MAX returns the largest value in the range and MIN the smallest. |
| 7 | 5. | COUNT counts cells holding numbers, and all five do. |
| 8 | `=B4*C4`. | Relative references follow the row, so row 4 replaces row 2. |
| 9 | 326.67. | 980 divided by 3 is 326.666…, and ROUND keeps two decimals. |
| 10 | The formula `=B2*C2`. | The cell shows the result, while the formula bar shows the formula actually stored. |
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.

