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:

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:

Accepted Answer

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

Answer

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

Answer

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

Answer

(A) - (III), (B) - (IV), (C) - (I), (D) - (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

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)