Exploring Microsoft Office 2010, Volume 1

Contents Windows 7 Chapter One ? Getting Started with Windows 7 Case Study: Cedar Cove Elementary School Objectives Windows 7 Fundamentals Understanding the Desktop Managing Windows HANDS-ON EXERCI SE 1: Windows 7 Fundamentals Windows Programs and Security Features Identifying Windows Accessories Working with Security Settings and Software HANDS-ON EXERCI SE 2: Windows Programs and Security Features WINDOWS SEARCH AND HELP Performing a Search Getting Help HANDS-ON EXERCI SE 3: Windows Search and Help Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Office Fundamentals and File Management Chapter One ? Office Fundamentals and File Management Case Study: Rails And Trails Objectives Files and Folders Using Windows Explorer Working with Folders and Files Selecting, Copying, and Moving Multiple Files and Folders Hands-On Excercise 1: Files and Folders Microsoft Office Software Identifying Common Interface Components Getting Office Help Hands-On Excercise 2: Microsoft Office Software Backstage View Tasks Opening a File Printing a File Closing a File and Application Hands-On Excercise 3: Backstage View Tasks Home Tab Tasks Selecting and Editing Text Using the Clipboard Group Tasks Using the Editing Group Tasks Hands-On Excercise 4: Home Tab Tasks Insert Tab Tasks Inserting Objects Review Tab Tasks Reviewing a File Page Layout Tab Tasks Changing Page Settings Hands-On Excercise 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Microsoft Office Word 2010 Chapter One ? Introduction to Word Case Study: First River Outfitter Objectives Introduction To Word Processing Understanding How Word Processors Work Customizing Word Hands-On Excercise 1: Introduction to Word Processing Document Organization Using Features That Improve Readability Checking Spelling and Grammar Displaying a Document in Different Views Hands-On Excercise 2: Document Organization Finalize A Document Preparing a Document for Distribution Modifying Document Properties Hands-On Excercise 3: Finalize a Document Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Two ? Document Presentation Case Study: Simserv-Pitka Enterprises Objectives Text Formatting Features Applying Font Attributes Through the Font Dialog Box Controlling Word Wrap HAN DS-ON EXERCI SE 1: Text Formatting Features Paragraph Formatting Features Setting Off Paragraphs with Tabs, Borders, Lists, and Columns Applying Paragraph Formats HAN DS-ON EXERCI SE 2: Paragraph Formatting Features Styles Understanding Styles Creating and Modifying Styles HAN DS-ON EXERCI SE 3: Styles Graphical Objects Formatting a Graphical Object Inserting Symbols into a Document Hands-On Excercise 4: Graphical Objects Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Three ? Collaboration and Research Case Study: Marketing Plan For Take Note Paperie Objectives Document Revisions Inserting Comments in a Document Tracking Changes in a Document Hands-On Excercise 1: Document Revisions Research Paper Basics Acknowledging a Source Creating and Modifying Footnotes and Endnotes Hands-On Excercise 2: Research Paper Basics Research Paper Enhancements Inserting a Table of Contents and Index Adding Other Reference Tables Creating Cross-References HAN DS-ON EXERCI SE 3: Research Paper Enhancements Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Four ? Document Productivity Case Study: Community Disaster Relief Center Objectives TABLES Inserting a Table Formatting a Table Hands-On Exercise 1: Tables Advanced Table Features Sorting and Applying Formulas to Table Data Converting Text to a Table HANDS-ON EXERCISE 2: Advanced Table Features Mail Merge Selecting a Main Document Selecting or Creating Recipients COLABORATION CAPSTONE Word Inserting Merge Fields Merging a Main Document and a Data Source HANDS-ON EXERCISE 3: Mail Merge Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom COLLABORATION CAPSTONE ? Word Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise Microsoft Office Excel 2010 Chapter One ? Introduction to Excel Case Study: Ok Office Systems Objectives Introduction To Spreadsheets Planning for Effective Workbook and Worksheet Design Exploring the Excel Window Entering and Editing Cell Data Hands-On Excercise 1: Introduction to Spreadsheets Mathematics and Formulas Using Symbols and the Order of Precedence Using Auto Fill Displaying Cell Formulas Hands-On Excercise 2: Mathematics and Formulas Workbook And Worksheet Management Managing Worksheets Managing Columns and Rows Selecting, Moving, Copying, and Pasting Hands-On Excercise 3: Workbook and Worksheet Management Formatting Applying Alignment and Font Options Applying Number Formats Hands-On Excercise 4: Formatting Page Setup And Printing Selecting Page Setup Options Printing a Worksheet Hands-On Excercise 5: Page Setup and Printing Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Two ? Formulas and Functions Case Study: Denver Mortgage Company Objectives Formula Basics Using Semi-Selection to Create a Formula Using Relative, Absolute, and Mixed Cell References in Formulas Avoiding Circular References HAN DS-ON EXERCI SE 1: Formula Basics Function Basics Inserting a Function Totaling Values with the SUM Function Inserting Basic Statistical Functions Using Date Functions Hands-On Excercise 2: Function Basics Logical, Lookup, and Financial Functions Determining Results with the IF Function Using Lookup Functions Calculating Payments with the PMT Function Hands-On Excercise 3: Logical, Lookup, and Financial Functions Range Names Creating and Maintaining Range Names Using Range Names in Formulas Hands-On Excercise 4: Range Names Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Three ? Charts Case Study: Hort University Majors Objectives Chart Basics Deciding Which Chart Type to Create Creating a Chart Hands-On Excercise 1: Chart Basics Chart Design Changing the Chart Type Changing the Data Source and Structure Applying a Chart Layout and a Chart Style Moving a Chart Printing Charts Inserting and Customizing a Sparkline Hands-On Excercise 2: Chart Design Chart Layout Selecting and Formatting Chart Elements Customizing Chart Labels Formatting the Axes and Gridlines Adding a Trendline Hands-On Excercise 3: Chart Layout Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Four ? Datasets and Tables Case Study: The Spa Experts Objectives Large Datasets Freezing Rows and Columns Printing Large Datasets HAN DS-ON EXERCI SE 1: Large Datasets Excel Tables Understanding Table Design Creating a Table Applying a Table Style Hands-On Excercise 2: Excel Tables Table Manipulation and Aggregation Sorting Data Filtering Data Using Structured References and a Total Row Collaboration Capstone Excel Hands-On Excercise 3: Table Manipulation and Aggregation Conditional Formatting Applying Conditional Formatting Creating a New Rule Sorting and Filtering Using Conditional Formatting Hands-On Excercise 4: Conditional Formatting Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom COLLABORATION CAPSTONE ? Excel Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise Microsoft Office Access 2010 Chapter One ? Introduction to Access Case Study: Managing A Business in the Global Economy Objectives Databases Are Everywhere! Navigating Among the Objects in an Access Database Understanding the Difference Between Working inStorage and Memory Practicing Good Database File Management Backing Up, Compacting, and Repairing Access Files Hands-On Excercise 1: Databases Are Everywhere! Filters, Sorts, and Acess Versus Excel Creating Filters Sorting Table Data on One or More Fields Knowing When to Use Access or Excel to Manage Data Hands-On Excercise 2: Filters, Sorts, and Access Versus Excel Relational Database Using the Relationships Windows Understanding Relational Power Hands-On Excercise 3: Relational Database Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Two ? Relational Databases and Queries Case Study: Bank Auditor Uncovers Midhandled Funds Objectives Table Design, Properties, Views, and Wizards Designing Data Creating Tables Hands-On Excercise 1: Table Design, Properties, Views, and Wizards Multiple Table Databases Understanding Table Relationships Sharing Data with Excel Establishing Table Relationships Hands-On Excercise 2: Multiple Table Databases Single-Table Queries Creating a Single-Table Query Specifying Criteria for Different Data Types Copying and Running a Query Using the Query Wizard Hands-On Excercise 3: Single-Table Queries Multi-Table Queries Creating a Multi-Table Query Modifying a Multi-Table Query Hands-On Excercise 4: Multi-Table Queries Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Three ? Customize, Analyze, and Summarize Query Data Case Study: Housing Slump Means Opportunity for College Students Objectives Calculations, Expressions, and Functions Understanding the Order of Operations Creating a Calculated Field in a Query Hands-On Excercise 1: Calculations, Expressions, and Functions Expression Builder, Functions, and Date Arithmetic Creating Expressions with the Expression Builder Using Built-In Functions in Access Performing Date Arithmetic Hands-On Exercise 2: Expression Builder, Functions, and Date Arithmetic Aggregate Functions Adding Aggregate Functions to Datasheets and Queries Hands-On Exercise 2: Aggregate Functions Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Four ? Creating and Using Professional Forms and Reports Case Study: Coffee Shop Starts new Business Objectives Form Basics Creating Forms Using the Form Tools Modifying a Form Sorting Records in a Form Hands-On Excercise 1: Form Basics Form Sections, Views, and Controls Identifying Form Sections Revising Forms Using Form Views Identifying Control Types in Forms Hands-On Excercise 2: Form Sections, Views, and Controls Report Basics Creating Reports Using Report Tools Modifying a Report Sorting Records in a Report Collaboration Capstone Access Hands-On Excercise 3: Report Basics Report Sections, Views, and Controls Identifying Report Sections Revising Reports Using Report Views Identifying Control Types in Reports Hands-On Excercise 4: Report Sections, Views, and Controls Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom COLLABORATION CAPSTONE ? Access Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise Microsoft Office Powerpoint 2010 Chapter One ? Introduction to PowerPoint Case Study: Be A Trainer Objectives Introduction to Powerpoint Using PowerPoint Views Saving as a Slide Show Hands-On Excercise 1: Introduction to PowerPoint Presentation Creation Planning a Presentation Assessing Presentation Content Using Slide Layouts Applying Themes Reviewing the Presentation Hands-On Excercise 2: Presentation Creation Presentation Development Inserting Media Objects Adding a Table Using Animations and Transitions Inserting a Header or Footer Hands-On Excercise 3: Presentation Development Navigation and Printing Running and Navigating a Slide Slow Printing in PowerPoint Hands-On Excercise 4: Navigation and Printing Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Two ? Presentation Development Case Study: The Wellness Education Center Objectives Templates Creating a Presentation Using a Template Modifying a Template Hands-On Excercise 1: Templates Outlines Creating a Presentation in Outline View Modifying an Outline Structure Printing an Outline Hands-On Excercise 2: Outlines Data Imports Importing an Outline Adding Existing Content to a Presentation Hands-On Excercise 3: Data Imports Design Using Sections Examining Slide Show Design Principles Modifying a Theme Hands-On Excercise 4: Design Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Three ? Presentation Design Case Study: Illustrations and Infographics Mini-Camp Objectives Shapes Creating Shapes Applying Quick Styles and Customizing Shapes Hands-On Excercise 1: Shapes Smartart and Wordart Creating SmartArt Modifying SmartArt Creating WordArt Modifying WordArt Hands-On Excercise 2: SmartArt and WordArt Object Manipulation Modifying Objects Arranging Objects Hands-On Excercise 3: Object Manipulation Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom Chapter Four ? PowerPoint Rich Media Tools Case Study: Wedding Albums Objectives Pictures Inserting a Picture Transforming a Picture Using the Internet as a Resource Hands-On Excercise 1: Pictures Video Adding Video Using Video Tools Hands-On Excercise 2: Video Audio Adding Audio Changing Audio Settings Hands-On Excercise 3: Audio Photo Albums Creating a Photo Album Setting Photo Album Options Hands-On Excercise 4: Photo Albums Chapter Objectives Review Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Beyond The Classroom COLLABORATION CAPSTONE ? PowerPoint Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise CAPSTONE EXERCISES VOLUME 1 ? Using Office in Paralegal, Zoo, and Medical Professions Paralegal Word Excel Access PowerPoint Integrated Zoo Word Excel Access PowerPoint Integrated Medical Word Excel Access PowerPoint Integrated Glossary Index