Go! With Microsoft Office 2010, Volume 1 - 2nd edition

Table of Contents 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 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 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, 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