Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 -work on a two-way XLOOKUP

This video tutorial guides viewers through exercises to practice Excel skills, including two-way X lookups, using Choose and RandBetween functions for random assignments, and employing the Switch function to convert job ratings to grades. The tutorial provides step-by-step instructions and examples to ensure understanding and application of these Excel functions.

What is the purpose of creating data validation drop-down lists in Excel?

• To format cells with colors

• To automatically calculate totals

• To create charts

• To restrict data entry to specific values

Which Excel function is used to perform a two-way lookup?

• VLOOKUP

• HLOOKUP

• XLOOKUP

• INDEX

How does the CHOOSE function work in Excel?

• It filters data based on criteria

• It selects a value from a list based on an index number

• It generates random numbers

• It sorts data in ascending order

What is the role of the RANDBETWEEN function in the exercise?

• To create a sequence of numbers

• To calculate averages

• To generate random numbers within a specified range

• To find the maximum value

What is the main advantage of using the SWITCH function over lookup functions?

• It does not rely on external tables

• It is faster to execute

• It allows for more complex calculations

• It automatically updates data

In the context of the exercise, what does the SWITCH function do?

• It filters data by date

• It sorts data alphabetically

• It converts job ratings into grades

• It changes the color of cells

Which of the following is NOT a job rating mentioned in the exercise?

• Poor

• Excellent

• Very Good

• Satisfactory