The spreadsheet below shows the results of student progress assessment (SPA) of core subjects for some year 8 students in a school.

a) Write down a cell address which contains

i. a label: **A1 (other answers: B1, C1, D1, E1, F1, G1, H1, A2, A3, A4, A5. A6, A7)**

ii. a date: **B2 (other answers: B3, B4, B5, B6, B7)**

b) What is the **formula/function** used to calculate the following:

i. **Total** in G2: **=SUM(C2:F2)**

other answer: **=C2+D2+E2+F2**

ii.** Average** in H2: **=AVERAGE(C2:F2)**

other answer: **=(C2+D2+E2+F2)/4**

c) The display in cell H2 appears as “######’

i. What does this mean?

**The cell is not wide enough to display its item.**

ii. How would you overcome this problem?

**By widening the column so that the item can be displayed properly.**

d) Describe how you would copy the formula from **G2** to **G3:G7.**

**1. Select cell G2, right-click on the mouse and select ‘Copy’.**

**2. Highlight cell G3:G7, right-click on the mouse and select ‘Paste’.**

e) List **two** of a function in a spreadsheet. (I’ve made change from formula to function)

**1. =SUM(C2:G2)**

**2. =AVERAGE(c2:G2)**

**The range can be anything.*