Download Excel 2013.77-420.SelfTestEngine.2017-07-15.17q.tqb

Step 1: Click on the picture.Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.  

Step 1: Open the correct worksheet (Summary Worksheet).Step 2: Click in cell B5.Step 3: Click on the insert function button.   Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.   Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.  

Step 1: Click cell C7, and the click the Insert Function Button.   Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, 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 C7 downwards until cell C29.   Result will be like:  

Step 1: Click cell C7, and then Shift-click cell C29Step 2: Click the Name box at the left end of the formula bar. Step 3: Type: Homework. Press ENTER.  

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. 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 E7, 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 cell E7 downwards until cell E29.   Result will be like:  

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.   Step 6: Copy cell F7 downwards until cell F29.   Result will be like:  

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 cell B6, and Shift-click cell F29.Step 2: Click the Insert tab, and click the Table button.   Step 3: In the Create Table dialog box click OK.   Step 4: In the Design tab, Table Styles select Table Style Medium 4.   Step 5: In the Design tab enable First Column.  

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.