Microsoft Excel 2021365 - Beginner to Advanced - Exercise 12 - work on two assignments

This video tutorial covers how to separate text into different columns using text functions like LEFT and MID. It also demonstrates finding the closest guess to a target number using INDEX and MATCH functions. The tutorial provides step-by-step instructions on extracting names and departments from a text string and determining the winner based on the closest guess.

Explain how to use the INDEX and MATCH functions together in this context.

What is the significance of using absolute numbers in the calculations?

What formula would you use to determine the winner based on the closest guess?