77-420 무료 덤프문제 온라인 액세스

Use the following steps to complete this task in
Explanation:
Step 1:Click Cell B2. Type the text: Date Step 2: Click cell C2. Type the text: 22-Aug Step 3: Click cell D2. Type the text: 29-Aug Step 3:Click cell C2, then shift-click cell D2.

Step 4:Copy until cell S2(by dragging from cell D2 to cell S2).

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

Use the following steps to complete this task in
Explanation:
Step 1:Click cell C3
Step 2:Shift-Click cell S25.
Step 3:On the Home tab, under Format, choose Conditional Formatting, and choose New
Rule...

Step 4:In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.

Step 5:In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.

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: