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

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

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

Question 4Fill in the blank: When searching for the value in the first argument of the function, VLOOKUP looks in the _____ column of the specified location. 1 pointfalseleftmosttruerightmost