Questions And Answers PDF
Microsoft 77-420 Excel 2013
Version: DEMO
http://www.TestWarrior.com/77-420-practice-exam.html
FOR 77-420 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/77-420-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Question 1 Insert a row. Directly below current row 1.
Aoswern Use the filliwiog steps ti cimplete this task io Explanatonn Step 1n Open the correct worksheet (Secton 3 Worksheet) Step 2n Click on a cell in row 2. Step 3n Right-click in the cell, and select Insert from the context menu. Step 4n In the Insert Dialog box select Entre row, and click OK.
Question 2 Apply a cell style Cell range A2nS2 Style 40% - Accent3
Aoswern Use the filliwiog steps ti cimplete this task io Explanatonn Step 1n Open the correct worksheet (Secton 3 Worksheet). Step 2n Click in cell A2. Step 3n Press down the Shif key and click in cell S2. Step 4n On the Home tab, under Format, scroll down untl you see 40% . Accent3, and click on it.
TestWarrior.com
2
Questions And Answers PDF
Question 3 Modify the cell format to date. Cell range C2nS2 Typen 14-Mar Locale (locaton)n English (United States)
Aoswern Use the filliwiog steps ti cimplete this task io Explanatonn Step 1n Open the correct worksheet (Secton 3 Worksheet). Step 2n Click in cell A2. Step 3n Press down the Shif key and click in cell S2. Step 4n On the Home tab, under Format, choose Format Cells.
Step 5n In the Format Cells dialog box, choose Date, 14-Mar, and Locale (locaton)n English (United States). Click OK.
TestWarrior.com
3
Questions And Answers PDF
Question 4 Add a header and the date for each of the columns (assignments) in the range. Cell B2. Text "Date". Cell Range C2n S2 Textn "22-Aug, 29-Aug,‌12-Dec"
Aoswern Use the filliwiog steps ti cimplete this task io Explanatonn Step 1n Click Cell B2. Type the textn Date Step 2n Click cell C2. Type the textn 22-Aug Step 3n Click cell D2. Type the textn 29-Aug Step 3n Click cell C2, then shif-click cell D2.
Step 4n Copy untl cell S2 (by dragging from cell D2 to cell S2).
TestWarrior.com
4
Questions And Answers PDF
Question 5 Modify the text in the ttle. Cell A1. Text "Math 1080 - Secton 3 Assignments"
Aoswern Use the filliwiog steps ti cimplete this task io Explanatonn Step 1n Click cell A1 Step 2n Change the text by typing ton Math 1080 - Secton 3 Assignments
TestWarrior.com
5
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual 77-420 Exam Questions With Answers.
http://www.TestWarrior.com/77-420-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/77-420-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
6