Microsoft Excel 2013 77-420 Exam Dumps: Updated Questions & Answers (October 2025)

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.

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:Click Cell B2. Type the text: Date

Step 2: Click cell C2. Type the text: 22-Aug

Step 3: Click cell D2. Type the text: 29-Aug

Step 3:Click cell C2, then shift-click cell D2.

Step 4:Copy until cell S2(by dragging from cell D2 to cell S2).

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 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.

Step 1:Click in a cellin the data table, and then click on the INSERT tab.

b

Step 2:Click Insert Column Chart, and select 3-D Clustered Column.

Step 3:If necessary move the chart to the right of the table.

Step 4:Click the Select Data button.

Step 5:In the Select Data Source dialog box click the Switch Row/Column button, Deselect everything except IDs for Horizontal Axis Labels, deselect everything excepts Series1 for Legend Entries (series), and click OK.

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.

Step 1:Click cell L2, and the click the Insert Function Button.

Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGEIF, and click OK.

Step 3:In the function Arguments dialog box click the reference button.

Step 4:Click cell F7, shift-click cell F29, and press the enter key.

Step 5:In the Function Arguments dialog box in the Criteria box type: 0, in the Average_range box type: Homework, and click the OK button.

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.