What do you know about absolute reference in MS Excel? Explain with the help of an example.
Answers
Answered by
3
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both. With the use of an absolute cell reference in excel, we can keep a row or a column constant or can keep both constant. It doesn't change when copied to other cells.
EXAMPLE
If the cell formula was copied from C2 to C3, it would become "=SUM($A$2+B3)." ... Absolute cells always point to the exact row or column described, regardless of where the reference appears.
Similar questions