Free Preparation Discussions
MENU
Microsoft Exam 77-427 Topic 9 Question 25 Discussion
Topic #: 9
You work as a Sales Manager for Maini Industries. Your company manufactures and sells construction equipment. You have to create a report that will show the highest selling items of each month. The report will be in the following format:
In a workbook, you create a table named Item_table as shown below:
You fill in the required entries in the workbook.
For the third column of the sheet, you want to use formulas to fill in the values. You want the cells in the third column to get automatically filled with the names corresponding to ItemID in the second column. You want the exact values to be filled in the column. You select the C2 cell in the third column.
Which of the following formulas will you enter in order to accomplish the task?
In order to accomplish the task, you will use the following formula: =VLOOKUP(B2,Item_table,2,FALSE) Answer option B is incorrect. According to the question, you want the exact values in the column. The TRUE value in the range_lookup argument provides the approximate match. Answer options C and D are incorrect. The VLOOKUP functions used in the formulas have wrong syntaxes.
Currently there are no comments in this discussion, be the first to comment!