In MS-Excel, which character is used to make full cell reference?
In MS-Excel, which character is used to make full cell reference?
(A) %
(B) $
(C) &
(D) #
The symbol "$" in MS Excel is used to produce absolute references which means the referenced row and column will remain unchanged even if the formula is moved or copied. By way of illustration, $A$1 is a cell reference that indicates cell A1 no matter where the formula containing it is placed or copied to.