77-420 Exam
A Complete Guide to mos exam 77-420
Practical of 77-420 free question materials and study guides for Microsoft certification for consumer, Real Success Guaranteed with Updated 77-420 pdf dumps vce Materials. 100% PASS Excel 2013 exam Today!
2021 Jan gmina lipka 77-420:
Q11. 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.
Q12. 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.
Q13. 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.
Q14. 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
Q15. 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.
Avant-garde gmina lipka 77-420:
Q16. 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.
Q17. 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.
Q18. 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.
Q19. 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.
Q20. 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.