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?

A.
Choose one of the pre-built themes.

B.
Create a new workbook through a template.
Copy all data and charts of the report to the new workbook.

C.
Select all the text of the document.
Change font style to Verdana and font color to light gray.
Use vibrant colors for charts.

D.
Use the SmartArt option.

Explanation:
In order to accomplish the task, you will have to choose one of the pre-built themes. Document
themes work on the overall design of the entire document. It enables users to specify colors, fonts,
and variety of graphic effects in a document. Themes change the look and feel of the document.

Microsoft Excel 2010 comes with a large collection of pre-built themes. Users can create their own
themes for a document. Themes can be specified through Page Layout > Themes.
Answer D is incorrect. The SmartArt option does not produce soothing graphic effects, soft fonts,
and light colors.
Answer B and C are incorrect. These options involve manual processing. Therefore, any formatting
done manually will increase the administrative burden.