Computer Applications
Explain Absolute Referencing
Spreadsheet
49 Likes
Answer
In Absolute Referencing, the address of the cells is specified in a way that it remains constant when the formula is copied to a new cell. To keep the cell value absolute, apply the '$' sign before the column name, as well as the row number.
For example, let us consider that cell C6 has the formula =A6*B6*$F$3. The formula takes the relative cell values from A6 and B6, and the absolute value from the cell F3. When this formula is copied to C7 or C8, it will automatically get adjusted as below:
For C7, it will become =A7*B7*$F$3
For C8, it will become =A8*B8*$F$3
Notice that the relative reference changes but the absolute reference $F$3 remains the same.
Answered By
29 Likes