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

by Geoff Evelyn, John Pierce

Overview

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
• Includes downloadable practice files

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

Product Details

ISBN-13:	9780735664869
Publisher:	Pearson Education
Publication date:	08/12/2011
Series:	MOS Study Guide
Sold by:	Barnes & Noble
Format:	eBook
Pages:	720
File size:	14 MB
Note:	This product may take a few minutes to download.

About 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 (http://www.sharepointgeoff.com). 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.

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;

John Pierce was a Microsoft® employee for nearly 12 years and now enjoys being a freelance writer and editor. He is the author of Microsoft Office Access® 2003 Inside Track, the coauthor of Microsoft Small Business Kit, and has contributed to numerous other books about Microsoft software.

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 (sharepointgeoff.com). 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.