Question

the cell address in a formula that does not change on copying is considered as ​

Answer 1

Answer:

These are called "relative" cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same.

Answer 2

Answer: Absolute reference

Explanation: