Lookup Function Types Overview
In MS Excel, a formula that looks for a value in the leftmost column of a table and then returns a value in the same row for a specific column is called:
Answer: Vertical Lookup
Explanation
The VLOOKUP (Vertical Lookup) function in MS Excel searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
For example
This is one of the most commonly used functions for finding and retrieving data in structured tables.
This question appeared in
Past Papers (5 times)
PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
PPSC Past Papers (1 times)
PPSC PHP ASI Past Papers and Syllabus (1 times)
PPSC Punjab Police ASI Past Papers and Syllabus (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- You need to jump to the next column breaking current column right at the cursor position. How can you break column ?
- In Excel Spacing in the column is called?
- How do you delete a column in MS Excel?
- The _____ option is used to show a specific row or column on every printed page.
- Which key is used for Excel to select the whole column highlight?
- The freezing row and column in Excel is in which pane
- Which key should be pressed continuously while moving a column in MS Excel?
- To select an entire column in MS Excel, press?
- In MS Word 2007, to select a column of the table from bottom to top, press?
- In MS Excel, which function automatically total a column or row of values?
