Which TWO of the following statements are true for XLOOKUP()?1 pointThe lookup array and return array have to be the same size.The lookup array and return array have to be next to each other.The lookup array and return array have to be on the same worksheet.You can set up a default value or string to return if the searched-for value is not found.

Which of the following statements about XLOOKUP is true?AIt requires the lookup and return arrays to be sortedBIt only works with numeric dataCIt doesn't support approximate matchesDIt can't handle multi-sheet workbooks

Which argument in XLOOKUP determines the search order for values returned from the lookup_array?Amatch_modeBsearch_modeCnot_foundDreturn_array

How does XLOOKUP handle multiple matches in the search array?AReturns the first match foundBReturns an array of all matching valuesCReturns the last match foundDIt depends on the order of values in the search array

If you use the VLOOKUP function to find a value, which of the following are required?1) The value you want to look up2) The range where the lookup value is located3) The column number in the range that contains the return value4) You can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you do not specify anything, the default value will always be TRUE or approximate match.Question 18Select one:a.1,2,3,4b.2,3,4c.1,2,3d.1,2

To search for multiple matches using XLOOKUP, what should be done with the formula?ANothing, XLOOKUP automatically returns multiple matchesBUse nested XLOOKUP functions within a single formulaCAdd the "search_mode" argument with the value for multiple matchesDConvert the search value to an array formula