Are you facing challenges in your career? Would you like to better prove yourself to others by improving your ability? Would you like to have more opportunities to get promoted? Hurry to sign up for IT certification exam and get the IT certificate. Microsoft certification exam is one of the important exams. If you obtain Microsoft certificate, you will get a great help. Because Microsoft 77-420 training online is a very important exam, you can begin with passing 77-420 training online. Are you wandering how to pass rapidly 77-420 training online? GetCertKey certification training dumps can help you to achieve your goals.

The free demo download pdf: http://www.getcertkey.com/77-420_braindumps.html  

Microsoft 77-420 training online,Training material, get exam dumps

Exam Name: Excel 2013

NO.1 CORRECT TEXT

Add conditional formatting.
Color Scales: Green -White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell C3
Step 2:Shift-Click cell S25.
Step 3:On the Home tab, under Format, choose Conditional Formatting, and choose New
Rule...
Step 4:In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum
Color to Green.
Step 5:In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set
Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum
Color to Red. Finally click OK.

NO.2 CORRECT TEXT
Formula Find the average score of all student ids without a zero homework score. Cell L2
Use Function AVERAGEIF
Range F7:F29
Criteria: "0"
Average_range: "Homework"
Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell L2, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGEIF, and
click OK.
Step 3:In the function Arguments dialog box click the reference button. Step 4:Click cell F7, shift-click
cell F29, and press the enter key.
Step 5:In the Function Arguments dialog box in the Criteria box type: 0, in the Average_range box
type: Homework, and click the OK button.

Article Link: http://www.getcertkey.com/77-420_braindumps.html    

Who should take this exam?

A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013. These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.