Match List I (Cell Reference) with List II (Definition and Feature) in the context of MS-Excel. Choose the correct answer from the options given below:
In Excel a dollar sign locks the part of a cell reference it precedes, so the dollar pattern decides what stays fixed while filling.
$E$5 pairs with an absolute reference, since both column and row are fixed when the fill handle is used.
E$5 pairs with a mixed reference where the row is fixed and the column changes, because the dollar precedes only the row.
E5 pairs with a relative reference, since neither column nor row is locked and both change on filling.
$E5 pairs with a mixed reference where the column is fixed and the row changes, because the dollar precedes only the column.
These four cases together cover every combination of fixed and changeable parts of a reference.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →