Page 1077 - SUBSEC October 2017_Neat

- 6 -
01229020/KMS/SPEC 2017

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

SO Question Key Mark
3. cont’d
(b) (i) 6

Correct SUM
Cell E8: function:

=SUM(E4:E7) Correct
Range: 1 mark
OR
Correct 1 mark
=SUM(E4..E7) brackets and
equal sign 1 mark
OR and (colon or
two dots):
=E4+E5+E6+E7

5.4

Cell E9

Possible options to
calculate the Both cell
difference: references 1 mark
correct
=F2-E8 1 mark
Equal sign
OR 1 mark
Minus sign
=$F$2-E8

5.3 (ii) 3

=IF(E9>F2,”Ye
s”,”No”) =IF
1 mark
OR Condition
1 mark
=IF(E9>0,”No” Y/N Options
,”Yes”) 1 mark