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

This video tutorial guides viewers through an exercise involving Excel functions. It covers creating data validation drop-down lists, using two-way X lookup to find sales totals, employing choose and rand between functions for random team assignments, and applying the switch function to convert job ratings to grades. The tutorial emphasizes practical application and testing of these functions within Excel.

What is the purpose of creating data validation drop-down lists in the context of this exercise?

• To automatically calculate sales totals

• To restrict data entry to specific values

• To format cells with colors

• To create a summary table

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

• INDEX

• XLOOKUP

• HLOOKUP

• VLOOKUP

What is the role of the RANDBETWEEN function in assigning team members to colors?

• To calculate the average team performance

• To filter team members by department

• To generate random numbers for color assignment

• To sort team members alphabetically

How does the CHOOSE function contribute to the random assignment of colors?

• It selects a color based on a random number

• It calculates the most frequent color

• It sorts colors alphabetically

• It filters colors by popularity

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

• It automatically updates with new data

• It does not rely on external tables

• It is easier to understand

• It allows for more complex calculations

In the SWITCH function, what does a value of '1' correspond to in terms of job rating?

• Excellent

• Very Good

• OK

• Poor

What is the output when the SWITCH function evaluates a job rating of '3'?

• Excellent

• Very Good

• Poor

• OK