Microsoft Microsoft Certifications 77-420 Questions & Answers

• Question 21:

  Formula.

  Find themaximum homework score for each student.

  Cell rangeE7:E29

  Use Function MAX

  Number 1: maximum homework score for each student on "Section 3" worksheet.

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

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

  

  Step 2: In the Insert Function dialog box select Category Statistical, select function MAX, 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 cellE7 downwards until cellE29.

  

  Result will be like:

  

• Question 22:

  Formula.

  Find the minimum homework score for each student.

  Cell range D7:D29

  Number 1: minimum homework score for each student on "Section 3" worksheet.

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

  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.

  

  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:

  

• Question 23:

  Hide columns.

  Column A.

  Columns O through R.

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

  Step 1:Right-click on the A column header, and select Hide from the context menu.

  

  Step 2:Click on the O columns header, and then Shift-click on the R Column Header.

  Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.

  

• Question 24:

  Crop the picture.

  Books.jpg

  Crop to Shape Snip Same Side Corner Rectangle.

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

  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.

  

• Question 25:

  Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style

  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 theInserttab, and click the Table button.

  

  Step 3:In the Create Table dialog box click OK.

  

  Step 4:In the Design tab, Table Styles select Table Style Medium 4.

  

  Step 5:In the Design tab enable First Column.

  

• Question 26:

  Create a new named range.

  Cell range C7:C29.

  Name: "Homework"

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

  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.

  

• Question 27:

  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,

  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 4:Click cell C2, then shift-click cell D2.

  

  Step 5:Copy until cell S2(by dragging from cell D2 to cell S2).

  

• Question 28:

  Insert a row.

  Directly below current row 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 29:

  Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1 : "Students with no " Text 2: header of column F Absolute Reference

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

  Step 1:Click K2andClick on the insert function button.

  Step 2:Select Category: Text, the CONCATENATE function, and click OK.

  

  Step 3:In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the header of column F in the worksheet, press the enter Key

  

  Step 4:Press the OK button in the Function Arguments dialog box.

• Question 30:

  Change the color theme. MathTracker.xlsx Slipstream

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

  Step 1:Click the PAGE LAYOUT tab, click Colors, scroll down and select Slipstream.