Microsoft Excel 2013 Expert Part One 77-427 Question # 3 Topic 1 Discussion

77-427 Exam Topic 1 Question 3 Discussion:

Question #: 3

Topic #: 1

Use a function to insert a value in a cell
Cell range I5:I299
Calculate the billable charge for each entry
Function VLOOKUP
Lookup_Value: "Name" (Column c) for each entry
Table_array: "Name" (column B), "Base Rate" (column C), on "Hourly_Rates" worksheet
Range_lookup: Only exact match
Multiply Function by "Duration" (column H)