Which of the following statement is true about MATCH function?Group of answer choicesIt returns the position of a value in a listIt returns a value within a range.Its Match_type is always equal to 0Its Match _type is always equal to 1

Which of the following statement is true about INDEX function?Group of answer choicesIt returns a value at a specific row and column within a rangeIt returns the position of a value in a listYou can nest INDEX function within MATCH function to look up a value and return a related value in another columnAll of the answers are correct

What does the function re.match do?Optionsmatches a pattern at the start of the stringsuch a function does not existnone of the mentionedmatches a pattern at any position in the string

Match List – I with List – II.Choose the correct answer from the options given below:

Select the correct answerWhat does the function re.match do?Optionsmatches a pattern at any position in the stringnone of the mentionedsuch a function does not existmatches a pattern at the start of the string

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