The correct answer is Dollar ($).Absolute reference in excel is used when we want to fix the position of the selected cell in any formula so that its value will be not changed whenever we are changing the cell or copying the formula to other cells or sheets.This is done by putting the dollar (œ$) sign before and after the column name of the selected cell.Or else, we can type the F4 function key, which will automatically cover the column alphabet with the dollar.For example, if you want to fix cell A1, then it will look as œ=$A$1.Important PointsStep to create an absolute cell reference in excel:?Select a cell where you want to create an absolute cell reference. Suppose cell A1.=A1, its a relative reference. We will discuss this in a later chapter.=$A1, if we put a $ dollar sign before the column coordinate, it locked the only column. This means when we drag this cell, the only row keeps changing in that particular column, and the column remains constant.=A$1, if we put a $ dollar sign before the row coordinate, it locked the only row. This means when we drag this cell, only the column keeps changing in that particular row, and the row remains constant.=$A$1, its called an absolute cell reference. It locked both the row and the column. If we drag this cell or copy this cell, the cell or formula cell will remain constant.