77-420 Exam
What Up to the immediate present 77-420 Is?
Master the 77-420 Excel 2013 content and be ready for exam day success quickly with this Ucertify 77-420 braindumps. We guarantee it!We make it a reality and give you real 77-420 questions in our Microsoft 77-420 braindumps.Latest 100% VALID Microsoft 77-420 Exam Questions Dumps at below page. You can use our Microsoft 77-420 braindumps and pass your exam.
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
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.
Q3. CORRECT TEXT
Apply a cell style
Cell range A2:S2
Style 40% - Accent3
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, scroll down until you see 40% . Accent3, and click
on it.
Q4. 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.
Q5. 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.
Q6. 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.
Q7. 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.
Q8. CORRECT TEXT
Insert data from a text file.
Cell A1.
File source Autumn.txt
Tab-delimited
Answer: Use the following steps to complete this task in explanation:
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.
Q9. 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:
Q10. 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.