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. Vertical Lookup

B. Variable Lookup

C. Value Lookup

D. Vector Lookup

Answer: Option A

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, a query that groups data and calculates sums, averages, or counts is known as:

A. Totals query

B. Parameter query

C. Select query

D. Crosstab query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Totals query (using Group By, Sum, Avg, etc.) aggregates data. Crosstab query also aggregates but in a cross-tab format.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which action query adds records from a query result to an existing table?

A. Append query

B. Update query

C. Delete query

D. Make-Table query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Append query inserts rows.

This question belongs to: Computer Microsoft Office

Question #3

To launch the 'Slide Show' from the beginning in PowerPoint, press:

A. F5

B. Alt + F5

C. Shift + F5

D. Ctrl + F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F5 from beginning.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs