Instruction: Provide definitions for both relative and absolute cell references and give an example of when you might use each.
Context: This question assesses the candidate's understanding of cell reference types in Excel and their ability to apply them appropriately in different scenarios.
Official answer available
Preview the opening of the answer, then unlock the full walkthrough.
To clarify, the core difference between relative and absolute cell references in Excel lies in how they behave when copied or filled into other cells.
Relative cell references change when a formula is copied to another cell. They are context-sensitive and adjust based on the relative position of rows and columns. For example, if you have a formula in cell A2 as =A1+10, and you copy this formula to B2, it changes to =B1+10. This is because Excel adjusts the formula relative to its new location, making it incredibly useful for applying the same calculation across multiple cells dynamically....