$\$$C4 or C$\$$4 is an example of _____ reference.

Mixed

The correct answer is Option 2:Mixed

Cell Reference: A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a cell address. Cell references are used in formulas, functions, charts, other Excel commands and also refer to a group or range of cells.The ranges are identified using colon (:) e.g. A1: E2 which tells Excel to include all the cells between these start and end points. By default cell reference is relative; which means that 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. The other cell reference is absolute cell reference which consists of the column letter and row number surrounded by dollar ($) signs e.g. $C$4. An absolute cell reference is used when we want a cell reference to stay fixed on specific cell, which means that when a formula or function is copied and pasted to other cells, the cell references in the formula or function do not change. A mixed reference is also a cell reference that holds either row or column constant when the formula or function is copied to another location e.g., $\$$C4 or C$\$$4 .