Free Microsoft 77-882 Exam Dumps Questions & Answers

You work in the Sales office at Weyland Industries. You are using Microsoft Office Excel 2010 to prepare a financial report. The report will be sent to managers at a partner company named ABC.com.
ABC.com users use various versions of Microsoft Office including Microsoft Office 2003, 2007 and 2010.
You need to ensure that your financial report can be viewed You should consider the managers at ABC.com irrespective of which version of Microsoft Office they are using.
How can you ensure that the Excel features used in your spreadsheet are compatible with previous versions of Excel?

• A.  You should consider marking the document as final.
• B.  You should consider running the Compatibility Checker.
• C.  You should consider running the Document Inspector.
• D.  You should consider adding a digital signature.

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is
creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used
many formulas in her report. She wants to monitor a cell which contains a formul a. 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?

• A.  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.
• B.  Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group,
  click Evaluate Formula.
• C.  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.
• D.  Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group,
  click Watch Window. Click Add Watch.

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

Correct Answer:

Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple
objects provided by Microsoft Office to add them to a document. A single shape or combined
multiple shapes can be inserted in the document. The Office 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 Microsoft Office.

2.Choose the required shape from the list.

You work as a Sales Manager at ABC.com. All users in the Sales department run Microsoft Office 2010 having recently been uABCraded from Microsoft Office 2003.
You are currently working on a Sales report in Microsoft Office Excel 2010.
You maximize the worksheet viewing area by selecting the Full Screen option on the View tab. When you select Full Screen, all toolbars and menus disappear.
How can you restore the worksheet view back to the Normal View so that you can see the toolbars?

• A.  You should consider making use of the Alt + W + L keyboard shortcut.
• B.  You should consider making use of the Windows + M keyboard shortcut.
• C.  You should consider making use of the Restore Down button in the Control menu.
• D.  You should consider making use of the Alt + W + M keyboard shortcut.
• E.  You should consider right-clicking on the taskbar tab for the workbook.

You work as a Help Desk Technician for Tech Perfect Inc. Rick, a Sales Manager, uses Microsoft
Excel 2010 to prepare sales reports. He is creating a sales report in which he wants to compare the
relative magnitude of the targets achieved by his sales team members as shown in the image given
below:

He wants your help in formatting the table in the required way. Choose the required steps to
accomplish the task.

Correct Answer:

Explanation:
In order to accomplish the task, Rick should take the following steps:
Select the range for which the display of relative magnitude is required.
Select the Data Bars option through Home tab > Styles Group > Conditional Formatting.
The Conditional Formatting feature of Excel provides a facility to compare the relative magnitude
of values in a cell range by applying colors. According to the image shown in the question, relative
magnitude of values in a cell range is displayed by extending a band of color across the cell.
Hence, you should ask Rick to use the Data Bars option of the Conditional Formatting feature. The
Color Scales option of the Conditional Formatting feature compares the relative magnitude of
values in a cell range by applying colors from a two-or three-color set to the cells. Using this
option the same table will appear as follows:

The Format as Table option is used to configure the whole table in a certain style. It does not
provide the facility to compare values in a range of cells.
Reference:
Microsoft Excel Help, Contents: "Add, change, or clear conditional formats"