Braindumps Microsoft MCSD Dumps

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

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

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

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

MOS: Using Microsoft Office Excel 2007

Question No: 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 2017 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 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

Explanation:

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

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 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 2017 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 2017 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 2017 EnsurePass 77-602 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE

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

Name of author

Name: admin