MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook® by Lambert, Joan -- Read -- Imperial Library of Trantor

Index

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

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

1. Exam 77-881: Microsoft Word 2010

1. Sharing and Maintaining Documents

1.1 Apply Different Views to a Document

Switching Views

Working in Print Layout View Working in Full Screen Reading View Working in Web Layout View Working in Outline View Working in Draft View

Modifying the Program Window Magnifying Document Content Splitting a Document Window Displaying Multiple Program Windows

1.2 Apply Protection to a Document

Marking a Document as Final Restricting Formatting and Editing Changes Restricting Document Access

1.3 Manage Document Versions 1.4 Share Documents

Sending Documents Saving Documents in Shared Locations Publishing Documents as Blog Posts

1.5 Save a Document 1.6 Apply a Template to a Document Objective Review

2. Formatting Content

2.1 Apply Font and Paragraph Attributes

Applying Character Formatting Applying Styles

2.2 Navigate and Search Through a Document

Moving Around in a Document Searching for Content and Formatting

2.3 Apply Indentation and Tab Settings to Paragraphs

Indenting Paragraphs Setting Tab Stops

2.4 Apply Spacing Settings to Text and Paragraphs 2.5 Create Tables

Creating Basic Tables Formatting Tables Inserting Preformatted Tables

2.6 Manipulate Tables in a Document

Modifying Table Data Modifying Table Structure

2.7 Apply Bullets to a Document Objective Review

3. Applying Page Layout and Reusable Content

3.1 Apply and Manipulate Page Setup Settings

Controlling Page Settings Setting Page Breaks Setting Section Breaks Flowing Text in Columns

3.2 Apply Themes 3.3 Construct Content in a Document by Using the Quick Parts Tool 3.4 Create and Manipulate Page Backgrounds 3.5 Create and Modify Headers and Footers Objective Review

4. Including Illustrations and Graphics in a Document

4.1 Insert and Format Pictures in a Document

Inserting Pictures Formatting Pictures

4.2 Insert and Format Shapes, WordArt, and SmartArt

Inserting and Formatting Shapes Inserting and Modifying WordArt Inserting and Modifying SmartArt Diagrams

4.3 Insert and Format Clip Art 4.4 Apply and Manipulate Text Boxes Objective Review

5. Proofreading Documents

5.1 Validate Content by Using Spelling and Grammar Checking Options 5.2 Configure AutoCorrect Settings 5.3 Insert and Modify Comments in a Document Objective Review

6. Applying References and Hyperlinks

6.1 Apply a Hyperlink

Inserting Hyperlinks Inserting Bookmarks

6.2 Create Endnotes and Footnotes 6.3 Create a Table of Contents Objective Review

7. Performing Mail Merge Operations

7.1 Set Up Mail Merge

Preparing Source Documents

Preparing a Data Source Preparing a Main Document

Merging Source Documents

Setting Up a Manual Mail Merge Setting Up a Mail Merge by Using the Mail Merge Wizard

Checking for Errors

7.2 Execute Mail Merge

Previewing the Results of a Mail Merge Operation Completing the Mail Merge Operation

Objective Review

2. Exam 77-882: Microsoft Excel 2010

1. Managing the Worksheet Environment

1.1 Navigate Through a Worksheet 1.2 Print a Worksheet or Workbook

Printing Part or All of a Workbook Setting Page Breaks Printing Gridlines and Headings Printing Page Headers and Footers

1.3 Personalize the Excel Environment

Managing Program Functionality

Managing Formula Options Managing Advanced Options

Customizing the Ribbon and Quick Access Toolbar

Customizing the Ribbon Customizing the Quick Access Toolbar

Managing Workbooks

Working with Properties Working with Versions

Objective Review

2. Creating Cell Data

2.1 Construct Cell Data

Pasting Structured Data Inserting and Deleting Data

2.2 Apply Auto Fill

Filling a Data Series Copying Data

2.3 Apply and Manipulate Hyperlinks

Creating Hyperlinks Modifying Hyperlinks

Objective Review

3. Formatting Cells and Worksheets

3.1 Apply and Modify Cell Formats

Formatting Cell Content Formatting Cell Fills and Borders Setting Row Height and Column Width Formatting Numbers

3.2 Merge or Split Cells 3.3 Create Row and Column Titles 3.4 Hide or Unhide Rows and Columns 3.5 Manipulate Page Setup Options for Worksheets 3.6 Create and Apply Cell Styles Objective Review

4. Managing Worksheets and Workbooks

4.1 Create and Format Worksheets 4.2 Manipulate Window Views

Freezing and Splitting Windows Displaying Multiple Windows

4.3 Manipulate Workbook Views

Switching Worksheet Views Customizing the Program Window Customizing Worksheet Appearance Changing the Zoom Level

Objective Review

5. Applying Formulas and Functions

5.1 Create Formulas 5.2 Enforce Precedence 5.3 Apply Cell References in Formulas 5.4 Apply Conditional Logic in Formulas

Creating Conditional Formulas Nesting Functions

5.5 Apply Named Ranges in Formulas 5.6 Apply Cell Ranges in Formulas Objective Review

6. Presenting Data Visually

6.1 Create Charts Based on Worksheet Data

Plotting Charts Applying Layouts and Styles Moving and Sizing Charts Editing Data Configuring Chart Elements

6.2 Apply and Manipulate Illustrations

Inserting and Formatting Clip Art Inserting and Modifying SmartArt Diagrams Inserting and Formatting Shapes Capturing Screenshots

6.3 Create and Modify Images 6.4 Apply Sparklines Objective Review

7. Sharing Worksheet Data with Other Users

7.1 Share Spreadsheets

Saving Workbooks in Specific Formats Sending Workbooks

7.2 Manage Comments Objective Review

8. Analyzing and Organizing Data

8.1 Filter Data 8.2 Sort Data 8.3 Apply Conditional Formatting Objective Review

3. Exam 77-883: Microsoft PowerPoint 2010

1. Managing the PowerPoint Environment

1.1 Adjust Views

Switching Views Zooming In and Out

1.2 Manipulate the PowerPoint Window

Working with Multiple Program Windows Sizing Panes in Normal View

1.3 Configure the Quick Access Toolbar 1.4 Configure PowerPoint File Options Objective Review

2. Creating a Slide Presentation

2.1 Construct and Edit Photo Albums

Creating Photo Albums Editing Photo Albums

2.2 Apply Slide Size and Orientation Settings 2.3 Add and Remove Slides

Inserting New Slides Reusing Slides Inserting Outlines Rearranging Slides Deleting Slides Hiding Slides

2.4 Format Slides

Applying and Modifying Themes Formatting the Background of Slides Inserting Footer Information Dividing a Presentation into Sections Customizing Slide Masters

2.5 Enter and Format Text

Entering Text in Text Placeholders Entering Text in Independent Text Boxes Editing Text Formatting Characters and Paragraphs Formatting Bulleted and Numbered Lists

2.6 Format Text Boxes

Changing the Shape of Text Boxes Sizing and Positioning Text Boxes Aligning Text Boxes Formatting Text Boxes Adjusting the Text Layout Setting Default Formatting

Objective Review

3. Working with Graphical and Multimedia Elements

3.1 Manipulate Graphical Elements

Opening the Format Dialog Box Applying Styles, Borders, and Effects Sizing and Positioning a Graphic Changing the Stacking Order Grouping Graphics Aligning Graphics Linking Graphics to Other Information

3.2 Manipulate Images

Cropping Images Formatting Images Compressing Pictures Resetting or Replacing Images

3.3 Modify WordArt and Shapes

Working with WordArt Working with Shapes

3.4 Manipulate SmartArt

Creating Diagrams Making Design Changes Changing Shapes in Diagrams Converting Diagrams to Shapes or Bullet Points

3.5 Edit Video and Audio Content

Inserting and Editing Video Content Inserting and Editing Audio Content

Objective Review

4. Creating Charts and Tables

4.1 Construct and Modify Tables

Inserting Tables and Editing Table Content Changing Table Structure Formatting Tables Inserting and Modifying Excel Worksheets

4.2 Insert and Modify Charts

Inserting Charts and Editing Chart Data Changing the Chart Type and Layout

4.3 Apply Chart Elements 4.4 Manipulate Chart Layouts

Selecting Chart Elements Sizing and Positioning Elements

4.5 Manipulate Chart Elements Objective Review

5. Applying Transitions and Animations

5.1 Apply Built-In and Custom Animations

Applying Built-In Animations Applying Fancier Animations Copying Animations

5.2 Apply Effect and Path Options

Fine-Tuning Animation Effects Adjusting Motion Paths

5.3 Manipulate Animations 5.4 Apply and Modify Transitions Between Slides Objective Review

6. Collaborating on Presentations

6.1 Manage Comments in Presentations 6.2 Apply Proofing Tools

Using AutoCorrect Correcting Spelling Mistakes Finding and Replacing Text and Fonts Using the Thesaurus Comparing and Combining Presentations

Objective Review

7. Preparing Presentations for Delivery

7.1 Save Presentations 7.2 Share Presentations

Compressing Media Packaging for CD Delivery Creating Videos

7.3 Print Presentations

Previewing and Printing Printing Handouts and Notes

7.4 Protect Presentations

Removing Extraneous Information Assigning Passwords Marking as Final Attaching Digital Signatures

Objective Review

8. Delivering Presentations

8.1 Apply Presentation Tools 8.2 Set Up Slide Shows

Adjusting Slide Show Settings Setting Up Presenter View Broadcasting Slide Shows Creating Custom Slide Shows

8.3 Set Presentation Timing 8.4 Record Presentations Objective Review

4. Exam 77-884: Microsoft Outlook 2010

1. Managing the Outlook Environment

1.1 Apply and Manipulate Outlook Program Options

Managing Mail Module Options

Compose Messages Outlook Panes Message Arrival Conversation Clean Up Replies and Forwards Save Messages Send Messages MailTips Tracking Other Mail Module Options

Managing Calendar Module Options

Work Time Calendar Options Display Options Time Zones Scheduling Options

Managing Contacts Module Options Managing Tasks Module Options Managing Notes Module and Journal Options Managing Language Options Managing Advanced Options

Outlook Panes Outlook Start And Exit AutoArchive Reminders Export RSS Feeds Send and Receive Other

1.2 Manipulate Item Tags

Working with Color Categories Setting Message Sensitivity and Importance Setting Message Properties Flagging Items for Follow-Up Changing Read Status

1.3 Arrange the Content Pane

Displaying and Hiding Program Window Panes

Managing the Navigation Pane Managing the Reading Pane Managing the To-Do Bar

Displaying Module Content Displaying List Views Modifying List Views Working with the Status Bar

1.4 Apply Search and Filter Tools

Using Instant Search Using Search Folders

1.5 Print an Outlook Item

Printing Items Printing Messages Printing a Calendar Printing Contact Records

Objective Review

2. Creating and Formatting Item Content

2.1 Create and Send Email Messages

Formatting Messages Setting Message Options Sending Messages

2.2 Create and Manage Quick Steps 2.3 Create Item Content

Inserting Visual Elements Inserting SmartArt Graphics Inserting Charts Inserting Screen Images Modifying Visual Elements Creating Hyperlinks

2.4 Format Item Content

Applying Text and Paragraph Formatting Applying and Managing Styles Applying and Managing Style Sets Applying and Managing Themes

2.5 Attach Content to Email Messages Objective Review

3. Managing Email Messages

3.1 Clean Up the Mailbox

Managing Mailbox Size Managing Conversations Saving Messages and Message Attachments

3.2 Create and Manage Rules

Managing Mail by Using Outlook Rules Creating Automatic Reply Rules

3.3 Manage Junk Email

Working with Junk Email Messages Configuring Junk Email Options

3.4 Manage Automatic Message Content

Creating and Using Automatic Signatures Setting a Default Theme, Stationery, and Fonts Identifying Response Text

Objective Review

4. Managing Contacts

4.1 Create and Manipulate Contacts

Creating Contact Records Creating Electronic Business Cards

4.2 Create and Manipulate Contact Groups Objective Review

5. Managing Calendar Objects

5.1 Create and Manipulate Appointments and Events

Scheduling Appointments Scheduling Events Setting Recurrence and Privacy Options Working with Appointments and Events

5.2 Create and Manipulate Meeting Requests

Creating Meeting Requests Scheduling Meetings Responding to Meeting Requests Rescheduling and Canceling Meetings

5.3 Manipulate the Calendar Pane

Arranging Calendar Content Displaying Different Views Displaying Multiple Calendars Changing Calendar Colors

Objective Review

6. Working with Tasks, Notes, and Journal Entries

6.1 Create and Manipulate Tasks

Creating Tasks Displaying Views of Tasks Managing Tasks Managing Task Details Managing Task Assignments Finalizing Tasks

6.2 Create and Manipulate Notes

Creating Notes Displaying Views of Notes Organizing Notes

6.3 Create and Manipulate Journal Entries

Activating the Outlook Journal Automatically Recording Information Editing Journal Entries

Objective Review

A. About the Authors

The Team Online Training Solutions, Inc. (OTSI)

Index About the Authors

← Prev
Back
Next →

← Prev
Back
Next →