Microsoft
77-427 · Question #20
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…
The correct answer is A. Search for the value 12 in the first column of the range, and then returns the value that is. 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.
Create advanced formulas
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
How the community answered
(27 responses)- A74% (20)
- B7% (2)
- C4% (1)
- D15% (4)
Explanation
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.
Topics
#VLOOKUP#exact match#range lookup#lookup functions
Community Discussion
No community discussion yet for this question.