[Free] 2018(Jan) EnsurePass Dumpsleader Microsoft 77-602 Dumps with VCE and PDF 1-10

EnsurePass
2018 Jan 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 2018 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 2018 PDF and VCE

    Answer:

    Ensurepass 2018 PDF and VCE

    Ensurepass 2018 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 2018 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 2018 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 2018 PDF and VCE

    Answer:

    Ensurepass 2018 PDF and VCE

    Ensurepass 2018 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 2018 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 2018 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 2018 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 2018 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 2018 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 2018 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 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 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 2018 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 2018 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 2018 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 2018 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 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Dumpsleader Microsoft 77-602 Dumps with VCE and PDF 11-20

EnsurePass
2018 Jan 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: 11

You work as an Office Assistant for Net Perfect Inc. You are working on Excel 2007 to create a sales report for the current week. Your workbook contains four worksheets. You have tabulated data in the first sheet. In the second worksheet, few cells contain formulas that refer to the first worksheet.

You want to view both worksheets side-by-side to see how modifying data in the first worksheet changes the formula#39;s result in the second sheet.

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

  1. Save a copy of the workbook with a different name. Open both copies in Excel.

    Use the Arrange Horizontal option in the Arrange Windows dialog-box.

  2. Click the New Window option on the View tab#39;s Window group. Use the Arrange Vertical option in the Arrange Windows dialog-box.

  3. Select both the sheets.

    Click the Landscape Orientation option on the Page Layout tab#39;s Page Setup group.

  4. Save a copy of the workbook with a different name. Open both copies in Excel.

Use the Arrange Vertical option in the Arrange Windows dialog-box.

Answer: B Explanation:

Excel 2007 provides the facility to open more than one copy of a workbook at a time. This option is very helpful when you need to simultaneously view two worksheets every time you want to see how modifying data in a worksheet changes the formula#39;s result in the other worksheet. According to the question, you want to view both the worksheets side-by-side.

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

Ensurepass 2018 PDF and VCE

Click the New Window option on the View tab#39;s Window group.

These steps will open a second copy of the workbook and arrange both copies side-by-side in a single Excel window. If the original workbook#39;s name is SalesReport, Excel 2007 will display the name of original workbook as SalesReprort:1 in the title bar and SalesReport:2

on the second workbook#39;s title bar. When you change data in a sheet of any workbook, the formula result will reflect on the respective sheet of the other workbook. Changes done in either of the workbook will reflect on the other.

Answer options D and A are incorrect. Saving a workbook with a different name will make two different individual workbooks. These workbooks will have separate identity. Hence, the changes done in one of the workbooks will not be reflected on the other.

Answer option C is incorrect. Setting orientation of a sheet to Landscape will not work for this situation. Landscape orientation is a part of layout option that is used to define how data will be printed on a sheet of paper.

Reference:

quot;http://www.allpm.com/modules.php?op=modloadamp;name=Newsamp;file=articleamp;sid=1813quot;

Question No: 12 HOTSPOT

You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales reports for the Sales department. You use Excel 2007 to create these reports. You have created a yearly sales report. The fragment of the report is shown below:

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 PDF and VCE

The question states that the report is quite wide and takes three pages to print. You are required to repeat column A in each printed page. In order to repeat the column in every printed page, you will have to take the following steps:

Choose the Print Titles option in the Page Setup group on the Page Layout tab. This will open the Page Setup window.

These steps will enforce Excel to repeat column A at the left side of each printed page.

Question No: 13

You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have inserted the sales figures of all sales managers as shown in the image given below:

Ensurepass 2018 PDF and VCE

You have to calculate the first quarter incentives for all sales managers. The incentive percentage (provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8 cell. Which of the following formulas will you insert to accomplish the task?

A. =B3/100 * $E$8 B. =$B$3/100 * E8 C. =amp;Bamp;3/100 * E8 D. =B3/100 * E8

E. =B3/100 * amp;Eamp;8

Answer: B Explanation:

In order to accomplish the task, you will have to insert the following formula: =$B$3/100 * E8

According to the question, the formula will be inserted in cell F8 and then the cell#39;s border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers and the value is provided in the cell B3. You will have to insert a formula that refers to the B3 cell as an absolute Reference. For this you will have to type currency

symbol ($) before the row name and column number. In order to accomplish the task, type the following formula in the cell F8: =$B$3/100 * E8

When absolute reference is used for referencing a cell in a formula, dragging cell#39;s border to another cell does not change the cell#39;s reference.

Answer option D is incorrect. This formula references the B3 cell as a relative Reference. After inserting the formula, when the cell#39;s border is dragged, it will change the cell reference relatively.

Answer options C and A are incorrect. Ampersand symbol (amp;) is not used for referencing cells in Excel.

Question No: 14

You work as a Sales Manager for Tech Perfect Inc. You are creating a weekly sales report. Before finalizing the report, you want to verify the correctness of all formulas that are used in the report.

For this, you want to print the report displaying all formulas, instead of their values. Which of the following steps will you take to accomplish the task?

  1. Click the Show Formula option in the Formula Auditing group on the Formula tab. Use the Print option to print the report.

  2. Select the Show Formula option in the Print dialog box.

  3. Click the Print Formula option in the Formula Auditing group on the Formula tab. Use the Print option to print the report.

  4. Select the Print Formula option in the Print dialog box.

Answer: A Explanation:

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

Ensurepass 2018 PDF and VCE

Click the Show Formula option in the Formula Auditing group on the Formula tab

Use the Print option to print the report.

Show Formula is a toggle option to display or hide formulas in a worksheet. Alternatively, you can use the Ctrl ` keys to show/hide the formula.

Answer options C, B, and D are incorrect. No such options are available in Excel 2007. Reference. Windows Excel 2007 Help, Contents: quot;Hide or display formulasquot;

Question No: 15 HOTSPOT

You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in Excel 2007. You have to insert a Venn-diagram in a worksheet. Mark the option you will choose to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

In order to accomplish the task, you will have to choose the Smart Art option. Through the Smart Art option in Office 2007, you can insert complex graphics such as a Venn-diagram in a document. Smart Art is a group of easily editable and formatted diagrams. This is a new option of Excel 2007. There are 115 preset Smart Art graphics layout templates, such as List, Process, Cycle, Hierarchy, etc. Smart Art graphics can automatically change their

colors, fonts, and effects to match the document#39;s theme. The Smart Art option appears under the Insert tab.

Ensurepass 2018 PDF and VCE

Each Smart Art graphic maps the text outline onto the graphic and automatically resizes the graphic for best fit. A number of quick styles can be used for each graphic shapes. Users can also manually change Smart Art graphics colors, fonts, and effects to match the document#39;s theme.

Reference. Microsoft Excel 2007 Help, Contents: quot;Learn more about Smart Art graphicsquot;

Question No: 16

Jenny works as Chief Operating Officer for Tech Perfect Inc. Her responsibilities include monitoring company#39;s sales data and analyzing them to offer the best possible solution to meet the sales target set by the management.

She often requires opening two workbooks simultaneously. One workbook contains yearly sales target figures and the other one includes the actual sales figures. Which of the following steps should she take to reduce the burden of opening these files individually?

  1. Copy the data of one workbook and paste it into a separate sheet in the other workbook.

  2. Place the files in a USB drive.

  3. Create a workspace containing reference of both workbooks.

  4. Place both workbooks at the same location.

Answer: C Explanation:

In order to reduce the burden of opening workbooks individually, Jenny should create a workspace containing reference of both the workbooks.

What is a workspace?

A workspace is an Excel file that allows users to open several files at once. If a user requires opening a set of workbooks to open simultaneously, he should create a workspace of those files. Excel creates a single file that reference to several workbooks. Whenever users open a workspace created, all the files referenced in it will open simultaneously. A workspace file is saved with the .xlw extension.

Question No: 17

You work as an Technician in Tech Perfect Inc. You are creating a report in Microsoft Excel. You protect the worksheet elements in the worksheet. Which of the following functionalities will be achieved by your action?

  1. It will limit the access to the worksheet.

  2. It will restrict users to make any changes in the worksheet.

  3. It will hide the confidential data.

  4. It will encryypt the data.

Answer: B Explanation:

Protecting the worksheet elements will restrict users to make any changes in the worksheet.

Protecting, hiding, and locking are not intended to help secure or protect any confidential information that you keep in a workbook. It only helps to obscure data or formulas that might confuse other users and prevents them from viewing or making changes to that data.

Answer options D, C, and A are incorrect. Protecting the worksheet elements will not achieve any of these functionalities.

Question No: 18

You work as a Sales Manager for Media Perfect Inc. You have created a report in a workbook in Excel 2007. You want to ensure that the A1 cell displays the current time whenever you open the workbook. For this, you select the A1 cell. Which of the following formulas will you insert to accomplish the task?

  1. PMT()

  2. NOW()

  3. TIME()

  4. TIMEVALUE()

Answer: B Explanation:

In order to accomplish the task, you will have to insert the NOW() function in the A1 cell. The NOW() function, in Excel, returns the time when the workbook was last opened. It means, if this function is used in a workbook, its value will change every time the workbook is opened. The NOW() function is not updated continuously. The value changes only when the worksheet is calculated or when a macro that contains the function is run.

Answer option C is incorrect. The TIME() function returns the decimal number for a particular time. Answer option A is incorrect. PMT() is a function used in Excel to calculate payments due on a loan, assuming a constant interest rate and constant payments.

Answer option D is incorrect. The TIMEVALUE() function returns the decimal number of the time represented by a text string.

Reference. Microsoft Excel 2007 Help, Contents: quot;NOWquot;

Question No: 19

You work as a Sales Manager for Net World Inc. You are creating a sales report in Excel 2007. You want to create the report while keeping an eye on how it will look in printed format. Which of the following views will you have to work on?

  1. Page Layout

  2. Normal

  3. Print Preview

  4. Page Break

Answer: A Explanation:

In order to fulfill the requirement of the question, you will have to work on Page Layout View.

Page Layout View is one of the several views provided by Excel 2007. This view has been introduced in Excel 2007 to enable users to create a worksheet while keeping an eye on how it will look in printed format. Users can work with page headers, footers, margin settings in the worksheet in this view. It also enables a user to place various objects, such as charts, at the place where the user wants to print them.

Various page setup options are also available in this view. It enables users to quickly set the worksheet page for printing purposes.

Answer option B is incorrect. The Normal view will not allow you to work on your worksheet while showing how it will appear in printed format.

Answer option D is incorrect. Although the Page Break view will show the print breaks of the worksheet pages, it will not provide different printing options to work on.

Answer option C is incorrect. There is no such view as Print Preview in Excel 2007. Reference: Microsoft Excel 2007 Help, Contents: quot;What#39;s new in Microsoft Office Excel 2007quot;

Question No: 20

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2007 to submit it to your manager. You have used several formulas in the report. You want to see which formula is referring to a cell. Which of the following steps will you take to accomplish the task?

  1. Select the cell. On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

  2. Select the cell. Choose the Trace Precedents in the Formula Auditing group in the Formula tab.

  3. Select the cell. On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

  4. Select the cell. Choose the Trace Dependents in the Formula Auditing group in the Formula tab.

Answer: D

Explanation:

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

Ensurepass 2018 PDF and VCE

Choose the Trace Dependents in the Formula Auditing group in the Formula tab. The Trace Dependents option is used to see which formulas refer to the value in the selected cell.

Answer option B is incorrect. The Trace Precedents option is used to see which cells provide values for the formula in the active cell.

Answer option A is incorrect. It will not accomplish the task as Watch Window is used to monitor the value in a cell. It provides users a convenient way to inspect, audit, or confirm formula calculations and results in large worksheets/workbooks.

Answer option C is incorrect. Evaluate Formula is a tool for examining formulas that do not produce an error, but also not generating the expected result.

Reference. Microsoft Excel 2007 Help, Contents: quot;Display the relationships between formulas and cellsquot;

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Dumpsleader Microsoft 77-602 Dumps with VCE and PDF 21-30

EnsurePass
2018 Jan 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: 21 HOTSPOT

You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the fill handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the Auto Fill button appears. You do not want to display the Auto Fill button. You

open the Excel Options window. Mark the check box that you will clear to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 PDF and VCE

In order to accomplish the task, you will clear the Show Paste Options buttons check box in the Cut, copy, and paste section of the Advanced Excel Options window.

Ensurepass 2018 PDF and VCE

Question No: 22

You work as a Sales Manager for Maini Industries. Your company manufactures and sells construction equipment. You have to create a report that will show the highest selling items of each month. The report will be in the following format:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

For the third column of the sheet, you want to use formulas to fill in the values. You want the cells in the third column to get automatically filled with the names corresponding to ItemID in the second column. You want the exact values to be filled in the column. You select the C2 cell in the third column.

Which of the following formulas will you enter in order to accomplish the task?

A. =VLOOKUP(2,Item_table,B2,TRUE)

B. =VLOOKUP(2,Item_table,B2,FALSE)

C. =VLOOKUP(B2,Item_table,2,TRUE)

D. =VLOOKUP(B2,Item_table,2,FALSE)

Answer: D Explanation:

In order to accomplish the task, you will use the following formula:

=VLOOKUP(B2,Item_table,2,FALSE)

Answer option C is incorrect. According to the question, you want the exact values in the column.

The TRUE value in the range_lookup argument provides the approximate match.

Answer options B and A are incorrect. The VLOOKUP functions used in the formulas have wrong syntaxes.

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

Question No: 23

Alan works as a Sales Manager for MVP Technologies. He uses Microsoft Excel XP to perform official tasks. He prepares a workbook that contains names of Sales Executives and sales (in dollar) target achieved by them in two consecutive months. The first worksheet of the workbook contains data of the first month and the second worksheet contains data of the second month. The sales values are contained in cell B2 through cell B5 in the worksheets 1 and 2. He wants to find the total sales occurred in the two consecutive months. Which of the following cell references will he use to accomplish the task?

  1. Relative cell reference

  2. Absolute cell reference

  3. Mixed cell reference

  4. 3-D cell reference

Answer: D Explanation:

Alan will use 3-D cell reference to accomplish the task.

A 3-D reference in Microsoft Excel is a reference that refers to the same cell or range of cells on two or more worksheets in a workbook. It creates link among the same cell or range of cells existing on different worksheets in a workbook to manipulate data. For example, the SUM function can be used to add the values of cell A1 existing on different worksheets in a workbook.

Take the following steps to refer to the same cell or range on multiple worksheets:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

1.Click the cell where function has to be entered in a worksheet.

Answer option B is incorrect. An absolute cell reference refers to a cell in a specific location in a formula. When a formula that uses the absolute cell reference is copied from one cell to another cell, the absolute cell reference remains unchanged. The #39;$#39; symbol is inserted before the row and the column of the cell reference to identify the absolute cell reference in a formula. For example, the formula =$A$1*$A$2 in cell A3 is written by using the absolute cell Reference. When this formula is copied from cell A3 to cell B3, the absolute cell reference remains unchanged and the formula in cell B3 also remains the same, i.e.

=$A$1*$A$2.

Ensurepass 2018 PDF and VCE

Question No: 24

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Excel 2007 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors.

Which of the following steps will you take to accomplish the task with least administrative burden?

  1. Use the Smart Art option.

  2. Create a new workbook through a template.

    Copy all data and charts of the report to the new workbook.

  3. Choose one of the pre-built themes.

  4. Select all the text of the document.

Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Answer: C Explanation:

In order to accomplish the task, you will have to choose one of the pre-built themes. Document themes work on the overall design of the entire document. It enables users to specify colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the document. Excel 2007 comes with a large collection of pre-built themes.

Users can create their own themes for a document. Themes can be specified through Page Layout gt; Themes.

Ensurepass 2018 PDF and VCE

Answer option A is incorrect. The Smart Art option does not produce soothing graphic effects, soft fonts and light colors.

Question No: 25

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel 2007. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in

the report. She wants to know the effects on the cell when the values in different sheets changes. She requests you to help her out to accomplish the task. Which of the following steps will you advice her to accomplish the task?

  1. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Cascade option.

  2. Select the cell which is to be monitored.

    On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

  3. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Vertical option.

  4. Select the cell which is to be monitored.

On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

Answer: B Explanation:

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

Ensurepass 2018 PDF and VCE

Select the cell which is to be monitored.

On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch. What is the Watch Window?

The Watch Window is a toolbar available in Excel 2007 to monitor the value in a cell, regardless of its location in a workbook. The Watch Window can be moved or docked like other toolbars available. It keeps track of the following properties of a cell: workbook, sheet, name, cell, value, and formula. The Watch Window provides users a convenient way to inspect, audit, or confirm formula calculations and results in large worksheets/workbooks.

Only one watch per cell can be configured in the Watch Window. To set a watch, click the cell to be monitored and then, on the Formulas tab, in the

Formula Auditing group, click Watch Window. Click Add Watch to monitor the selected cell. Answer option D is incorrect. Evaluate Formula is the formula examination tool provided by Excel 2007. This tool is useful for examining formulas that do not produce an error but are not generating the expected result.

Answer options C and A are incorrect. Clicking the New Window option in the Window group on the View tab opens an instance of the workbook within the Excel window. This is useful when you work on different worksheets, and at the same time you want to navigate among them.

Reference: Windows Excel 2007 Help, Contents: quot;Watch a formula and its result by using

the Watch Windowquot;

Question No: 26

You work as a Sales Manager for Dreams Unlimited Inc. Your computer runs Windows Vista Home Premium. You have recently installed Microsoft Office 2007 on your computer. You use Excel to create your reports. As the interface has been changed in the new version, you often use Excel 2007 Help to find out your required commands.

Sometimes, when you look at the Ribbon, you might not see all of the icons or the text that is used in some Help topics to describe the commands on the Ribbon.

What is the most likely cause?

  1. The Home Premium edition of Vista does not support some of the Office 2007 commands.

  2. The Help file of the Office suite is not current.

  3. You are using Beta version of Excel 2007.

  4. The program window is shrinked.

Answer: D Explanation:

This is a common phenomenon for programs in Office 2007 suite. The size of the Ribbon is optimized for a screen resolution of 1024 786 pixels when the Microsoft Office program is maximized on your screen. The Help topics were written by using that standard size for the Ribbon.

Ensurepass 2018 PDF and VCE

Reference. Microsoft Excel 2007 Help, Contents: quot;I can#39;t see a command on the Ribbonquot;

Question No: 27

You work as an Office Assistant for Tech Perfect Inc. You have created a complex workbook on Excel 2007. The workbook is a consolidated sales report that contains sales data for the last five years. This report will be circulated to all the company managers having different versions of Excel. You have to ensure the following:

The optimal performances of the workbook backward compatibility with earlier versions of Excel which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose two.

  1. Use the Run Compatibility Checker option through the Office button gt; Prepare.

  2. Save the file in the Excel 2007 Binary file format.

  3. Use the Inspect Document option through the Office button gt; Prepare.

  4. Save the file in the Excel 2007 XML-based file format.

Answer: A,B Explanation:

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

Use the Run Compatibility Checker option through the Office button gt; Prepare. This option will run Compatibility Checker, which will show you a report regarding compatibility of the document with earlier versions of Excel.

Question No: 28

You work as an Office Assistant for Dreams Unlimited Inc. You use Excel 2007 for creating various types of reports. You have created a report in the format given below:

Ensurepass 2018 PDF and VCE

In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell. Which of the following formulas will provide the required result?

  1. COUNTIF(B2:B5,quot;=Yesquot;,C2:C5,quot;=Yesquot;)

  2. COUNTIFS(B2:B5,quot;=Yesquot;,C2:C5,quot;=Yesquot;)

  3. COUNTIF(B2:C5,quot;=Yesquot;)

  4. COUNTIFS(B2:C5,quot;=Yesquot;)

Answer: B Explanation:

In order to get the required result, you will have to insert the following formula in the B7 cell: COUNTIFS(B2:B5,quot;=Yesquot;,C2:C5,quot;=Yesquot;)

Only Sarah and David have exceeded their January and February quotas, therefore the formula will provide 2 as the result.

Answer option A is incorrect. The COUNTIF function of Excel 2007 does not support multiple criteria.

Answer options C and D are incorrect. This formula will count all cells that have the value quot;Yesquot; in the range B2:C5. As multiple criteria are not applied in the formula, it will provide 6 as the result.

Reference. Microsoft Excel 2007 Help, Contents: quot;COUNTIFquot;

Question No: 29

You work as an Office Assistant for Peach Tree Inc. Your responsibilities include creating sales reports of the company. You have created a report in a workbook in Excel 2007. One

of the worksheets in the report contains some formulas. In order to finally verify formulas used in the worksheet, you have displayed the formulas as shown in the image given below:

Ensurepass 2018 PDF and VCE

You select the E3 cell and want to know the current value of the formula in the cell. You do not want to hide formulas in the sheet. Which of the following steps will you take to accomplish the task with least administrative burden?

  1. Click the Evaluate Formula option in the Formula Auditing group on the Formulas tab. Click the Evaluate button.

  2. Click the Calculate Now option in the Calculation group on the Formulas tab.

  3. Click the Watch Window option in the Formula Auditing group on the Formulas tab. Click the Add Watch option and select the E3 cell.

  4. Watch the value displayed at the status bar.

Answer: A Explanation:

According to the image displayed in the question, formulas are displayed instead of values in cells. You are required to find the result of a formula in the E3 cell that you have already selected. In order to accomplish the task with minimum administrative burden, you will have to take the following steps:

Ensurepass 2018 PDF and VCE

Click the Evaluate Formula option in the Formula Auditing group on the Formulas tab. This will open the Evaluate Formula dialog box.

Ensurepass 2018 PDF and VCE

Answer option C is incorrect. Although these steps will also accomplish the task, the administrative burden will be more.

Answer option D is incorrect. The Status bar does not evaluate the formula.

Answer option B is incorrect. The Calculate Now option is used to calculate the entire worksheet at the current point of time. It is very useful for calculating values when automatic calculation is turned off. This step will not accomplish the task, as it displays the calculated value in their respective places when the Show Formula option is disabled.

Reference. Microsoft Excel 2007 Help, Contents: quot;Evaluate a nested formula one step at a timequot;

Question No: 30

You work as an Office Assistant for Blue Well Inc. You have created a workbook in Excel 2007. This workbook will be shared with other users who will collaborate to enter data in the workbook. You want to enable Excel in such a manner that if you have a question regarding the editing done by any collaborator, you can identify who made the changes and verify that it is correct. Which of the following steps will you take to accomplish the task?

Each correct answer represents a complete solution. Choose two.

  1. Enable the Show Comments feature.

  2. Turn on the Change Tracking feature.

  3. Share the workbook.

  4. Add a History worksheet to the workbook.

Answer: B,C Explanation:

According to the question, you are required to accomplish two tasks:

Ensurepass 2018 PDF and VCE

Configure the workbook in such a manner that more than one user can work simultaneously.

Keep track of changes. In order to accomplish the task, you will have to take the following steps:

Share the workbook by clicking the Share Workbook option in the Changes group on the Review tab.

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Dumpsleader Microsoft 77-602 Dumps with VCE and PDF 31-40

EnsurePass
2018 Jan 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: 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% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Testinsides Microsoft 77-602 Dumps with VCE and PDF 11-20

EnsurePass
2018 Jan 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: 11

You work as an Office Assistant for Net Perfect Inc. You are working on Excel 2007 to create a sales report for the current week. Your workbook contains four worksheets. You have tabulated data in the first sheet. In the second worksheet, few cells contain formulas that refer to the first worksheet.

You want to view both worksheets side-by-side to see how modifying data in the first worksheet changes the formula#39;s result in the second sheet.

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

  1. Save a copy of the workbook with a different name. Open both copies in Excel.

    Use the Arrange Horizontal option in the Arrange Windows dialog-box.

  2. Click the New Window option on the View tab#39;s Window group. Use the Arrange Vertical option in the Arrange Windows dialog-box.

  3. Select both the sheets.

    Click the Landscape Orientation option on the Page Layout tab#39;s Page Setup group.

  4. Save a copy of the workbook with a different name. Open both copies in Excel.

Use the Arrange Vertical option in the Arrange Windows dialog-box.

Answer: B Explanation:

Excel 2007 provides the facility to open more than one copy of a workbook at a time. This option is very helpful when you need to simultaneously view two worksheets every time you want to see how modifying data in a worksheet changes the formula#39;s result in the other worksheet. According to the question, you want to view both the worksheets side-by-side.

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

Ensurepass 2018 PDF and VCE

Click the New Window option on the View tab#39;s Window group.

These steps will open a second copy of the workbook and arrange both copies side-by-side in a single Excel window. If the original workbook#39;s name is SalesReport, Excel 2007 will display the name of original workbook as SalesReprort:1 in the title bar and SalesReport:2

on the second workbook#39;s title bar. When you change data in a sheet of any workbook, the formula result will reflect on the respective sheet of the other workbook. Changes done in either of the workbook will reflect on the other.

Answer options D and A are incorrect. Saving a workbook with a different name will make two different individual workbooks. These workbooks will have separate identity. Hence, the changes done in one of the workbooks will not be reflected on the other.

Answer option C is incorrect. Setting orientation of a sheet to Landscape will not work for this situation. Landscape orientation is a part of layout option that is used to define how data will be printed on a sheet of paper.

Reference:

quot;http://www.allpm.com/modules.php?op=modloadamp;name=Newsamp;file=articleamp;sid=1813quot;

Question No: 12 HOTSPOT

You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales reports for the Sales department. You use Excel 2007 to create these reports. You have created a yearly sales report. The fragment of the report is shown below:

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 PDF and VCE

The question states that the report is quite wide and takes three pages to print. You are required to repeat column A in each printed page. In order to repeat the column in every printed page, you will have to take the following steps:

Choose the Print Titles option in the Page Setup group on the Page Layout tab. This will open the Page Setup window.

These steps will enforce Excel to repeat column A at the left side of each printed page.

Question No: 13

You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have inserted the sales figures of all sales managers as shown in the image given below:

Ensurepass 2018 PDF and VCE

You have to calculate the first quarter incentives for all sales managers. The incentive percentage (provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8 cell. Which of the following formulas will you insert to accomplish the task?

A. =B3/100 * $E$8 B. =$B$3/100 * E8 C. =amp;Bamp;3/100 * E8 D. =B3/100 * E8

E. =B3/100 * amp;Eamp;8

Answer: B Explanation:

In order to accomplish the task, you will have to insert the following formula: =$B$3/100 * E8

According to the question, the formula will be inserted in cell F8 and then the cell#39;s border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers and the value is provided in the cell B3. You will have to insert a formula that refers to the B3 cell as an absolute Reference. For this you will have to type currency

symbol ($) before the row name and column number. In order to accomplish the task, type the following formula in the cell F8: =$B$3/100 * E8

When absolute reference is used for referencing a cell in a formula, dragging cell#39;s border to another cell does not change the cell#39;s reference.

Answer option D is incorrect. This formula references the B3 cell as a relative Reference. After inserting the formula, when the cell#39;s border is dragged, it will change the cell reference relatively.

Answer options C and A are incorrect. Ampersand symbol (amp;) is not used for referencing cells in Excel.

Question No: 14

You work as a Sales Manager for Tech Perfect Inc. You are creating a weekly sales report. Before finalizing the report, you want to verify the correctness of all formulas that are used in the report.

For this, you want to print the report displaying all formulas, instead of their values. Which of the following steps will you take to accomplish the task?

  1. Click the Show Formula option in the Formula Auditing group on the Formula tab. Use the Print option to print the report.

  2. Select the Show Formula option in the Print dialog box.

  3. Click the Print Formula option in the Formula Auditing group on the Formula tab. Use the Print option to print the report.

  4. Select the Print Formula option in the Print dialog box.

Answer: A Explanation:

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

Ensurepass 2018 PDF and VCE

Click the Show Formula option in the Formula Auditing group on the Formula tab

Use the Print option to print the report.

Show Formula is a toggle option to display or hide formulas in a worksheet. Alternatively, you can use the Ctrl ` keys to show/hide the formula.

Answer options C, B, and D are incorrect. No such options are available in Excel 2007. Reference. Windows Excel 2007 Help, Contents: quot;Hide or display formulasquot;

Question No: 15 HOTSPOT

You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in Excel 2007. You have to insert a Venn-diagram in a worksheet. Mark the option you will choose to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

In order to accomplish the task, you will have to choose the Smart Art option. Through the Smart Art option in Office 2007, you can insert complex graphics such as a Venn-diagram in a document. Smart Art is a group of easily editable and formatted diagrams. This is a new option of Excel 2007. There are 115 preset Smart Art graphics layout templates, such as List, Process, Cycle, Hierarchy, etc. Smart Art graphics can automatically change their

colors, fonts, and effects to match the document#39;s theme. The Smart Art option appears under the Insert tab.

Ensurepass 2018 PDF and VCE

Each Smart Art graphic maps the text outline onto the graphic and automatically resizes the graphic for best fit. A number of quick styles can be used for each graphic shapes. Users can also manually change Smart Art graphics colors, fonts, and effects to match the document#39;s theme.

Reference. Microsoft Excel 2007 Help, Contents: quot;Learn more about Smart Art graphicsquot;

Question No: 16

Jenny works as Chief Operating Officer for Tech Perfect Inc. Her responsibilities include monitoring company#39;s sales data and analyzing them to offer the best possible solution to meet the sales target set by the management.

She often requires opening two workbooks simultaneously. One workbook contains yearly sales target figures and the other one includes the actual sales figures. Which of the following steps should she take to reduce the burden of opening these files individually?

  1. Copy the data of one workbook and paste it into a separate sheet in the other workbook.

  2. Place the files in a USB drive.

  3. Create a workspace containing reference of both workbooks.

  4. Place both workbooks at the same location.

Answer: C Explanation:

In order to reduce the burden of opening workbooks individually, Jenny should create a workspace containing reference of both the workbooks.

What is a workspace?

A workspace is an Excel file that allows users to open several files at once. If a user requires opening a set of workbooks to open simultaneously, he should create a workspace of those files. Excel creates a single file that reference to several workbooks. Whenever users open a workspace created, all the files referenced in it will open simultaneously. A workspace file is saved with the .xlw extension.

Question No: 17

You work as an Technician in Tech Perfect Inc. You are creating a report in Microsoft Excel. You protect the worksheet elements in the worksheet. Which of the following functionalities will be achieved by your action?

  1. It will limit the access to the worksheet.

  2. It will restrict users to make any changes in the worksheet.

  3. It will hide the confidential data.

  4. It will encryypt the data.

Answer: B Explanation:

Protecting the worksheet elements will restrict users to make any changes in the worksheet.

Protecting, hiding, and locking are not intended to help secure or protect any confidential information that you keep in a workbook. It only helps to obscure data or formulas that might confuse other users and prevents them from viewing or making changes to that data.

Answer options D, C, and A are incorrect. Protecting the worksheet elements will not achieve any of these functionalities.

Question No: 18

You work as a Sales Manager for Media Perfect Inc. You have created a report in a workbook in Excel 2007. You want to ensure that the A1 cell displays the current time whenever you open the workbook. For this, you select the A1 cell. Which of the following formulas will you insert to accomplish the task?

  1. PMT()

  2. NOW()

  3. TIME()

  4. TIMEVALUE()

Answer: B Explanation:

In order to accomplish the task, you will have to insert the NOW() function in the A1 cell. The NOW() function, in Excel, returns the time when the workbook was last opened. It means, if this function is used in a workbook, its value will change every time the workbook is opened. The NOW() function is not updated continuously. The value changes only when the worksheet is calculated or when a macro that contains the function is run.

Answer option C is incorrect. The TIME() function returns the decimal number for a particular time. Answer option A is incorrect. PMT() is a function used in Excel to calculate payments due on a loan, assuming a constant interest rate and constant payments.

Answer option D is incorrect. The TIMEVALUE() function returns the decimal number of the time represented by a text string.

Reference. Microsoft Excel 2007 Help, Contents: quot;NOWquot;

Question No: 19

You work as a Sales Manager for Net World Inc. You are creating a sales report in Excel 2007. You want to create the report while keeping an eye on how it will look in printed format. Which of the following views will you have to work on?

  1. Page Layout

  2. Normal

  3. Print Preview

  4. Page Break

Answer: A Explanation:

In order to fulfill the requirement of the question, you will have to work on Page Layout View.

Page Layout View is one of the several views provided by Excel 2007. This view has been introduced in Excel 2007 to enable users to create a worksheet while keeping an eye on how it will look in printed format. Users can work with page headers, footers, margin settings in the worksheet in this view. It also enables a user to place various objects, such as charts, at the place where the user wants to print them.

Various page setup options are also available in this view. It enables users to quickly set the worksheet page for printing purposes.

Answer option B is incorrect. The Normal view will not allow you to work on your worksheet while showing how it will appear in printed format.

Answer option D is incorrect. Although the Page Break view will show the print breaks of the worksheet pages, it will not provide different printing options to work on.

Answer option C is incorrect. There is no such view as Print Preview in Excel 2007. Reference: Microsoft Excel 2007 Help, Contents: quot;What#39;s new in Microsoft Office Excel 2007quot;

Question No: 20

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2007 to submit it to your manager. You have used several formulas in the report. You want to see which formula is referring to a cell. Which of the following steps will you take to accomplish the task?

  1. Select the cell. On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

  2. Select the cell. Choose the Trace Precedents in the Formula Auditing group in the Formula tab.

  3. Select the cell. On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

  4. Select the cell. Choose the Trace Dependents in the Formula Auditing group in the Formula tab.

Answer: D

Explanation:

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

Ensurepass 2018 PDF and VCE

Choose the Trace Dependents in the Formula Auditing group in the Formula tab. The Trace Dependents option is used to see which formulas refer to the value in the selected cell.

Answer option B is incorrect. The Trace Precedents option is used to see which cells provide values for the formula in the active cell.

Answer option A is incorrect. It will not accomplish the task as Watch Window is used to monitor the value in a cell. It provides users a convenient way to inspect, audit, or confirm formula calculations and results in large worksheets/workbooks.

Answer option C is incorrect. Evaluate Formula is a tool for examining formulas that do not produce an error, but also not generating the expected result.

Reference. Microsoft Excel 2007 Help, Contents: quot;Display the relationships between formulas and cellsquot;

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Testinsides Microsoft 77-602 Dumps with VCE and PDF 21-30

EnsurePass
2018 Jan 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: 21 HOTSPOT

You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the fill handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the Auto Fill button appears. You do not want to display the Auto Fill button. You

open the Excel Options window. Mark the check box that you will clear to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 PDF and VCE

In order to accomplish the task, you will clear the Show Paste Options buttons check box in the Cut, copy, and paste section of the Advanced Excel Options window.

Ensurepass 2018 PDF and VCE

Question No: 22

You work as a Sales Manager for Maini Industries. Your company manufactures and sells construction equipment. You have to create a report that will show the highest selling items of each month. The report will be in the following format:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

For the third column of the sheet, you want to use formulas to fill in the values. You want the cells in the third column to get automatically filled with the names corresponding to ItemID in the second column. You want the exact values to be filled in the column. You select the C2 cell in the third column.

Which of the following formulas will you enter in order to accomplish the task?

A. =VLOOKUP(2,Item_table,B2,TRUE)

B. =VLOOKUP(2,Item_table,B2,FALSE)

C. =VLOOKUP(B2,Item_table,2,TRUE)

D. =VLOOKUP(B2,Item_table,2,FALSE)

Answer: D Explanation:

In order to accomplish the task, you will use the following formula:

=VLOOKUP(B2,Item_table,2,FALSE)

Answer option C is incorrect. According to the question, you want the exact values in the column.

The TRUE value in the range_lookup argument provides the approximate match.

Answer options B and A are incorrect. The VLOOKUP functions used in the formulas have wrong syntaxes.

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

Question No: 23

Alan works as a Sales Manager for MVP Technologies. He uses Microsoft Excel XP to perform official tasks. He prepares a workbook that contains names of Sales Executives and sales (in dollar) target achieved by them in two consecutive months. The first worksheet of the workbook contains data of the first month and the second worksheet contains data of the second month. The sales values are contained in cell B2 through cell B5 in the worksheets 1 and 2. He wants to find the total sales occurred in the two consecutive months. Which of the following cell references will he use to accomplish the task?

  1. Relative cell reference

  2. Absolute cell reference

  3. Mixed cell reference

  4. 3-D cell reference

Answer: D Explanation:

Alan will use 3-D cell reference to accomplish the task.

A 3-D reference in Microsoft Excel is a reference that refers to the same cell or range of cells on two or more worksheets in a workbook. It creates link among the same cell or range of cells existing on different worksheets in a workbook to manipulate data. For example, the SUM function can be used to add the values of cell A1 existing on different worksheets in a workbook.

Take the following steps to refer to the same cell or range on multiple worksheets:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

1.Click the cell where function has to be entered in a worksheet.

Answer option B is incorrect. An absolute cell reference refers to a cell in a specific location in a formula. When a formula that uses the absolute cell reference is copied from one cell to another cell, the absolute cell reference remains unchanged. The #39;$#39; symbol is inserted before the row and the column of the cell reference to identify the absolute cell reference in a formula. For example, the formula =$A$1*$A$2 in cell A3 is written by using the absolute cell Reference. When this formula is copied from cell A3 to cell B3, the absolute cell reference remains unchanged and the formula in cell B3 also remains the same, i.e.

=$A$1*$A$2.

Ensurepass 2018 PDF and VCE

Question No: 24

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Excel 2007 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors.

Which of the following steps will you take to accomplish the task with least administrative burden?

  1. Use the Smart Art option.

  2. Create a new workbook through a template.

    Copy all data and charts of the report to the new workbook.

  3. Choose one of the pre-built themes.

  4. Select all the text of the document.

Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Answer: C Explanation:

In order to accomplish the task, you will have to choose one of the pre-built themes. Document themes work on the overall design of the entire document. It enables users to specify colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the document. Excel 2007 comes with a large collection of pre-built themes.

Users can create their own themes for a document. Themes can be specified through Page Layout gt; Themes.

Ensurepass 2018 PDF and VCE

Answer option A is incorrect. The Smart Art option does not produce soothing graphic effects, soft fonts and light colors.

Question No: 25

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel 2007. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in

the report. She wants to know the effects on the cell when the values in different sheets changes. She requests you to help her out to accomplish the task. Which of the following steps will you advice her to accomplish the task?

  1. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Cascade option.

  2. Select the cell which is to be monitored.

    On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

  3. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Vertical option.

  4. Select the cell which is to be monitored.

On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

Answer: B Explanation:

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

Ensurepass 2018 PDF and VCE

Select the cell which is to be monitored.

On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch. What is the Watch Window?

The Watch Window is a toolbar available in Excel 2007 to monitor the value in a cell, regardless of its location in a workbook. The Watch Window can be moved or docked like other toolbars available. It keeps track of the following properties of a cell: workbook, sheet, name, cell, value, and formula. The Watch Window provides users a convenient way to inspect, audit, or confirm formula calculations and results in large worksheets/workbooks.

Only one watch per cell can be configured in the Watch Window. To set a watch, click the cell to be monitored and then, on the Formulas tab, in the

Formula Auditing group, click Watch Window. Click Add Watch to monitor the selected cell. Answer option D is incorrect. Evaluate Formula is the formula examination tool provided by Excel 2007. This tool is useful for examining formulas that do not produce an error but are not generating the expected result.

Answer options C and A are incorrect. Clicking the New Window option in the Window group on the View tab opens an instance of the workbook within the Excel window. This is useful when you work on different worksheets, and at the same time you want to navigate among them.

Reference: Windows Excel 2007 Help, Contents: quot;Watch a formula and its result by using

the Watch Windowquot;

Question No: 26

You work as a Sales Manager for Dreams Unlimited Inc. Your computer runs Windows Vista Home Premium. You have recently installed Microsoft Office 2007 on your computer. You use Excel to create your reports. As the interface has been changed in the new version, you often use Excel 2007 Help to find out your required commands.

Sometimes, when you look at the Ribbon, you might not see all of the icons or the text that is used in some Help topics to describe the commands on the Ribbon.

What is the most likely cause?

  1. The Home Premium edition of Vista does not support some of the Office 2007 commands.

  2. The Help file of the Office suite is not current.

  3. You are using Beta version of Excel 2007.

  4. The program window is shrinked.

Answer: D Explanation:

This is a common phenomenon for programs in Office 2007 suite. The size of the Ribbon is optimized for a screen resolution of 1024 786 pixels when the Microsoft Office program is maximized on your screen. The Help topics were written by using that standard size for the Ribbon.

Ensurepass 2018 PDF and VCE

Reference. Microsoft Excel 2007 Help, Contents: quot;I can#39;t see a command on the Ribbonquot;

Question No: 27

You work as an Office Assistant for Tech Perfect Inc. You have created a complex workbook on Excel 2007. The workbook is a consolidated sales report that contains sales data for the last five years. This report will be circulated to all the company managers having different versions of Excel. You have to ensure the following:

The optimal performances of the workbook backward compatibility with earlier versions of Excel which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose two.

  1. Use the Run Compatibility Checker option through the Office button gt; Prepare.

  2. Save the file in the Excel 2007 Binary file format.

  3. Use the Inspect Document option through the Office button gt; Prepare.

  4. Save the file in the Excel 2007 XML-based file format.

Answer: A,B Explanation:

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

Use the Run Compatibility Checker option through the Office button gt; Prepare. This option will run Compatibility Checker, which will show you a report regarding compatibility of the document with earlier versions of Excel.

Question No: 28

You work as an Office Assistant for Dreams Unlimited Inc. You use Excel 2007 for creating various types of reports. You have created a report in the format given below:

Ensurepass 2018 PDF and VCE

In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell. Which of the following formulas will provide the required result?

  1. COUNTIF(B2:B5,quot;=Yesquot;,C2:C5,quot;=Yesquot;)

  2. COUNTIFS(B2:B5,quot;=Yesquot;,C2:C5,quot;=Yesquot;)

  3. COUNTIF(B2:C5,quot;=Yesquot;)

  4. COUNTIFS(B2:C5,quot;=Yesquot;)

Answer: B Explanation:

In order to get the required result, you will have to insert the following formula in the B7 cell: COUNTIFS(B2:B5,quot;=Yesquot;,C2:C5,quot;=Yesquot;)

Only Sarah and David have exceeded their January and February quotas, therefore the formula will provide 2 as the result.

Answer option A is incorrect. The COUNTIF function of Excel 2007 does not support multiple criteria.

Answer options C and D are incorrect. This formula will count all cells that have the value quot;Yesquot; in the range B2:C5. As multiple criteria are not applied in the formula, it will provide 6 as the result.

Reference. Microsoft Excel 2007 Help, Contents: quot;COUNTIFquot;

Question No: 29

You work as an Office Assistant for Peach Tree Inc. Your responsibilities include creating sales reports of the company. You have created a report in a workbook in Excel 2007. One

of the worksheets in the report contains some formulas. In order to finally verify formulas used in the worksheet, you have displayed the formulas as shown in the image given below:

Ensurepass 2018 PDF and VCE

You select the E3 cell and want to know the current value of the formula in the cell. You do not want to hide formulas in the sheet. Which of the following steps will you take to accomplish the task with least administrative burden?

  1. Click the Evaluate Formula option in the Formula Auditing group on the Formulas tab. Click the Evaluate button.

  2. Click the Calculate Now option in the Calculation group on the Formulas tab.

  3. Click the Watch Window option in the Formula Auditing group on the Formulas tab. Click the Add Watch option and select the E3 cell.

  4. Watch the value displayed at the status bar.

Answer: A Explanation:

According to the image displayed in the question, formulas are displayed instead of values in cells. You are required to find the result of a formula in the E3 cell that you have already selected. In order to accomplish the task with minimum administrative burden, you will have to take the following steps:

Ensurepass 2018 PDF and VCE

Click the Evaluate Formula option in the Formula Auditing group on the Formulas tab. This will open the Evaluate Formula dialog box.

Ensurepass 2018 PDF and VCE

Answer option C is incorrect. Although these steps will also accomplish the task, the administrative burden will be more.

Answer option D is incorrect. The Status bar does not evaluate the formula.

Answer option B is incorrect. The Calculate Now option is used to calculate the entire worksheet at the current point of time. It is very useful for calculating values when automatic calculation is turned off. This step will not accomplish the task, as it displays the calculated value in their respective places when the Show Formula option is disabled.

Reference. Microsoft Excel 2007 Help, Contents: quot;Evaluate a nested formula one step at a timequot;

Question No: 30

You work as an Office Assistant for Blue Well Inc. You have created a workbook in Excel 2007. This workbook will be shared with other users who will collaborate to enter data in the workbook. You want to enable Excel in such a manner that if you have a question regarding the editing done by any collaborator, you can identify who made the changes and verify that it is correct. Which of the following steps will you take to accomplish the task?

Each correct answer represents a complete solution. Choose two.

  1. Enable the Show Comments feature.

  2. Turn on the Change Tracking feature.

  3. Share the workbook.

  4. Add a History worksheet to the workbook.

Answer: B,C Explanation:

According to the question, you are required to accomplish two tasks:

Ensurepass 2018 PDF and VCE

Configure the workbook in such a manner that more than one user can work simultaneously.

Keep track of changes. In order to accomplish the task, you will have to take the following steps:

Share the workbook by clicking the Share Workbook option in the Changes group on the Review tab.

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Testinsides Microsoft 77-602 Dumps with VCE and PDF 31-40

EnsurePass
2018 Jan 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: 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% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Testinsides Microsoft 77-602 Dumps with VCE and PDF 1-10

EnsurePass
2018 Jan 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 2018 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 2018 PDF and VCE

    Answer:

    Ensurepass 2018 PDF and VCE

    Ensurepass 2018 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 2018 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 2018 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 2018 PDF and VCE

    Answer:

    Ensurepass 2018 PDF and VCE

    Ensurepass 2018 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 2018 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 2018 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 2018 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 2018 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 2018 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 2018 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 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 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 2018 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 2018 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 2018 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 2018 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 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Passguide Microsoft 77-602 Dumps with VCE and PDF 31-40

EnsurePass
2018 Jan 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: 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% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE

[Free] 2018(Jan) EnsurePass Passguide Microsoft 77-602 Dumps with VCE and PDF 1-10

EnsurePass
2018 Jan 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 2018 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 2018 PDF and VCE

    Answer:

    Ensurepass 2018 PDF and VCE

    Ensurepass 2018 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 2018 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 2018 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 2018 PDF and VCE

    Answer:

    Ensurepass 2018 PDF and VCE

    Ensurepass 2018 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 2018 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 2018 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 2018 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 2018 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 2018 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 2018 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 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 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 2018 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 2018 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 2018 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 2018 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 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

100% Free Download!
Download Free Demo:77-602 Demo PDF
100% Pass Guaranteed!
Download 2018 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

2018 EnsurePass IT Certification PDF and VCE