Asked in PPSC, FPSC and other one-paper exams (compiled from unofficial resources).
Microsoft Office & ProductivityMS Excel
What function does VLOOKUP perform in an Excel spreadsheet?
- A.It looks up a value vertically and returns a corresponding value from the same rowCorrect answer
- B.It looks up a value horizontally and returns a corresponding value from the same column
- C.It searches for a value and returns its cell reference only
- D.It combines values from multiple cells into a single string
Timed quizzes, instant results, track your progress — free
Practice these MCQs in the appQuick fact: VLOOKUP looks up a value vertically in the first column of a range and returns a corresponding value from the same row in a specified column.