Question

    Consider the following statement about MATCH() function

    of MS-Excel 2010: P: It searches for a specified item in a range of cells, and then returns the relative position of that item in the range. Q: The MATCH function syntax is MATCH(lookup_value, lookup_array, [match_type]) R: All the arguments in a MATCH() function are required. Which of the following statement(s) is/are true
    A Only Q Correct Answer Incorrect Answer
    B All P, Q, R Correct Answer Incorrect Answer
    C Only P and R Correct Answer Incorrect Answer
    D Only P and Q Correct Answer Incorrect Answer

    Solution

    The correct answer is D

    Practice Next