1.

Define absolute cell referencing.

Answer» It is the referencing in which both the column name and the cell value remains constant when we drag the formula
Absolute An absolute cell reference is fixed. Absolute references do not change if you copy a formula from one cell to another. Absolute references have dollar sign ($) like $S$9. As the shows, when the formula =C4*$D$9 is copied from row, the absolute cell reference remains as $D$9


Discussion

No Comment Found