MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®

Chapter 6. Presenting Data Visually

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2010 relate to adding visual interest to a worksheet. Specifically, the following objectives are associated with this set of skills:

6.1 6.1 Create Charts Based on Worksheet Data

6.2 6.2 Apply and Manipulate Illustrations

6.3 6.3 Create and Modify Images

6.4 6.4 Apply Sparklines

You can insert many of the same graphic elements in an Excel workbook that you can insert in other Microsft Office documents, including clip art, SmartArt diagrams, shapes, screenshots, and pictures. You can also express numeric data by creating charts, and summarize numeric data by using sparklines.

This chapter guides you in studying ways of ...