77-420 Microsoft Excel 2013 Free Practice Exam Questions (2025 Updated)

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.

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

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

Formula.

Find the minimum homework score for each student.

Answer:

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

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

The function Arguments Dialog box appears:

Step 3: Click on the Section 3 tab (left bottom part of the window).

Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.

Step 5: Copy cell D7 downwards until cell D29.

Result will be like:

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

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

The function Arguments Dialog box appears:

Step 3: Click on the Section 3 tab (left bottom part of the window).

Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2.Press Enter.

Step 5:In the Function Arguments Dialog box, in the Criteria field type: 0. Then click the OK button.

Step6: Copy cellF7 downwards until cellF29.

Result will be like:

Step 1: Open the correct worksheet (Section 3 Worksheet)

Step 2: Click on a cell in row 2.

Step 3: Right-click in the cell, and select Insert from the context menu.

Step 4: In the Insert Dialog box select Entire row, and click OK.

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