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?

A.
Select the sheets containing charts. Select the Effects option in the Themes group on the Page
Layout page.

B.
Select the sheets containing charts. Right-click on the sheet tabs. Choose the Tab Color option
from the shortcut menu.

C.
Select the sheets containing charts. Select the Colors option in the Themes group on the Page
Layout page.

D.
Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color option
from the shortcut menu.

Explanation:
According to the question, you want the sheet tabs of the sheets containing chart to appear in red
color. In order to accomplish the task, you will have to take the following steps:
1.Select the sheets containing charts.

2.Right-click on the sheet tabs. Choose the Tab Color option from the shortcut menu.