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

Question Report Error

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

A. Variable Lookup

B. Vertical Lookup

C. Value Lookup

D. Vector Lookup

Answer: Option B

Solution (By JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Word, the 'Compare' feature is used to:

A. Compare two versions of a document and show differences

B. Check grammar

C. Measure reading level

D. Compare document with a template

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Compare (Review tab) merges and highlights changes between two documents.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, what is the result of the formula =SUM(A1:A3, B1:B3) if A1=5, A2=3, A3=2, B1=1, B2=4, B3=2?

A. 17

B. 19

C. 12

D. 15

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
SUM(A1:A3) = 5+3+2 = 10, SUM(B1:B3) = 1+4+2 = 7, total 17.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In PowerPoint, to record a slide show with narration and timings, go to:

A. Insert tab -> Audio -> Record

B. Slide Show tab -> Record Slide Show

C. Transitions tab -> Timing

D. Animations tab -> Record

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Record Slide Show is under Slide Show tab.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs