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: Understand the concept.
In a spreadsheet, a formula can refer to cells in different ways. A range is a block of cells. A reference can be relative (the default), absolute or mixed. We match each with its meaning.

Step 2: Match (A) Ranges.
A range is a group of cells identified by the first cell (upper left) and the last cell (lower right), for example A1:C5. So (A) matches (IV).

Step 3: Match (B) Mixed reference.
A mixed reference fixes only one part, either the row or the column, for example A$1 or $A1. So it holds either the row or the column constant when copied. (B) matches (I).

Step 4: Match (C) Absolute reference.
An absolute reference such as $A$1 always points to one specific cell. It does not change when copied. (C) matches (II).

Step 5: Match (D) Default reference.
The default reference is the relative reference. When the formula is copied to other cells, the reference shifts to show the new location. (D) matches (III).

Step 6: Choose the option.
The pairs are A-IV, B-I, C-II, D-III. This is option 2. Option 1 pairs A with I, which is the mixed reference meaning. Option 3 pairs C with IV, which is the range meaning. Option 4 pairs A with III, the relative meaning. So options 1, 3 and 4 are WRONG.

Final Answer:
The correct matching is (A)-(IV), (B)-(I), (C)-(II), (D)-(III), option 2.
\[ \boxed{\text{Option 2}} \]