describing when to use absolute cell references\nwhen would an absolute cell reference be most…

describing when to use absolute cell references\nwhen would an absolute cell reference be most helpful?\nwhen there is a long list of cell references in a formula\nwhen there is a need to copy a formula and have the references update based on the new location\nwhen some cell references need to be removed from a formula\nwhen there is a need to reference the same cell when a formula is copied

describing when to use absolute cell references\nwhen would an absolute cell reference be most helpful?\nwhen there is a long list of cell references in a formula\nwhen there is a need to copy a formula and have the references update based on the new location\nwhen some cell references need to be removed from a formula\nwhen there is a need to reference the same cell when a formula is copied

Answer

Brief Explanations:

Absolute cell references keep the same cell reference when a formula is copied. They don't change like relative references. So they are useful when you want to always refer to the same cell.

Answer:

when there is a need to reference the same cell when a formula is copied