Match the LIST-I with LIST-II in the context of MS-Excel:LIST-I (Cell…
2026
Match the LIST-I with LIST-II in the context of MS-Excel:
LIST-I (Cell Reference)
A. $E$5
B. E$5
C. E5
D. $E5
LIST-II (Definition and Feature)
I. Absolute reference. Column and row are fixed when fill handle is used.
II. Mixed reference. Row is fixed and column is changeable when fill handle is used.
III. Relative reference. Column and row are changeable when fill handle is used.
IV. Mixed reference. Column is fixed and row is changeable when fill handle is used.
Choose the correct answer from the options given below:
- A.
A-I, B-II, C-III, D-IV
- B.
A-IV, B-II, C-III, D-I
- C.
A-I, B-III, C-II, D-IV
- D.
A-III, B-IV, C-I, D-II
Attempted by 42 students.
Show answer & explanation
Correct answer: A
In MS Excel, cell references determine how formulas adjust when copied. A ($E$5) is an absolute reference where both column and row are fixed (I). B (E$5) is a mixed reference where the row is fixed but column changes (II). C (E5) is a relative reference where both change (III). D ($E5) is a mixed reference where the column is fixed but row changes (IV). Thus, the correct match is A-I, B-II, C-III, D-IV.