Ensurepass.com : Ensure you pass the IT Exams
2018 Aug Microsoft Official New Released 70-462
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.
Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.
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.
Step 3:Still in the Page Layout tab, Enable the Gridlines Print option.
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.
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.
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
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.
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.
Step 2: In the Insert Function dialog box select Category Statistical, select function
AVERAGEIF, and click OK.
Step 3:In the function Arguments dialog box click the reference button.
Step 4:Click cell F7, shift-click cell F29, and press the enter key.
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.
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.
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.
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).
Step 2:Right-click on the new worksheet, and click Rename from the context menu.
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.
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.
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.