In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in:

A. The row 102

B. The entire range

C. The first column of the range A2:C10

D. The second column

Answer: Option C

Solution (By JKSSB Mock Tests)

VLOOKUP searches the first column of the table_array.

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 Word, to add a border to a page, go to:

A. Design -> Page Borders

B. Insert -> Borders

C. Home -> Borders

D. Layout -> Borders

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Page Borders is under Design tab.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, to add a sound that plays across multiple slides, use:

A. Animations -> Sound

B. Insert -> Audio -> Play Across

C. Audio Tools Playback -> Play Across Slides

D. Transitions -> Sound

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Play Across Slides under Playback tab.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function is used to calculate the future value of a lump sum?

A. PV

B. PMT

C. FV

D. NPER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
FV can calculate future value of a lump sum (if PMT=0).

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs