Braindumps Microsoft MCSD Dumps

70-410,70-411,70-412,70-413,70-414,70-417,70-461,70-462,70-463,70-464,70-465,70-480,70-483,70-486,70-487

Home » [Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-602 Dumps with VCE and PDF 1-10

[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-602 Dumps with VCE and PDF 1-10

EnsurePass
2017 Sep Microsoft Official New Released 77-602
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/77-602.html

MOS: Using Microsoft Office Excel 2007

Question No: 1

You work as a Sales Manager for Young World Inc. You have created a sales report that needs to be submitted to the head office. Before sending the report to your manager, you want to ensure that the integrity of the document is maintained. You also want to place your signature as shown in the image below:

Ensurepass 2017 PDF and VCE

Which of the following steps will you take to accomplish the task?

  1. Insert a Drawing object.

    Add the signature image to the object. Validate all data entries.

  2. Insert a Signature Line object.

    Place the digital signature on the Signature Line.

  3. Insert a Text object.

    Add the signature image to the object. Add a read-only attribute to the workbook.

  4. Insert a WordArt object.

    Add the signature file to the object. Protect the workbook.

    Answer: B Explanation:

    In order to accomplish the task, you will have to take the following steps:

    Insert a Signature Line object. This will provide a place to show the digital signature on the document.

    Place the digital signature on the Signature Line. This will ensure the integrity of the document, and the image used will be shown in the document.

    What is a digital signature? Hide

    A digital signature is a technique to authenticate digital documents by using computer cryptography. A digital signature not only validates the sender#39;s identity, but also ensures that the document#39;s contents have not been altered. It verifies that the source and integrity of the document is not compromised since the document is signed. A digital signature provides the following assurances: Authenticity, Integrity, and Non-repudiation. Microsoft Office 2007 Excel and Word provide a feature known as Signature line to insert a user#39;s digital signature on a document.

    Question No: 2 HOTSPOT

    You work as an Office Assistant for Pecuniary Inc. You have created a report in a workbook in Excel 2007. You want to quickly format headings and titles in the workbook. Mark the option that you will choose to accomplish the task.

    Ensurepass 2017 PDF and VCE

    Answer:

    Ensurepass 2017 PDF and VCE

    Ensurepass 2017 PDF and VCE

    Explanation:

    According to the question, you have to quickly format headings and titles in the workbook. In order to accomplish the task, you will have to take the following steps:

    Ensurepass 2017 PDF and VCE

    Click the Cell Styles option in the Styles group on the Home tab. This will open the pre- formatted styles available with Excel. Choose the required option.

    Ensurepass 2017 PDF and VCE

    A cell style is a defined set of formatting characteristics available in Excel, such as fonts and font sizes, number formats, cell borders, and cell shading. A cell style is used to apply several formats quickly. It also ensures that cells have consistent formatting. Microsoft Office Excel provides several built-in cell styles to apply on cells. Users can also modify these styles to create custom cell styles.

    Cell styles are based on the document theme that is applied to the entire workbook. If a user changes the document theme, the cell styles are updated to match the new document theme.

    Reference. Microsoft Excel 2007 Help, Contents: quot;Apply, create, or remove a cell stylequot;

    Question No: 3 HOTSPOT

    Shelly works as an Office Assistant for Star Publishing Co. She creates a report that includes a list of books, along with the author#39;s name. By mistake, she enters the incorrect spelling of an author#39;s name that appears most often in the whole report. She wants to change incorrect spelling of the author#39;s name with the correct spelling in the whole report. Choose the option that he will use to accomplish the task.

    Ensurepass 2017 PDF and VCE

    Answer:

    Ensurepass 2017 PDF and VCE

    Ensurepass 2017 PDF and VCE

    Explanation:

    The Replace option on the Edit menu will open the Find and Replace dialog box with the Replace tab selected. The options under the replace tab are used to find the specific text or number and replace it with the other one on a worksheet.

    Ensurepass 2017 PDF and VCE

    Perform the following actions in the Find and Replace dialog box to find the specific text or number and replace it with the other one in a worksheet.

    1. Enter text or number to be searched in the Find what text box.

    2. In the Replace with text box, enter the text or number that will replace text or the number in the Find what text box.

    3. Click the Find All or Find Next button.

      NOTE. Click the Find All button to get the list of all occurrences of text or the number that is mentioned in the Find what text box.

    4. Click the Replace All or Replace button to replace the all occurrences or highlighted occurrence.

      NOTE. The following message box will appear if a user clicks the Find All button, and then the

      Replace All button.

      Ensurepass 2017 PDF and VCE

      Reference. Microsoft Excel Help, contents: quot;Find or replace text and numbers on a

      worksheetquot;

      Question No: 4

      Rick works as an Office Assistant for Tech Perfect Inc. He uses Microsoft Excel 2007 for creating reports. He is working on a report in which he has used few macros. He saves the report in macroenabled workbook format. Which of the following extensions will Excel use to save the workbook?

      1. xlsm

      2. xls

      3. xlsx

      4. xlsb

Answer: A Explanation:

In order to save the macro-enabled workbook, Excel 2007 uses the xlsm extension. The new

Microsoft Office system breaks a file into different groups as document data, macro code, and header information and saves them in separate compartments. It then combines these compartments into a single file. Separating macro code from the data enhances the security of the document. It enables users to prevent Excel 2007 from executing macro codes that possibly can harm computers or data.

Question No: 5

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. You have selected all worksheets available in the workbook as shown below:

Ensurepass 2017 PDF and VCE

Now, you want to cancel the selection. Which of the following steps will you take to accomplish the task with least administrative effort?

  1. Click on one of the selected sheets.

  2. Double-click on one of the selected sheets.

  3. Click any unselected sheet.

  4. Right-click the selected sheets.

    Click the Ungroup Sheets option from the shortcut menu.

  5. Click the Single Sheet options in the Sheet Options group on the Page Layout tab.

Answer: D Explanation:

When multiple sheets are selected, Excel groups the sheet and the [Group] appears in the title bar as shown below:

Ensurepass 2017 PDF and VCE

To unselect the sheet, you are required to click any unselected sheet. However, the question states that all sheets are selected. In such a case, in order to unselect the sheets, you will have to take the following steps:

Right-click the selected sheets.

Click the Ungroup Sheets option from the shortcut menu.

Answer options B and A are incorrect. These options will not ungroup the sheets. Answer option C is incorrect. The question states that all the sheets are selected. Hence, no unselected sheet will be available.

Answer option E is incorrect. No option such as Single Sheet is available in Excel. Reference. Microsoft Excel 2007 Help, Contents: quot;Select one or multiple worksheetsquot;

Question No: 6

You work as a Sales Manager for Media Perfect Inc. You have created a sales report in a workbook in Excel 2007. You want to display the file name with complete path of the current document in A1 cell as shown in the image below: Which of the following steps will you take to accomplish the task?

Ensurepass 2017 PDF and VCE

  1. Insert the following formula in cell A1: =filename(quot;A1quot;)

  2. Click the Header amp; Footer option in the Text group of the Insert tab. Select the Footer section.

    Click the File Name option in the Header amp; Footer Elements group of the Design tab.

  3. Click the Header amp; Footer option in the Text group of the Insert tab. Select the Header section.

    Click the File Name option in the Header amp; Footer Elements group of the Design tab.

  4. Insert the following formula in cell A1: =cell(quot;filenamequot;)

Answer: D Explanation:

In order to display the current file name with its full path and the name of the current

worksheet, type the following formula in the required cell: =cell(quot;filenamequot;)

Inserting the above formula in the cell A1 will display the file name as shown below: Answer option A is incorrect. No such function as filename() is supported by Excel 2007.

Ensurepass 2017 PDF and VCE

Answer options C and B are incorrect. These steps will insert the file name in the document in the header and footer sections. However, the question clearly states that the file name with full path is to be inserted in the A1 cell. Hence, these steps will not accomplish the task.

Reference. Microsoft Excel 2007 Help, Contents: “Insert the current Excel file name, path, or worksheet in a cell”

Question No: 7

You work as an Office Assistant for Pecuniary Inc. You are creating a report in a workbook in Excel 2007. The company borrowed a sum of $1000000 at 6% interest rate, which is to be paid within 24 months. You are required to prepare a report in a workbook in Excel 2007, which shows the calculation of monthly installments to be paid to repay the loan.

Which of the following formulas will you use to accomplish the task?

A. PMT(1000000, 6/12, 24, 0, 0)

B. PMT(6/12, 24, 1000000, 0,0)

C. PMT(6%/12, 24, 1000000, 0, 0)

D. PMT(1000000, 6%/12, 24, 0, 0)

Answer: C Explanation:

According to the question, you have to calculate monthly installments for repayment of loan on principal amount of $1000000 borrowed at 6 percent fixed yearly interest rate to be paid within 24 months. In order to accomplish the task, you will have to use the following formula. PMT(6%/12, 24,

1000000, 0, 0)

A PMT() function is used in Excel to calculate payments due on a loan, assuming a constant interest rate and constant payments.

Syntax:

PMT (Rate, NoOfPayments, PV, FV, Type)

Here, Rate is the rate of interest to be divided by 12 for monthly payments. NoOfPayments is the total number of payment for the loan.

PV is the principal value.

FV is the forward value. It is the left over at the end of the payment cycle, usually left blank. Type is either 0 or 1 indicating whether payments are made at the beginning or at the end of the month. Usually left blank which indicates 0 (end of month).

Answer options A and D are incorrect. These formulas contain incorrect syntaxes of the function.

Answer option B is incorrect. It is required to provide rate of interest with percent symbol (%) in the formula.

Question No: 8 HOTSPOT

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2007. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flowchart symbols in the report.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by 2007 Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office 2007 includes simple shapes such as lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts. Users can add text, bullets, numbering, and Quick Styles to these shapes after inserting them in the document. Take the following steps to add a shape in a document:

1.Click on the Shapes option in the Illustrations group on the Insert tab. This will open the list of shapes available in Office 2007.

Ensurepass 2017 PDF and VCE

Question No: 9

You work as a Sales Manager for Deep Lake Inc. You create a report in Excel 2007. This report will be used by your sales team members to fill daily sales data. You save the report with the name Daily Sales Report. After saving the report, you share it to all your team

members. You want to validate entries in some of the cells in the report. You open Daily Sales Report and try to validate one of the cells. However, you find that the validation option is not enabled.

Ensurepass 2017 PDF and VCE

You want to have validation in place in the shared workbook. Which of the following steps will you take to accomplish the task?

  1. Disable protection of the sheet. Apply validation rules.

  2. Enable protection for the sheet. Apply validation rules.

  3. Disable sharing of the sheet. Apply validation rules.

  4. Select all the cells that need to be validated. Ensure that no validation rules are applied previously. Apply validation rules.

Answer: C Explanation:

Microsoft Excel does not allow validating a cell after a sheet is shared. In order to accomplish the task, you will have to take the following steps:

Ensurepass 2017 PDF and VCE

Disable sharing of the sheet. Apply validation rules.

Microsoft Excel 2007 allows sharing of a workbook in order to allow multiple users to edit a workbook simultaneously. By using this feature, the owner of the workbook does not have to worry about changes, as the shared workbook keeps the original data, all edits, additions, and deletions. How to share a workbook?

Take the following steps to share a workbook:

1.Click the Share Workbook option in the Changes group on the Review tab. This will open the Share Workbook window.

After sharing a workbook, the following features cannot be modified: workbook and worksheet protection, macros, data validation, charts, pictures objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, merged cells and conditional formats. However, these features used prior to sharing a workbook will work in the shared workbook.

Answer option A is incorrect. It is not mentioned in the scenario that protection is applied on the sheet.

Answer option B is incorrect. Enabling protection for the sheet will not enable you to apply validation. The question clearly states that you have shared the workbook. After sharing of workbook, validation cannot be modified.

Reference: Microsoft Excel 2007 Help, Contents: quot;Overview of sharing and collaborating on

Excel dataquot;

Question No: 10

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. The report worksheet will include the sales made by all the sales managers in the month of January.

Ensurepass 2017 PDF and VCE

In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?

  1. Line

  2. Pie

  3. Bar

  4. Column

Answer: B Explanation:

In order to accomplish the task, you will have to insert a pie chart in the worksheet. Excel provides a pie chart facility to display data that is arranged in one column or row on a worksheet. Pie charts display the size of items in one data series, proportional to the sum of the items.

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass 77-602 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-602 Dumps with VCE and PDF 11-20
[Free] 2017(Sep) EnsurePass Passguide Microsoft 77-602 Dumps with VCE and PDF 31-40

Name of author

Name: admin

Leave a Reply