MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams

Chapter 3. Presenting Data Visually

The skills tested in this section of the Microsoft Office Expert exam for Microsoft Excel 2010 relate to working with charts, PivotTables, data analysis tools, and external sources of data. Specifically, the following objectives are associated with this set of skills:

3.1 Apply Advanced Chart Features

3.2 Apply Data Analysis

3.3 Apply and Manipulate PivotTables

3.4 Apply and Manipulate PivotCharts

3.5 Use External Data Sources

3.1 Apply Advanced Chart Features

The data contained in a Microsoft Excel worksheet can often be presented as a chart for the purposes of analysis, reporting, and sharing. When you create a chart, you can choose from many options for the type of chart (pie, line, column, and others, for ...