Microsoft MOS 77-420 Questions & Answers

• Question 1:

  Modify the text in the title.

  Cell A1.

  Text "Math 1080 - Section 3 Assignments"

  Correct Answer: Use the following steps to complete this task in explanation:

  Step 1:Click cell A1 Step 2:Change the text by typing to: Math 1080 - Section 3 Assignments

• Question 2:

  Insert data from a text file.

  Cell A1.

  File source Autumn.txt

  Tab-delimited

  Correct Answer: Use the following steps to complete this task in explanation:

  Step 1:Click cell A1.

  Step 2:Click the Data tab, and click the From Text button.

  

  The Text Import Wizard starts.

  Step 3:Make sure Delimited is select, and click Next.

  

  Step 4:Make sure Delimiters: Tab is selected. Then click Next.

  

  Step 5:Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.

  

• Question 3:

  Rename a table. Cell range B6:F29 Name: "Overview"

  Correct Answer: Use the following steps to complete this task in explanation:

  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.

  

• Question 4:

  Modify the document property.

  MathTracker.xlsx

  Subject "Homework"

  Correct Answer: Use the following steps to complete this task in explanation:

  Step 1:Click the File menu.

  

  Step 2:Select Info (if necessary) and click Show All Properties,

  

  Step 3:In the Subject textbox type: HomeWork and click theReturn button.

  

• Question 5:

  Rename the title of the chart.

  Chart

  Text "All Zero Scores"

  Correct Answer: Use the following steps to complete this task in explanation:

  Step 1:Click on the Chart.

  Step 2:Click on the Chart title.

  Step 3:Changeby typingthe title to:All Zero Scores

  

• Question 6:

  Modify the cell alignment settings.

  Cell range B3:B25

  Horizontal: Right (Indent)

  Correct Answer: Use the following steps to complete this task in explanation:

  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.

  

• Question 7:

  Create a hyperlink to another worksheet.

  Cell A2.

  Cell reference "A3"

  Sheet reference "Section 3" worksheet.

  Correct Answer: Use the following steps to complete this task in explanation:

  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.

  

• Question 8:

  Apply a style to the chart.

  Chart.

  Chart Styles Style 7

  Correct Answer: Use the following steps to complete this task in explanation:

  Step 1:Click on the chart.

  Step 2:On the Design tab, in the Chart Styles group, click theStyle 7chart style.

  

• Question 9:

  Formula.

  Count the number of 0 homework scores for each student.

  Cell range F7:F29

  Use function COUNTIF

  Range: all possible homework scores for each student on "Section 3" worksheet.

  Criteria: 0

  Correct Answer: Use the following steps to complete this task in explanation:

  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:

  

• Question 10:

  Modify the cell format to date.

  Cell range C2:S2

  Type: 14-Mar

  Locale (location): English (United States)

  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.