77-427 Exam Dumps | Use a function to insert a value in a cell Cell range I5:I299 Calculate the billable charge for each

Valid 77-427 Dumps shared by ExamDiscuss.com for Helping Passing 77-427 Exam! ExamDiscuss.com now offer the newest 77-427 exam dumps, the ExamDiscuss.com 77-427 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 77-427 dumps with Test Engine here:

Access 77-427 Dumps Premium Version
(62 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 6/12

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)

Correct Answer:

Use the following steps in explanation.
Explanation/Reference:
Explanation:
Step 1: Click cell I5, click the Insert Function button, select category Lookup & Reference, select VLOOKUP, and click OK.

Step 2: In the Functions arguments dialog box, for Lookup Value click cell C5, for Table_Array switch to Hourly_rates worksheet click Cell B2, shift-click cell C29.

Step 3: For Col_index_num type 2, for Range_lookup select FALSE, and click OK.

Step 4: Edit the Formula by typing *5 in the formula box, and change the B2 and C29 references to absolute references by clicking them and using the F4 key.