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

Chapter 3. Formatting Cells and Worksheets

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

3.1 3.1 Apply and Modify Cell Formats

3.2 3.2 Merge or Split Cells

3.3 3.3 Create Row and Column Titles

3.4 3.4 Hide or Unhide Rows and Columns

3.5 3.5 Manipulate Page Setup Options for Worksheets

3.6 3.6 Create and Apply Cell Styles

Worksheets can contain just a few columns and rows of data or complex calculations involving hundreds of cells. The goal of formatting a worksheet is to structure the data in such a way that no matter what size the worksheet is, key ...