Page 1061 - SUBSEC October 2017_Neat
P. 1061

- 10 -



                           (iii)   Write the text for the function to be inserted in D13 to calculate the TOTAL expected
                                  costs.


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

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

                                  .................................................................................................................................  DO NOT WRITE IN THIS AREA
                                                                                                   (2 marks)

                           (iv)   Write a function that would insert the average cost per unit of an item in cell B15.


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

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

                                  .................................................................................................................................
                                                                                                   (2 marks)








                            (v)   John decides that he wants the rows reorganized so that they are in order of the     DO NOT WRITE IN THIS AREA
                                  most expensive to the least expensive.


                                  Explain how he could do this using features of the spreadsheet software.

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

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


                                  .................................................................................................................................
                                                                                                   (2 marks)

                                                                                              Total 20 marks           DO NOT WRITE IN THIS AREA






















                                                                              GO ON TO THE NEXT PAGE
              01229020 SPEC/2017
                                                       ‘‘*’’Barcode Area”*”
                                                       Sequential Bar Code
   1056   1057   1058   1059   1060   1061   1062   1063   1064   1065   1066