Question

Match List-I with List-II

List-I	List-II
(A) Ranges	(I) Holds either row or column constant when the formula or function is copied to another location
(B) Mixed reference	(II) Used when we want a cell reference to stay fixed on specific cell
(C) Absolute reference	(III) As a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location
(D) Default reference	(IV) Identified by cell references of the cells from the upper left to lower right

Choose the correct answer from the options given below:

• (A) - (I), (B) - (II), (C) - (III), (D) - (IV)
• (A) - (IV), (B) - (I), (C) - (II), (D) - (III)
• (A) - (I), (B) - (II), (C) - (IV), (D) - (III)
• (A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Hint:

Absolute reference stays fixed on one cell. Mixed fixes only the row or the column. Default (relative) changes on copying. A range runs from the upper left to the lower right cell.

Answer 1

The Correct Option is B

Step 1: Start with the easiest items.
The absolute reference is the one that is locked on a single cell, so it matches the statement about staying fixed on a specific cell. That is (C)-(II).

Step 2: Use the default type.
Excel changes the cell address automatically when you copy a formula. That is the default, relative behaviour, so (D)-(III).

Step 3: Handle the range.
A range is described by its corners, upper left to lower right. So (A)-(IV).

Step 4: The leftover pair.
Only (B) and statement (I) remain. This fits too, because a mixed reference locks either the row or the column. So (B)-(I).

Step 5: Find the option.
The set A-IV, B-I, C-II, D-III appears only in option 2. Each of the others breaks at least one of the pairs found above.
\[ \boxed{\text{Option 2}} \]

Final Answer:
The match is A-IV, B-I, C-II, D-III (option 2).