Online Access Free 77-420 Practice Test

Use the following steps to complete this task in
Explanation:
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:

Use the following steps to complete this task in
Explanation:
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.

Use the following steps to complete this task in
Explanation:
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.

Use the following steps to complete this task in
Explanation:
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.