Which of the following features of Office 2010 houses options to configure options that affect the
document as a whole or the application itself?

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.

You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2010 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in
the log. Plowing through all the records will be time taking. Which option can be used to view only the relevant records?

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:

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?

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of
the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created a
quarterly sales report of the department. After entering required data and inserting charts, you want
to give a professional look to the document. You want to produce the document with soothing
graphic effects, soft fonts, and light colors.
Which of the following steps will you take to accomplish the task with least administrative burden?

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel
2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he
will choose to accomplish the task.

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?

You work as an Office Assistant for Peach Tree Inc. You have created a sales report worksheet in
Excel 2010. In the worksheet, you have created a chart to visually summarize the sales achieved by Mark:

You want to transfer the chart to a new worksheet named MarkSales. Which of the following steps
will you take to accomplish the task?

You work as an Office Assistant for Peach Tree Inc. You have created a report in a workbook using
Microsoft Excel 2010. The report includes a worksheet that contains sales data of the company. You
want to use complex criteria to filter the list. For testing, you have inserted criteria rows in the sheet.
The fragment of the worksheet is shown below:

The list range is defined as A9:D44. For testing, you want to filter the list for all the records of Mark.
You want to ensure that the filtered list does not provide duplicate rows. You also want to display
the filtered list at a new location at the G9 cell position. You open the Advanced Filter dialog box by
clicking the Advance option in the Sort & Filter group on the Data tab.

Fill the Advanced Filter dialog box options to fulfill your requirements.