Microsoft Excel 2010 Expert — Question 12

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?

Answer options

• A. Use the SmartArt option.
• B. Create a new workbook through a template. Copy all data and charts of the report to the new workbook.
• C. Choose one of the pre-built themes.
• D. Select all the text of the document. Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Correct answer: C

Explanation

The correct answer is C because selecting a pre-built theme allows for quick and easy application of a cohesive design to the entire document without extensive formatting. Options A and B require additional steps that do not streamline the process as effectively, while option D involves manual changes that can be time-consuming and may not produce a unified look.