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:

Answer: A. A-III, B-I, C-IV, D-II

  1. A.

    A-III, B-I, C-IV, D-II

  2. B.

    A-II, B-I, C-IV, D-III

  3. C.

    A-III, B-IV, C-I, D-II

  4. D.

    A-IV, B-I, C-III, D-II

Attempted by 60 students.

Show answer & explanation

Correct answer: A

Explore the full course: Ssc Cgl Tier 2

Loading lesson…