MOS 2010 Study Guide for Microsoft Word, Excel, PowerPoint and Outlook

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.

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; Exam 77-881: Microsoft Word 2010; Exam 77-882: Microsoft Excel 2010; Exam 77-883: Microsoft PowerPoint 2010; Exam 77-884: Microsoft Outlook 2010; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Procedure Steps; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; Getting Support and Giving Feedback; Errata; Getting Help with Microsoft Office 2010; We Want to Hear from You; Stay in Touch; Part 1: Exam 77-881: Microsoft Word 2010; Chapter 1: Sharing and Maintaining Documents; 1.1 1.1 Apply Different Views to a Document; 1.2 1.2 Apply Protection to a Document; 1.3 1.3 Manage Document Versions; 1.4 1.4 Share Documents; 1.5 1.5 Save a Document; 1.6 1.6 Apply a Template to a Document; 1.7 Objective Review; Chapter 2: Formatting Content; 2.1 2.1 Apply Font and Paragraph Attributes; 2.2 2.2 Navigate and Search Through a Document; 2.3 2.3 Apply Indentation and Tab Settings to Paragraphs; 2.4 2.4 Apply Spacing Settings to Text and Paragraphs; 2.5 2.5 Create Tables; 2.6 2.6 Manipulate Tables in a Document; 2.7 2.7 Apply Bullets to a Document; 2.8 Objective Review; Chapter 3: Applying Page Layout and Reusable Content; 3.1 3.1 Apply and Manipulate Page Setup Settings; 3.2 3.2 Apply Themes; 3.3 3.3 Construct Content in a Document by Using the Quick Parts Tool; 3.4 3.4 Create and Manipulate Page Backgrounds; 3.5 3.5 Create and Modify Headers and Footers; 3.6 Objective Review; Chapter 4: Including Illustrations and Graphics in a Document; 4.1 4.1 Insert and Format Pictures in a Document; 4.2 4.2 Insert and Format Shapes, WordArt, and SmartArt; 4.3 4.3 Insert and Format Clip Art; 4.4 4.4 Apply and Manipulate Text Boxes; 4.5 Objective Review; Chapter 5: Proofreading Documents; 5.1 5.1 Validate Content by Using Spelling and Grammar Checking Options; 5.2 5.2 Configure AutoCorrect Settings; 5.3 5.3 Insert and Modify Comments in a Document; 5.4 Objective Review; Chapter 6: Applying References and Hyperlinks; 6.1 6.1 Apply a Hyperlink; 6.2 6.2 Create Endnotes and Footnotes; 6.3 6.3 Create a Table of Contents; 6.4 Objective Review; Chapter 7: Performing Mail Merge Operations; 7.1 7.1 Set Up Mail Merge; 7.2 7.2 Execute Mail Merge; 7.3 Objective Review; Part 2: Exam 77-882: Microsoft Excel 2010; Chapter 1: Managing the Worksheet Environment; 8.1 1.1 Navigate Through a Worksheet; 8.2 1.2 Print a Worksheet or Workbook; 8.3 1.3 Personalize the Excel Environment; 8.4 Objective Review; Chapter 2: Creating Cell Data; 9.1 2.1 Construct Cell Data; 9.2 2.2 Apply Auto Fill; 9.3 2.3 Apply and Manipulate Hyperlinks; 9.4 Objective Review; Chapter 3: Formatting Cells and Worksheets; 10.1 3.1 Apply and Modify Cell Formats; 10.2 3.2 Merge or Split Cells; 10.3 3.3 Create Row and Column Titles; 10.4 3.4 Hide or Unhide Rows and Columns; 10.5 3.5 Manipulate Page Setup Options for Worksheets; 10.6 3.6 Create and Apply Cell Styles; 10.7 Objective Review; Chapter 4: Managing Worksheets and Workbooks; 11.1 4.1 Create and Format Worksheets; 11.2 4.2 Manipulate Window Views; 11.3 4.3 Manipulate Workbook Views; 11.4 Objective Review; Chapter 5: Applying Formulas and Functions; 12.1 5.1 Create Formulas; 12.2 5.2 Enforce Precedence; 12.3 5.3 Apply Cell References in Formulas; 12.4 5.4 Apply Conditional Logic in Formulas; 12.5 5.5 Apply Named Ranges in Formulas; 12.6 5.6 Apply Cell Ranges in Formulas; 12.7 Objective Review; Chapter 6: Presenting Data Visually; 13.1 6.1 Create Charts Based on Worksheet Data; 13.2 6.2 Apply and Manipulate Illustrations; 13.3 6.3 Create and Modify Images; 13.4 6.4 Apply Sparklines; 13.5 Objective Review; Chapter 7: Sharing Worksheet Data with Other Users; 14.1 7.1 Share Spreadsheets; 14.2 7.2 Manage Comments; 14.3 Objective Review; Chapter 8: Analyzing and Organizing Data; 15.1 8.1 Filter Data; 15.2 8.2 Sort Data; 15.3 8.3 Apply Conditional Formatting; 15.4 Objective Review; Part 3: Exam 77-883: Microsoft PowerPoint 2010; Chapter 1: Managing the PowerPoint Environment; 16.1 1.1 Adjust Views; 16.2 1.2 Manipulate the PowerPoint Window; 16.3 1.3 Configure the Quick Access Toolbar; 16.4 1.4 Configure PowerPoint File Options; 16.5 Objective Review; Chapter 2: Creating a Slide Presentation; 17.1 2.1 Construct and Edit Photo Albums; 17.2 222222.2 Apply Slide Size and Orientation Settings; 17.3 2.3 Add and Remove Slides; 17.4 2.4 Format Slides; 17.5 2.5 Enter and Format Text; 17.6 2.6 Format Text Boxes; 17.7 Objective Review; Chapter 3: Working with Graphical and Multimedia Elements; 18.1 3.1 Manipulate Graphical Elements; 18.2 3.2 Manipulate Images; 18.3 3.3 Modify WordArt and Shapes; 18.4 3.4 Manipulate SmartArt; 18.5 3.5 Edit Video and Audio Content; 18.6 Objective Review; Chapter 4: Creating Charts and Tables; 19.1 4.1 Construct and Modify Tables; 19.2 4.2 Insert and Modify Charts; 19.3 4.3 Apply Chart Elements; 19.4 4.4 Manipulate Chart Layouts; 19.5 4.5 Manipulate Chart Elements; 19.6 Objective Review; Chapter 5: Applying Transitions and Animations; 20.1 5.1 Apply Built-In and Custom Animations; 20.2 5.2 Apply Effect and Path Options; 20.3 5.3 Manipulate Animations; 20.4 5.4 Apply and Modify Transitions Between Slides; 20.5 Objective Review; Chapter 6: Collaborating on Presentations; 21.1 6.1 Manage Comments in Presentations; 21.2 6.2 Apply Proofing Tools; 21.3 Objective Review; Chapter 7: Preparing Presentations for Delivery; 22.1 7.1 Save Presentations; 22.2 7.2 Share Presentations; 22.3 7.3 Print Presentations; 22.4 7.4 Protect Presentations; 22.5 Objective Review; Chapter 8: Delivering Presentations; 23.1 8.1 Apply Presentation Tools; 23.2 8.2 Set Up Slide Shows; 23.3 8.3 Set Presentation Timing; 23.4 8.4 Record Presentations; 23.5 Objective Review; Part 4: Exam 77-884: Microsoft Outlook 2010; Chapter 1: Managing the Outlook Environment; 24.1 1.1 Apply and Manipulate Outlook Program Options; 24.2 1.2 Manipulate Item Tags; 24.3 1.3 Arrange the Content Pane; 24.4 1.4 Apply Search and Filter Tools; 24.5 1.5 Print an Outlook Item; 24.6 Objective Review; Chapter 2: Creating and Formatting Item Content; 25.1 2.1 Create and Send Email Messages; 25.2 2.2 Create and Manage Quick Steps; 25.3 2.3 Create Item Content; 25.4 2.4 Format Item Content; 25.5 2.5 Attach Content to Email Messages; 25.6 Objective Review; Chapter 3: Managing Email Messages; 26.1 3.1 Clean Up the Mailbox; 26.2 3.2 Create and Manage Rules; 26.3 3.3 Manage Junk Email; 26.4 3.4 Manage Automatic Message Content; 26.5 Objective Review; Chapter 4: Managing Contacts; 27.1 4.1 Create and Manipulate Contacts; 27.2 4.2 Create and Manipulate Contact Groups; 27.3 Objective Review; Chapter 5: Managing Calendar Objects; 28.1 5.1 Create and Manipulate Appointments and Events; 28.2 5.2 Create and Manipulate Meeting Requests; 28.3 5.3 Manipulate the Calendar Pane; 28.4 Objective Review; Chapter 6: Working with Tasks, Notes, and Journal Entries; 29.1 6.1 Create and Manipulate Tasks; 29.2 6.2 Create and Manipulate Notes; 29.3 6.3 Create and Manipulate Journal Entries; 29.4 Objective Review; About the Authors; The Team; Online Training Solutions, Inc. (OTSI);