Microsoft 77-882 : Excel 2010

You work as the Sales Manager at ABC.com. Sally works as an Office Assistant in the Sales Office.
You have asked Sally to create a sales report on the sales targets for the previous quarter. Sally uses Microsoft Office Excel 2010 to create the report. Sally uses multiple conditional formatting rules to change the styles of the cells according to certain conditions.
Sally completes the report and emails it to you. However, when you open the report, it does not look how it should according to your instructions. You note that only a few of the required conditional formatting rules are applying.
Which of the following actions should you take?

• A. You should ask Sally to save the workbook in the .xls format.
• B. You should modify the conflicting conditional formatting rules.
• C. You should ask Sally to save the workbook in the Excel 97-2003 format.
• D. You should open the report using Microsoft Excel 2007 or later.

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 2010. Your
workbook includes several worksheets as shown in the image given below:

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?

• A. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Tab Color option
  from the shortcut menu.
• B. Select the sheets containing charts. Select the Colors option in the Themes group on the Page
  Layout page.
• C. Select the sheets containing charts. Select the Effects option in the Themes group on the Page
  Layout page.
• D. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color option
  from the shortcut menu.

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.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a report on the sales targets for the previous quarter.
The report contains the table shown below.

You want to configure the cells so that any value less than 70% is displayed as a red cell and any value of more than 70% is displayed as a green cell as shown in the table below.

Which function should you use in your table?

• A. You should use the Cell Styles function on the Home tab.
• B. You should use the Table Style function on the Design tab.
• C. You should use the auto control function on the Home tab.
• D. You should use the Conditional Formatting function on the Home tab.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a Sales Report.
The sales report contains a table that lists the sales figures for each month for each of the Sales Account Managers. A column in the table uses the SUM() function to provide a value for the total annual sales for each of the Sales Account Managers.
The cell that contains the annual total sales for one of the Sales Account Managers displays the formula as shown below whereas the totals for all the other Sales Account Managers are displayed as values.

How can you display the formula as a value?

• A. You should consider changing the format of the cell.
• B. You should consider removing the blank space in the cell before the formula.
• C. You should consider clicking the Evaluate Formula option on the Formulas tab.
• D. You should consider deselecting the Show Formulas option on the Formulas tab.