Page 1086 - SUBSEC October 2017_Neat
P. 1086
- 6 -
(b) Retrieve the worksheet SALES, copy of the worksheet is provided below, and perform
the following tasks.
SALES
A B
1 2018 Revenue DO NOT WRITE IN THIS AREA
2 QUARTER REVENUE ($)
3 Quarter 1 1 155 000.00
4 Quarter 2 925 000.00
5 Quarter 3 1 290 000.00
6 Quarter 4
(i) Link the missing value in cell B6 with cell B8 from the STOCK sheet in the
DEALERSHIP workbook to complete the 2018 Revenue.
(1 mark)
(ii) Filter the REVENUE data for the quarters where the revenue was less than
$1 000 000.00. Set up the extraction range in a blank area of the STOCK sheet in
the DEALERSHIP workbook.
Save your workbook with the filename DO NOT WRITE IN THIS AREA
DEALERSHIPCANDIDATENUMBER (2 marks)
Total 20 marks
GO ON TO THE NEXT PAGE DO NOT WRITE IN THIS AREA
01229032 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code
