Download Excel 2013.77-420.TestKing.2018-06-19.14q.tqb

Step 1: Click in a cell to the right of the data.Step 2: Click the INSERT tab, and then the Pictures command.  Step 3: From the Insert Picture dialog box select the Books.jpg file.

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 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 on the chart.Step 2: On the Design tab, in the Chart Styles group, click the Style 7 chart style.