Question 6 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 6 - Image 1
    Step 3: Still in the Page Layout tab, Enable the Gridlines Print option.
    Exam 77-420: Question 6 - Image 2 Use the following steps to complete this task in explanation:
Question 7 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 7 - 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 7 - Image 2 Use the following steps to complete this task in explanation:
Question 8 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 8 - Image 1
    [1] Use the following steps to complete this task in explanation:
Question 9 of 30
Crop the picture.
[1]
Crop to Shape Snip Same Side Corner Rectangle.
    Correct Answer:
    Step 1: Click on the picture.
    Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.
    Exam 77-420: Question 9 - Image 1 Use the following steps to complete this task in explanation:
Question 10 of 30
Insert the instructor's name for column B.
Cell B5.

Use Function RIGHT -

Text: B2 -

Absolute reference -
Num_chars: "16"
    Correct Answer:
    Step 1: Open the correct worksheet (Summary Worksheet).
    Step 2: Click in cell B5.
    Step 3: Click on the insert function button.
    Exam 77-420: Question 10 - Image 1
    Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.
    Exam 77-420: Question 10 - Image 2
    Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.
    Exam 77-420: Question 10 - Image 3 Use the following steps to complete this task in explanation: