Microsoft
77-427 · Question #20
77-427 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
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?
Options
- ASearch for the value 12 in the first column of the range, and then returns the value that is
- BWrong syntax used.
- CSearch the value 3 in the last column of the range, and then returns the value that is in the
- DSearch the value 12 in the third column of the range and then returns the value that is
Unlock 77-427 to see the answer
You've previewed enough free 77-427 questions. Unlock 77-427 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.