Excel 2013

Here you have the best Microsoft 77-420 practice exam questions

You have 30 total questions to study from
Each page has 5 questions, making a total of 6 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 28, 2025
This site is not affiliated with or endorsed by Microsoft.

Question 1 of 30

Insert a row.
Directly below current row 1.

Correct Answer:

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.
Exam 77-420: Question 1 - Image 1

Use the following steps to complete this task in explanation:

Question 2 of 30

Apply a cell style -

Cell range A2:S2 -

Style 40% - Accent3 -

Correct Answer:

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.
Exam 77-420: Question 2 - Image 1

Use the following steps to complete this task in explanation:

Question 3 of 30

Modify the text in the title.
Cell A1.
Text "Math 1080 - Section 3 Assignments"

Correct Answer:

Question 4 of 30

Modify the cell alignment settings.

Cell range B3:B25 -
Horizontal: Right (Indent)

Correct Answer:

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.
Exam 77-420: Question 4 - Image 1

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.
Exam 77-420: Question 4 - Image 2

Use the following steps to complete this task in explanation:

Question 5 of 30

Add conditional formatting.
Color Scales: Green ""White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"

Correct Answer:

Step 1: Click cell C3 -
Step 2: Shift-Click cell S25.
Step 3: On the Home tab, under Format, choose Conditional Formatting, and choose New Rule...
Exam 77-420: Question 5 - Image 1

Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.
Exam 77-420: Question 5 - Image 2

Step 5: In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number,
Maximum value to 25, and Maximum Color to Red. Finally click OK.
Exam 77-420: Question 5 - Image 3

Use the following steps to complete this task in explanation: