Question

explain absolute cells referencing with the help of a example​

Answer 1

The definition of absolute cell reference is one that does not change when it's moved, copied or filled.

This way, the reference points back to the same cell, no matter where it appears in the workbook. It's indicated by a dollar sign in the column or row coordinate.

Answer 2

• Techopedia explains Absolute Cell Reference

1. An absolute cell reference always remains the same no matter where it is copied and is often denoted by the "$" symbol.
2. For instance, if the cell reference is typed as $A1, continuous pressing of F4 will change the cell reference to A$1 and then A1.

$I \: \: HOPE \: \: ITS \: \: HELPFULL$