You are previewing MOS 2010 Study Guide for Microsoft® Excel®.
O'Reilly logo
MOS 2010 Study Guide for Microsoft® Excel®

Book Description

Demonstrate your expertise with Microsoft Excel 2010 with a MOS certification. Use this Study Guide and downloadable practice files to help advance your proficiency with Excel and earn the credential that proves it.

Table of Contents

  1. MOS 2010 Study Guide for Microsoft® Excel®
  2. A Note Regarding Supplemental Files
  3. Taking a Microsoft Office Specialist Exam
    1. Microsoft Office Specialist Certification
    2. Selecting a Certification Path
    3. Test-Taking Tips
    4. Certification Benefits
    5. For More Information
  4. Using This Book to Study for a Certification Exam
    1. Features and Conventions of This Book
  5. Using the Book’s Companion Content
    1. Exam 77-882: Microsoft Excel 2010
  6. Modifying the Display of the Ribbon
    1. Dynamic Ribbon Elements
    2. Changing the Width of the Ribbon
    3. Adapting Procedure Steps
  7. Getting Support and Giving Feedback
    1. Errata
    2. Getting Help with Microsoft Office 2010
    3. We Want to Hear from You
    4. Stay in Touch
  8. Exam 77-882 Microsoft Excel 2010
    1. Prerequisites
      1. Managing Worksheets
      2. Managing Worksheet Content
      3. Managing Excel Tables
      4. Managing Data Entries
  9. 1. Managing the Worksheet Environment
    1. Navigate Through a Worksheet
    2. Print a Worksheet or Workbook
      1. Printing Part or All of a Workbook
      2. Setting Page Breaks
      3. Printing Gridlines and Headings
      4. Printing Page Headers and Footers
    3. Personalize the Excel Environment
      1. Managing Program Functionality
        1. Managing Formula Options
        2. Managing Advanced Options
      2. Customizing the Ribbon and Quick Access Toolbar
        1. Customizing the Ribbon
        2. Customizing the Quick Access Toolbar
      3. Managing Workbooks
        1. Working with Properties
        2. Working with Versions
    4. Objective Review
  10. 2. Creating Cell Data
    1. Construct Cell Data
      1. Pasting Structured Data
      2. Inserting and Deleting Data
    2. Apply Auto Fill
      1. Filling a Data Series
      2. Copying Data
    3. Apply and Manipulate Hyperlinks
      1. Creating Hyperlinks
      2. Modifying Hyperlinks
    4. Objective Review
  11. 3. Formatting Cells and Worksheets
    1. Apply and Modify Cell Formats
      1. Formatting Cell Content
      2. Formatting Cell Fills and Borders
      3. Setting Row Height and Column Width
      4. Formatting Numbers
    2. Merge or Split Cells
    3. Create Row and Column Titles
    4. Hide or Unhide Rows and Columns
    5. Manipulate Page Setup Options for Worksheets
    6. Create and Apply Cell Styles
    7. Objective Review
  12. 4. Managing Worksheets and Workbooks
    1. Create and Format Worksheets
    2. Manipulate Window Views
      1. Freezing and Splitting Windows
      2. Displaying Multiple Windows
    3. Manipulate Workbook Views
      1. Switching Worksheet Views
      2. Customizing the Program Window
      3. Customizing Worksheet Appearance
      4. Changing the Zoom Level
    4. Objective Review
  13. 5. Applying Formulas and Functions
    1. Create Formulas
    2. Enforce Precedence
    3. Apply Cell References in Formulas
    4. Apply Conditional Logic in Formulas
      1. Creating Conditional Formulas
      2. Nesting Functions
    5. Apply Named Ranges in Formulas
    6. Apply Cell Ranges in Formulas
    7. Objective Review
  14. 6. Presenting Data Visually
    1. Create Charts Based on Worksheet Data
      1. Plotting Charts
      2. Applying Layouts and Styles
      3. Moving and Sizing Charts
      4. Editing Data
      5. Configuring Chart Elements
    2. Apply and Manipulate Illustrations
      1. Inserting and Formatting Clip Art
      2. Inserting and Modifying SmartArt Diagrams
      3. Inserting and Formatting Shapes
      4. Capturing Screenshots
    3. Create and Modify Images
    4. Apply Sparklines
    5. Objective Review
  15. 7. Sharing Worksheet Data with Other Users
    1. Share Spreadsheets
      1. Saving Workbooks in Specific Formats
      2. Sending Workbooks
    2. Manage Comments
    3. Objective Review
  16. 8. Analyzing and Organizing Data
    1. Filter Data
    2. Sort Data
    3. Apply Conditional Formatting
    4. Objective Review
  17. A. About the Authors
    1. Joan Lambert
    2. Joyce Cox
    3. The Team
    4. Online Training Solutions, Inc. (OTSI)
  18. About the Authors
  19. Copyright