GO! with Office 2010 Volume 1

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois ¿ University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing. ¿ Robert L. Ferrett recently retired as the director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty.¿ He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher, WordPerfect, and Word.¿ Before writing the GO! Series, Bob was a series editor and author for the Learn Series. ¿He has a bachelor’s degree in psychology, a master’s degree in geography, and a master’s degree in interdisciplinary technology from Eastern Michigan University.¿ Bob’s doctoral studies were in instructional technology at Wayne State University.¿ For fun, Bob teaches a four-week computers and genealogy class and has written genealogy and local history books. ¿ Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College.¿ She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Carolyn McLellan is the Dean of the Division of Information Technology and Business at Tidewater Community College in Virginia Beach, Virginia.¿ She has an M.A. degree in Secondary Education from Regent University and a B.S. degree in Business Education from Old Dominion University.¿ She taught for Norfolk Public Schools for 17 years in Business Education and served as a faculty member at Tidewater Community College for eight years teaching networking, where she developed over 23 new courses and earned the Microsoft Certified Trainer and Microsoft Certified System Engineer industry certifications.¿ In addition to teaching, Carolyn loves to play volleyball, boogie board at the beach, bicycle, crochet, cook, and read.

GO! with Microsoft Office 2010 Volume 1   2e

 

Table of Contents

  

Common Features Chapter 1 Using the Common Features of Office 2010      

Scenario: Oceana Palm Grill   

Project 1A: PowerPoint File   

Objective 1    Use Windows Explorer to Locate Files and Folder

Activity 1.01   Using Windows Explorer to Locate Files and Folders

Objective 2    Locate and Start a Microsoft Office 2010 Program

Activity 1.02   Locating and Starting a Microsoft Office 2010 Program

Objective 3    Enter and Edit Text in an Office Program

Activity 1.03   Entering and Editing Text in an Office 2010 Program

Objective 4    Perform Commands From a Dialog Box

Activity 1.04   Performing Commands From a Dialog Box

Objective 5    Create a Folder, Save a File, and Close a Program

Activity 1.05 Creating a Folder, Saving a File, and Closing a Program

Objective 6    Add Document Properties and Print a File

Activity 1.06 Adding Document Properties and Printing a File

Project 1B: Word File   

Objective 7    Open an Existing File and Save it With a New Name

Activity 1.07 Opening an Existing File and Saving it With a New Name

Objective 8    Explore Options for an Application

Activity 1.08 Viewing Application Options

Objective 9    Perform Commands from the Ribbon

Activity 1.09 Performing Commands from the Ribbon

Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon

Objective 10 Apply Formatting in Office Programs

Activity 1.11   Formatting and Viewing Pages

Activity 1.12 Formatting Text

Activity 1.13   Using the Office Clipboard to Cut, Copy, and Paste

Activity 1.14   Viewing Print Preview and Printing a Word Document

Objective 11 Use the Microsoft Office 2010 Help System

Activity 1.15 Using the Microsoft Office 2010 Help System in Excel

Objective 12 Compress Files

Activity 1.16 Compressing Files

 

Word Chapter 1 Creating Documents with Microsoft Word 2010   

Scenario: Laurel College

Project 1A: Flyer   

Objective 1    Create a New Document and Insert Text

Activity 1.01   Starting a New Word Document and Inserting Text

Objective 2    Insert and Format Graphics

Activity 1.02   Formatting Text Using Text Effects

Activity 1.03   Inserting and Resizing Pictures

Activity 1.04   Wrapping Text Around a Picture

Activity 1.05   Moving a Picture

Activity 1.06   Applying Picture Styles and Artistic Effects

Activity 1.07   Adding a Page Border

Objective 3    Insert and Modify Text Boxes and Shapes

Activity 1.08   Inserting a Shape

Activity 1.09   Inserting a Text Box

Activity 1.10   Moving, Resizing, and Formatting Shapes and Text Boxes

Objective 4    Preview and Print a Document

Activity 1.11   Adding a File Name to the Footer

Activity 1.12   Previewing and Printing a Document

Project 1B: Information Handout  

Objective 5    Change Document and Paragraph Layout

Activity 1.13   Setting Margins

Activity 1.14   Aligning Text

Activity 1.15   Changing Line Spacing

Activity 1.16   Indenting Text and Adding Space After Paragraphs

Objective 6    Create and Modify Lists

Activity 1.17   Creating a Bulleted List

Activity 1.18   Creating a Numbered List

Activity 1.19   Customizing Bullets

Objective 7    Set and Modify Tab Stops

Activity 1.20   Setting Tab Stops

Activity 1.21   Modifying Tab Stops

Objective 8    Insert a SmartArt Graphic

Activity 1.22   Inserting a SmartArt Graphic

Activity 1.23   Modifying a SmartArt Graphic



Word Chapter 2 Using Tables and Templates to Create Resumes and Cover Letters  

Scenario: Madison Staffing Services  

Project 2A: Resume  

Objective 1    Create a Table

Activity 2.01   Creating a Table

Objective 2    Add Text to a Table

Activity 2.02   Adding Text to a Table

Activity 2.03   Inserting Existing Text into a Table Cell

Activity 2.04   Creating Bulleted Lists in a Table

Objective 3    Format a Table

Activity 2.05   Changing the Width of Table Columns

Activity 2.06   Adding Rows to a Table

Activity 2.07   Merging Cells

Activity 2.08   Formatting Text in Cells

Activity 2.09   Changing the Table Borders

Project 2B: Cover Letter and Resume  

Objective 4    Create a New Document from an Existing Document

Activity 2.10   Creating a Letterhead

Activity 2.11   Creating a Document from an Existing Document

Objective 5    Change and Reorganize Text

Activity 2.12   Recording AutoCorrect Entries

Activity 2.13   Creating a Cover Letter

Activity 2.14   Finding and Replacing Text

Activity 2.15   Selecting and Moving Text to a New Location

Activity 2.16   Inserting and Formatting a Table in a Document

Objective 6    Use the Proofing Options

Activity 2.17   Checking Spelling and Grammar Errors

Activity 2.18   Using the Thesaurus

Objective 7    Create a Document Using a Pre-Designed Template

Activity 2.19   Locating and Opening a Template

Activity 2.20   Replacing Template Placeholder Text

Activity 2.21   Removing Template Controls and Formatting the Resume

Activity 2.22   Saving a Resume as a Web Page



Word Chapter 3 Creating Research Papers, Newsletters, and Merged Mailing Labels   

Scenario: Memphis Primary Materials

Project 3A: Research Paper   

Objective 1    Create a Research Paper

Activity 3.01   Formatting Text and Page Numbers in a Research Paper

Objective 2    Insert Footnotes in a Research Paper

Activity 3.02   Inserting Footnotes

Activity 3.03   Modifying a Footnote Style

Objective 3    Create Citations and a Bibliography in a Research Paper

Activity 3.04   Adding Citations

Activity 3.05   Inserting Page Breaks

Activity 3.06   Creating a Reference Page

Activity 3.07   Managing Document Properties

Project 3B: Newsletter with Mailing Labels  

Objective 4    Format a Multiple-Column Newsletter

Activity 3.08   Changing One Column Text to Two Columns

Activity 3.09   Formatting Multiple Columns

Activity 3.10   Inserting a Column Break

Activity 3.11   Inserting a ClipArt Image

Activity 3.12   Inserting a Screenshot

Objective 5    Use Special Character and Paragraph Formatting

Activity 3.13   Applying the Small Caps Font Effect

Activity 3.14   Adding a Border and Shading to a Paragraph

Objective 6    Create Mailing Labels Using Mail Merge

Activity 3.15   Opening the Mail Merge Wizard Template

Activity 3.16   Completing the Mail Merge Wizard

Activity 3.17   Previewing and Printing the Mail Merge Document



Excel Chapter 1 Creating a Worksheet and Charting Data   

Scenario: Texas Spectrum Wireless

Project 1A: Sales Report with Embedded Column Chart and Sparklines  

Objective 1    Create, Save, and Navigate an Excel Workbook

Activity 1.01   Starting Excel and Naming and Saving a Workbook

Activity 1.02   Navigating a Worksheet and a Workbook

Objective 2    Enter Data in a Worksheet

Activity 1.03   Entering Text and Using AutoComplete

Activity 1.04   Using Auto Fill and Keyboard Shortcuts

Activity 1.05   Aligning Text and Adjusting the Size of Columns

Activity 1.06   Entering Numbers

Objective 3    Construct and Copy Formulas and Use the Sum Function

Activity 1.07   Constructing a Formula and Using the Sum Function

Activity 1.08   Copying a Formula by Using the Fill Handle

Objective 4    Format Cells with Merge & Center and Cell Styles

Activity 1.09   Using Merge & Center and Applying Cell Styles

Activity 1.10   Formatting Financial Numbers

Objective 5    Chart Data to Create a Column Chart and Insert Sparklines

Activity 1.11   Charting Data in a Column Chart

Activity 1.12   Creating and Formatting Sparklines

Objective 6    Print, Display Formulas, and Close Excel

Activity 1.13   Changing Views, Creating a Footer, and Using Print Preview

Activity 1.14   Deleting Unused Sheets in a Workbook

Activity 1.15   Printing a Worksheet

Activity 1.16   Displaying, Printing, and Hiding Formulas

Project 1B: Inventory Valuation

Objective 7   Check Spelling in a Worksheet

Activity 1.16   Checking Spelling in a Worksheet

Objective 8    Enter Data by Range

Activity 1.17 Entering Data by Range

Objective 9   Construct Formulas for Mathematical Operations

Activity 1.18   Using Arithmetic Operators

Activity 1.19   Copying Formulas Containing Absolute Cell References

Objective 10 Edit Values in a Worksheet

Activity 1.20   Editing Values in a Worksheet

Activity 1.21   Formatting Cells with the Percent Style

Objective 11    Format a Worksheet

Activity 1.22   Inserting and Deleting Rows and Columns

Activity 1.23   Adjusting Column Widths and Wrapping Text

 

Excel Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks      

Scenario: Laurales Herbs and Spices  

Project 2A: Inventory Status Report  

Objective 1    Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

Activity 2.01   Using the SUM and AVERAGE Functions

Activity 2.02   Using the MEDIAN Function

Activity 2.03   Using the MIN and MAX Functions

Objective 2    Move Data, Resolve Error Messages, and Rotate Text

Activity 2.04   Moving Data and Resolving a # # # # Error Message

Activity 2.05   Rotating Text

Objective 3    Use COUNTIF and IF Functions and Apply Conditional Formatting

Activity 2.06   Using the COUNTIF Function

Activity 2.07   Using the IF Function

Activity 2.08   Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars

Activity 2.09   Using Find and Replace

Objective 4    Use Date & Time Functions and Freeze Panes

Activity 2.10   Using the NOW Function to Display a System Date

Activity 2.11   Freezing and Unfreezing Panes

Objective 5    Create, Sort, and Filter an Excel Table

Activity 2.12   Creating an Excel Table

Activity 2.13   Sorting and Filtering an Excel Table

Activity 2.14   Converting a Table to a Range of Data

Objective 6    Format and Print a Large Worksheet

Activity 2.15   Printing Titles and Scaling to Fit

Project 2B: Weekly Sales Summary

Objective 7    Navigate a Workbook and Rename Worksheets

Activity 2.16   Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color Worksheets

Objective 8    Enter Dates, Clear Contents, and Clear Formats

Activity 2.17   Entering and Formatting Dates

Activity 2.18   Clearing Cell Contents and Formats

Objective 9    Copy and Paste by Using the Paste Options Gallery

Activity 2.19   Copying and Pasting by Using the Paste Options Gallery

Objective 10 Edit and Format Multiple Worksheets at the Same Time

Activity 2.20   Grouping Worksheets for Editing

Activity 2.21   Formatting and Constructing Formulas on Grouped Worksheets

Objective 11    Create a Summary Sheet

Activity 2.22   Constructing Formulas that Refer to Cells in Another Worksheet

Activity 2.23   Changing Values in a Detail Worksheet to Update a Summary Worksheet

Activity 2.24   Inserting Sparklines

Objective 12    Format and Print Multiple Worksheets in a Workbook

Activity 2.25   Moving and Formatting Worksheets in a Workbook

Activity 2.26   Printing All the Worksheets in a Workbook



Excel Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools  

Scenario: City of Orange Blossom Beach

Project 3A: Budget Pie Chart

Objective 1    Chart Data with a Pie Chart

Activity 3.01   Creating a Pie Chart and a Chart Sheet

Objective 2    Format a Pie Chart

Activity 3.02   Applying Percentages to Labels in a Pie Chart

Activity 3.03   Formatting a Pie Chart with 3-D

Activity 3.04   Rotating a Pie Chart

Activity 3.05   Exploding and Coloring a Pie Slice

Activity 3.06   Formatting the Chart Area

Activity 3.07   Inserting a Text Box in a Chart

Objective 3    Edit a Workbook and Update a Chart

Activity 3.08   Editing a Workbook and Updating a Chartt

Activity 3.09   Inserting WordArt in a Worksheet

Objective 4    Use Goal Seek to Perform What-If Analysis

Activity 3.10   Using Goal Seek to Perform What-If Analysis

Activity 3.11   Preparing and Printing a Workbook with a Chart Sheet

Project 3B: Growth Projection with Line Chart

Objective 5    Design a Worksheet for What-If Analysis

Activity 3.12   Using Parentheses in a Formula to Calculate a Percentage Rate of Increase

Activity 3.13   Using Format Painter and Formatting as You Type

Activity 3.14   Calculating a Value After an Increase

Objective 6    Answer What-If Questions by Changing Values in a Worksheet

Activity 3.15   Answering What-If Questions and Using Paste Special

Objective 7    Chart Data with a Line Chart

Activity 3.16   Inserting Multiple Rows and Creating a Line Chart

Activity 3.17   Formatting Axes in a Line Chart

Activity 3.18   Formatting the Chart and Plot Areas

Activity 3.19   Preparing and Printing Your Worksheet





Access Chapter 1 Getting Started with Access Databases   

Scenario: Capital Cities Community College

Project 1A: Contact Information Database with Two Tables

Objective 1    Identify Good Database Design

Activity 1.01 Using Good Design Techniques to Plan a Database

Objective 2   Create a Table and Define Fields in a New Blank Database

Activity 1.02   Starting with a New Blank Database

Activity 1.03   Assigning the Data Type and Name to Fields

Activity 1.04   Renaming Fields and Changing Data Types in a Table

Activity 1.05   Adding a Record to a Table

Activity 1.06   Adding Additional Records to a Table

Activity 1.07   Importing Data From an Excel Workbook to an Existing Access Table

Objective 3    Change the Structure of Tables and Add a Second Table

Activity 1.08   Deleting a Table Field in Design View

Activity 1.09   Modifying a Field Size and Adding a Description

Activity 1.10   Viewing a Primary Key in Design View

Activity 1.11   Adding a Second Table to a Database by Importing an Excel Spreadsheet

Activity 1.12   Adjusting Column Widths

Activity 1.13   Printing a Table

Objective 4    Create and Use a Query, Form, and Report

Activity 1.14   Using the Simple Query Wizard to Create a Query

Activity 1.15   Creating and Printing a Form

Activity 1.16   Creating, Modifying, and Printing a Report

Objective 5    Save and Close a Database

Activity 1.17   Closing and Saving a Database

Project 1B: Student Workshops Database

Objective 6    Create a Database Using a Template

Activity 1.18 Creating a New Database Using a Template

Activity 1.19 Building a Table by Entering Records in a Multiple Items Form

Objective 7    Organize Objects in the Navigation Pane

Activity 1.20 Organizing Database Objects in the Navigation Pane

Objective 8    Create a New Table in a Database Created with a Template

Activity 1.21 Creating a New Table and Changing Its Design

Objective 9    Print a Report and a Table in a Database Created with a Template

Activity 1.22 Viewing and Printing a Report

Activity 1.23   Printing a Table



Access Chapter 2 Sort and Query a Database

Scenario: Capital Cities Community College

Project 2A: Instructors and Courses Database  

Objective 1: Open an Existing Database

Activity 2.01 Opening and Renaming an Existing Database

Activity 2.02   Resolving Security Alerts and Renaming Tables

Objective 2:   Create Table Relationships

Activity 2.03   Creating Table Relationships and Enforcing Referential Integrity

Activity 2.04 Printing a Relationship Report and Displaying Subdatasheet Records

Objective 3: Sort Records in a Table

Activity 2.05 Sorting Records in a Table in Ascending or Descending Order

Activity 2.06 Sorting Records in a Table on Multiple Fields

Objective 4: Create a Query in Design View

Activity 2.07 Creating a New Select Query in Design View

Activity 2.08 Running, Saving, Printing, and Closing a Query

Objective 5: Create a New Query from an Existing Query

Activity 2.09 Creating a New Query from an Existing Query

Objective 6:   Sort Query Results

Activity 2.10 Sorting Query Results

Objective 7: Specify Criteria in a Query

Activity 2.11 Specifying Text Criteria in a Query

Activity 2.12 Specifying Criteria Using a Field Not Displayed in the Query Results

Activity 2.13 Using Is Null Criteria to Find Empty Fields

Project 2B: Athletic Scholarships   

Objective 8: Specify Numeric Criteria in a Query

Activity 2.14 Opening an Existing Database and Importing a Spreadsheet

Activity 2.15 Creating Table Relationships

Activity 2.16 Specifying Numeric Criteria in a Query

Activity 2.17 Using Comparison Operators

Activity 2.18 Using the Between . . . And Comparison Operator

Objective 9:   Use Compound Criteria

Activity 2.19 Using AND Criteria in a Query

Activity 2.20 Using OR Criteria in a Query

Objective 10: Create a Query Based on More Than One Table

Activity 2.21 Creating a Query Based on More Than One Table

Objective 11: Use Wildcards in a Query

Activity 2.22 Using a Wildcard in a Query

Objective 12: Use Calculated Fields in a Query

Activity 2.23 Using Calculated Fields in a Query

Objective 13: Calculate Statistics and Group Data in a Query

Activity 2.24 Using the MIN, MAX, AVG, and SUM Functions in a Query

Activity 2.25 Grouping Data in a Query

Objective 14: Create a Crosstab Query

Activity 2.26   Creating a Crosstab Query Using One Table



Access Chapter 3 Forms, Filters, and Reports   

Scenario: Capital Cities Community College

Project 3A: Students and Majors  

Objective 1: Create and Use a Form to Add and Delete Records

Activity 3.01 Creating a Form

Activity 3.02 Adding Records to a Table by Using a Form

Activity 3.03 Deleting Records from a Table by Using a Form

Activity 3.04 Printing a Form

Objective 2: Create a Form by Using the Form Wizard

Activity 3.05 Creating a Form by Using the Form Wizard

Objective 3: Modify a Form in Design View and in Layout View

Activity 3.06 Grouping Controls and Applying a Theme to a Form in Layout View

Activity 3.07 Modifying a Form in Design View

Activity 3.08 Adding, Resizing, and Moving Controls in Layout View

Activity 3.09 Formatting and Aligning Controls in Layout View

Objective 4: Filter Records

Activity 3.10 Filtering Data by Selection on One Field

Activity 3.11 Using Filter By Form and Advanced Filter/Sort

Project 3B: Job Openings  

Objective 5: Create a Report by Using the Report Tool

Activity 3.12 Creating a Report Using the Report Tool

Activity 3.13 Modifying a Report in Layout View and Printing a Report

Objective 6: Create Reports by Using the Blank Report Tool and the Report Wizard

Activity 3.14 Creating a Report by Using the Blank Report Tool

Activity 3.15 Creating a Report by Using the Report Wizard

Objective 7: Modify the Design of a Report

Activity 3.16 Formatting and Deleting Controls in Layout View

Activity 3.17 Modifying Controls in Design View

Activity 3.18 Aligning Controls in Design View

Objective 8:   Print a Report and Keep Data Together

Activity 3.19



PowerPoint Chapter 1 Getting Started with Microsoft Office PowerPoint  

Scenario: Lehua Hawaiian Tours

Project 1A: Company Overview

Objective 1: Create a New Presentation

Activity 1.01 Identifying Parts of the PowerPoint Window

Activity 1.02 Entering Presentation Text and Saving a Presentation

Activity 1.03 Applying a Presentation Theme

Objective 2: Edit a Presentation in Normal View

Activity 1.04 Inserting a New Slide

Activity 1.05 Increasing and Decreasing List Levels

Activity 1.06 Adding Speakers Notes to a Presentation

Activity 1.07 Displaying and Editing Slides in the Slide Pane

Objective 3: Add Pictures to a Presentation

Activity 1.08   Inserting a Picture from a File

Activity 1.09 Applying a Style to a Picture

Activity 1.10 Applying and Removing Artistic Effects

Objective 4: Print and View a Presentation

Activity 1.11 Viewing a Slide Show

Activity 1.12 Inserting Headers and Footers

Activity 1.13     Printing a Presentation

Project 1B: New Product Announcement

Objective 5: Edit an Existing Presentation

Activity 1.14 Displaying and Editing the Presentation Outline

Activity 1.15 Inserting Slides from an Existing Presentation

Activity 1.16 Finding and Replacing Text

Objective 6: Format a Presentation

Activity 1.17   Changing Fonts, Font Sizes, Font Styles, and Font Colors

Activity 1.18 Aligning Text and Changing Line Spacing

Activity 1.19 Modifying Slide Layout

Objective 7:   Use Slide Sorter View

Activity 1.20     Deleting Slides in Slide Sorter View

Activity 1.21 Moving Slides in Slide Sorter View

Objective 8: Apply Slide Transitions

Activity 1.22 Applying Slide Transitions to a Presentation

Activity 1.23 Displaying a Presentation in Reading View



PowerPoint Chapter 2 Formatting PowerPoint Presentations   

Scenario: Fascination Entertainment Group   

Project 2A: Employee Training Presentation  

Objective 1:     Format Numbered and Bulleted Lists

Activity 2.01 Selecting Placeholder Text

Activity 2.02   Changing a Bulleted List to a Numbered List

Activity 2.03 Modifying the Bulleted List Style

Activity 2.04 Removing a Bullet Symbol from a Bullet Point

Objective 2:     Insert ClipArt

Activity 2.05   Inserting ClipArt

Activity 2.06 Moving and Sizing Images

Activity 2.07 Changing the Shape of a Picture

Objective 3:     Insert Text Boxes and Shapes

Activity 2.08 Inserting a Text Box

Activity 2.09 Inserting, Sizing, and Positioning Shapes

Activity 2.10 Adding Text to Shapes

Objective 4:     Format Objects

Activity 2.11 Applying Shape Fills, Outlines, and Styles

Activity 2.12 Applying Shape and Picture Effects

Activity 2.13 Duplicating Objects

Activity 2.14 Aligning and Distributing Objects

Project 2B: Event Announcement   

Objective 5: Remove Picture Backgrounds and Insert WordArt

Activity 2.15     Removing the background froma Picture and Applying Soft Edge Options

Activity 2.16     Applying WordArt Styles to Existing Text

Activity 2.17 Inserting a WordArt Object

Objective 6: Create and Format a SmartArt Graphic

Activity 2.18 Creating a SmartArt Graphic from Bullet Points

Activity 2.19 Adding Shapes in a SmartArt Graphic

Activity 2.20 Creating a SmartArt Graphic Using a Content Layout

Activity 2.21 Changing the SmartArt Layout

Activity 2.22 Changing the Color and Style of a SmartArt Graphic

Activity 2.23 Customize the Size and Shape of a SmartArt Graphic

Activity 2.24 Converting a SmartArt to Text



PowerPoint Chapter 3 Enhancing a Presentation with Animation, Video, Tables, and Charts  

Scenario: City of Golden Grove 

Project 3A Informational Presentation  

Objective 1: Customize Slide Backgrounds

Activity 3.01 Changing the Theme Colors and Theme Fonts

Activity 3.02 Applying a Background Style

Activity 3.03 Hiding Background Graphics

Activity 3.04 Formatting a Slide Background with a Picture

Activity 3.05 Applying a Background Fill Color and Resetting the Slide Background

Objective 2: Animate a Slide Show

Activity 3.06 Applying Animation Entrance Effects and Effect Options

Activity 3.07 Setting Animation Timing Options

Activity 3.08 Using Animation Painter and Removing Animation

Objective 3: Insert a Video

Activity 3.09 Inserting a Video

Activity 3.10 Formatting a video

Activity 3.11   Editing and Compressing a Video

Project 3B Summary and Analysis Presentation 

Objective 3:   Create and Modify Tables

Activity 3.12 Creating a Table

Activity 3.13 Modifying the Layout of a Table

Activity 3.14 Modifying a Table Design

Objective 4: Create and Modify Charts

Activity 3.15 Creating a Column Chart and Applying a Chart Style

Activity 3.16 Creating a Line Chart and Deleting Chart Data

Activity 3.17 Animating a Chart



Integrated Projects Chapter 1 Integrated Projects 2010

Scenario: Front Range Action Sports  

Project 1A: State Sales  

Objective 1: Export Access Data to Excel

Activity 1.01 Exporting Access Data to Excel

Activity 1.02 Creating and Sorting an Excel Table

Activity 1.03 Inserting a Total Row in an Excel Table

Objective 2: Create an Excel Worksheet from a Word Table

Activity 1.04 Formatting a Word Table

Activity 1.05 Copying and Pasting a Word Table into an Excel Workbook

Activity 1.06 Using the SUM Function and Fill Handle in Excel

Objective 3: Copy and Paste an Excel Chart into Other Programs

Activity 1.07 Creating and Formatting Charts in Excel

Activity 1.08 Copying and Pasting an Excel Chart into Word

Activity 1.09 Pasting an Excel Chart in PowerPoint

Objective 4: Copy and Paste an Object from PowerPoint into Excel

Activity 1.10   Inserting a SmartArt Graphic

Activity 1.11 Copying and Pasting a SmartArt Graphic

Project 1B: Taos Memo

Objective 5:   Link Excel Data to a Word Document

Activity 1.12 Accessing Paste Special

Objective 6: Modify Linked Data and Update Links

Activity 1.13 Updating the Linked Data

Objective 7: Create a Table in Word from Access Data

Activity 1.14 Exporting an Access Table to an RTF File

Activity 1.15 Inserting Access Data into a Word Document

Objective 8: Use Access Data to Complete a Mail Merge in Word

Activity 1.16 Adding Records to an Access Table

Activity 1.17 Starting Mail Merge in Word

Activity 1.18 Adding Merge Fields