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.