Microsoft Excel 2021365 - Beginner to Advanced - Exercise 02 - apply the Lookup functions

This video tutorial guides viewers through an exercise on using lookup functions in Excel. It covers creating a data validation dropdown list for athlete names, using INDEX and MATCH functions to retrieve athlete data, and implementing error checking in formulas. The tutorial also demonstrates using VLOOKUP to find athlete positions, ensuring viewers can handle errors and verify results effectively.

What is the primary task described in the introduction of the exercise?

• Generating a data validation drop-down list

• Creating a chart of athlete performances

• Writing a report on athlete statistics

• Designing a new athlete training program

Which function is suggested for error checking in the lookup formula?

• AVERAGEIF

• COUNTIF

• SUMIF

• IFERROR

What is the first step in creating a data validation drop-down list?

• Select the athlete names

• Open the Data Validation menu

• Enter the formula in the cell

• Format the cell as a table

Which lookup function is used to find the bib number in the example?

• HLOOKUP

• FILTER

• VLOOKUP

• INDEX and MATCH

What is the purpose of using the MATCH function in the lookup formula?

• To filter the results

• To sort the data

• To find the row number

• To find the column number

Which function is used to retrieve the athlete's position in the final example?

• INDEX

• MATCH

• HLOOKUP

• VLOOKUP

What is the result when the lookup value is not found in the table?

• The value 'not found'

• A blank cell

• An error message

• The first value in the table