| 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 |