What allows keeping the exact cell reference when copying a formula?

What allows keeping the exact cell reference when copying a formula?

• A. Relative Cell References
• B. XFGetCell References
• C. Absolute Cell References
• D. Mixed References

Answer: (C)

The ability to keep an exact cell reference when copying a formula comes from using absolute references. Absolute references lock the row and column by placing dollar signs in front of both the column and the row, like $A$1. This tells the program not to adjust that reference no matter where you copy the formula. For example, if a formula uses =$A$1 and you copy it anywhere else, it still points to cell A1. In contrast, relative references (no dollar signs) would shift as you copy, and mixed references lock only one dimension (either the column or the row). The term that specifically preserves the exact cell is absolute references.

The ability to keep an exact cell reference when copying a formula comes from using absolute references. Absolute references lock the row and column by placing dollar signs in front of both the column and the row, like $A$1. This tells the program not to adjust that reference no matter where you copy the formula.

For example, if a formula uses =$A$1 and you copy it anywhere else, it still points to cell A1. In contrast, relative references (no dollar signs) would shift as you copy, and mixed references lock only one dimension (either the column or the row). The term that specifically preserves the exact cell is absolute references.