Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 77-427 Topic 3 Question 45 Discussion

Actual exam question for Microsoft's exam
Question #: 45
Topic #: 3
[All Questions]

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?

Show Suggested Answer Hide 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.


Comments

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


Save Cancel