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 argument in XLOOKUP determines the search order for values returned from the lookup_array?Amatch_modeBsearch_modeCnot_foundDreturn_array

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

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

Looking Up Data - INDEX() & MATCH()How do the INDEX() and MATCH() functions work together to fetch data?The MATCH() function uses the INDEX() function to ascertain the relative position of data in the lookup arrayMATCH() identifies equivalent values in the lookup and source tables, while INDEX() provides the position of those valuesINDEX() identifies the relative position in the source array and produces values for MATCH() to referenceThe MATCH() function, when placed inside the INDEX() function, gives the relative position of data within the lookup array