Gift Guide

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

( 2 )


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 ...
See more details below
$31.47 price
(Save 37%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (25) from $11.47   
  • New (14) from $29.21   
  • Used (11) from $11.46   
MOS 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access, and SharePoint Exams

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99 price
(Save 42%)$39.99 List Price


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
Read More Show Less

Product Details

  • ISBN-13: 9780735657885
  • Publisher: Microsoft Press
  • Publication date: 8/19/2011
  • Pages: 720
  • Sales rank: 327,305
  • Product dimensions: 7.30 (w) x 8.90 (h) x 1.40 (d)

Meet the Author

Geoff Evelyn enjoys over 25 years in Information Technology with over 10 years' experience in SharePoint, covering development, design and implementation. He majors in SharePoint information systems design, architecture, implementation, planning, governance and automation, all in the land of SharePoint. Geoff headed the team to introduce SharePoint to the Scottish Highland University in 2001 and then on to over 30 Scottish colleges. He then went on to help implement, manage and govern SharePoint in many global companies. Geoff is a Fellow of Institute of Analysts and Programmers, a member of the Institute for the Management of Information Systems and has published many articles and guides on SharePoint, all available online and on his website ( Geoff is an MCITP in SharePoint 2010 Administrator, and holds an MCTS in SharePoint 2007 in Configuration and Development. He is also a Microsoft Office Specialist Project, Word, Outlook and PowerPoint, holds MCDST and is a Prince 2 Practitioner.

Read More Show Less

Table of Contents

Taking a Microsoft Office Specialist Exam; Microsoft Office Specialist Certification; Selecting a Certification Path; Test-Taking Tips; Certification Benefits; For More Information; Using This Book to Study for a Certification Exam; Features and Conventions of This Book; Using the Book’s Companion Content; Your Companion eBook; Modifying the Display of the Ribbon; How to Get Support and Provide Feedback; Errata & Book Support; We Want to Hear from You; Stay in Touch; Part 1: Exam 77-887 Microsoft Word 2010 Expert; Chapter 1: Sharing and Maintaining Documents; 1.1 1.1 Configure Word Options; 1.2 1.2 Apply Protection to a Document; 1.3 1.3 Apply a Template to a Document; 1.4 Objective Review; Chapter 2: Formatting Content; 2.1 2.1 Apply Advanced Font and Paragraph Attributes; 2.2 2.2 Create Tables and Charts; 2.3 2.3 Construct Reusable Content in a Document; 2.4 2.4 Link Text Boxes and Sections; 2.5 Objective Review; Chapter 3: Tracking and Referencing Documents; 3.1 3.1 Review, Compare, and Combine Documents; 3.2 3.2 Create a Reference Page; 3.3 3.3 Create a Table of Authorities in a Document; 3.4 3.4 Mark and Compile an Index for a Document; 3.5 Objective Review; Chapter 4: Performing Mail Merge Operations; 4.1 4.1 Execute a Mail Merge Operation; 4.2 4.2 Create a Mail Merge by Using Other Data Sources; 4.3 4.3 Create Labels and Envelopes; 4.4 Objective Review; Chapter 5: Managing Macros and Forms; 5.1 5.1 Apply and Manipulate Macros; 5.2 5.2 Apply and Manipulate Macro Options; 5.3 5.3 Create Forms; 5.4 5.4 Manipulate Forms; 5.5 Objective Review; Part 2: Exam 77-888 Microsoft Excel 2010 Expert; Chapter 1: Sharing and Maintaining Workbooks; 6.1 1.1 Apply Workbook Settings, Properties, and Data Options; 6.2 1.2 Apply Protection and Sharing Properties to Workbooks and Worksheets; 6.3 1.3 Maintain Shared Workbooks; 6.4 Objective Review; Chapter 2: Applying Formulas and Functions; 7.1 2.1 Audit Formulas; 7.2 2.2 Manipulate Formula Options; 7.3 2.3 Perform Data Summary Tasks; 7.4 2.4 Apply Functions in Formulas; 7.5 Objective Review; Chapter 3: Presenting Data Visually; 8.1 3.1 Apply Advanced Chart Features; 8.2 3.2 Apply Data Analysis; 8.3 3.3 Apply and Manipulate PivotTables; 8.4 3.4 Apply and Manipulate PivotCharts; 8.5 3.5 Use External Data Sources; 8.6 Objective Review; Chapter 4: Working with Macros and Forms; 9.1 4.1 Create and Manipulate Macros; 9.2 4.2 Insert and Manipulate Form Controls; Part 3: Exam 77-885 Microsoft Access 2010 Specialist; Chapter 1: Using the Access Workspace; 10.1 1.1 Create and Manage a Database; 10.2 1.2 Configure the Navigation Pane; 10.3 1.3 Use Application Parts; 10.4 Objective Review; Chapter 2: Building Tables; 11.1 2.1 Create Tables in Design View; 11.2 2.2 Create and Modify Fields; 11.3 2.3 Sort and Filter Records; 11.4 2.4 Set Relationships; 11.5 2.5 Import Data from a Single Data File; 11.6 Objective Review; Chapter 3: Building Forms; 12.1 3.1 Create Forms; 12.2 3.2 Apply Form Design Options; 12.3 3.3 Arrange Fields and Objects on a Form; 12.4 3.4 Format Forms; 12.5 Objective Review; Chapter 4: Creating and Managing Queries; 13.1 4.1 Construct Queries; 13.2 4.2 Manage Source Tables and Relationships; 13.3 4.3 Manipulate Fields; 13.4 4.4 Calculate Totals; 13.5 4.5 Generate Calculated Fields; 13.6 Objective Review; Chapter 5: Designing Reports; 14.1 5.1 Create Reports; 14.2 5.2 Apply Report Design Tab Options; 14.3 5.3 Apply Report Arrange Tab Options; 14.4 5.4 Apply Report Format Tab Options; 14.5 5.5 Apply Report Page Setup Tab Options; 14.6 5.6 Sort and Filter Records for Reporting; 14.7 Objective Review; Part 4: Exam 77-886 Microsoft SharePoint 2010 Specialist; Chapter 1: Creating and Formatting Content; 15.1 1.1 Navigate the SharePoint Hierarchy; 15.2 1.2 Manage Lists and Document Libraries; 15.3 1.3 Manage List Items; 15.4 1.4 Work with Document Sets; 15.5 Objective Review; Chapter 2: Managing SharePoint Sites; 16.1 2.1 Manage Pages; 16.2 2.2 Administer Sites; 16.3 2.3 Manage Web Parts on a Page; 16.4 2.4 Manage Content Types; 16.5 2.5 Manage Users and Groups; 16.6 2.6 Create SharePoint Workspace Sites; 16.7 2.7 Analyze Site Activity; 16.8 Objective Review; Chapter 3: Participating in User Communities; 17.1 3.1 Configure My Site; 17.2 3.2 Collaborate Through My Site; 17.3 3.3 Tag and Note Content; 17.4 Objective Review; Chapter 4: Configuring and Consuming Site Search Results; 18.1 4.1 Administer Search at the Site Level; 18.2 4.2 Search SharePoint for Content; 18.3 4.3 View Search Results; 18.4 4.4 Perform Advanced Searches; 18.5 4.5 Search for People; 18.6 OOOOOObjective Review; Chapter 5: Integrating SharePoint 2010 Services and Microsoft Office 2010 Applications; 19.1 5.1 Configure SharePoint 2010 Services; 19.2 5.2 Run Microsoft Office 2010 Applications with SharePoint 2010 Services; 19.3 5.3 Create Dashboards; 19.4 Objective Review;

Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted October 9, 2013

    Very Useful

    This is the ONLY study guide I could find for 77-886: SharePoint 2010 and I easily passed the exam after using it. Well that and a year of hands-on experience with 2010.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 12, 2014

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)