Question: Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?

  1. OFFSET
  2. VLOOKUP
  3. INDEX
  4. MATCH

Answer: The correct answer of the above question is Option A:OFFSET