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.

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 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?