Question

    In Microsoft Excel, what does the function VLOOKUP

    do?
    A Searches for a value in a column and returns the corresponding value from another column Correct Answer Incorrect Answer
    B Adds up all the values in a selected range Correct Answer Incorrect Answer
    C Multiplies the values in a selected range Correct Answer Incorrect Answer
    D Counts the number of cells in a range that contain numbers Correct Answer Incorrect Answer
    E none of these Correct Answer Incorrect Answer

    Solution

    VLOOKUP searches for a value in a specified column and returns a corresponding value from another column. It is commonly used for looking up information in tables.

    Practice Next