77-420 Exam Dumps : Excel 2013

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

Step 2: In the Insert Function dialog box select Category Statistical, select function COUNTIF, 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.Press Enter.

Step 5:In the Function Arguments Dialog box, in the Criteria field type: 0. Then click the OK button.

Step6: Copy cellF7 downwards until cellF29.

Result will be like:

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

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

Formula.

Find the minimum homework score for each student.

Answer:

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

Step 2: In the Insert Function dialog box select Category Statistical, select function MIN, 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 cell D7 downwards until cell D29.

Result will be like:

Step 1:Click Cell B2. Type the text: Date

Step 2: Click cell C2. Type the text: 22-Aug

Step 3: Click cell D2. Type the text: 29-Aug

Step 3:Click cell C2, then shift-click cell D2.

Step 4:Copy until cell S2(by dragging from cell D2 to cell S2).