In Excel, what does the 'VLOOKUP' function stand for? MCQ with Answer and Explanation

Question
In Excel, what does the 'VLOOKUP' function stand for?
A. Value Lookup
B. Vector Lookup
C. Variable Lookup
D. Vertical Lookup
Answer: Option D
Solution (By JKSSB Mock Tests)
VLOOKUP stands for Vertical Lookup, used to search for a value in the first column of a table and return a value in the same row from another column.
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 MS Access, which property makes a text field accept only uppercase letters?
A. Input Mask with >
B. Format property set to >
C. Validation Rule
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format > displays uppercase. Input mask > forces entry to uppercase. Both can achieve.
This question belongs to: Computer Microsoft Office
Question #2
What is the function of the keyboard shortcut Ctrl + Shift + L when working with an active data grid range in MS Excel?
A. Locks the selected cell ranges
B. Aligns cell contents to the left edge
C. Toggles AutoFilter drop-down arrows on or off
D. Inserts a bulleted list inside a cell text string
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Shift + L is the native keyboard shortcut to instantly apply or remove the dynamic AutoFilter toggle sorting keys on the active data range headers.
This question belongs to: Computer Microsoft Office
Question #3
What is the default orientation of a page in MS Word?
A. Letter
B. Portrait
C. A4
D. Landscape
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Default orientation is portrait. Landscape is wider.
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.