Synopses & Reviews
Demonstrate your expertise with the 2007 Microsoft Office system! This comprehensive study guide covers all the Microsoft Certified Application Specialist exams for Microsoft Office, including Word 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Access 2007. For each exam, youll build the skills and knowledge measured by its objectives through a series of step-by-step exercises, practice questions, and real-world scenarios. Easy-to-follow screen shots and explanations bring key concepts to life and expertly guide you through the material. You'll even get a voucher for a practice pre-test. Earn the premier credential and showcase your expertise in the popular Microsoft Office programs.
Synopsis
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.
About the Author
Joan Lambert has worked closely with Microsoft technologies since 1986 and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently.
Joan is the author or coauthor of more than three dozen books about Windows and Office (for the Windows, Mac, and iPad platforms) and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for Office 2013, Office 2010, and Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.
Joyce Cox has 20+ years’ experience developing training materials on technical subjects for non-technical audiences, including dozens of books about Office and Windows.
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 Books 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);