Free Practice Questions for Microsoft 77-420 Exam

Step 1:Click in a cell to the right of the data.

Step 2:Click the INSERT tab, and then the Pictures command.

Step 3:From the Insert Picture dialog box select the Books.jpg file.

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.

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.

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.

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.

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.

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

Step 2:Click theInserttab, and click the Table button.

Step 3:In the Create Table dialog box click OK.

Step 4:In the Design tab, Table Styles select Table Style Medium 4.

Step 5:In the Design tab enable First Column.

Step 1:Click on the Chart.

Step 2:Click on the Chart title.

Step 3:Changeby typingthe title to:All Zero Scores