You work as a Sales Manager for Peach Tree Inc. Your responsibility includes creating sales reports of
the company. You create a report in a workbook in Excel 2010. The report contains a worksheet that
has been formatted by using the conditional formatting feature. You have specified five conditions
for conditional formatting of a list appearing in the sheet. You save the report and send it to your
manager. He informs you that the sheet on which conditional formatting feature is applied is not
appearing according to his requirement. He further specifies that only a few of the conditions are
applying. What is the most likely cause?

You have upgraded your Excel 2007 to Excel 2010. You want to personalize your Excel environment
through the Excel Options window given below:

You are unable to find the Office button. Choose the steps you will take to accomplish the task.

You have created a sales report in Microsoft Excel 2010 as shown in the image below:

You need to sort the data in such a way that sales data for the year 2010 is listed in higher to lower
order. Which of the following steps will you take to accomplish the task?

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel
2010. The report worksheet will include the sales made by all the sales managers in the month of January.

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?

Alan works as a Sales Manager for MVP Technologies. He is creating a sales report in Microsoft Excel
2010. In the report, he needs to enter the names of sales executives in one column and the sales
target (in dollars) achieved by them in the next column as shown in the image below:

He wants to ensure that the color of a cell changes automatically to orange when the sales figure
entered in the cell is more than $10,000. Which of the following actions will he take to accomplish the task?

You work as an Office Assistant for Tech Perfect Inc. You create a worksheet in Excel 2010 that
contains various tables, headings, charts, and SmartArt objects. In order to give it a professional
look, you choose Office theme as shown below:

You like the appearance of the sheet in this theme; however, you want to use the Lucida Calligraphy
font for heading and Arial font for the body text. You often use this font combination for formatting
office sheets. You are required to accomplish the following tasks:
Use the font combination in your current document.
Enable Excel to provide this combination in other office documents too.
Choose the required steps to accomplish the tasks.

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

You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the
Microsoft Excel 2010 application on the network. You open the application and see various changes
in Excel 2010. You have to open an existing worksheet through the application. You are unable to
find the Office button.

Rick works as an Office Executive for Perfect Wear Inc. He uses Microsoft Excel 2010 to maintain
sales record of each day. He needs to print the daily sales report. The management of the company
wants to ensure that each crucial report printed, must print a picture named conf.gif as a watermark
showing the confidential message.
Which of the following options should he use to accomplish the task?

You work as a Sales Manager for Blue Well Inc. You have to create a report in Excel 2010 in the
following format:

You want to insert formulas in the cells in the First Quarter column. These cells will display the sum
of values of respective columns in January, February, and March columns. For this, you insert the
following formula in the E2 cell:
=sum(B2:D2)
However, Excel is treating the formula as a text and displaying it in the following format:

What is the most likely cause?