Cell Reference

Absolute Address in a Spreadsheet
An Absolute Address in a spreadsheet refers to a fixed location that does not change when a formula is copied to another location. This is in contrast to a Relative Cell Reference which adjusts based on the new location of the formula.
Relative Cell Reference
A Relative Cell Reference in computer spreadsheet programs identifies the position of a cell in relation to another cell. When the reference is copied to a new location, it adjusts to refer to a cell in the same relative position.

Accounting Terms Lexicon

Discover comprehensive accounting definitions and practical insights. Empowering students and professionals with clear and concise explanations for a better understanding of financial terms.