Lesson Summary

In Excel, a cell reference is a way to identify and locate a specific cell within a spreadsheet. It is used to retrieve data from a specific cell or perform calculations using the values in a specific cell. There are two types of cell references: relative and absolute.

• Relative cell references are the default type of reference in Excel. When a formula is copied to a different cell, the relative cell reference will change based on the new location of the formula.
• Absolute cell references, on the other hand, always refer to a specific cell, regardless of where the formula is copied. Absolute references are useful when you want to maintain the same reference to a cell in multiple formulas.