Excel 2013: 77-420

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell B6, and shift-click cell F29.

Step 2: Click the Name box at the left end of the formula bar.

Step 3: Type: Overview. Press ENTER.

Correct 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.

Correct 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.