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

Chapter 8. Analyzing and Organizing Data

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2010 relate to identifying and formatting data for analysis. Specifically, the following objectives are associated with this set of skills:

8.1 8.1 Filter Data

8.2 8.2 Sort Data

8.3 8.3 Apply Conditional Formatting

A single Excel workbook can contain over one million rows and 16,000 columns of data. Although it’s unlikely that you’ll be working with that much data in Excel, you might frequently need to locate specific types of information within a data set or an Excel table. You can filter data to display only the records that meet specific criteria, and sort data to organize it in a logical manner. You can also ...