Question

To keep a row or column cell reference constant in a formula, you would use:

Answer 1

Answer:

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.