Home›Browse›MS Office & Productivity›MCQ
easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Question

What is the function of Vlookup formula in Excel ?

AVLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
BVLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
CVLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
DVLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.

Choose an option to check yourself, or reveal the answer and explanation instantly.

More MS Office & Productivity MCQs

Related MS Office & Productivity MCQs

View all

Test Yourself

Take a full quiz on MS Office & Productivity

Start Quiz

Exam Coverage

FPSCNTSCSSPPSC

Trust

Answer is visible after reveal
Explanation helps learning
Free topic quiz available

Subject

MS Office & Productivity

Save your progress

Create a free account to bookmark MCQs and track weak areas.

Register Free
Start QuizMore MCQs
Answer and explanation

Correct Answer: A: VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.

Explanation: The correct answer is A: VLOOKUP retrieves data based on specified criteria from the most left column of the table, searching vertically down for a specified value. The 'V' stands for vertical, meaning it searches down the first column of a table array. It then returns a value from the same row in a column you specify.

What is the function of Vlookup formula in Excel ? - MCQ Answer | M...