Page 1063 - SUBSEC October 2017_Neat

- 12 -

(b) Kara wants to create the spreadsheet shown below to track the orders placed for the
items.

A B C D E F
1 Cost of
Costume DO NOT WRITE IN THIS AREA
2 $350.00
3 Date Item Cost Quantity Total Due
Ordered

4 11 July Chocolate cake $20.00 6 $120.00
5 11 July Sponge cake $20.00 5 $100.00
6 14 July Swirl cake $20.00 2 $40.00
7 17 July Cupcakes cake $20.00 12 $240.00
8
9
10

(i) Using the spreadsheet above, write the functions and/or formulas in cell E8 or E9
to illustrate whether Kara has raised enough funds. DO NOT WRITE IN THIS AREA

......................................................................................................................

.................................................................................................................................

(6 marks)

(ii) Write the function that would be entered in cell E10 to output ‘Yes’ if Kara would
be able to purchase the costume, or ‘No’ if she has not raised enough funds.

......................................................................................................................

.................................................................................................................................

(3 marks)

(iii) Kara wants to insert another order for 10 July, in row 4. Explain what would DO NOT WRITE IN THIS AREA
happen to the data in row 4.

......................................................................................................................

.................................................................................................................................
(1 mark)

GO ON TO THE NEXT PAGE
01229020 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code