Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - VLOOKUP formula

This video tutorial covers the use of VLOOKUP and logical functions in Excel to manage and analyze data. It includes exercises on formatting data as tables, using VLOOKUP to find test scores and grades, applying logical functions to select venues, and using text functions for data cleaning. The tutorial provides practical examples and step-by-step guidance to ensure understanding and application of these functions.

What is the purpose of using VLOOKUP in the Test Scores worksheet?

How do you format data as a table in Excel?

How can you test if the VLOOKUP formula is working correctly?

What should you do if you encounter errors in the VLOOKUP formula?

What is the significance of naming a table in Excel?

How do you handle a situation where a student's average score is below the passing grade?

Describe how to use the IF function in conjunction with VLOOKUP.

Explain how to use logical functions to determine venue suitability.

What steps are involved in cleaning customer data using text functions?

What is the process for separating first and last names using Flash Fill?