Top
| 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. Ferret 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. |
| GO! with Microsoft Office 2010 Volume 1 | |
| 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 Using Graphics and Lists | |
| 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 Creating Table and 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 and Newsletters | |
| 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 |
| Activitiy 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, 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 |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
Need Help? Copyright © 1999-2026
