The last two digits of the Representative ID Number is the Office ID. Which function, when entered into cell B2 and then dragged to cell B6, returns the Office ID for each representative?

  • =TRIM(A2,2)
  • =LEFT(A2,2)
  • =RIGHT(A2,2)
  • =MID(A2,2)

The correct answer is:

  • =RIGHT(A2,2)

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers