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)
*The range can be anything.