what is absolute referencing give with example
Answers
Answered by
1
Answer:
An absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. Unlike a relative reference, an absolute reference refers to an actual fixed location on a worksheet. To create an absolute reference in Excel, add a dollar sign before the row and column.
Answered by
2
Answer:
Absolute-reference
- An address or pointer that does not change. For example, in a spreadsheet, a cell with an absolute reference does not change even if copied elsewhere. Contrast with relative reference.
Similar questions