Page 1075 - SUBSEC October 2017_Neat

- 4 -
01229020/KMS/SPEC 2017

Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER

SO Question Key Mark
2. cont’d
(iv) =Average(C4:C13)
[1 for correct function and 1 for correct 2
parameter in the function]

(v) Sort the items by column C – Cost Per Unit [1] in
descending order [1] 2

TOTAL 20