Page 1085 - SUBSEC October 2017_Neat

- 5 -

DO NOT WRITE IN THIS AREA
2. SPREADSHEET

(a) Retrieve the workbook DELEARSHIP, and perform the following tasks on the STOCK
worksheet. The data should reflect what is shown below.

A B C D E
1 REVENUE
MANUFACTURER OPENING CLOSING PRICE FROM
STOCK STOCK
SALES
2 NISSAN 5 3 85 000
3 TOYOTA 5 4 100 000
4 MITSUBISHI 5 1 90 000
5 MAZDA 5 5 75 000
DO NOT WRITE IN THIS AREA
6 SUZUKI 5 2 55 000
7
8
9

(i) Format the labels in row 1 to Arial font, bold, 12 point, and centre the data in the
cells horizontally and vertically.
(2 marks)

(ii) Insert a formula in cell E2 to calculate the REVENUE FROM SALES for cars
from the Nissan Manufacturer, and replicate your formula in cells E3:E6.

(2 marks)
(iii) In the range A8:A9, enter the following text:

TOTAL REVENUE
AVERAGE REVENUE
DO NOT WRITE IN THIS AREA

Then insert appropriate functions in range B8:B9 which will compute the total and
average revenue from the sales of all vehicles.
(2 marks)

(iv) Apply currency and two decimal places to the data in cells D2:E6.
(1 mark)

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