MOS 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access, and SharePoint Exams

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
• Online pre-test to assess your readiness

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

Special Offer: free online pre-test!

• Get 25% off your MOS exam fee and a free Microsoft Official Pre-Test from Certiport
• Use the pre-test to assess your skill level and get feedback on your results, including a custom learning plan
• See details on the Certiport offer page inside

Table of Contents

Exam 77-887 Microsoft Word 2010 Expert
Chapter 1: Sharing and Maintaining Documents
Chapter 2: Formatting Content
Chapter 3: Tracking and Referencing Documents
Chapter 4: Performing Mail Merge Operations
Chapter 5: Managing Macros and Forms

Exam 77-888 Microsoft Excel 2010 Expert
Chapter 1: Sharing and Maintaining Workbooks
Chapter 2: Applying Formulas and Functions
Chapter 3: Presenting Data Visually
Chapter 4: Working with Macros and Forms

Exam 77-885 Microsoft Access 2010 Specialist
Chapter 1: Using the Access Workspace
Chapter 2: Building Tables
Chapter 3: Building Forms
Chapter 4: Creating and Managing Queries
Chapter 5: Designing Reports

Exam 77-886 Microsoft SharePoint 2010 Specialist
Chapter 1: Creating and Formatting Content
Chapter 2: Managing SharePoint Sites
Chapter 3: Participating in User Communities
Chapter 4: Configuring and Consuming Site Search Results
Chapter 5: Integrating SharePoint 2010 Services and Microsoft Office 2010 Applications