Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column? MCQ with Answer and Explanation

Question
Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column?
A. VLOOKUP
B. LOOKUP
C. MATCH
D. HLOOKUP
Answer: Option A
Solution (By JKSSB Mock Tests)
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In Excel, the function to return the position of a substring within a string is:
A. FIND()
B. SEARCH()
C. MATCH()
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both FIND and SEARCH return the starting position of a substring. FIND is case-sensitive, SEARCH is not. MATCH is for ranges.
This question belongs to: Computer Microsoft Office
Question #2
The shortcut to switch between open workbooks in Excel is:
A. Ctrl + Tab
B. Both A and C
C. Ctrl + F6
D. Alt + Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Tab and Ctrl+F6 switch between open Excel workbook windows.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which of the following is a valid data type for storing monetary values?
A. Number
B. Currency
C. Decimal
D. Double
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Currency is a specific data type designed for monetary values with fixed decimal precision to avoid rounding errors. Number can also store monetary but Currency is more appropriate.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.