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

Question

Share Report Error

In Excel, what does the 'VLOOKUP' function stand for?

A. Vector Lookup

B. Variable Lookup

C. Vertical Lookup

D. Value Lookup

Answer: Option C

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

Which command tool in MS Excel removes duplicate rows from a selected data worksheet based on chosen columns?

A. Consolidate Data

B. Remove Duplicates

C. Data Validation

D. Text to Columns

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The 'Remove Duplicates' feature on the Data tab analyzes selected rows and permanently deletes duplicate entries.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key to open the 'Spelling' dialog in MS Excel?

A. Alt + F7

B. F7

C. Shift + F7

D. Ctrl + F7

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F7 opens the Spelling dialog in Excel as well as Word.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, to enter a new line within a cell, press:

A. Enter

B. Shift + Enter

C. Alt + Enter

D. Ctrl + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt+Enter starts a new line in the same cell.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs