ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!

    Question

    Which of the following functions in MS Excel 365 is used

    to search for an item in a range of cells and then return the relative position of that item in the range?
    A CHOOSE Correct Answer Incorrect Answer
    B MATCH Correct Answer Incorrect Answer
    C VLOOKUP Correct Answer Incorrect Answer
    D Lookup Correct Answer Incorrect Answer

    Solution

    The MATCH function returns the relative position of a value in a range of cells. It is useful for locating data without retrieving the actual value. Knowledge Booster: 1. VLOOKUP retrieves data from a specific column. 2. CHOOSE selects a value based on index number. 3. MATCH is often paired with INDEX for advanced lookups. 4. Use MATCH for flexible and efficient data searches.

    Practice Next
    More MS Office Questions

    Relevant for Exams:

    ask-question