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.