Question

    In Excel, what does the VLOOKUP function

    do?
    A Validates data Correct Answer Incorrect Answer
    B Looks up a value in a table and returns a corresponding value Correct Answer Incorrect Answer
    C Creates a chart Correct Answer Incorrect Answer
    D Converts text to uppercase Correct Answer Incorrect Answer

    Solution

    Explanation: VLOOKUP searches for a value in the first column of a table and returns a value in the same row from another column.

    Practice Next