77-420 Sample Questions Answers

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 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.

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

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:Right-click on the A column header, and select Hide from the context menu.

Step 2:Click on the O columns header, and then Shift-click on the R Column Header.

Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.

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: