Replicating Formulae · CSEC Information Technology

2 past-paper questions on Replicating Formulae, part of Spreadsheets, from every CSEC Information Technology paper on Quelpr.

1. Q311 mark · multiple choice· CSEC Information Technology · May/June 2018 · Paper 1The 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
2. Q421 mark · multiple choice· CSEC Information Technology · May/June 2019 · Paper 1Which of the following symbols MUST be placed in front of the column letter and row number to create an absolute reference?