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) | LIST-II (Definition and Features) |
A. $D$5 | I. Mixed reference. Row is fixed and column is changeable when fill handle is used |
B. D$5 | II. Mixed reference. Column is fixed and row is changeable when fill handle is used |
C. D5 | III. Absolute reference. Column and row are fixed when fill handle is used |
D. $D5 | IV. Relative reference. Column and row are changeable when fill handle is used |
Choose the correct answer from the options given below:
- A.
A-III, B-I, C-IV, D-II
- B.
A-II, B-I, C-IV, D-III
- C.
A-III, B-IV, C-I, D-II
- D.
A-IV, B-I, C-III, D-II
Attempted by 14 students.
Show answer & explanation
Correct answer: A
The correct matching is A-III, B-I, C-IV, D-II. $D$5 represents an absolute reference where both column and row are fixed (III). D$5 is a mixed reference with the row fixed and column changeable (I). D5 is a relative reference where both are changeable (IV). $D5 is a mixed reference with the column fixed and row changeable (II).