Instruction: Provide an example of how the 'OFFSET' function can be utilized to reference a dynamic range of cells.
Context: This question assesses the candidate's knowledge of advanced Excel functions for dynamic data range selection, crucial for adaptive data analysis and modeling.