The spreadsheet below shows the result of core subjects of a Year 8 student in a school.

a) Write down a cell address which contains

i. a label: **A1 (other answers: A2, B2, A3, A4, A5, A6, A8, A9)**

ii. a number: **B3 (other answers: B4, B5, B6)**

b) Write down the formula/functions used to calculate the following:

i. Total Marks in **B8**: **=SUM(B3:B6) (other answer: =B3+B4+B5+B6)**

ii. Average in **B9: =AVERAGE(B3:B6) (other answer: =(B3+B4+B5+B6)/4)**

c) Give **two **advantages of spreadsheet.

**1. Easier to edit or change data. **

**2. Formulae for calculation to be done automatically.**

d) List the **four **items that can be contained in the cell.

**1. Text/Label **

**2. Formulae/Functions
**

**3. Numbers **

**4. Date/Time**