Page 1060 - SUBSEC October 2017_Neat

- 9 -

DO NOT WRITE IN THIS AREA
The required report must include a well-organized spreadsheet outlining all the needs of the lab,
and the expected costs in terms of equipment. The incomplete spreadsheet is shown below.

A B C D
1 Expected Costs for New Computer Lab
2 Description Item Units Cost per Unit Total
3 Student computer 30 $ 5 , 000.00
4 Computer Table 30 $ 800.00
5 Teacher Computer 1 $ 5,500.00
6 Teacher Table 1 $ 750.00
7 Student Chairs 30 $ 500.00
8 Teacher Chairs 1 $ 650.00
DO NOT WRITE IN THIS AREA
9 20ft UTP Cabling 15 $ 80.00
10 Projector 1 $ 3,000.00
11 Screen 1 $ 2,400.00
12 White board 2 $ 380.00
13 TOTAL Expected Costs
14
15 Average Item Cost

(e) Cell A1 is formatted across the columns for effective presentation.

(i) State the name of the formatting feature used to achieve this.

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

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

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

(ii) Write the text for the formula to be inserted in D3 to calculate the TOTAL cost for
student computers.

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

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

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

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