Excel XLOOKUP Quiz

What is the main advantage of XLOOKUP over older lookup functions like VLOOKUP and HLOOKUP?

• It can only search vertically.

• It can only search horizontally.

• It can search both vertically and horizontally.

• It is slower than VLOOKUP and HLOOKUP.

In which versions of Excel was XLOOKUP introduced?

• Excel 2016 and Office 2013

• Excel 2019 and Office 365

• Excel 2010 and Office 2016

• Excel 2007 and Office 2010

What is the purpose of the "lookup_value" in the XLOOKUP function?

• The range or array to return a value from.

• The value to search for.

• The range or array to search within.

• Specify the search order.

Which parameter in the XLOOKUP function specifies the range or array to search within?

• return_array

• lookup_value

• lookup_array

• match_mode

What does the "if_not_found" parameter in the XLOOKUP function do?

• Specifies the search order.

• Specifies the range to return a value from.

• Specifies the value to return if no match is found.

• Specifies the exact or approximate match.

In the XLOOKUP function, what is the role of the "match_mode" parameter?

• Specifies the search order.

• Specifies the value to search for.

• Specifies the range to return a value from.

• Specifies exact or approximate match.

What does the "search_mode" parameter in the XLOOKUP function specify?

• The value to search for.

• The range or array to search within.

• The search order (e.g., first to last or last to first).

• The value to return if no match is found.

What is the purpose of the 'Lookup Value' in XLOOKUP?

• The range from which to return the result.

• The data to search for.

• The range that contains the value you are looking for.

• The value or message to display if the lookup value is not found.

Which component of XLOOKUP specifies the range that contains the value you are looking for?

• Lookup Value

• Return Array

• Lookup Array

• If Not Found

What does the 'Return Array' in XLOOKUP refer to?

• The data to search for.

• The range from which to return the result.

• The range that contains the value you are looking for.

• The value or message to display if the lookup value is not found.