New 👉 Ask your RBI Grade B 2025 Preparation Queries Here!!

    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

    Relevant for Exams: