77-420 Exam
Avant-garde 77-420: Ucertify real rapidshare from 11 to 20
Your success in Microsoft 77-420 is our sole target and we develop all our 77-420 braindumps in a way that facilitates the attainment of this target. Not only is our 77-420 study material the best you can find, it is also the most detailed and the most updated. 77-420 Practice Exams for Microsoft Office 77-420 are written to the highest standards of technical accuracy.
Q11. CORRECT TEXT
Insert a row.
Directly below current row 1.
Answer: Use the following steps to complete this task in explanation:
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.
Q12. 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.
Q13. CORRECT TEXT
Rename the title of the chart. Chart
Text "All Zero Scores"
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click on the Chart.
Step 2:Click on the Chart title.
Step 3:Changeby typingthe title to:All Zero Scores
Q14. 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.
Q15. CORRECT TEXT
Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows
Horizontal Axis Labels: "IDs" column in table
Series 1: "Zero Scores" column in table.
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click in a cellin the data table, and then click on the INSERT tab.
b
Step 2:Click Insert Column Chart, and select 3-D Clustered Column.
Step 3:If necessary move the chart to the right of the table.
Step 4:Click the Select Data button.
Step 5:In the Select Data Source dialog box click the Switch Row/Column button, Deselect everything except IDs for Horizontal Axis Labels, deselect everything excepts Series1 for Legend Entries (series), and click OK.
Q16. 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.
Q17. CORRECT TEXT
Modify the cell format to date.
Cell range C2:S2
Type: 14-Mar
Locale (location): English (United States)
Answer: Use the following steps to complete this task in explanation:
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.
Q18. CORRECT TEXT
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Open the correct worksheet (Summary Worksheet).
Step 2:Click in cell B5.
Step 3:Click on the insert function button.
Step 4:In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.
Step 5:In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.
Q19. 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.
Q20. CORRECT TEXT
Insert a picture.
To the right of the data
File source Books.jpg
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click in a cell to the right of the data.
Step 2:Click the INSERT tab, and then the Pictures command.
Step 3:From the Insert Picture dialog box select the Books.jpg file.