You are previewing MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams.
O'Reilly logo
MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams

Book Description

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for four Microsoft Office Specialist (MOS) exams, this all-in-one study guide features:

  • Full, objective-by-objective exam coverage

  • Easy-to-follow procedures and illustrations to review essential skills

  • Hands-on practice tasks to apply what you’ve learned; files included


  • Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves it!

    Exams covered:

  • 77-887: MOS: Microsoft Office Word 2010 Expert

  • 77-888: MOS: Microsoft Office Excel 2010 Expert

  • 77-885: MOS: Microsoft Office Access 2010

  • 77-886: MOS: Microsoft SharePoint 2010



  • Companion Content includes:

  • Practice files for each exam

  • Fully searchable eBook

  • Sample chapters from five STEP BY STEP books from Microsoft Press (TBD)

  • Additional eBooks and resources

  • Table of Contents

    1. MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams
    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
    6. Your Companion eBook
    7. Modifying the Display of the Ribbon
    8. How to Get Support and Provide Feedback
      1. Errata & Book Support
      2. We Want to Hear from You
      3. Stay in Touch
    9. 1. Exam 77-887 Microsoft Word 2010 Expert
      1. 1. Sharing and Maintaining Documents
        1. 1.1 Configure Word Options
          1. Setting Default Program Options
            1. General
            2. Display
            3. Proofing
            4. Save
            5. Language
            6. Advanced
            7. Customize Ribbon and Quick Access Toolbar
            8. Add-Ins
            9. Trust Center
          2. Changing Options for Checking Spelling and Grammar
        2. 1.2 Apply Protection to a Document
          1. Controlling the Editing of a Document
          2. Managing Access to a Document
          3. Adding a Password to a Document
        3. 1.3 Apply a Template to a Document
          1. Using a Document Template
          2. Working with a Global Template
          3. Modifying a Template
          4. Designing Your Own Template
            1. Adding Content Controls
            2. Working with Content Control Properties
            3. Changing the Text in a Content Control
            4. Protecting a Template You Design
          5. Managing Templates by Using the Organizer
        4. Objective Review
      2. 2. Formatting Content
        1. 2.1 Apply Advanced Font and Paragraph Attributes
          1. Formatting Characters
            1. Using the Font Tab
            2. Applying Text Effects
            3. Applying Text Effects from the Home Tab
            4. Making Use of the Advanced Tab
            5. Adding a Drop Cap
          2. Creating and Modifying Styles
          3. Defining and Applying Character Styles
        2. 2.2 Create Tables and Charts
          1. Inserting and Formatting a Table
          2. Inserting Table Data by Using Microsoft Excel
          3. Using Formulas and Calculations in a Table
          4. Charting Data in Microsoft Word
        3. 2.3 Construct Reusable Content in a Document
          1. Customizing Building Blocks
          2. Saving and Inserting Quick Parts
          3. Working with Headers and Footers
        4. 2.4 Link Text Boxes and Sections
          1. Linking and Unlinking Text Boxes
          2. Linking Document Sections
        5. Objective Review
      3. 3. Tracking and Referencing Documents
        1. 3.1 Review, Compare, and Combine Documents
          1. Adding Comments to a Document
          2. Using Track Changes and Setting Track Changes Options
          3. Merging Documents
          4. Reviewing a Combined Document
        2. 3.2 Create a Reference Page
          1. Adding Citations to a Document
          2. Managing Sources
          3. Creating a Bibliography
          4. Using Cross-References in a Document
            1. Creating a Caption
            2. Inserting a Cross-Reference
        3. 3.3 Create a Table of Authorities in a Document
          1. Marking Citations
          2. Formatting and Aligning a Table of Authorities
        4. 3.4 Mark and Compile an Index for a Document
          1. Marking Index Entries
          2. Setting Index Options
          3. Editing and Updating an Index
        5. Objective Review
      4. 4. Performing Mail Merge Operations
        1. 4.1 Execute a Mail Merge Operation
          1. Building a Recipient List in Word
          2. Adding Merge Fields
          3. Using Merge Rules
          4. Sending a Personal E-Mail Message to a Group of Recipients
        2. 4.2 Create a Mail Merge by Using Other Data Sources
          1. Selecting an External Data Source
          2. Using the Outlook Contacts List
          3. Modifying the Recipient List
        3. 4.3 Create Labels and Envelopes
          1. Setting Up Labels or Envelopes for a Mail Merge
          2. Preparing and Printing Envelopes and Labels
        4. Objective Review
      5. 5. Managing Macros and Forms
        1. 5.1 Apply and Manipulate Macros
          1. Using the Macro Recorder
          2. Running a Macro
          3. Applying Macro Security
        2. 5.2 Apply and Manipulate Macro Options
          1. Running a Macro When You Open a Document
          2. Running a Macro from a Command Button
          3. Adding a Custom Macro Button to the Quick Access Toolbar
        3. 5.3 Create Forms
          1. Designing a Form
          2. Working with Control Properties
            1. Locking Controls
            2. Formatting a Control
            3. Building a List
          3. Adding Help to a Form
          4. Assigning XML Elements to Form Controls
        4. 5.4 Manipulate Forms
          1. Locking and Unlocking a Form
          2. Adding and Removing Form Fields
        5. Objective Review
    10. 2. Exam 77-888 Microsoft Excel 2010 Expert
      1. 1. Sharing and Maintaining Workbooks
        1. 1.1 Apply Workbook Settings, Properties, and Data Options
          1. Saving a Workbook as a Template
          2. Setting Workbook Properties
          3. Exchanging Data with XML
        2. 1.2 Apply Protection and Sharing Properties to Workbooks and Worksheets
          1. Protecting Worksheets and Workbooks
          2. Restricting User Access
          3. Adding a Password to a Workbook
        3. 1.3 Maintain Shared Workbooks
          1. Preparing to Share a Workbook
          2. Sharing a Workbook and Tracking Changes
          3. Reviewing Changes
          4. Merging Workbooks
        4. Objective Review
      2. 2. Applying Formulas and Functions
        1. 2.1 Audit Formulas
          1. Using Auditing Tools to Trace Formulas
          2. Identifying Invalid Data and Formulas
          3. Correcting Formula Errors
            1. Error Checking Options
            2. The Error Checking and Trace Error Commands
          4. Using the Watch Window
        2. 2.2 Manipulate Formula Options
          1. Using Automatic Workbook Calculation
          2. Setting Options for Iterative Calculations
        3. 2.3 Perform Data Summary Tasks
          1. Summing Data with the SUMIF and SUMIFS Functions
          2. Understanding and Defining Array Formulas
            1. Working with Array Formulas
            2. Defining Array Constants
            3. Examples of Array Functions and Formulas
        4. 2.4 Apply Functions in Formulas
          1. Using Built-in Functions
          2. Correcting Function Errors
        5. Objective Review
      3. 3. Presenting Data Visually
        1. 3.1 Apply Advanced Chart Features
          1. Adding Trendlines to Data
          2. Using a Chart Template
          3. Visualizing the Data in a Cell by Using Sparklines
            1. Sparkline Group
            2. Type Group
            3. Show Group
            4. Style Group
            5. Group Group
          4. Creating Dual-Axes Charts
        2. 3.2 Apply Data Analysis
          1. Performing a What-If Analysis
            1. Using Goal Seek
            2. Using Data Tables
            3. Building What-If Scenarios
            4. Using Solver
          2. Using Automated Analysis Tools
            1. Generating Descriptive Statistics
            2. Displaying a Histogram
            3. Using Rank And Percentile
            4. Generating Random Numbers
            5. Sampling Data
        3. 3.3 Apply and Manipulate PivotTables
          1. Building a PivotTable
          2. Working with Data in a PivotTable
            1. Using Field Headers
            2. Managing the Data
            3. Changing Your View of the Data
            4. Using the Calculations Group
            5. Using a Report Filter
          3. Slicing the Data in a PivotTable
        4. 3.4 Apply and Manipulate PivotCharts
          1. Creating a PivotChart
          2. Changing the View for a PivotChart
        5. 3.5 Use External Data Sources
          1. Creating a Data Connection
            1. From Access
            2. From Web
            3. From Text
            4. From Other Sources
          2. Using Existing Connections
          3. Editing Links
        6. Objective Review
      4. 4. Working with Macros and Forms
        1. 4.1 Create and Manipulate Macros
          1. Recording and Storing a Macro
          2. Modifying a Macro
          3. Run a Macro from the Macro Dialog Box
          4. Assigning a Keystroke to a Macro
          5. Running a Macro When You Open a Workbook
          6. Adding a Macro Button to the Ribbon
          7. Adding a Macro Button to the Quick Access Toolbar
          8. Creating an Action Macro
        2. 4.2 Insert and Manipulate Form Controls
          1. Inserting Form Controls
            1. Inserting a Command Button
            2. Setting Up a Combo Box or a List Box
            3. Inserting Check Boxes and Option Buttons
            4. Using Spin Buttons and Scroll Bars
            5. Adding a Label
          2. Defining Form Control Properties
          3. Making Use of ActiveX Controls
          4. A Simple Order Form
          5. Objective Review
    11. 3. Exam 77-885 Microsoft Access 2010 Specialist
      1. 1. Using the Access Workspace
        1. 1.1 Create and Manage a Database
          1. Creating a Database by Using a Template
          2. Using the Save Object As Command
          3. Using Open Dialog Box Options
          4. Working on the Save & Publish Page
            1. Using the Save Database As Option
            2. Using the Save Object As Option
            3. Publishing a Database to Access Services
          5. Compacting and Repairing a Database
          6. Encrypting a Database File
          7. Setting Access Options
            1. General
            2. Current Database
            3. Datasheet
            4. Object Designers
            5. Proofing
            6. Language
            7. Client Settings
            8. Add-Ins
            9. Trust Center
        2. 1.2 Configure the Navigation Pane
          1. Renaming Objects
          2. Deleting Objects
          3. Setting Options for the Navigation Pane
        3. 1.3 Use Application Parts
          1. Insert a Blank Form
          2. Using Quick Start Elements
          3. Applying a User Template
        4. Objective Review
      2. 2. Building Tables
        1. 2.1 Create Tables in Design View
          1. Getting Started
          2. Creating a Lookup Field
          3. Setting Table Properties
            1. Creating a Table Validation Rule
            2. Inserting a Subdatasheet
          4. Defining Indexes
          5. Creating a Data Macro
        2. 2.2 Create and Modify Fields
          1. Inserting, Deleting, and Renaming Fields
            1. Working with Fields in Datasheet View
            2. Working with Fields in Design View
          2. Hiding and Freezing Fields
          3. Setting and Updating Field Properties
            1. Setting Field Properties in Design View
            2. Setting Field Properties in Datasheet View
        3. 2.3 Sort and Filter Records
          1. Finding Records
          2. Sorting Records
          3. Filtering Records
        4. 2.4 Set Relationships
          1. Specifying a Primary Key
          2. Setting Relationships
        5. 2.5 Import Data from a Single Data File
          1. Importing Data into a New Table
            1. Importing Data from Excel
            2. Importing Data from Another Access Database
            3. Importing a Text File
          2. Appending Records
          3. Using Linked Tables
            1. Linking to a Table in Another Access Database
            2. Linking to an Excel Worksheet or a Text File
          4. Managing Linked Tables
        6. Objective Review
      3. 3. Building Forms
        1. 3.1 Create Forms
          1. Building a Form with the Form Wizard
          2. Creating a Blank Form
          3. Creating and Modifying a Form with Form Design Tools
          4. Building a Navigation Form
        2. 3.2 Apply Form Design Options
          1. Applying Themes to a Form
          2. Adding Form Controls
            1. Working with Control Properties
            2. Using Control Wizards
            3. Adding a Subform
          3. Using a Form Header and Footer
          4. Updating Forms from the Tools Group
            1. Setting Form Properties
            2. Setting the Tab Order for a Form
        3. 3.3 Arrange Fields and Objects on a Form
          1. Sizing and Ordering Controls in Design View
          2. Working with Control Layouts in Layout View
        4. 3.4 Format Forms
          1. Modifying a Form’s Background
          2. Formatting Form Controls
          3. Applying Conditional Formatting
            1. Checking Values in the Current Record or Using an Expression
            2. Using Data Bars
        5. Objective Review
      4. 4. Creating and Managing Queries
        1. 4.1 Construct Queries
          1. Selecting Records with a Query
            1. Using the Simple Query Wizard
            2. Using the Query Designer
          2. Using a Make-Table Query
          3. Appending Records with a Query
          4. Updating and Deleting Records with a Query
          5. Viewing Data in a Crosstab Query
            1. Using the Crosstab Query Wizard
            2. Creating a Crosstab Query in Design View
        2. 4.2 Manage Source Tables and Relationships
          1. Adding and Removing Data Sources for a Query
          2. Working with Joins and Relationships in a Query
        3. 4.3 Manipulate Fields
          1. Changing the Fields in a Query
          2. Showing and Hiding Query Fields
          3. Specifying the Sort Order for a Query
        4. 4.4 Calculate Totals
          1. Grouping Query Records
          2. Summarizing Data in a Query
        5. 4.5 Generate Calculated Fields
          1. Adding an Expression to a Query
          2. Entering an Expression in the Zoom Dialog Box
          3. Getting Help with the Expression Builder
        6. Objective Review
      5. 5. Designing Reports
        1. 5.1 Create Reports
          1. Running the Report Wizard
          2. Building a Report in Layout View
          3. Using Report Design Tools
        2. 5.2 Apply Report Design Tab Options
          1. Applying a Theme to a Report
          2. Grouping Report Fields and Calculating Totals
          3. Working with Controls on a Report
          4. Using a Subreport
          5. Adding Information to a Report’s Header and Footer
          6. Managing Report Fields and Properties
        3. 5.3 Apply Report Arrange Tab Options
          1. Arranging Reports in Design View
          2. Working with Report Layouts
        4. 5.4 Apply Report Format Tab Options
          1. Adding a Background Image to a Report
          2. Formatting Report Controls
          3. Highlighting Report Data with Conditional Formatting
        5. 5.5 Apply Report Page Setup Tab Options
          1. Specifying the Page Size for a Report
          2. Changing the Page Layout for a Report
        6. 5.6 Sort and Filter Records for Reporting
          1. Using Report View Types
          2. Filtering Records in Report View
        7. Objective Review
    12. 4. Exam 77-886 Microsoft SharePoint 2010 Specialist
      1. 1. Creating and Formatting Content
        1. 1.1 Navigate the SharePoint Hierarchy
          1. Using the Quick Launch Bar
          2. Adding Content to the Quick Launch Bar
          3. Using All Site Content
          4. Using the SharePoint Breadcrumb Trails Feature
        2. 1.2 Manage Lists and Document Libraries
          1. Creating Lists and Libraries
          2. Editing List and Document Library Properties
            1. Viewing Formats Using the Standard and Datasheet View
            2. Creating, Modifying, and Deleting Views
            3. Creating Columns
        3. 1.3 Manage List Items
          1. Creating Items
          2. Editing Item Properties
          3. Using the Inline Editing Feature
          4. Deleting Items
            1. Delete a Single File or List Item Using the Delete Button
            2. Delete a Single File or List Item by Using the Drop-Down Menu
            3. Delete Several Files or Items by Using the Delete Button
            4. Delete Several Files or List Items by Using Datasheet View
            5. Delete Files in a Document Library by Using the Open With Explorer Option
          5. Enabling Version Control
          6. Managing Workflows
          7. Uploading Documents
          8. Creating and Saving Documents
        4. 1.4 Work with Document Sets
          1. Defining the Document Set Content Type and Creating a Document Set
          2. Adding Documents to a Document Set
            1. About Setting Document Set Versioning
        5. Objective Review
      2. 2. Managing SharePoint Sites
        1. 2.1 Manage Pages
          1. Creating a SharePoint Page
          2. Editing Pages
          3. Deleting Pages
        2. 2.2 Administer Sites
          1. Creating and Configuring a SharePoint Site
          2. Organizing Site Content
          3. Using the Content Organizer
          4. Viewing User Alerts
          5. Modifying Site Appearance
            1. Using a SharePoint Tree View
            2. Applying a SharePoint Site Theme
          6. Recovering Data
        3. 2.3 Manage Web Parts on a Page
          1. Creating a Web Part Page
          2. Adding and Configuring a Web Part
          3. Hiding and Removing a Web Part
          4. Export and Import a Web Part
        4. 2.4 Manage Content Types
          1. Assigning Content Type Management
          2. Assigning a Content Type to a Document Library or List
          3. Adding a Column to a Content Type
        5. 2.5 Manage Users and Groups
          1. Defining User and Group Accounts
          2. Setting User and Group Permissions
        6. 2.6 Create SharePoint Workspace Sites
          1. Setting Up and Using a Document Workspace
          2. Setting Up and Using a Meeting Workspace
        7. 2.7 Analyze Site Activity
        8. Objective Review
      3. 3. Participating in User Communities
        1. 3.1 Configure My Site
          1. Setting Up My Site
          2. Setting Up RSS Feeds
          3. Configuring Profiles
        2. 3.2 Collaborate Through My Site
          1. Updating the Profile Status
          2. Sharing Pictures and Documents in My Site
          3. Managing Personal Documents
          4. Browsing the Organization Hierarchy
          5. Adding Web Parts to My Site
        3. 3.3 Tag and Note Content
          1. Adding Notes on the Note Board for a List or Library
          2. Adding Tags for a List or Library
          3. Rating an Item
          4. Using and Reviewing Tags and Tag Clouds
        4. Objective Review
      4. 4. Configuring and Consuming Site Search Results
        1. 4.1 Administer Search at the Site Level
          1. Setting Up Columns to Be Searched
          2. Searching in a List
          3. Configuring Site Search Visibility
        2. 4.2 Search SharePoint for Content
          1. Searching SharePoint Content with Windows
          2. Searching SharePoint Content from Office 2010
        3. 4.3 View Search Results
          1. Browsing Search Results
          2. Using Best Bet Results
          3. Using the Refinement Panel
          4. Using Alerts and RSS Feeds
          5. Viewing Document Previews
        4. 4.4 Perform Advanced Searches
          1. Setting Up and Running an Advanced Search
        5. 4.5 Search for People
          1. Searching for People
          2. Using Advanced Search Features for People
        6. Objective Review
      5. 5. Integrating SharePoint 2010 Services and Microsoft Office 2010 Applications
        1. 5.1 Configure SharePoint 2010 Services
          1. Understanding SharePoint Services
            1. Visio Services
            2. Access Services
            3. Excel Services
          2. Configuring SharePoint 2010 Services for Excel, Access, and Visio
            1. Publishing a Workbook to Excel Services
            2. Adding an Access Database to a SharePoint Site
            3. Publishing a Visio Diagram to SharePoint
            4. Configuring Form Services
        2. 5.2 Run Microsoft Office 2010 Applications with SharePoint 2010 Services
          1. Using Microsoft Outlook with SharePoint
            1. Document Libraries
            2. Contact Lists
            3. Task Lists
          2. Working with SharePoint Workspace 2010
            1. Understanding Navigation and Layout of a SharePoint 2010 Workspace
            2. Go Offline, Go Online, and Synchronize the SharePoint 2010 Workspace with SharePoint
          3. Using Office Web Apps
        3. 5.3 Create Dashboards
          1. Creating a Dashboard Page
          2. Adding and Configuring Web Parts for Your Dashboard
        4. Objective Review
      6. Index
    13. About the Authors
    14. Copyright