You are previewing Microsoft® Office Specialist Study Guide Office 2003 Edition.
O'Reilly logo
Microsoft® Office Specialist Study Guide Office 2003 Edition

Book Description

Get in-depth, all-in-one exam prep for the Microsoft Office Specialist (MOS) exams for the Microsoft Office 2003 Editions track, including Microsoft Office Word, Excel, Access, PowerPoint®, and Outlook®.

Table of Contents

  1. Microsoft® Office Specialist Study Guide—Office 2003 Edition
  2. A Note Regarding Supplemental Files
  3. Introduction
    1. About Microsoft Office Specialist Certification
      1. Proving Yourself
      2. Putting Microsoft on Your Résumé
      3. Earning College Credit
    2. About This Book
      1. Organization
      2. Recommended Strategy
      3. Knowledge You Need Before Beginning This Book
      4. Conventions
    3. About the Book’s CD-ROM
      1. Minimum System Requirements
      2. Installing the Practice Files
      3. Uninstalling the Practice Files
    4. How to Get Help
      1. Getting Help with This Book and Its CD-ROM
      2. Getting Additional Help
  4. I. Microsoft Office Specialist Word 2003 Core Exam
    1. W03C-1. Creating Content
      1. W03C-1-1. Insert and Edit Text, Symbols, and Special Characters
        1. Inserting Visible and Hidden Text
        2. Practice Exercise
        3. Inserting Symbols and Special Characters
        4. Practice Exercise
        5. Editing and Deleting Text
        6. Practice Exercise
        7. Moving and Copying Text
        8. Practice Exercise
        9. Checking Spelling and Grammar
        10. Practice Exercise
        11. Using the Thesaurus to Find the Best Word
        12. Practice Exercise
      2. W03C-1-2. Insert Frequently Used and Predefined Text
        1. Using AutoCorrect
        2. Practice Exercise
        3. Using AutoText
        4. Practice Exercise
        5. Inserting the Date and Time
        6. Practice Exercise
      3. W03C-1-3. Navigate to Specific Content
        1. Finding and Replacing Text
        2. Practice Exercise
        3. Jumping to a Specific Item
        4. Practice Exercise
      4. W03C-1-4. Insert, Position, and Size Graphics
        1. Inserting, Positioning, and Sizing Graphics
        2. Practice Exercise
        3. Inserting, Positioning, and Sizing Text Boxes
        4. Practice Exercise
        5. Inserting, Positioning, and Sizing Shapes
        6. Practice Exercise
      5. W03C-1-5. Create and Modify Diagrams and Charts
        1. Inserting and Formatting Organization Charts
        2. Practice Exercise
        3. Inserting and Formatting Charts
        4. Practice Exercise
      6. W03C-1-6. Locate, Select, and Insert Supporting Information
        1. Using the Research Service to Locate and Insert Information
        2. Practice Exercise
      7. W03C-1. Review
    2. W03C-2. Organizing Content
      1. W03C-2-1. Insert and Modify Tables
        1. Inserting Tables
        2. Practice Exercise
        3. Converting Text to Tables
        4. Practice Exercise
        5. Changing Table Structure
        6. Practice Exercise
        7. Formatting Tables Manually
        8. Practice Exercise
        9. Applying Predefined Formats to Tables
        10. Practice Exercise
      2. W03C-2-2. Create Bulleted Lists, Numbered Lists, and Outlines
        1. Creating and Customizing Bulleted Lists
        2. Practice Exercise
        3. Creating and Customizing Numbered Lists
        4. Practice Exercise
        5. Creating Outlines
        6. Practice Exercise
      3. W03C-2-3. Insert and Modify Hyperlinks
        1. Inserting Hyperlinks to Documents, Web Pages, and E-Mail Addresses
        2. Practice Exercise
        3. Editing and Removing Hyperlinks
        4. Practice Exercise
      4. W03C-2. Review
    3. W03C-3. Formatting Content
      1. W03C-3-1. Format Text
        1. Applying Common Character Formatting
        2. Practice Exercise
        3. Finding and Replacing Character Formatting
        4. Practice Exercise
        5. Working with Styles
        6. Practice Exercises
        7. Highlighting Text
        8. Practice Exercise
        9. Applying Text Effects
        10. Practice Exercise
        11. Modifying Character Spacing
        12. Practice Exercise
      2. W03C-3-2. Format Paragraphs
        1. Indenting, Spacing, and Aligning Paragraphs
        2. Practice Exercise
        3. Applying Borders and Shading to Paragraphs
        4. Practice Exercise
        5. Setting, Removing, and Modifying Tab Stops
        6. Practice Exercise
      3. W03C-3-3. Apply and Format Columns
        1. Setting Up Multiple Columns
        2. Practice Exercise
        3. Formatting Columns
        4. Practice Exercise
      4. W03C-3-4. Insert and Modify Content in Headers and Footers
        1. Creating and Modifying Headers and Footers
        2. Practice Exercise
        3. Inserting and Formatting Page Numbers
        4. Practice Exercise
      5. W03C-3-5. Modify Document Layout and Page Setup
        1. Inserting and Deleting Breaks
        2. Practice Exercise
        3. Modifying Page Margins and Page Orientation
        4. Practice Exercise
      6. W03C-3. Review
    4. W03C-4. Collaborating
      1. W03C-4-1. Circulate Documents for Review
        1. Sending a Document for Review
        2. Practice Exercise
        3. Sending a Document as an E-Mail Attachment
        4. Practice Exercise
      2. W03C-4-2. Compare and Merge Document Versions
        1. Comparing and Merging Documents
        2. Practice Exercise
        3. Viewing Changes in a Merged Document
        4. Practice Exercise
      3. W03C-4-3. Insert, View, and Edit Comments
        1. Inserting and Reviewing Comments
        2. Practice Exercise
        3. Editing Comments
        4. Practice Exercise
      4. W03C-4-4. Track, Accept, and Reject Proposed Changes
        1. Tracking Changes to a Document
        2. Practice Exercise
        3. Locating and Managing Document Changes
        4. Practice Exercise
      5. W03C-4. Review
    5. W03C-5. Formatting and Managing Documents
      1. W03C-5-1. Create New Documents Using Templates
        1. Creating a New Document Based on a Template
        2. Practice Exercise
      2. W03C-5-2. Review and Modify Document Properties
        1. Reviewing and Modifying Summary Information
        2. Practice Exercise
        3. Checking Word, Paragraph, and Character Counts
        4. Practice Exercise
      3. W03C-5-3. Organize Documents Using File Folders
        1. Creating a Folder in Which to Store a Document
        2. Practice Exercise
        3. Renaming or Deleting a Document or Folder
        4. Practice Exercise
      4. W03C-5-4. Save Documents in Appropriate Formats for Different Uses
        1. Saving a Document for Use in Another Program
        2. Practice Exercise
        3. Saving a Document as a Web Page
        4. Practice Exercise
      5. W03C-5-5. Print Documents, Envelopes, and Labels
        1. Printing a Document
        2. Practice Exercise
        3. Printing an Envelope or Label
        4. Practice Exercise
      6. W03C-5-6. Preview Documents and Web Pages
        1. Previewing a Document Before Printing
        2. Practice Exercise
        3. Previewing a Web Page for Publication
        4. Practice Exercise
      7. W03C-5-7. Change and Organize Document Views and Windows
        1. Switching Views
        2. Working in Print Layout View
        3. Practice Exercise
        4. Working in Reading Layout View
        5. Practice Exercise
        6. Arranging and Splitting Windows
        7. Practice Exercise
      8. W03C-5. Review
  5. II. Microsoft Office Specialist Word 2003 Expert Exam
    1. W03E-1. Formatting Content
      1. W03E-1-1. Create Custom Styles for Text, Tables, and Lists
        1. Creating Character and Paragraph Styles
        2. Practice Exercise
        3. Creating Table Styles
        4. Practice Exercise
        5. Creating List Styles
        6. Practice Exercise
      2. W03E-1-2. Control Pagination
        1. Controlling Orphans and Widows
        2. Practice Exercise
        3. Keeping Paragraphs Together
        4. Practice Exercise
      3. W03E-1-3. Format, Position, and Resize Graphics Using Advanced Layout Features
        1. Sizing, Scaling, Cropping, and Rotating a Graphic
        2. Practice Exercise
        3. Controlling Contrast and Brightness
        4. Practice Exercise
        5. Positioning a Graphic in Relation to the Surrounding Text
        6. Practice Exercise
      4. W03E-1-4. Insert and Modify Objects
        1. Inserting and Modifying a New Object
        2. Practice Exercise
        3. Inserting and Modifying an Object from a File
        4. Practice Exercise
      5. W03E-1-5. Create and Modify Diagrams and Charts Using Data from Other Sources
        1. Importing Data to Create a Chart
        2. Practice Exercise
        3. Linking a Chart to Data from Another Source
        4. Practice Exercise
      6. W03E-1. Review
    2. W03E-2. Organizing Content
      1. W03E-2-1. Sort Content in Lists and Tables
        1. Sorting the Items in a List
        2. Practice Exercise
        3. Sorting the Data in a Table
        4. Practice Exercise
      2. W03E-2-2. Perform Calculations in Tables
        1. Using a Formula in a Table
        2. Practice Exercise
      3. W03E-2-3. Modify Table Formats
        1. Merging and Splitting Table Cells
        2. Practice Exercise
        3. Changing the Position and Direction of Cell Contents
        4. Practice Exercise
        5. Modifying Table Properties
        6. Practice Exercise
        7. Inserting and Modifying Fields
        8. Practice Exercise
      4. W03E-2-4. Summarize Document Content Using Automated Tools
        1. Summarizing a Document
        2. Practice Exercise
        3. Analyzing Content Readability
        4. Practice Exercise
      5. W03E-2-5. Use Automated Tools for Document Navigation
        1. Inserting a Bookmark
        2. Practice Exercise
        3. Using the Document Map and Thumbnails
        4. Practice Exercise
      6. W03E-2-6. Merge Letters with Other Data Sources
        1. Specifying the Data Source
        2. Practice Exercise
        3. Preparing the Form Letter
        4. Practice Exercise
        5. Merging the Data with the Form Letter
        6. Practice Exercise
      7. W03E-2-7. Merge Labels with Other Data Sources
        1. Creating and Printing Mailing Labels
        2. Practice Exercise
      8. W03E-2-8. Structure Documents Using XML
        1. Creating an XML Document Based on a Schema
        2. Practice Exercise
      9. W03E-2. Review
    3. W03E-3. Formatting Documents
      1. W03E-3-1. Create and Modify Forms
        1. Setting Up a Form
        2. Practice Exercise
        3. Modifying a Form
        4. Practice Exercise
      2. W03E-3-2. Create and Modify Document Background
        1. Changing the Background Color and Fill Effect
        2. Practice Exercise
        3. Creating a Watermark
        4. Practice Exercise
        5. Applying a Document Theme
        6. Practice Exercise
      3. W03E-3-3. Create and Modify Document Indexes and Tables
        1. Creating an Index
        2. Practice Exercise
        3. Creating a Table of Contents, a Table of Figures, or a Table of Authorities
        4. Practice Exercise
      4. W03E-3-4. Insert and Modify Endnotes, Footnotes, Captions, and Cross-references
        1. Inserting and Formatting Footnotes and Endnotes
        2. Practice Exercise
        3. Inserting and Formatting Captions
        4. Practice Exercise
        5. Inserting Cross-References
        6. Practice Exercise
      5. W03E-3-5. Create and Manage Master Documents and Subdocuments
        1. Working with a Master Document and Subdocuments
        2. Practice Exercise
      6. W03E-3. Review
    4. W03E-4. Collaborating
      1. W03E-4-1. Modify Track Changes Options
        1. Setting Reviewer Options
        2. Practice Exercise
        3. Setting Balloon Options
        4. Practice Exercise
      2. W03E-4-2. Publish and Edit Web Documents in Word
        1. Opening and Editing a Web Page
        2. Practice Exercise
        3. Creating a Frames Page
        4. Practice Exercise
      3. W03E-4-3. Manage Document Versions
        1. Creating and Managing Document Versions
        2. Practice Exercise
      4. W03E-4-4. Protect and Restrict Forms and Documents
        1. Protecting a Form
        2. Practice Exercise
        3. Setting a Password
        4. Practice Exercise
        5. Restricting Editing or Formatting
        6. Practice Exercise
      5. W03E-4-5. Attach Digital Signatures to Documents
        1. Authenticating a Document with a Digital Signature
        2. Practice Exercise
      6. W03E-4-6. Customize Document Properties
        1. Inserting and Editing Advanced Summary Information
        2. Practice Exercise
        3. Inserting and Editing Custom Information
        4. Practice Exercise
      7. W03E-4. Review
    5. W03E-5. Customizing Word
      1. W03E-5-1. Create, Edit, and Run Macros
        1. Creating, Running, and Deleting a Macro
        2. Practice Exercise
        3. Editing a Macro
        4. Practice Exercise
      2. W03E-5-2. Customize Menus and Toolbars
        1. Creating a Custom Menu
        2. Practice Exercise
        3. Customizing a Toolbar
        4. Practice Exercise
      3. W03E-5-3. Modify Word Default Settings
        1. Changing Default File Locations
        2. Practice Exercise
        3. Changing the Custom Dictionary
        4. Practice Exercise
        5. Modifying Default Font Settings
        6. Practice Exercise
      4. W03E-5. Review
  6. III. Microsoft Office Specialist Excel 2003 Core Exam
    1. E03C-1. Creating Data and Content
      1. E03C-1-1. Enter and Edit Cell Content
        1. Entering Text, Numbers, and Symbols
        2. Practice Exercise
        3. Entering Cell Content by Using the Fill Handle
        4. Practice Exercise
        5. Editing and Clearing Cell Contents
        6. Practice Exercise
      2. E03C-1-2. Navigate to Specific Cell Content
        1. Finding Cell Content or Formatting
        2. Practice Exercise
        3. Navigating by Using the Go To Command
        4. Practice Exercise
      3. E03C-1-3. Locate, Select, and Insert Supporting Information
        1. Using the Thesaurus to Find the Best Word
        2. Practice Exercise
        3. Using the Research Tool to Locate and Insert Supporting Information
        4. Practice Exercise
      4. E03C-1-4. Insert, Position, and Size Graphics
        1. Inserting and Positioning Graphics
        2. Practice Exercise
        3. Sizing Graphics
        4. Practice Exercise
      5. E03C-1. Review
    2. E03C-2. Analyzing Data
      1. E03C-2-1. Filter Lists Using AutoFilter
        1. Displaying Rows with a Specific Entry in a Specific Column
        2. Practice Exercise
        3. Displaying Rows That Match Certain Criteria
        4. Practice Exercise
      2. E03C-2-2. Sort Lists
        1. Sorting on One Column
        2. Practice Exercise
        3. Sorting on Two or Three Columns
        4. Practice Exercise
      3. E03C-2-3. Insert and Modify Formulas
        1. Doing Simple Arithmetic
        2. Practice Exercise
        3. Using a Function in a Formula
        4. Practice Exercise
        5. Using Cell and Range References in a Formula
        6. Practice Exercise
      4. E03C-2-4. Use Statistical, Date and Time, Financial, and Logical Functions
        1. Using Statistical Functions in Formulas
        2. Practice Exercise
        3. Using Date and Time Functions in Formulas
        4. Practice Exercise
        5. Using Financial Functions in Formulas
        6. Practice Exercise
        7. Using Logical Functions in Formulas
        8. Practice Exercise
      5. E03C-2-5. Create, Modify, and Position Diagrams and Charts Based on Worksheet Data
        1. Creating, Modifying, and Positioning Diagrams
        2. Practice Exercise
        3. Creating, Modifying, and Positioning Charts
        4. Practice Exercise
      6. E03C-2. Review
    3. E03C-3. Formatting Data and Content
      1. E03C-3-1. Apply and Modify Cell Formats
        1. Changing the Look of Cells and Cell Entries
        2. Practice Exercise
        3. Changing Cell Alignment
        4. Practice Exercise
        5. Applying an AutoFormat
        6. Practice Exercise
        7. Changing the Format of Cell Entries
        8. Practice Exercise
        9. Copying Formatting
        10. Practice Exercise
      2. E03C-3-2. Apply and Modify Cell Styles
        1. Apply a Style
        2. Practice Exercise
        3. Modify a Style
        4. Practice Exercise
      3. E03C-3-3. Modify Row and Column Formats
        1. Adjusting Column Widths and Row Heights
        2. Practice Exercise
        3. Hiding and Revealing Columns and Rows
        4. Practice Exercise
        5. Inserting and Deleting Columns and Rows
        6. Practice Exercise
      4. E03C-3-4. Format Worksheets
        1. Changing a Worksheet’s Name, Tab, and Background
        2. Practice Exercise
        3. Hiding and Revealing a Worksheet
        4. Practice Exercise
      5. E03C-3. Review
    4. E03C-4. Collaborating
      1. E03C-4-1. Insert, View, and Edit Comments
        1. Attaching a Comment to a Worksheet Cell
        2. Practice Exercise
        3. Editing or Deleting a Comment
        4. Practice Exercise
      2. E03C-4. Review
    5. E03C-5. Managing Workbooks
      1. E03C-5-1. Create New Workbooks from Templates
        1. Creating a Workbook Based on a Template
        2. Practice Exercise
      2. E03C-5-2. Insert, Delete, and Move Cells
        1. Inserting and Deleting Cells
        2. Practice Exercise
        3. Copying and Moving Entries
        4. Practice Exercise
        5. Controlling How Excel Pastes
        6. Practice Exercise
      3. E03C-5-3. Create and Modify Hyperlinks
        1. Inserting a Hyperlink
        2. Practice Exercise
        3. Editing a Hyperlink
        4. Practice Exercise
      4. E03C-5-4. Organize Worksheets
        1. Inserting and Deleting Worksheets
        2. Practice Exercise
        3. Moving a Worksheet
        4. Practice Exercise
      5. E03C-5-5. Preview Data in Other Views
        1. Previewing a Worksheet That Will Be Printed
        2. Practice Exercise
        3. Previewing a Web Workbook
        4. Practice Exercise
      6. E03C-5-6. Customize Window Layout
        1. Splitting a Window
        2. Practice Exercise
        3. Freezing a Column or Row
        4. Practice Exercise
        5. Arranging Windows
        6. Practice Exercise
        7. Hiding and Revealing Workbooks
        8. Practice Exercise
      7. E03C-5-7. Set Up Pages for Printing
        1. Specifying a Print Area
        2. Practice Exercise
        3. Controlling What Appears on Each Page
        4. Practice Exercise
        5. Adding a Header or Footer
        6. Practice Exercise
      8. E03C-5-8. Print Data
        1. Printing Selections, Worksheets, and Workbooks
        2. Practice Exercise
      9. E03C-5-9. Organize Workbooks Using File Folders
        1. Creating a Folder in Which to Store a Workbook
        2. Practice Exercise
        3. Renaming or Deleting a Workbook or Folder
        4. Practice Exercise
      10. E03C-5-10. Save Data in Appropriate Formats for Different Uses
        1. Saving a Workbook for Use in Another Program
        2. Practice Exercise
        3. Saving a Selection, Worksheet, or Workbook as a Web Page
        4. Practice Exercise
      11. E03C-5. Review
  7. IV. Microsoft Office Specialist Excel 2003 Expert Exam
    1. E03E-1. Organizing and Analyzing Data
      1. E03E-1-1. Use Subtotals
        1. Calculating Subtotals
        2. Practice Exercise
      2. E03E-1-2. Define and Apply Advanced Filters
        1. Creating a Criteria Range for Advanced Filtering
        2. Practice Exercise
      3. E03E-1-3. Group and Outline Data
        1. Outlining a Worksheet
        2. Practice Exercise
      4. E03E-1-4. Use Data Validation
        1. Avoiding Input Errors
        2. Practice Exercise
      5. E03E-1-5. Create and Modify List Ranges
        1. Creating and Modifying a List
        2. Practice Exercise
      6. E03E-1-6. Add, Show, Close, Edit, Merge, and Summarize Scenarios
        1. Creating and Showing Scenarios
        2. Practice Exercise
        3. Merging Scenarios
        4. Practice Exercise
        5. Creating a Scenario Report
        6. Practice Exercise
      7. E03E-1-7. Perform Data Analysis Using Automated Tools
        1. Using the Analysis ToolPak
        2. Practice Exercise
        3. Using Goal Seek
        4. Practice Exercise
        5. Using a Data Table
        6. Practice Exercise
        7. Using Solver
        8. Practice Exercise
      8. E03E-1-8. Create Pivot Table and PivotChart Reports
        1. Creating a PivotTable Report
        2. Practice Exercise
        3. Plotting a PivotTable as a PivotChart
        4. Practice Exercise
      9. E03E-1-9. Use Lookup and Reference Functions
        1. Looking Up Information
        2. Practice Exercise
      10. E03E-1-10. Use Database Functions
        1. Creating Formulas That Use Database Functions
        2. Practice Exercise
      11. E03E-1-11. Trace Formula Precedents, Dependents, and Errors
        1. Fixing Errors
        2. Practice Exercise
        3. Auditing a Worksheet
        4. Practice Exercise
      12. E03E-1-12. Locate Invalid Data and Formulas
        1. Using Error Checking
        2. Practice Exercise
        3. Circling Invalid Data
        4. Practice Exercise
      13. E03E-1-13. Watch and Evaluate Formulas
        1. Watching a Cell
        2. Practice Exercise
        3. Evaluating a Formula
        4. Practice Exercise
      14. E03E-1-14. Define, Modify, and Use Named Ranges
        1. Naming a Cell or Range
        2. Practice Exercise
      15. Using a Name in a Formula
        1. Practice Exercise
      16. E03E-1-15. Structure Workbooks Using XML
        1. Adding and Deleting a Data Map
        2. Practice Exercise
        3. Setting Up an XML Worksheet and Entering Data
        4. Practice Exercise
      17. E03E-1. Review
    2. E03E-2. Formatting Data and Content
      1. E03E-2-1. Create and Modify Custom Data Formats
        1. Creating a Custom Number Format
        2. Practice Exercise
      2. E03E-2-2. Use Conditional Formatting
        1. Monitoring a Worksheet with Conditional Formatting
        2. Practice Exercise
      3. E03E-2-3. Format and Resize Graphics
        1. Controlling the Contrast and Brightness of a Graphic
        2. Practice Exercise
        3. Sizing, Scaling, Cropping, and Rotating a Graphic
        4. Practice Exercise
      4. E03E-2-4. Format Charts and Diagrams
        1. Formatting a Chart
        2. Practice Exercise
        3. Formatting an Organization Chart
        4. Practice Exercise
      5. E03E-2. Review
    3. E03E-3. Collaborating
      1. E03E-3-1. Protect Cells, Worksheets, and Workbooks
        1. Preventing Changes to Cells, Worksheets, and Workbooks
        2. Practice Exercise
      2. E03E-3-2. Apply Workbook Security Settings
        1. Authenticating a Workbook with a Digital Signature
        2. Practice Exercise
        3. Setting a Password
        4. Practice Exercise
        5. Adjusting Macro Settings
        6. Practice Exercise
      3. E03E-3-3. Share Workbooks
        1. Creating a Shared Workbook
        2. Practice Exercise
        3. Using a Shared Workbook
        4. Practice Exercise
      4. E03E-3-4. Merge Workbooks
        1. Comparing and Merging Workbooks
        2. Practice Exercise
      5. E03E-3-5. Track, Accept, and Reject Changes to Workbooks
        1. Tracking Changes to a Workbook
        2. Practice Exercise
        3. Accepting and Rejecting Changes
        4. Practice Exercise
      6. E03E-3. Review
    4. E03E-4. Managing Data and Workbooks
      1. E03E-4-1. Import Data to Excel
        1. Importing Data from an External Data Source
        2. Practice Exercise
        3. Importing Data from a Web Page
        4. Practice Exercise
      2. E03E-4-2. Export Data from Excel
        1. Exporting an XML Data File
        2. Practice Exercise
      3. E03E-4-3. Publish and Edit Web Worksheets and Workbooks
        1. Publishing a Worksheet as a Web Page
        2. Practice Exercise
      4. E03E-4-4. Create and Edit Templates
        1. Saving and Using a Custom Workbook Template
        2. Practice Exercise
        3. Editing a Workbook Template
        4. Practice Exercise
      5. E03E-4-5. Consolidate Data
        1. Consolidating Data from Two or More Worksheets
        2. Practice Exercise
      6. E03E-4-6. Define and Modify Workbook Properties
        1. Viewing and Changing Workbook Properties
        2. Practice Exercise
      7. E03E-4. Review
    5. E03E-5. Customizing Excel
      1. E03E-5-1. Customize Toolbars and Menus
        1. Customizing a Toolbar
        2. Practice Exercise
        3. Creating a Custom Menu
        4. Practice Exercise
      2. E03E-5-2. Create, Edit, and Run Macros
        1. Creating, Running, and Deleting a Macro
        2. Practice Exercise
      3. Editing a Macro
        1. Practice Exercise
      4. E03E-5-3. Modify Excel Default Settings
        1. Changing the Default Number of Worksheets, Font Settings, and File Locations
        2. Practice Exercise
      5. E03E-5. Review
  8. V. Microsoft Office Specialist 2003 Exam
    1. P03C-1. Creating Content
      1. P03C-1-1. Create New Presentations from Templates
        1. Creating a Presentation by Using the AutoContent Wizard
        2. Practice Exercise
        3. Creating a Presentation by Using a Design Template
        4. Practice Exercise
      2. P03C-1-2. Insert and Edit Text-Based Content
        1. Adding and Editing Text
        2. Practice Exercises
        3. Changing the Hierarchical Level of Text
        4. Practice Exercise
        5. Importing Text from Other Sources
        6. Practice Exercise
        7. Checking Spelling and Style
        8. Practice Exercise
        9. Using the Thesaurus to Find the Best Word
        10. Practice Exercise
      3. P03C-1-3. Insert Tables, Charts, and Diagrams
        1. Creating Tables
        2. Practice Exercise
        3. Creating Charts
        4. Practice Exercise
        5. Creating Diagrams
        6. Practice Exercise
      4. P03C-1-4. Insert Pictures, Shapes, and Graphics
        1. Adding Clip Art
        2. Practice Exercise
        3. Adding Pictures
        4. Practice Exercise
        5. Adding Shapes
        6. Practice Exercise
        7. Adding WordArt
        8. Practice Exercise
      5. P03C-1-5. Insert Objects
        1. Inserting a Word Table
        2. Practice Exercise
        3. Inserting an Excel Worksheet
        4. Practice Exercise
        5. Inserting a Media Clip
        6. Practice Exercise
      6. P03C-1. Review
    2. P03C-2. Formatting Content
      1. P03C-2-1. Format Text-based Content
        1. Changing the Font, Size, and Font Style of Text
        2. Practice Exercise
        3. Modifying Text Colors
        4. Practice Exercise
        5. Changing Text Alignment
        6. Practice Exercise
        7. Finding and Replacing Fonts
        8. Practice Exercise
      2. P03C-2-2. Format Pictures, Shapes, and Graphics
        1. Sizing and Cropping Graphics
        2. Practice Exercise
        3. Adjusting the Color of Graphics
        4. Practice Exercise
        5. Aligning, Connecting, and Rotating Graphics
        6. Practice Exercise
        7. Adding Effects to Shapes
        8. Practice Exercise
      3. P03C-2-3. Format Slides
        1. Coloring and Shading a Slide Background
        2. Practice Exercise
        3. Modifying the Slide Layout
        4. Practice Exercise
        5. Using a Design Template to Make a Presentation Look Consistent
        6. Practice Exercise
        7. Setting the Slide Size and Orientation
        8. Practice Exercise
      4. P03C-2-4. Apply Animation Schemes
        1. Animating Slides
        2. Practice Exercise
      5. P03C-2-5. Apply Slide Transitions
        1. Applying Transition Effects
        2. Practice Exercise
      6. P03C-2-6. Customize Slide Templates
        1. Saving a Presentation as a Template
        2. Practice Exercise
      7. P03C-2-7. Work with Masters
        1. Changing a Presentation’s Masters
        2. Practice Exercise
        3. Adding, Deleting, and Modifying Placeholders
        4. Practice Exercise
        5. Inserting Content in Headers and Footers
        6. Practice Exercise
      8. P03C-2. Review
    3. P03C-3. Collaborating
      1. P03C-3-1. Track, Accept, and Reject Changes in a Presentation
        1. Viewing Tracked Changes
        2. Practice Exercise
        3. Accepting and Rejecting Changes
        4. Practice Exercise
      2. P03C-3-2. Add, Edit, and Delete Comments in a Presentation
        1. Adding Comments
        2. Practice Exercise
        3. Working with Comments
        4. Practice Exercise
      3. P03C-3-3. Compare and Merge Presentations
        1. Comparing and Merging Presentations
        2. Practice Exercise
      4. P03C-3. Review
    4. P03C-4. Managing and Delivering Presentations
      1. P03C-4-1. Organize a Presentation
        1. Working with Different Views
        2. Practice Exercise
        3. Organizing and Deleting Slides
        4. Practice Exercise
        5. Adding and Viewing Notes
        6. Practice Exercise
        7. Adding Hyperlinks
        8. Practice Exercise
      2. P03C-4-2. Set Up Slide Shows for Delivery
        1. Creating a Custom Slide Show
        2. Practice Exercise
        3. Working with Action Buttons
        4. Practice Exercise
        5. Working with Hidden Slides
        6. Practice Exercise
      3. P03C-4-3. Rehearse Timing
        1. Setting Slide Timings
        2. Practice Exercise
        3. Rehearsing a Presentation
        4. Practice Exercise
      4. P03C-4-4. Deliver Presentations
        1. Delivering a Slide Show
        2. Practice Exercise
        3. Using Tools for Emphasis
        4. Practice Exercise
      5. P03C-4-5. Prepare Presentations for Remote Delivery
        1. Packaging a Presentation for CD Storage
        2. Practice Exercise
      6. P03C-4-6. Save and Publish Presentations
        1. Saving an Entire Presentation or a Single Slide
        2. Practice Exercise
        3. Saving and Publishing a Presentation as a Web Page
        4. Practice Exercise
      7. P03C-4-7. Print Slides, Outlines, Handouts, and Speaker Notes
        1. Previewing a Presentation
        2. Practice Exercise
        3. Printing a Presentation
        4. Practice Exercise
      8. P03C-4-8. Export a Presentation to Another Microsoft Office Program
        1. Sending a Presentation to Microsoft Word
        2. Practice Exercise
      9. P03C-4. Review
  9. VI. Microsoft Office Specialist Access 2003 Exam
    1. A03C-1. Structuring Databases
      1. A03C-1-1. Create Access Databases
        1. Creating a Database by Using the Database Wizard
        2. Practice Exercise
        3. Creating a Blank Database
        4. Practice Exercise
      2. A03C-1-2. Create and Modify Tables
        1. Creating a Table by Using the Table Wizard
        2. Practice Exercise
        3. Creating a Table by Entering Data
        4. Practice Exercise
        5. Creating and Modifying a Table in Design View
        6. Practice Exercise
      3. A03C-1-3. Define and Create Field Types
        1. Setting the Data Type and Size of a Field
        2. Practice Exercise
        3. Creating a Primary Key Field
        4. Practice Exercise
        5. Creating a Lookup Field
        6. Practice Exercise
      4. A03C-1-4. Modify Field Properties
        1. Setting Field Properties
        2. Practice Exercise
        3. Using an Input Mask
        4. Practice Exercise
      5. A03C-1-5. Create and Modify One-to-Many Relationships
        1. Creating a Relationship Between Two Tables
        2. Practice Exercise
      6. A03C-1-6. Enforce Referential Integrity
        1. Setting Referential Integrity Rules
        2. Practice Exercise
      7. A03C-1-7. Create and Modify Queries
        1. Creating a Query by Using the Simple Query Wizard
        2. Practice Exercise
        3. Modifying a Query in Design View
        4. Practice Exercise
        5. Creating a Crosstab Query
        6. Practice Exercise
        7. Finding Duplicate Records
        8. Practice Exercise
        9. Finding Unmatched Records
        10. Practice Exercise
        11. Updating Information with an Action Query
        12. Practice Exercise
      8. A03C-1-8. Create Forms
        1. Creating an AutoForm
        2. Practice Exercise
        3. Creating a Form by Using the Form Wizard
        4. Practice Exercise
      9. A03C-1-9. Add and Modify Form Controls and Properties
        1. Setting Form and Control Properties
        2. Practice Exercise
        3. Adding Controls to a Form
        4. Practice Exercise
      10. A03C-1-10. Create Reports
        1. Creating a Report by Using the Report Wizard
        2. Practice Exercise
        3. Creating Mailing Labels
        4. Practice Exercise
      11. A03C-1-11. Add and Modify Report Control Properties
        1. Setting Report and Control Properties
        2. Practice Exercise
        3. Adding Controls to a Report
        4. Practice Exercise
      12. A03C-1-12. Create a Data Access Page
        1. Creating and Modifying a Data Access Page
        2. Practice Exercise
      13. A03C-1. Review
    2. A03C-2. Entering Data
      1. A03C-2-1. Enter, Edit, and Delete Records
        1. Entering Data in a Table’s Datasheet
        2. Practice Exercise
        3. Deleting Records from a Table
        4. Practice Exercise
      2. A03C-2-2. Find and Move Among Records
        1. Navigating Among Records
        2. Practice Exercise
        3. Finding a Specific Record
        4. Practice Exercise
      3. A03C-2-3. Import Data to Access
        1. Importing Objects from an Access Database
        2. Practice Exercise
        3. Importing Data from Other Sources
        4. Practice Exercise
      4. A03C-2. Review
    3. A03C-3. Organizing Data
      1. A03C-3-1. Create and Modify Calculated Fields and Aggregate Functions
        1. Adding Calculated Fields to Queries
        2. Practice Exercise
        3. Calculating Totals in Queries
        4. Practice Exercise
      2. A03C-3-2. Modify Form Layout
        1. Setting Control Size, Alignment, and Spacing
        2. Practice Exercise
        3. Modifying Form and Section Layout
        4. Practice Exercise
      3. A03C-3-3. Modify Report Layout and Page Setup
        1. Setting Control Size, Alignment, and Spacing
        2. Practice Exercise
        3. Modifying Report and Section Layout
        4. Practice Exercise
      4. A03C-3-4. Format Datasheets
        1. Formatting a Datasheet
        2. Practice Exercise
      5. A03C-3-5. Sort Records
        1. Sorting Records in a Form or Datasheet
        2. Practice Exercise
        3. Sorting Records in a Report
        4. Practice Exercise
      6. A03C-3-6. Filter Records
        1. Filtering Records for a Selected Value
        2. Practice Exercise
        3. Filtering Records for Specified Values
        4. Practice Exercise
      7. A03C-3. Review
    4. A03C-4. Managing Databases
      1. A03C-4-1. Identify and Modify Object Dependencies
        1. Identifying Object Dependencies
        2. Practice Exercise
      2. A03C-4-2. View Objects and Object Data in Other Views
        1. Using Print Preview and Layout Preview
        2. Practice Exercise
        3. Viewing PivotTables
        4. Practice Exercise
        5. Viewing PivotCharts
        6. Practice Exercise
      3. A03C-4-3. Print Database Objects and Data
        1. Printing Objects and Data
        2. Practice Exercise
      4. A03C-4-4. Export Data from Access
        1. Exporting Data
        2. Practice Exercise
      5. A03C-4-5. Back Up a Database
        1. Backing Up a Database
        2. Practice Exercise
      6. A03C-4-6. Compact and Repair Databases
        1. Compacting and Repairing a Database
        2. Practice Exercise
      7. A03C-4. Review
  10. VII. Microsoft Office Specialist Outlook 2003 Exam
    1. O03C-1. Messaging
      1. O03C-1-1. Originate and Respond to E-Mail and Instant Messages
        1. Addressing and Sending a New E-Mail Message
        2. Practice Exercise
        3. Handling E-Mail Messages You Receive
        4. Practice Exercise
        5. Sending and Replying to Instant Messages
        6. Practice Exercise
      2. O03C-1-2. Attach Files to Items
        1. Attaching a File to an E-Mail Message
        2. Practice Exercise
        3. Sending a File Through an Instant Message
        4. Practice Exercise
      3. O03C-1-3. Create and Modify a Personal Signature for Messages
        1. Creating and Modifying an E-Mail Signature
        2. Practice Exercise
        3. Specifying Unique Signatures for Multiple E-Mail Accounts
        4. Practice Exercise
      4. O03C-1-4. Modify E-Mail Message Settings and Delivery Options
        1. Flagging an E-Mail Message for Follow-Up
        2. Practice Exercise
        3. Setting E-Mail Message Formats
        4. Practice Exercise
        5. Setting E-Mail Message Importance, Sensitivity, and Delivery Options
        6. Practice Exercise
      5. O03C-1-5. Create and Edit Contacts
        1. Creating and Updating Contact Entries
        2. Practice Exercise
        3. Creating Instant Messaging Contact Entries
        4. Practice Exercise
      6. O03C-1-6. Accept, Decline, and Delegate Tasks
        1. Handling Task Assignments
        2. Practice Exercise
      7. O03C-1. Review
    2. O03C-2. Scheduling
      1. O03C-2-1. Create and Modify Appointments, Meetings, and Events
        1. Adding an Appointment or Event to the Outlook Calendar
        2. Practice Exercise
        3. Inviting People and Resources to a Meeting
        4. Practice Exercise
      2. O03C-2-2. Update, Cancel, and Respond to Meeting Requests
        1. Responding to a Meeting Request
        2. Practice Exercise
        3. Updating or Canceling a Meeting
        4. Practice Exercise
      3. O03C-2-3. Customize Calendar Settings
        1. Setting Your Outlook Calendar Options
        2. Practice Exercise
        3. Defining Your Available Time
        4. Practice Exercise
      4. O03C-2-4. Create, Modify, and Assign Tasks
        1. Creating and Modifying a Task
        2. Practice Exercise
        3. Assigning a Task
        4. Practice Exercise
      5. O03C-2. Review
    3. O03C-3. Organizing
      1. O03C-3-1. Create and Modify Distribution Lists
        1. Creating a Distribution List
        2. Practice Exercise
        3. Modifying a Distribution List
        4. Practice Exercise
      2. O03C-3-2. Link Contacts to Other Items
        1. Linking an Outlook Item to a Contact Entry
        2. Practice Exercise
      3. O03C-3-3. Create and Modify Notes
        1. Creating and Editing Notes
        2. Practice Exercise
      4. O03C-3-4. Organize Items
        1. Adding and Deleting Fields from Folder Views
        2. Practice Exercise
        3. Sorting Outlook Items
        4. Practice Exercise
        5. Filtering E-Mail Messages
        6. Practice Exercise
        7. Organizing Outlook Items by Using Colors
        8. Practice Exercise
        9. Organizing E-Mail Messages by Using Rules
        10. Practice Exercise
        11. Organizing Outlook Items by Using Views
        12. Practice Exercise
      5. O03C-3-5. Organize Items Using Folders
        1. Organizing E-Mail Messages in Folders
        2. Practice Exercise
        3. Archiving Outlook Items
        4. Practice Exercise
      6. O03C-3-6. Search for Items
        1. Finding E-Mail Messages
        2. Practice Exercise
        3. Using Search Folders
        4. Practice Exercise
      7. O03C-3-7. Save Items in Different File Formats
        1. Saving E-Mail Messages in Other Formats
        2. Practice Exercise
      8. O03C-3-8. Assign Items to Categories
        1. Assigning Outlook Items to Categories
        2. Practice Exercise
      9. O03C-3-9. Preview and Print Items
        1. Previewing and Printing an E-Mail Message
        2. Practice Exercise
        3. Previewing and Printing Your Outlook Calendar
        4. Practice Exercise
        5. Previewing and Printing Contact Information
        6. Practice Exercise
      10. O03C-3. Review
  11. About the Authors
    1. Online Training Solutions, Inc. (OTSI)
  12. Index
  13. About the Authors
  14. Copyright