Step 1: Idea of a cell reference:
A spreadsheet is a grid of rows and columns. Every box in it is a cell.
A cell is named by its column letter and row number, for example B3.
The question asks four meanings, and each carries 1 mark.
Step 2: (i) Cell reference:
A cell reference identifies the location of a cell or a group of cells in the spreadsheet.
It is also called a cell address. For example, A1 refers to column A and row 1.
Formulas use cell references to pick up values from other cells. (1 mark)
Step 3: (ii) Relative cell reference:
This is the default type of reference.
When a formula is copied and pasted to other cells, the reference changes to match the new location.
For example, =A1+B1 in row 1 becomes =A2+B2 when copied one row down. (1 mark)
Step 4: (iii) Absolute cell reference:
It has a dollar sign before the column letter and before the row number, such as dollar A dollar 1.
The user needs it when the reference must stay fixed on one cell.
Even when the formula is copied to another cell, the reference does not change. (1 mark)
Step 5: (iv) Mixed cell reference:
It holds either the row or the column constant when the formula is copied to another place.
Examples are dollar A1 (column fixed) and A dollar 1 (row fixed).
The other part of the reference changes as in a relative reference. (1 mark)
Final Answer:
Cell reference = address of a cell. Relative = changes on copying. Absolute = fixed (dollar A dollar 1). Mixed = either row or column fixed (dollar A1 or A dollar 1). 4 marks.