Question

in ____ referencing the reference does not change rows and columns automatically when it is copied to a new cell​

Answer 1

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. Place a "$" before a row number if you want that to always stay the same.

holp I help you