77-420 Exam
The Up to the immediate present Guide To 77-420 paper Sep 2021
we provide Simulation Microsoft 77-420 test preparation which are the best for clearing 77-420 test, and to get certified by Microsoft Excel 2013. The 77-420 Questions & Answers covers all the knowledge points of the real 77-420 exam. Crack your Microsoft 77-420 Exam with latest dumps, guaranteed!
Q11. 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.
Q12. 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.
Q13. 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
Q14. 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.
Q15. 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.
Q16. 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.
Q17. 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.
Q18. 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.
Q19. 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.
Q20. 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.