Microsoft Excel 2021365 - Beginner to Advanced - Using XLOOKUP and XMATCH

The video introduces two new Excel 2021 functions, X LOOKUP and X MATCH, as alternatives to the traditional INDEX and MATCH functions. It explains the basic and advanced usage of X LOOKUP, including mandatory and optional arguments, and demonstrates how to use it with Excel tables. The video also covers the X MATCH function, highlighting its similarities to the MATCH function but with added flexibility and options.

What are the new functions introduced in Excel 2021 that are similar to INDEX and MATCH?

• FILTER and SORT

• SUMIF and COUNTIF

• VLOOKUP and HLOOKUP

• X LOOKUP and X MATCH

What is the primary benefit of using X LOOKUP over INDEX and MATCH?

• It is more accurate

• It uses fewer arguments

• It is easier to construct

• It is faster

Which of the following is NOT a mandatory argument in the X LOOKUP function?

• If not found

• Return array

• Lookup array

• Lookup value

In X LOOKUP, what happens if the lookup value is not found and no 'if not found' argument is specified?

• The function returns zero

• An error is returned

• The function returns a blank cell

• The function returns the first value

How can you specify a column in an Excel table when using X LOOKUP?

• By using square brackets to select the column

• By typing the column name directly

• By using parentheses

• By using curly braces

When using X LOOKUP with tables, how do you skip an optional argument?

• Leave it blank

• Use two commas

• Use a semicolon

• Use a dash

What does the search mode option in X LOOKUP allow you to do?

• Define the lookup value

• Select the return array

• Specify the order of search

• Choose the type of match

What result does X LOOKUP return when searching from last to first?

• The first occurrence

• The last occurrence

• The smallest value

• The largest value

Which function can be used as an alternative to MATCH in Excel 2021?

• FILTER

• HLOOKUP

• VLOOKUP

• X MATCH

What additional feature does X MATCH provide compared to the basic MATCH function?

• It can filter data

• It allows for multiple return values

• It includes a search mode option

• It can sort data automatically