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 are creating a worksheet in Excel 2010. You want to add a visible digital signature to your
worksheet. Which of the following steps will you take to accomplish the task?