Have a go

1. A spreadsheet is used to calculate the cost of carpeting a house. It is shown here with the formula view switched on so that you can see how it is constructed (Image is not included)
(a)  Identify the two functions used in this spreadsheet. 
(b)  (i) Cell D12 contains the expression (D2:D10). Describe the meaning of the information in this expression. [2 marks]
(c)   Explain how features of a spreadsheet can be used in order to investigate “what-if” questions. [4 marks]