Free Practice Questions for the Microsoft Office Specialist 77-420 Exam (2026 Updated)

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

Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, 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 C7 downwards until cell C29.

Result will be like:

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

Step 2: Change the text by typing to: Math 1080 - Section 3 Assignments

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.

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.