You are previewing MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®.
O'Reilly logo
MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®

Book Description

Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams.

With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:

  • Exam 77-881: Microsoft Word 2010

  • Exam 77-882: Microsoft Excel 2010

  • Exam 77-883: Microsoft PowerPoint 2010

  • Exam 77-884: Microsoft Outlook 2010

  • Use the book’s easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you’ve learned hands-on—using the downloadable files for all the book’s practice tasks.

    Table of Contents

    1. Special Upgrade Offer
    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-881: Microsoft Word 2010
      2. Exam 77-882: Microsoft Excel 2010
      3. Exam 77-883: Microsoft PowerPoint 2010
      4. Exam 77-884: Microsoft Outlook 2010
    6. Modifying the Display of the Ribbon
      1. Dynamic Ribbon Elements
      2. Changing the Width of the Ribbon
      3. Adapting Procedure Steps
    7. How to Access Your Online Edition Hosted by Safari
      1. How to Download the Online Edition to Your Computer
    8. 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
    9. 1. Exam 77-881: Microsoft Word 2010
      1. 1. Sharing and Maintaining Documents
        1. 1.1 Apply Different Views to a Document
          1. Switching Views
            1. Working in Print Layout View
            2. Working in Full Screen Reading View
            3. Working in Web Layout View
            4. Working in Outline View
            5. Working in Draft View
          2. Modifying the Program Window
          3. Magnifying Document Content
          4. Splitting a Document Window
          5. Displaying Multiple Program Windows
        2. 1.2 Apply Protection to a Document
          1. Marking a Document as Final
          2. Restricting Formatting and Editing Changes
          3. Restricting Document Access
        3. 1.3 Manage Document Versions
        4. 1.4 Share Documents
          1. Sending Documents
          2. Saving Documents in Shared Locations
          3. Publishing Documents as Blog Posts
        5. 1.5 Save a Document
        6. 1.6 Apply a Template to a Document
        7. Objective Review
      2. 2. Formatting Content
        1. 2.1 Apply Font and Paragraph Attributes
          1. Applying Character Formatting
          2. Applying Styles
        2. 2.2 Navigate and Search Through a Document
          1. Moving Around in a Document
          2. Searching for Content and Formatting
        3. 2.3 Apply Indentation and Tab Settings to Paragraphs
          1. Indenting Paragraphs
          2. Setting Tab Stops
        4. 2.4 Apply Spacing Settings to Text and Paragraphs
        5. 2.5 Create Tables
          1. Creating Basic Tables
          2. Formatting Tables
          3. Inserting Preformatted Tables
        6. 2.6 Manipulate Tables in a Document
          1. Modifying Table Data
          2. Modifying Table Structure
        7. 2.7 Apply Bullets to a Document
        8. Objective Review
      3. 3. Applying Page Layout and Reusable Content
        1. 3.1 Apply and Manipulate Page Setup Settings
          1. Controlling Page Settings
          2. Setting Page Breaks
          3. Setting Section Breaks
          4. Flowing Text in Columns
        2. 3.2 Apply Themes
        3. 3.3 Construct Content in a Document by Using the Quick Parts Tool
        4. 3.4 Create and Manipulate Page Backgrounds
        5. 3.5 Create and Modify Headers and Footers
        6. Objective Review
      4. 4. Including Illustrations and Graphics in a Document
        1. 4.1 Insert and Format Pictures in a Document
          1. Inserting Pictures
          2. Formatting Pictures
        2. 4.2 Insert and Format Shapes, WordArt, and SmartArt
          1. Inserting and Formatting Shapes
          2. Inserting and Modifying WordArt
          3. Inserting and Modifying SmartArt Diagrams
        3. 4.3 Insert and Format Clip Art
        4. 4.4 Apply and Manipulate Text Boxes
        5. Objective Review
      5. 5. Proofreading Documents
        1. 5.1 Validate Content by Using Spelling and Grammar Checking Options
        2. 5.2 Configure AutoCorrect Settings
        3. 5.3 Insert and Modify Comments in a Document
        4. Objective Review
      6. 6. Applying References and Hyperlinks
        1. 6.1 Apply a Hyperlink
          1. Inserting Hyperlinks
          2. Inserting Bookmarks
        2. 6.2 Create Endnotes and Footnotes
        3. 6.3 Create a Table of Contents
        4. Objective Review
      7. 7. Performing Mail Merge Operations
        1. 7.1 Set Up Mail Merge
          1. Preparing Source Documents
            1. Preparing a Data Source
            2. Preparing a Main Document
          2. Merging Source Documents
            1. Setting Up a Manual Mail Merge
            2. Setting Up a Mail Merge by Using the Mail Merge Wizard
          3. Checking for Errors
        2. 7.2 Execute Mail Merge
          1. Previewing the Results of a Mail Merge Operation
          2. Completing the Mail Merge Operation
        3. Objective Review
    10. 2. Exam 77-882: Microsoft Excel 2010
      1. 1. Managing the Worksheet Environment
        1. 1.1 Navigate Through a Worksheet
        2. 1.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. 1.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
      2. 2. Creating Cell Data
        1. 2.1 Construct Cell Data
          1. Pasting Structured Data
          2. Inserting and Deleting Data
        2. 2.2 Apply Auto Fill
          1. Filling a Data Series
          2. Copying Data
        3. 2.3 Apply and Manipulate Hyperlinks
          1. Creating Hyperlinks
          2. Modifying Hyperlinks
        4. Objective Review
      3. 3. Formatting Cells and Worksheets
        1. 3.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. 3.2 Merge or Split Cells
        3. 3.3 Create Row and Column Titles
        4. 3.4 Hide or Unhide Rows and Columns
        5. 3.5 Manipulate Page Setup Options for Worksheets
        6. 3.6 Create and Apply Cell Styles
        7. Objective Review
      4. 4. Managing Worksheets and Workbooks
        1. 4.1 Create and Format Worksheets
        2. 4.2 Manipulate Window Views
          1. Freezing and Splitting Windows
          2. Displaying Multiple Windows
        3. 4.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
      5. 5. Applying Formulas and Functions
        1. 5.1 Create Formulas
        2. 5.2 Enforce Precedence
        3. 5.3 Apply Cell References in Formulas
        4. 5.4 Apply Conditional Logic in Formulas
          1. Creating Conditional Formulas
          2. Nesting Functions
        5. 5.5 Apply Named Ranges in Formulas
        6. 5.6 Apply Cell Ranges in Formulas
        7. Objective Review
      6. 6. Presenting Data Visually
        1. 6.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. 6.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. 6.3 Create and Modify Images
        4. 6.4 Apply Sparklines
        5. Objective Review
      7. 7. Sharing Worksheet Data with Other Users
        1. 7.1 Share Spreadsheets
          1. Saving Workbooks in Specific Formats
          2. Sending Workbooks
        2. 7.2 Manage Comments
        3. Objective Review
      8. 8. Analyzing and Organizing Data
        1. 8.1 Filter Data
        2. 8.2 Sort Data
        3. 8.3 Apply Conditional Formatting
        4. Objective Review
    11. 3. Exam 77-883: Microsoft PowerPoint 2010
      1. 1. Managing the PowerPoint Environment
        1. 1.1 Adjust Views
          1. Switching Views
          2. Zooming In and Out
        2. 1.2 Manipulate the PowerPoint Window
          1. Working with Multiple Program Windows
          2. Sizing Panes in Normal View
        3. 1.3 Configure the Quick Access Toolbar
        4. 1.4 Configure PowerPoint File Options
        5. Objective Review
      2. 2. Creating a Slide Presentation
        1. 2.1 Construct and Edit Photo Albums
          1. Creating Photo Albums
          2. Editing Photo Albums
        2. 2.2 Apply Slide Size and Orientation Settings
        3. 2.3 Add and Remove Slides
          1. Inserting New Slides
          2. Reusing Slides
          3. Inserting Outlines
          4. Rearranging Slides
          5. Deleting Slides
          6. Hiding Slides
        4. 2.4 Format Slides
          1. Applying and Modifying Themes
          2. Formatting the Background of Slides
          3. Inserting Footer Information
          4. Dividing a Presentation into Sections
          5. Customizing Slide Masters
        5. 2.5 Enter and Format Text
          1. Entering Text in Text Placeholders
          2. Entering Text in Independent Text Boxes
          3. Editing Text
          4. Formatting Characters and Paragraphs
          5. Formatting Bulleted and Numbered Lists
        6. 2.6 Format Text Boxes
          1. Changing the Shape of Text Boxes
          2. Sizing and Positioning Text Boxes
          3. Aligning Text Boxes
          4. Formatting Text Boxes
          5. Adjusting the Text Layout
          6. Setting Default Formatting
        7. Objective Review
      3. 3. Working with Graphical and Multimedia Elements
        1. 3.1 Manipulate Graphical Elements
          1. Opening the Format Dialog Box
          2. Applying Styles, Borders, and Effects
          3. Sizing and Positioning a Graphic
          4. Changing the Stacking Order
          5. Grouping Graphics
          6. Aligning Graphics
          7. Linking Graphics to Other Information
        2. 3.2 Manipulate Images
          1. Cropping Images
          2. Formatting Images
          3. Compressing Pictures
          4. Resetting or Replacing Images
        3. 3.3 Modify WordArt and Shapes
          1. Working with WordArt
          2. Working with Shapes
        4. 3.4 Manipulate SmartArt
          1. Creating Diagrams
          2. Making Design Changes
          3. Changing Shapes in Diagrams
          4. Converting Diagrams to Shapes or Bullet Points
        5. 3.5 Edit Video and Audio Content
          1. Inserting and Editing Video Content
          2. Inserting and Editing Audio Content
        6. Objective Review
      4. 4. Creating Charts and Tables
        1. 4.1 Construct and Modify Tables
          1. Inserting Tables and Editing Table Content
          2. Changing Table Structure
          3. Formatting Tables
          4. Inserting and Modifying Excel Worksheets
        2. 4.2 Insert and Modify Charts
          1. Inserting Charts and Editing Chart Data
          2. Changing the Chart Type and Layout
        3. 4.3 Apply Chart Elements
        4. 4.4 Manipulate Chart Layouts
          1. Selecting Chart Elements
          2. Sizing and Positioning Elements
        5. 4.5 Manipulate Chart Elements
        6. Objective Review
      5. 5. Applying Transitions and Animations
        1. 5.1 Apply Built-In and Custom Animations
          1. Applying Built-In Animations
          2. Applying Fancier Animations
          3. Copying Animations
        2. 5.2 Apply Effect and Path Options
          1. Fine-Tuning Animation Effects
          2. Adjusting Motion Paths
        3. 5.3 Manipulate Animations
        4. 5.4 Apply and Modify Transitions Between Slides
        5. Objective Review
      6. 6. Collaborating on Presentations
        1. 6.1 Manage Comments in Presentations
        2. 6.2 Apply Proofing Tools
          1. Using AutoCorrect
          2. Correcting Spelling Mistakes
          3. Finding and Replacing Text and Fonts
          4. Using the Thesaurus
          5. Comparing and Combining Presentations
        3. Objective Review
      7. 7. Preparing Presentations for Delivery
        1. 7.1 Save Presentations
        2. 7.2 Share Presentations
          1. Compressing Media
          2. Packaging for CD Delivery
          3. Creating Videos
        3. 7.3 Print Presentations
          1. Previewing and Printing
          2. Printing Handouts and Notes
        4. 7.4 Protect Presentations
          1. Removing Extraneous Information
          2. Assigning Passwords
          3. Marking as Final
          4. Attaching Digital Signatures
        5. Objective Review
      8. 8. Delivering Presentations
        1. 8.1 Apply Presentation Tools
        2. 8.2 Set Up Slide Shows
          1. Adjusting Slide Show Settings
          2. Setting Up Presenter View
          3. Broadcasting Slide Shows
          4. Creating Custom Slide Shows
        3. 8.3 Set Presentation Timing
        4. 8.4 Record Presentations
        5. Objective Review
    12. 4. Exam 77-884: Microsoft Outlook 2010
      1. 1. Managing the Outlook Environment
        1. 1.1 Apply and Manipulate Outlook Program Options
          1. Managing Mail Module Options
            1. Compose Messages
            2. Outlook Panes
            3. Message Arrival
            4. Conversation Clean Up
            5. Replies and Forwards
            6. Save Messages
            7. Send Messages
            8. MailTips
            9. Tracking
            10. Other Mail Module Options
          2. Managing Calendar Module Options
            1. Work Time
            2. Calendar Options
            3. Display Options
            4. Time Zones
            5. Scheduling Options
          3. Managing Contacts Module Options
          4. Managing Tasks Module Options
          5. Managing Notes Module and Journal Options
          6. Managing Language Options
          7. Managing Advanced Options
            1. Outlook Panes
            2. Outlook Start And Exit
            3. AutoArchive
            4. Reminders
            5. Export
            6. RSS Feeds
            7. Send and Receive
            8. Other
        2. 1.2 Manipulate Item Tags
          1. Working with Color Categories
          2. Setting Message Sensitivity and Importance
          3. Setting Message Properties
          4. Flagging Items for Follow-Up
          5. Changing Read Status
        3. 1.3 Arrange the Content Pane
          1. Displaying and Hiding Program Window Panes
            1. Managing the Navigation Pane
            2. Managing the Reading Pane
            3. Managing the To-Do Bar
          2. Displaying Module Content
          3. Displaying List Views
          4. Modifying List Views
          5. Working with the Status Bar
        4. 1.4 Apply Search and Filter Tools
          1. Using Instant Search
          2. Using Search Folders
        5. 1.5 Print an Outlook Item
          1. Printing Items
          2. Printing Messages
          3. Printing a Calendar
          4. Printing Contact Records
        6. Objective Review
      2. 2. Creating and Formatting Item Content
        1. 2.1 Create and Send Email Messages
          1. Formatting Messages
          2. Setting Message Options
          3. Sending Messages
        2. 2.2 Create and Manage Quick Steps
        3. 2.3 Create Item Content
          1. Inserting Visual Elements
          2. Inserting SmartArt Graphics
          3. Inserting Charts
          4. Inserting Screen Images
          5. Modifying Visual Elements
          6. Creating Hyperlinks
        4. 2.4 Format Item Content
          1. Applying Text and Paragraph Formatting
          2. Applying and Managing Styles
          3. Applying and Managing Style Sets
          4. Applying and Managing Themes
        5. 2.5 Attach Content to Email Messages
        6. Objective Review
      3. 3. Managing Email Messages
        1. 3.1 Clean Up the Mailbox
          1. Managing Mailbox Size
          2. Managing Conversations
          3. Saving Messages and Message Attachments
        2. 3.2 Create and Manage Rules
          1. Managing Mail by Using Outlook Rules
          2. Creating Automatic Reply Rules
        3. 3.3 Manage Junk Email
          1. Working with Junk Email Messages
          2. Configuring Junk Email Options
        4. 3.4 Manage Automatic Message Content
          1. Creating and Using Automatic Signatures
          2. Setting a Default Theme, Stationery, and Fonts
          3. Identifying Response Text
        5. Objective Review
      4. 4. Managing Contacts
        1. 4.1 Create and Manipulate Contacts
          1. Creating Contact Records
          2. Creating Electronic Business Cards
        2. 4.2 Create and Manipulate Contact Groups
        3. Objective Review
      5. 5. Managing Calendar Objects
        1. 5.1 Create and Manipulate Appointments and Events
          1. Scheduling Appointments
          2. Scheduling Events
          3. Setting Recurrence and Privacy Options
          4. Working with Appointments and Events
        2. 5.2 Create and Manipulate Meeting Requests
          1. Creating Meeting Requests
          2. Scheduling Meetings
          3. Responding to Meeting Requests
          4. Rescheduling and Canceling Meetings
        3. 5.3 Manipulate the Calendar Pane
          1. Arranging Calendar Content
          2. Displaying Different Views
          3. Displaying Multiple Calendars
          4. Changing Calendar Colors
        4. Objective Review
      6. 6. Working with Tasks, Notes, and Journal Entries
        1. 6.1 Create and Manipulate Tasks
          1. Creating Tasks
          2. Displaying Views of Tasks
          3. Managing Tasks
          4. Managing Task Details
          5. Managing Task Assignments
          6. Finalizing Tasks
        2. 6.2 Create and Manipulate Notes
          1. Creating Notes
          2. Displaying Views of Notes
          3. Organizing Notes
        3. 6.3 Create and Manipulate Journal Entries
          1. Activating the Outlook Journal
          2. Automatically Recording Information
          3. Editing Journal Entries
        4. Objective Review
    13. A. About the Authors
      1. The Team
      2. Online Training Solutions, Inc. (OTSI)
    14. Index
    15. About the Authors
    16. Special Upgrade Offer
    17. Copyright