CSEC Information Technology · May/June 2018 · Paper 1 · Question Q31
The following formula is located in position B6 of a spreadsheet. What would be the resulting formula if it was copied to the position located immediately on the left?
= B3 + B4 + B5
- (A)C3 + C4 + C5
- (B)A3 + A4 + A5
- (C)A3 + A4 +
B5 - (D)C3 + C4 +
B5
The answer is shown once you've answered.
Practise this question