You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales
reports of the company. You create a report in a workbook in Excel 2010. A worksheet in the report
contains a list. The fragment of the sheet is shown below:

The list contains the sales data of all sales managers of the company. You want to format all the cells
that contain the value “Mark” in the Sales Manager column, so that they appear differently. You
have to do it with the least administrative burden. Choose the required steps that you will take to accomplish the task.

Answer:

Explanation:
In order to accomplish the task with the least administrative burden, you will have to
take the following steps:
Select the Sales Managers column.

Click the Conditional Formatting option in the Style group on the Home tab, and then click the Text
that Contains option from the sub-menu.

In the dialog box, provide “Mark” as the criteria and select the required formatting.