Question 6 of 30
Modify the cell alignment settings.

Cell range B3:B25 -
Horizontal: Right (Indent)
Correct Answer:
Step 1: Click cell B3.

Step 2:Shift-click cell B25 -
Step 3: Right-click somewhere in the B3-B25 cell range, and choose Format Cells from the context menu.
Exam 77-420: Question 6 - Image 1
Step 4: In the Format Cells dialog box click the Alignment Tab, change Horizontal: to Right (Indent), change Indent: to 1, and then click the OK button.
Exam 77-420: Question 6 - Image 2 Use the following steps to complete this task in explanation:
Question 7 of 30
Add conditional formatting.
Color Scales: Green ""White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Correct Answer:
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...
Exam 77-420: Question 7 - Image 1
Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.
Exam 77-420: Question 7 - Image 2
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.
Exam 77-420: Question 7 - Image 3 Use the following steps to complete this task in explanation:
Question 8 of 30
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
Correct Answer:
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.
Exam 77-420: Question 8 - Image 1
Step 3: Still in the Page Layout tab, Enable the Gridlines Print option.
Exam 77-420: Question 8 - Image 2 Use the following steps to complete this task in explanation:
Question 9 of 30
Hide columns.
Column A.
Columns O through R.
Correct Answer:
Step 1: Right-click on the A column header, and select Hide from the context menu.
Exam 77-420: Question 9 - Image 1
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.
Exam 77-420: Question 9 - Image 2 Use the following steps to complete this task in explanation:
Question 10 of 30
Insert a picture.

To the right of the data -
[1]
Correct Answer:
Step 1: Click in a cell to the right of the data.
Step 2: Click the INSERT tab, and then the Pictures command.
Exam 77-420: Question 10 - Image 1
[1] Use the following steps to complete this task in explanation: