Match List I (Cell Reference) with List II (Definition and Features) in the context of MS Excel.

List I

i.$D$5

ii.D$5

iii.D5

iv.$D5

List II

a.Mixed reference. Row is fixed and column is changeable when fill handle is used

b.Mixed reference. Column is fixed and row is changeable when fill handle is used

c.Absolute reference. Column and row are fixed when fill handle is used

d.Relative reference. Column and row are changeable when fill handle is used

Ai-c, ii-a, iii-d, iv-b ✓ Correct

Bi-b, ii-a, iii-d, iv-c

Ci-c, ii-d, iii-a, iv-b

Di-d, ii-a, iii-c, iv-b

Correct answer: (A) i-c, ii-a, iii-d, iv-b

Explanation

In Excel a dollar sign locks the part of a cell reference it precedes, so the pattern of dollar signs decides what stays fixed when copying.

$D$5 pairs with an absolute reference, since both column and row are fixed when the fill handle is used.

D$5 pairs with a mixed reference where the row is fixed and the column changes, because the dollar precedes only the row.

D5 pairs with a relative reference, since neither column nor row is locked and both change on filling.

$D5 pairs with a mixed reference where the column is fixed and the row changes, because the dollar precedes only the column.

Pressing F4 while editing a reference cycles through these dollar-sign combinations.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.