77-420 Exam
Finding Rebirth 77-420 vce
Breathing of 77-420 free exam questions materials and study guides for Microsoft certification for IT candidates, Real Success Guaranteed with Updated 77-420 pdf dumps vce Materials. 100% PASS Excel 2013 exam Today!
Q1. 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).
Q2. 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.
Q3. 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.
Q4. 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).
Q5. 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.
Q6. 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.
Q7. 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.
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
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
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click in cell B3, and then shift-click in cell S25.
Step 2:On the Page Layout tab, in the Page Setup group, click Print Area, and then click
Set Print Area.
Step 3:Still in the Page Layout tab, Enable the Gridlines Print option.