77-420 Online Practice Questions and Answers

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell B6, and shift-click cell F29.

Step 2: Click the Name box at the left end of the formula bar.

Step 3: Type: Overview. Press ENTER.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click the File menu.

Step 2:Select Info (if necessary) and click Show All Properties,

Step 3:In the Subject textbox type: HomeWork and click theReturn button.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click on the Chart.

Step 2:Click on the Chart title.

Step 3:Changeby typingthe title to:All Zero Scores

Correct Answer: Use the following steps to complete this task in explanation:

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.

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.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell A2.

Step 2:On the Insert tab, in the Links group, click Hyperlink.

Step 3:In the Insert Hyperlink dialog box, in the Type the cell reference: type A3, select Cell Reference 'Section 3', and click OK.

Correct Answer: 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, choose Format Cells.

Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.

Correct Answer: 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.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click on the New sheet button (in the left bottom corner).

Step 2:Right-click on the new worksheet, and click Rename from the context menu.

Step 3:Type: Section 5 Step 4:Press the enter key.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click on the picture.

Step 2:In the Format menu (which is displayedautomatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.

Correct Answer: 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.