Microsoft Exam 77-427 Topic 3 Question 45 Discussion

Actual exam question for Microsoft's exam

Question #: 45
Topic #: 3

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:

VLOOKUP(12, A2:C10, 3, FALSE )

Which of the following actions will be performed by the formula?

ASearch for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

BWrong syntax used.

CSearch the value 3 in the last column of the range, and then returns the value that is in the column of the range and on the same row as the lookup value.

DSearch the value 12 in the third column of the range and then returns the value that is contained in the 12th column of the range and on the same column as the lookup value.

Show Suggested Answer

Suggested Answer: A

The formula will search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

by Mariann at Aug 01, 2022, 01:38 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!