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

Submitted by: Aziz Ur Rehman

Mcq Added by:

Microsoft Excel Mcqs
Microsoft Excel Mcqs for Preparation -Ms Excel Mcqs - PakMcqs.com Microsoft Excel Mcqs for Preparation. Ms Excel Mcqs are very important Mcqs in Computer section.its very important to know the basic Knowledge of computer.Most of the test conductors like FPSC, NTS, KPPSC, PPSC SPSC and others, are adding computer knowledge MCQs in their test patron.

IF YOU THINK THAT ABOVE POSTED MCQ IS WRONG.

PLEASE COMMENT BELOW WITH CORRECT ANSWER AND ITS DETAIL EXPLANATION.

Leave a Reply

Your email address will not be published. Required fields are marked *