Microsoft 77-420 Excel 2013 Exam Practice Test

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:

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

Step 2:Click theInserttab, 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:Click on the Chart title.

Step 3:Changeby typingthe title to:All Zero Scores

Step 1:Click cell C7, and then Shift-click cell C29

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

Step 3:Type: Homework. Press ENTER.