Question 6 of 30
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
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.
Step 3: Still in the Page Layout tab, Enable the Gridlines Print option.
Use the following steps to complete this task in explanation:
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:Question 7 of 30
Hide columns.
Column A.
Columns O through R.
Column A.
Columns O through R.
Correct Answer:
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 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:Question 8 of 30
Insert a picture.
To the right of the data -
[1]
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.
[1] Use the following steps to complete this task in explanation:
Step 2: Click the INSERT tab, and then the Pictures command.
[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.
[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.
Use the following steps to complete this task in explanation:
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.
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"
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.
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.
Use the following steps to complete this task in explanation:
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.
Use the following steps to complete this task in explanation: