[Free] 2018(Aug) Ensurepass Microsoft 77-420 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Aug Microsoft Official New Released 77-420
100% Free Download! 100% Pass Guaranteed!

Excel 2013

Question No: 11 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.

Ensurepass 2018 PDF and VCE

Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.

Ensurepass 2018 PDF and VCE

Question No: 12 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.

Ensurepass 2018 PDF and VCE

Step 3:Still in the Page Layout tab, Enable the Gridlines Print option.

Ensurepass 2018 PDF and VCE

Question No: 13 CORRECT TEXT

Hide columns. Column A.

Columns O through R.

Answer: Use the following steps to complete this task in explanation:

Explanation:

Step 1:Right-click on the A column header, and select Hide from the context menu.

Ensurepass 2018 PDF and VCE

Step 2:Click on the O columns header, and then Shift-click on the R Column Header. Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.

Ensurepass 2018 PDF and VCE

Question No: 14 CORRECT TEXT

Rename the title of the chart. Chart

Text quot;All Zero Scoresquot;

Answer: Use the following steps to complete this task in explanation:

Explanation:

Step 1:Click on the Chart. Step 2:Click on the Chart title.

Step 3:Changeby typingthe title to:All Zero Scores

Ensurepass 2018 PDF and VCE

Question No: 15 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.

Ensurepass 2018 PDF and VCE

Question No: 16 CORRECT TEXT

Formula

Find the average score of all student ids without a zero homework score. Cell L2

Use Function AVERAGEIF Range F7:F29

Criteria: quot;0quot;

Average_range: quot;Homeworkquot;

Answer: Use the following steps to complete this task in explanation:

Explanation:

Step 1:Click cell L2, and the click the Insert Function Button.

Ensurepass 2018 PDF and VCE

Step 2: In the Insert Function dialog box select Category Statistical, select function

AVERAGEIF, and click OK.

Ensurepass 2018 PDF and VCE

Step 3:In the function Arguments dialog box click the reference button.

Ensurepass 2018 PDF and VCE

Step 4:Click cell F7, shift-click cell F29, and press the enter key.

Ensurepass 2018 PDF and VCE

Step 5:In the Function Arguments dialog box in the Criteria box type: 0, in the Average_range box type: Homework, and click the OK button.

Ensurepass 2018 PDF and VCE

Question No: 17 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.

Ensurepass 2018 PDF and VCE

The Text Import Wizard starts.

Step 3:Make sure Delimited is select, and click Next.

Ensurepass 2018 PDF and VCE

Step 4:Make sure Delimiters: Tab is selected. Then click Next.

Ensurepass 2018 PDF and VCE

Step 5:Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.

Ensurepass 2018 PDF and VCE

Question No: 18 CORRECT TEXT

Add a worksheet

After other worksheets Rename quot;Section 5quot;

Answer: Use the following steps to complete this task in explanation:

Explanation:

Step 1:Click on the New sheet button (in the left bottom corner).

Ensurepass 2018 PDF and VCE

Step 2:Right-click on the new worksheet, and click Rename from the context menu.

Ensurepass 2018 PDF and VCE

Step 3:Type: Section 5 Step 4:Press the enter key.

Question No: 19 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.

Ensurepass 2018 PDF and VCE

Step 3:From the Insert Picture dialog box select the Books.jpg file.

Question No: 20 CORRECT TEXT

Create a hyperlink to another worksheet. Cell A2.

Cell reference quot;A3quot;

Sheet reference quot;Section 3quot; 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.

Ensurepass 2018 PDF and VCE

Step 3:In the Insert Hyperlink dialog box, in the Type the cell reference: type A3, select Cell Reference #39;Section 3#39;, and click OK.

Ensurepass 2018 PDF and VCE

100% Ensurepass Free Download!
77-420 PDF
100% Ensurepass Free Guaranteed!
77-420 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Categories

  • Tags

  • Hot Exam List

  • Hot Exams

  • Hot Catageories List