XLOOKUP in Excel Quiz

Which Excel versions support the XLOOKUP function?

• Excel 2019 and 2021

• Excel 2013 and 2016

• Excel 2021 and Microsoft 365

• Excel 2016 and 2019

What is the first step in creating an XLOOKUP formula?

• Type the formula name in lowercase

• Type an equal sign followed by the formula name

• Select the return array first

• Highlight the lookup array

What does the 'lookup value' parameter represent in XLOOKUP?

• The default value if not found

• The value to be returned

• The range of cells to search

• The value to match in the lookup array

Which parameter in XLOOKUP allows you to specify a value if the lookup value is not found?

• Match mode

• Return array

• Search mode

• If not found

What does the match mode parameter in XLOOKUP allow you to do?

• Specify the order of search

• Define how the lookup value is matched

• Select the return array

• Choose the lookup array

How can you lock cell references in an XLOOKUP formula?

• By using wildcard characters

• By selecting the return array first

• By typing the formula in uppercase

• By using the F4 key

What does the green flag in the top left-hand corner of a cell indicate?

• Formula is incomplete

• Formula is locked

• Formula omits adjacent cells

• Formula is correct

What is the purpose of the FX icon next to the formula in Excel?

• To save the formula

• To delete the formula

• To open the insert function helper

• To lock the formula

What is the main difference when using XLOOKUP for horizontal lookups?

• You use a different function name

• You don't need to lock cell references

• You use row headers instead of column headers

• You start with the return array

In the context of XLOOKUP, what is a humorous reason given for why XLOOKUP broke up with VLOOKUP?

• Because it found someone who can look both ways

• Because it was too slow

• Because it couldn't handle errors

• Because it was outdated