You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
Some of the cells in a worksheet are formatted using the Heading1 style and some are formatted using the Heading2 style. You select one of the cells formatted with the Heading1 style and press the Delete button on the keyboard.
When you enter some new text into the cell, you discover that the new text is formatted with the Heading1 style. You want to delete the text and the formatting from all the cells formatted with the Heading1 or Heading2 styles.
You select all the formatted cells and select the Clear icon in the Editing group on the Home tab. Which option should you select to delete the formatting and the contents of the selected cells?

• A. You should select the Clear All option.
• B. You should select the Clear Contents option.
• C. You should select the Clear Formats option.
• D. You should select the Clear Comments option.

You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
You want the worksheet tabs to appear in colors as shown below.

How do you change the color of worksheet tabs?

• A. You should consider right-clicking on the tab and selecting Sheet Color from the menu.
• B. You should consider selecting the Colors tool in the Themes group on the Page Layout tab.
• C. You should consider selecting the Font Color tool on the Home tab.
• D. You should consider right-clicking on the tab and selecting Tab Color from the menu.

You work as an Office Administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook. When completed, the workbook will be sent to other users in the Sales department, company managers and board members.
You have completed the workbook. You want to ensure that all hidden rows and columns, comments and personal information are removed from the workbook before you distribute it.
What should you do before sending the workbook?

• A. You should run the Compatibility Checker.
• B. You should mark the document as final.
• C. You should encrypt the document.
• D. You should run the Document Inspector.

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 ask Sally to save the workbook in the Excel 97-2003 format.
• C. You should open the report using Microsoft Excel 2007 or later.
• D. You should modify the conflicting conditional formatting rules.