[Free] 2018(Aug) Ensurepass Microsoft 77-602 Dumps with VCE and PDF 31-40

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

MOS: Using Microsoft Office Excel 2007

Question No: 31

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell: VLOOKUP (12, A2:C10, 3, FALSE)

Which of the following actions will be performed by the formula?

  1. Search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

  2. Wrong syntax used.

  3. Search the value 12 in the third column of the range and then returns the value that is contained in the 12th column of the range and on the same column as the lookup value.

  4. Search the value 3 in the last column of the range, and then returns the value that is in the column of the range and on the same row as the lookup value.

Answer: A Explanation:

The formula will search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

Question No: 32

Martha works as an Office Executive for Tech Profile Inc. She uses Excel 2007 to create office reports. She often needs to fill names of all employees in each department of the company in her reports. Which of the following steps should she take to ease her task?

  1. Fill different columns with names of employees department-wise, in an Excel worksheet. Copy and paste the columns from the worksheet into a new sheet whenever required.

  2. Fill different columns with names of employees department-wise, in an Excel worksheet. Save the sheet as a template file.

    Use this template for creating reports.

  3. Create custom lists of employees department-wise in Excel. Use the Fill handle to fill the cell with the names of employees.

  4. Fill different columns with names of employees department-wise, in an Excel worksheet. Save the sheet and use it as a template.

Answer: C Explanation:

Martha should take the following steps to accomplish the task: Create custom lists of employees department-wise in Excel.

Use the Fill handle to fill the cell with the names of employees.

Microsoft Excel 2007 provides a feature to create a custom list to fill series through Fill handle. Take the following steps to create a custom list for AutoFill:

  1. Create and select the list on the Excel worksheet.

    Ensurepass 2018 PDF and VCE

  2. Open the Excel option through the Microsoft Office button gt; Excel Options. This will open the Excel Options window.

    Ensurepass 2018 PDF and VCE

  3. On the Excel Options Window, click the Edit Custom Lists button. This will open the Custom Lists dialog box.

  4. In the dialog box, click the Import button. Click the OK button.

Ensurepass 2018 PDF and VCE

Answer options D, B, and C are incorrect. There is no need to take these steps. By using the custom list, Martha can easily accomplish the task.

Reference. Windows Excel Help, Contents: quot;Fill data by using a custom fill seriesquot;

Question No: 33 HOTSPOT

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Excel 2007. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will chose to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

The Fill command is used to fill the active cell with the content of the adjacent cell. The Fill command is run through Home tab gt;

Ensurepass 2018 PDF and VCE

Editing group gt; Fill.

Click the Down, Right, Up, Left, or Series option to fill cells.

Reference. Windows Help, Contents: quot;Fill data automatically in worksheet cellsquot;

Question No: 34

You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team using Excel 2007. You want the report to appear in the following format:

Ensurepass 2018 PDF and VCE

Which of the following conditional formulas will you insert to accomplish the task?

A. =IF(E2gt;=1200,quot;Improve in Next Quarterquot;,quot;Well Donequot;)

B. =IF(E2lt;=1200,quot;Well Donequot;,quot;Improve in Next Quarterquot;)

C. =IF(E2gt;1200,quot;Improve in Next Quarterquot;,quot;Well Donequot;)

D. =IF(E2gt;=1200,quot;Well Donequot;,quot;Improve in Next Quarterquot;)

Answer: D Explanation:

In order to accomplish the task, you will have to insert the following formula in the F2 cell:

=IF(E2gt;=1200,quot;Well Donequot;,quot;Improve in Next Quarterquot;)

Answer option A is incorrect. This will display the wrong messages for the given conditions. The first expression after the logical condition is returned by the IF function when the condition is TRUE.

Answer option B is incorrect. This formula will not accomplish the task as the logical condition is not correct. The specified condition in this formula is testing for values less than or equal to 1200. Whereas, the question#39;s requirement is to evaluate values greater than or equal to 1200.

Answer option C is incorrect. This formula will not accomplish the task because of the two reasons. First, the equal sign is missing in the condition. Second, the expressions are not in the correct order.

Reference: Microsoft Excel 2007 Help, Contents: quot;IFquot;

Question No: 35 HOTSPOT

You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2007 application on the network. You open the application and see various changes in Excel 2007. You have to open an existing worksheet through the application.

Mark the option that you will click to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

You will have to click Office Button to accomplish the task

Ensurepass 2018 PDF and VCE

Question No: 36

You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2007. Your workbook includes several worksheets as shown in the image given below:

Ensurepass 2018 PDF and VCE

You want the sheet tabs of the sheets containing charts to appear in red color. Which of the following steps will you take to accomplish the task?

  1. Select the sheets containing charts.

    Select the Colors option in the Themes group on the Page Layout page.

  2. Select the sheets containing charts.

    Select the Effects option in the Themes group on the Page Layout page.

  3. Select the sheets containing charts.

    Right-click on the sheet tab.

    Choose the Tab Color option from the shortcut menu.

  4. Select the sheets containing charts. Right-click on the sheet tab.

Choose the Sheet Color option from the shortcut menu.

Answer: C Explanation:

According to the question, you want the sheet tabs of the sheets containing chart to appear in red color. In order to accomplish the task, you will have to take the following steps: 1.Select the sheets containing charts.

Ensurepass 2018 PDF and VCE

Answer options A and B are incorrect. These steps will affect the sheets itself, rather than affecting the appearance of sheet tabs.

Answer option D is incorrect. There is no such option as Sheet Color available in Excel 2007.

Question No: 37

You work as a Sales Manager for Blue Well Inc. You have created a sales report in Excel 2007. You are required to publish it to your company#39;s intranet. Before publishing it to the intranet, you want to save the report in PDF format. However, when you try to use the SAVE AS option, you are unable to find the option for saving the document in PDF format.

What is the most likely cause?

  1. The document is not protected.

  2. The required add-ins are not installed.

  3. Excel 2007 does not support saving documents in PDF format.

  4. The Save as PDF option is available under the Office button gt; Publish.

Answer: B Explanation:

The most likely cause of the issue is that the required add-ins are not installed to save the document in PDF format.

Question No: 38

You work as an Office Assistant for Peach Tree Inc. You receive an Excel file that is digitally signed and a digital certificate is attached with it. When you open the Digital Signature Detail window, the following icon is displayed.

Ensurepass 2018 PDF and VCE

Which of the following are the possible causes of the issue?

Each correct answer represents a complete solution. Choose all that apply.

  1. The publisher is not trusted.

  2. The digital signature is expired.

  3. The digital signature is invalid.

  4. The certificate associated with the digital signature was not issued by a certificate authority

    (CA).

  5. The certificate attached is not from your domain.

Answer: A,B,C,D Explanation:

A digital signature that presents issues shows the image with a red X in the Digital Signature detail windows. This icon is displayed due to any of the following listed reasons: The digital signature is expired.

The digital signature is invalid.

The certificate associated with the digital signature was not issued by a certificate authority (CA). The publisher is not trusted.

After verifying the cause of the issue, you can take one of the following steps to resolve it: Contact the source of the signed content, and let the source know that there is a issue with the signature.

If you feel that the macro or other active content associated with the document is trustworthy, you can save the document to a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system. You can explicitly trust the publisher.

Answer option E is incorrect. The certificate attached is not required to be from your domain to digitally sign a document. This will not display the error icon.

Reference. Microsoft Excel 2007 Help, Contents: quot;How to tell if a digital signature is trustworthyquot;

Question No: 39 HOTSPOT

You work as an Office Assistant for Rainbow Inc. You have created a workbook in Excel 2007. You have completed the data entry part on the worksheet. You want to set page breaks before printing the sheet. Choose one of the icons available in the status bar to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 PDF and VCE

In order to accomplish the task, you will have to switch to the Page Break Preview view of the worksheet. The Page Break Preview view is used to view a preview of where pages will break when the document is printed. In this view, you can also set the breaks by dragging break lines. The status bar of Excel 2007 displays the following icons to quickly switch the views:

Question No: 40

Ensurepass 2018 PDF and VCE

Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2007. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer message in the A1 cell of each sheet in the workbook as shown in the image given below:

Which of the following is the easiest way to accomplish the task?

  1. Select all the five sheets.

    Write a disclaimer message in the A1 cell of the active sheet.

  2. Write a disclaimer message in the A1 cell of the first sheet.

    In the other sheets, insert a formula that points to the A1 cell of the first worksheet.

  3. Write a disclaimer message in the A1 cell of the first sheet. Copy the disclaimer message and paste it on the remaining sheets.

  4. Select all the five sheets. Click the first sheet.

Write a disclaimer message in the A1 cell of the active sheet.

Answer: A Explanation:

In order to accomplish the task, Rick should take the following steps:

Ensurepass 2018 PDF and VCE

Select all the five sheets.

Write a disclaimer message in the A1 cell of the active sheet.

Selecting more than one sheet groups those sheets. When multiple sheets are selected, in an Excel 2007 workbook, data that a user enters or edits in the active sheet is reflected in all sheets in the group. To select all sheets, right-click a sheet tabs, and then click Select All Sheets on the shortcut menu.

Answer option D is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and message will only get inserted in the first sheet.

Answer options B and C are incorrect. Both these options will work but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on

multiple sheets.

Reference: Microsoft Excel 2007 Help, Contents: quot; Select one or multiple worksheetsquot;

100% Ensurepass Free Download!
77-602 PDF
100% Ensurepass Free Guaranteed!
77-602 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 Exams

  • Hot Exams

  • Hot Catageories

  • microsoft dumps

    62-193 Dumps
    70-243 Dumps
    70-246 Dumps
    70-247 Dumps
    70-331 Dumps
    70-332 Dumps
    70-333 Dumps
    70-334 Dumps
    70-339 Dumps
    70-341 Dumps
    70-342 Dumps
    70-345 Dumps
    70-346 Dumps
    70-347 Dumps
    70-348 Dumps
    70-354 Dumps
    70-355 Dumps
    70-357 Dumps
    70-383 Dumps
    70-384 Dumps
    70-385 Dumps
    70-398 Dumps
    70-410 Dumps
    70-411 Dumps
    70-412 Dumps
    70-413 Dumps
    70-414 Dumps
    70-417 Dumps
    70-461 Dumps
    70-462 Dumps
    70-463 Dumps
    70-464 Dumps
    70-465 Dumps
    70-466 Dumps
    70-467 Dumps
    70-469 Dumps
    70-470 Dumps
    70-473 Dumps
    70-475 Dumps
    70-480 Dumps
    70-481 Dumps
    70-482 Dumps
    70-483 Dumps
    70-484 Dumps
    70-485 Dumps
    70-486 Dumps
    70-487 Dumps
    70-488 Dumps
    70-489 Dumps
    70-490 Dumps
    70-491 Dumps
    70-492 Dumps
    70-494 Dumps
    70-496 Dumps
    70-497 Dumps
    70-498 Dumps
    70-499 Dumps
    70-517 Dumps
    70-532 Dumps
    70-533 Dumps
    70-534 Dumps
    70-535 Dumps
    70-537 Dumps
    70-640 Dumps
    70-642 Dumps
    70-646 Dumps
    70-673 Dumps
    70-680 Dumps
    70-681 Dumps
    70-682 Dumps
    70-684 Dumps
    70-685 Dumps
    70-686 Dumps
    70-687 Dumps
    70-688 Dumps
    70-689 Dumps
    70-692 Dumps
    70-694 Dumps
    70-695 Dumps
    70-696 Dumps
    70-697 Dumps
    70-698 Dumps
    70-703 Dumps
    70-705 Dumps
    70-713 Dumps
    70-734 Dumps
    70-735 Dumps
    70-740 Dumps
    70-741 Dumps
    70-742 Dumps
    70-743 Dumps
    70-744 Dumps
    70-745 Dumps
    70-761 Dumps
    70-762 Dumps
    70-764 Dumps
    70-765 Dumps
    70-767 Dumps
    70-768 Dumps
    70-773 Dumps
    70-774 Dumps
    70-775 Dumps
    70-776 Dumps
    70-778 Dumps
    70-779 Dumps
    70-980 Dumps
    70-981 Dumps
    70-982 Dumps
    74-343 Dumps
    74-344 Dumps
    74-409 Dumps
    74-678 Dumps
    74-697 Dumps
    77-418 Dumps
    77-419 Dumps
    77-420 Dumps
    77-421 Dumps
    77-422 Dumps
    77-423 Dumps
    77-424 Dumps
    77-425 Dumps
    77-426 Dumps
    77-427 Dumps
    77-428 Dumps
    77-600 Dumps
    77-601 Dumps
    77-602 Dumps
    77-603 Dumps
    77-604 Dumps
    77-605 Dumps
    77-725 Dumps
    77-726 Dumps
    77-727 Dumps
    77-728 Dumps
    77-729 Dumps
    77-730 Dumps
    77-731 Dumps
    77-853 Dumps
    77-881 Dumps
    77-882 Dumps
    77-883 Dumps
    77-884 Dumps
    77-885 Dumps
    77-886 Dumps
    77-887 Dumps
    77-888 Dumps
    77-891 Dumps
    98-349 Dumps
    98-361 Dumps
    98-362 Dumps
    98-363 Dumps
    98-364 Dumps
    98-365 Dumps
    98-366 Dumps
    98-367 Dumps
    98-368 Dumps
    98-369 Dumps
    98-372 Dumps
    98-373 Dumps
    98-374 Dumps
    98-375 Dumps
    98-379 Dumps
    98-380 Dumps
    98-381 Dumps
    98-382 Dumps
    98-383 Dumps
    98-388 Dumps
    AZ-100 Dumps
    AZ-101 Dumps
    AZ-102 Dumps
    INF-203x Dumps
    INF-204x Dumps
    INF-205x Dumps
    INF-206x Dumps
    MB2-700 Dumps
    MB2-701 Dumps
    MB2-702 Dumps
    MB2-703 Dumps
    MB2-704 Dumps
    MB2-706 Dumps
    MB2-707 Dumps
    MB2-708 Dumps
    MB2-709 Dumps
    MB2-710 Dumps
    MB2-711 Dumps
    MB2-712 Dumps
    MB2-713 Dumps
    MB2-714 Dumps
    MB2-715 Dumps
    MB2-716 Dumps
    MB2-717 Dumps
    MB2-718 Dumps
    MB2-719 Dumps
    MB2-877 Dumps
    MB5-705 Dumps
    MB6-700 Dumps
    MB6-701 Dumps
    MB6-702 Dumps
    MB6-703 Dumps
    MB6-704 Dumps
    MB6-705 Dumps
    MB6-884 Dumps
    MB6-885 Dumps
    MB6-886 Dumps
    MB6-889 Dumps
    MB6-890 Dumps
    MB6-892 Dumps
    MB6-893 Dumps
    MB6-894 Dumps
    MB6-895 Dumps
    MB6-896 Dumps
    MB6-897 Dumps
    MB6-898 Dumps