Prep
Bee
Pakistan
Free MCQ Practice Platform for Govt Job Exams
Home
MCQs
Quiz
Past Papers
FIA Prep
Contact
Quiz Mode
Login
Register
Preparing your study page...
Home
MCQs
Computer Science
MEDIUM
ENGLISH
Computer Science
What is the function of Vlookup formula in Excel ?
VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
Correct answer
B
VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
Option B
C
VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
Option C
D
VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.
Option D
Correct answer: A
Explanation
No explanation provided for this MCQ yet.
Hide Answer
Hide Explanation
Start Related Quiz
Submit Correction
More MCQs