77-420 Exam
Shortcuts To 77-420（1 to 10）
It is more faster and easier to pass the Microsoft 77-420 exam by using Exact Microsoft Excel 2013 questuins and answers. Immediate access to the Improved 77-420 Exam and find the same core area 77-420 questions with professionally verified answers, then PASS your exam with a high score now.
Q1. CORRECT TEXT
Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1 : "Students with no " Text 2: header of column F Absolute Reference
Answer: Use the following steps to complete this task in explanation:
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.
Q2. CORRECT TEXT
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
Answer: Use the following steps to complete this task in explanation:
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.
Q3. CORRECT TEXT
Add conditional formatting.
Color Scales: Green –White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Answer: Use the following steps to complete this task in explanation:
Explanation:
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...
Step 4:In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.
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.
Q4. CORRECT TEXT
Apply a style to the chart.
Chart.
Chart Styles Style 7
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click on the chart.
Step 2:On the Design tab, in the Chart Styles group, click theStyle 7chart style.
Q5. CORRECT TEXT
Modify the text in the title. Cell A1.
Text "Math 1080 - Section 3 Assignments"
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click cell A1 Step 2:Change the text by typing to: Math 1080 - Section 3 Assignments
Q6. CORRECT TEXT
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Answer: Use the following steps to complete this task in explanation:
Explanation:
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:
Q7. CORRECT TEXT
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"
Answer: Use the following steps to complete this task in explanation:
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).
Q8. CORRECT TEXT
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Answer: Use the following steps to complete this task in explanation:
Explanation:
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:
Q9. CORRECT TEXT
Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.
Answer: Use the following steps to complete this task in explanation:
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.
Q10. CORRECT TEXT
Crop the picture.
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.
Answer: Use the following steps to complete this task in explanation:
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.