Pass the Microsoft Microsoft Office Specialist 77-420 Questions and answers with CertsForce

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: Open the correct worksheet(Section 3 Worksheet).

Step 2: Click in cell A2.

Step 3: Press down the Shift key and click in cell S2.

Step 4:On the Home tab, under Format, scroll down until you see 40% . Accent3, and click on it.

Step 1:Click in cell B3, and then shift-click in cell S25.

Step 2:On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Step 3:Still in the Page Layout tab, Enable the Gridlines Print option.

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

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.

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: Open the correct worksheet (Section 3 Worksheet)

Step 2: Click on a cell in row 2.

Step 3: Right-click in the cell, and select Insert from the context menu.

Step 4: In the Insert Dialog box select Entire row, and click OK.

Step 1:Click K2andClick on the insert function button.

Step 2:Select Category: Text, the CONCATENATE function, and click OK.

Step 3:In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the header of column F in the worksheet, press the enter Key

Step 4:Press the OK button in the Function Arguments dialog box.

Step 1:Click on the New sheet button (in the left bottom corner).

Step 2:Right-click on the new worksheet, and click Rename from the context menu.

Step 3:Type: Section 5

Step 4:Press the enter key.