What does the VLOOKUP function do in Excel? MCQ with Answer and Explanation

Question

Share Report Error

What does the VLOOKUP function do in Excel?

A. Returns the current date and time

B. Rounds a number to a specified number of digits

C. Counts the number of cells that meet a condition

D. Searches for a value in the first column of a table and returns a value in the same row from a specified column

Answer: Option D

Solution (By JKSSB Mock Tests)

VLOOKUP looks up a value vertically. It searches down the first column and returns a value from another column in that row.

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

Share Report

In MS PowerPoint, which pane is used to alter the sequence order, adjust triggers, or apply delays to individual slide entry animations?

A. Animation Pane

B. Transition Properties

C. Slide Master Layout

D. Selection Pane

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Animation Pane opens on the right side of the screen, allowing users to fine-tune animation timings, ordering, and playback mechanics.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)?

A. #DIV/0!

B. #NAME?

C. #VALUE!

D. #NUM!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The #NUM! error indicates a problem with a number in a formula, such as an argument that falls outside a function's supported domain (e.g., performing a square root on a negative number).

This question belongs to: Computer Microsoft Office