IC3_GS4_CF 無料問題集「Certiport IC3 Computing Fundamentals」
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 2007. 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.


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.

正解:
