Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Microsoft 77-427 Microsoft Excel 2013 Expert Part 1 Exam Practice Test

Page: 1 / 6
Total 62 questions

Microsoft Excel 2013 Expert Part 1 Questions and Answers

Question 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)

Options:

Page: 1 / 6
Total 62 questions