Explain the difference between relative and absolute cell references in Excel.
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.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
To clarify, the core difference between relative and...