Microsoft 77-420 Dumps Questions Answers

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.

Step 1:Click the PAGE LAYOUT tab, click Colors, scroll down and select Slipstream.

Step 1: Click cellE7, and the click the Insert Function Button.

Step 2: In the Insert Function dialog box select Category Statistical, select function MAX, and click OK.

The function Arguments Dialog box appears:

Step 3: Click on the Section 3 tab (left bottom part of the window).

Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.

Step 5: Copy cellE7 downwards until cellE29.

Result will be like: