New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Examstrust Logo
examstrust mcafee
  1. Home
  2. Microsoft
  3. Microsoft Office Specialist
  4. 77-427 - Microsoft Excel 2013 Expert Part 1

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

Page: 1 / 6
Total 62 questions
Get 77-427 Full Access Download 77-427 PDF

Microsoft Excel 2013 Expert Part 1 Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $139.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$55.5  $184.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$36  $119.99
Add to Cart
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:

Load More 77-427 Questions
Page: 1 / 6
Total 62 questions
Get 77-427 Full Access Download 77-427 PDF