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.

Answer:

Explanation:
In order to accomplish the task, Rick should take the following steps:
Select the range for which the display of relative magnitude is required.
Select the Data Bars option through Home tab > Styles Group > Conditional Formatting.
The Conditional Formatting feature of Excel provides a facility to compare the relative magnitude of
values in a cell range by applying colors. According to the image shown in the question, relative
magnitude of values in a cell range is displayed by extending a band of color across the cell. Hence,
you should ask Rick to use the Data Bars option of the Conditional Formatting feature.
The Color Scales option of the Conditional Formatting feature compares the relative magnitude of
values in a cell range by applying colors from a two-or three-color set to the cells. Using this option
the same table will appear as follows:

The Format as Table option is used to configure the whole table in a certain style. It does not provide
the facility to compare values in a range of cells.