Question

what is absolute referencing give with example​

Answer 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.

Answer 2

Answer:

Absolute-reference

1. 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.