Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

Microsoft 77-420 Exam Actual Questions

The questions for 77-420 were last updated on March 27, 2024.
  • Viewing page 1 out of 8 pages.
  • Viewing questions 1-4 out of 33 questions

Topic 1 - Single Topic

Question #1 Topic 1

Insert a row.
Directly below current row 1.

Reveal Solution Hide Solution   Discussion   1

Correct Answer: Use the following steps to complete this task in explanation:
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.

Question #2 Topic 1

Apply a cell style -

Cell range A2:S2 -

Style 40% - Accent3 -

Reveal Solution Hide Solution   Discussion  

Correct Answer: Use the following steps to complete this task in explanation:
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.

Question #3 Topic 1

Modify the cell format to date.

Cell range C2:S2 -

Type: 14-Mar -
Locale (location): English (United States)

Reveal Solution Hide Solution   Discussion  

Correct Answer: Use the following steps to complete this task in explanation:
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.

Question #4 Topic 1

Add a header and the date for each of the columns (assignments) in the range.
Cell B2.
Text "Date".

Cell Range C2: S2 -
Text: "22-Aug, 29-Aug,"¦12-Dec"

Reveal Solution Hide Solution   Discussion  

Correct Answer: Use the following steps to complete this task in explanation:
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).

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...