Exploring Microsoft Office 2007 / Edition 1

Exploring Microsoft Office 2007 / Edition 1

by Robert Grauer, Michelle Hulett, Cynthia Krebs, Maurie Lockley, Judy Scheeren
     
 

ISBN-10: 0132393816

ISBN-13: 9780132393812

Pub. Date: 09/03/2007

Publisher: Prentice Hall

The Exploring series helps students master the How and Why of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature Perfect pages where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen

Overview

The Exploring series helps students master the How and Why of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature Perfect pages where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired.

Exploring Microsoft Office 2007 Plus Edition, 1/e provides thorough coverage of Word, Excel, Access, and PowerPoint.

Ideal for students and individuals seeking a comprehensive introduction to Microsoft Office 2007.

Product Details

ISBN-13:
9780132393812
Publisher:
Prentice Hall
Publication date:
09/03/2007
Series:
Custom PHIT: the Pearson Custom Program for CIS Series
Edition description:
Plus Edition
Pages:
1376
Product dimensions:
10.92(w) x 11.06(h) x 2.20(d)

Table of Contents

Section 1 Microsoft Office 2007 Software

Identifying Common Interface Components

Using Office 2007 Help

Hands-on Exercise #1: Identifying Program Interface Components and Using Help

Section 2 Universal Tasks

Opening a File

Saving a File

Printing a Document

Hands-on Exercise #2: Performing UniversalTasks

Section 3 Basic Tasks

Selecting Text to Edit

Inserting Text and Changing to the Overtype Mode

Moving and Copying Text

Finding, Replacing, and Going to Text

Using the Undo and Redo Commands

Using Language Tools

Applying Font Attributes

Copying Formats with the Format Painter

Hands-on Exercise #3: Performing Basic Tasks

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Exploring Microsoft Office Word 2007

Chapter 1 - What Will Word Processing Do for Me?

Section 1 Introduction to Word Processing

Understanding Word Basics

Using AutoText

Viewing a Document

Using the Mini Toolbar

Hands-On Exercise #1: Introduction to Microsoft Word

Section 2 Document Formatting

Setting Margins and Specifying Page Orientation

Inserting Page Breaks

Adding Page Numbers

Inserting Headers and Footers

Creating Sections

Inserting a Cover Page

Using Find and Replace Commands

Hands-On Exercise #2: Document Organization

Section 3 The Final Touches

Checking Spelling and Grammar

Using Save and Backup Options

Selecting Printing Options

Customizing Word

Hands-On Exercise #3: The Final Touches

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 2 - Gaining Proficiency: Editing and Formatting

Section 1 Text Formatting

Applying Font Attributes Through the Font Dialog Box

Highlighting Text

Controlling Word Wrapping with Nonbreaking Hyphens and Nonbreaking Spaces

Copying Formats with the Format Painter

Hands-on exercise #1: Character Formatting

Section 2 Paragraph Formats

Setting Off Paragraphs with Tabs, Borders, Lists, and Columns

Applying Paragraph Formats

Hands-on exercise #2: Paragraph formatting

Section 3 Styles and Document References

Creating and Modifying Styles

Hands-on exercise #3: Styles

Table of Contents and Indexes

Hands-on exercise #4: Reference Pages

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 3 - Enhancing a Document: Tables and Graphics

Section 1 Tables

Inserting a Table

Hands-On Exercise #1: Insert a Table

Section 2 Advanced Table Features

Formatting a Table

Sort and Apply Formulas to Table Data

Converting Text to a table

Hands-On Exercise #2: Advanced Table Features

Section 3 Graphic Tools

Inserting Clipart and Images into a Document

Formatting a Graphic Element

Inserting WordArt into a Document

Inserting Symbols into a Document

Hands-On Exercise #3: Clip Art, WordArt, and Symbols

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 4 - Share, Compare, and Document

Section 1 Workgroups and Collaboration

Inserting Comments in a Document

Tracking Changes in a Document

Hands-On Exercise #1: Document Collaboration

Section 2 Multiple Documents

Viewing Documents Side by Side

Comparing and Combining Documents

Creating Master Documents and Subdocuments

Using Navigation Tools

Hands-On Exercise #2: Document Comparison, Mergers, and Navigation

Section 3 Reference Resources

Acknowledging a Source

Creating a Bibliography

Selecting the Writing Style

Creating and Modifying Footnotes and Endnotes

Hands-On Exercise #3: Reference Resources

Section 4 Additional Reference Resources

Adding Figure References

Inserting a Table of Figures

Adding Legal References

Creating a Cross-Reference

Modifying Document Properties

Hands-On Exercise #4: Additional Reference Resources

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Exploring Microsoft Office Excel 2007

Chapter 1 - Introduction to Excel

Section 1: Introduction to Spreadsheets

Defining Worksheets and Workbooks

Using Spreadsheets Across Disciplines

Planning for Good Workbook and Worksheet Design

Identifying Excel Window Components

Entering and Editing Data in Cells

Hands-On Exercise #1: Introduction to Microsoft Excel

Section 2: Mathematics and Formulas

Describing and Using Symbols and the Order of Precedence

Displaying Cell Formulas

Inserting and Deleting Rows and Columns

Using Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFill

Hands-On Exercise #2: Jakes Gym Continued

Section 3: Workbook and Worksheet Enhancements

Managing Worksheets

Formatting Worksheets

Hands-On Exercise #3: Formatting Jake's Gym Worksheet

Section 4: Page Setup and Printing

Selecting Page Setup Options for Printing

Managing Cell Comments

Hands-On Exercise #4: Printing Jake's Gym Worksheet

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 2 - Microsoft Excel: Formulas and Functions

Section 1: Formula Basics

Creating and Copying Formulas

Using Relative and Absolute Cell Addresses

Hands-On Exercise #1: Smithtown Hospital Radiology Department Payroll

Section 2: Function Basics

Using AutoSum

Inserting Basic Statistical Functions

Using Date Functions

Hands-On Exercise #2: Completing the Smithtown Hospital Radiology Department

Section 3: Logical and Lookup Functions

Using the IF Function

Using the VLOOKUP Function

Hands-On Exercise #3: Athletic Department Eligibility Gradebook

Section 4: Financial Functions

Using the PMT Function

Using the FV Function

Hands-On Exercise #4: Purchasing a Van for the School for Exceptional Children

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 3 - Microsoft Excel: Charts

Section 1: A Picture is the Message

Choosing A Chart Type

Creating a Chart

Hands-on Exercise 1: The First Chart

Section 2: Chart Enhancements

Modifying a Chart

Enhancing Charts with Graphic Shapes

Hands-on Exercise 2: Multiple Data Series

Section 3: Chart Distribution

Embedding Charts

Printing Charts

Hands-on Exercise 3: Embedding, Printing, And Saving Chart as a Web Page

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 4: Microsoft Excel: Working with Large Worksheets and Tables

Section 1: Large Worksheet Preparation

Freezing Rows and Columns

Hiding and Unhiding Rows, Columns, and Worksheets

Protecting a Cell, a Worksheet and a Workbook

Controlling Calculation

Printing Large Worksheets

Hands-On Exercise #1: Marching Band Roster

Section 2: Excel Data Tables

Exploring Basic Table Management

Sorting Data

Filtering and Totaling Data

Hands-On Exercise #2: Marching Band Roster Revisited

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 5 - Data to Information

Section 1 Table Management

Designing Tables Based on Table Data Theory

Importing Data from Text Files and Other Sources

Applying Conditional Formatting

Hands-on Exercise 1: Gee Airlines Human Resources Department

Section 2 Data Management

Applying Advanced Filtering and Sorting Methods

Creating and Using Range Names

Using Database Functions

Hands-on Exercise 2: Gee Airlines Human Resources Department Revisited

Section 3 Data Analysis with PivotTables and PivotCharts

Creating and Deleting PivotTables and PivotChart Reports

Formatting, Sorting, Filtering, Subtotaling, and Refreshing a PivotTable

Hands-on Exercise 3: Eye First Advertising Department Sales

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 6 – Data Tables and Amortization Tables

Section 1 Tables

Separating and Combining Text

Manipulating Text with Functions

Hands-on Exercise 1: IT Department String Manipulation

Section 2 Data Analysis and Windows

Identifying and Removing Duplicate Rows

Grouping and Subtotaling Data

Working with Windows

Hands-on Exercise 2: Ajax College Band

Section 3 Conditional and Logical Functions

Using Conditions in Functions

Creating Nested IF Functions

Using AND, OR, NOT and IFERROR Functions

Hands-on Exercise 3: Classic Cars and Security

Section 4 Amortization Table

Defining the Amortization Table

Using Functions in Amortization Tables

Hands-on Exercise 4: Purchase a New House

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 7 – Data Consolidation, Links, and Formula Auditing

Section 1 Data Consolidation

Consolidating Data from Multiple Worksheets

Defining the Three-Dimensional Workbook

Creating Three-Dimensional References in Formulas

Hands-on Exercise 1: Consolidating Best Restaurant Corporate Sales

Section 2 Workbook Linking and Documentation

Linking Workbooks

Creating the Documentation Worksheet

Hands-on Exercise 2: Consolidating Workbooks for Corporate Sales and Adding Documentation

Section 3 Workbook Auditing

Restricting Values to a Drop-Down List

Validating Data

Auditing Formulas

Setting up a Watch Window

Hands-on Exercise 3: JAS Manufacturing

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Exploring Microsoft Office Access 2007

Chapter 1 - Introduction to Access: Finding Your Way through a Database

Section 1: Data and Files Everywhere!

Exploring, Describing, and Navigating Among the Objects in an Access Database

Understanding the Difference Between Working in Storage and Memory

Practicing Good File Management

Backing up, Compacting, and Repairing Access Files

Hands-On Exercises 1 Introduction to Databases

Section 2: Filters, Sorts, and Access Versus Excel

Creating Filters

Sorting Table Data on One or More Fields

Knowing When to Use Access or Excel to Manage Data

Hands-On Exercises 2: Data Manipulation: Filters and Sorts

Section 3: The Relational Database

Using the Relationship Window

Understanding Relational Power

Hands-On Exercises 3: Introduction to Relationships

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using

Section 1: Related Data

Table Design, Properties, Views, and Wizards

Designing Data

Creating Tables

Hands-On Exercises 1: Table Design, Properties, Views, and Wizards

Section 2: Multiple Table Database

Understanding Table Relationships

Sharing Data with Excel

Establishing Table Relationships

Hands-on Exercises 2: Imports and Relationships

Section 3: Queries

Creating a Query

Specifying Criteria for Different Data Types

Copying and Running a Query

Using the Query Wizard

Understanding Large Database Differences

Hands-On Exercises 3: Multi-Table Query

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Section 1: Data Summary and Analysis

Understanding the Order of Precedence

Creating a Calculated Field in a Query

Hands-On Exercises 1: Calculated Query Fields

Section 2: Expression Builder

Creating Expressions with the Expression Builder

Creating and Editing Access Functions

Performing Date Arithmetic

Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic

Section 3: Data Aggregates

Creating and Working with Data Aggregates

Hands-On Exercises 3: Data Aggregates

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

Section 1: Appearance Matter

Planning Reports

Using Different Report Views

Creating and Editing a Report

Hands-On Exercises 1: Introduction to Access Reports

Section 2: The Anatomy of a Report

Identifying Report Elements, Sections and Controls

Adding Grouping Levels Using the Layout View

Adding Fields to a Report

Hands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from Reports

Section 3: The Report and Label Wizard

Using the Report Wizard

Hands-On Exercises 3: Report Wizard

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 5 – Pivot Tables and Charts

Section 1 Data Mining

Create a PivotTable view

Calculate aggregate statistics

Modify a PivotTable

Hands-on Exercise 1: Create and Use a PivotTable

Section 2 Charts Convey Information

Select an appropriate chart type

Identify chart elements

Edit a PivotChart

Hands-on Exercise 2: PivotCharts and Modifications

Section 3 Calculations in PivotTables and PivotCharts

Create calculations in a PivotTable

Hands-on Exercise 3: 3 Calculating Field Values in PivotTables

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 6 – Data Protection: Integrity, Validation, Reliability

Section 1 Data Validity

Establish Data Validity

Create a Lookup

Modify a Lookup by Adding and Deleting Values

Create and Modify a Multivalue Lookup Field

Work with Input Masks

Hands-on Exercise 1: Data Protection

Section 2 Forms

Create Forms Using the Forms Tools

Hands-on Exercise 2: Form Creation Tools

Section 3 Form Customization

Create Custom Forms Using Design View

Add Action Buttons and Combo Box Controls

Create Subforms

Fashion Functional Formats

Hands-on Exercise 3: Customizing Forms

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Exploring MS Office PowerPoint 2007

Chapter 1: Introduction to PowerPoint: Presentations Made Easy

Section 1 Introduction to PowerPoint

Identifying PowerPoint User Interface Elements

User PowerPoint Views

Opening and Saving a Slide Show

Getting Help

Hands-On Exercise 1: Introduction to PowerPoint

Section 2 Presentation Creation

Creating a Storyboard

Using Slide Layouts

Applying Design Theme

Reviewing the Presentation

Hands-On Exercise 2: Creating a Presentation

Section 3 Presentation Development

Adding a Table

Inserting Clip Art

Using Transitions and Animations

Hands-On Exercise 3: Strengthening a Presentation

Section 4 Navigation and Printing

Running and Navigating a Slide Show

Printing with PowerPoint

Hands-On Exercise 4: Navigating and Printing

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 2: Presentation Development: Planning and Preparing a Presentation

Section 1 Templates

Creating a Presentation Using a Template

Modifying a Template

Hands-On Exercise 1: Using a template

Section 2 Outlines

Creating a Presentation in Outline View

Modifying an Outline Structure

Printing an Outline

Hands-On Exercise 2: Creating and Modifying an Outline

Section 3 Data Imports

Importing an Outline

Adding Existing Content to a Presentation

Hands-On Exercise 3: Importing an Outline and Reusing Slides

Section 4 Design

Examining Slide Show Design Principles

Applying and Modifying a Design Theme

Inserting a Header or Footer

Hands-On Exercise 4: Applying and Modifying a Design Theme

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Windows XP

Section 1 Basics of Windows XP

Identifying Components on the Windows Desktop

Working with Windows, Menus, and Dialog Boxes

Identify Dialog Box Components

Using the Help and Support Center

Hands-on Exercise #1: Introduction to Windows XP

Section 2 Files and Folders

Working with Folders

Managing Folders and Files in Windows Explorer

Deleting Items and Managing the Recycle Bin

Hands-on Exercise #2: File and Folder Management

Section 3 Windows Customization

Changing the Display Settings

Changing Computer Settings

Using the Control Panel

Creating Shortcuts on the Desktop and Quick Launch Toolbar

Using Windows Desktop Search

Hands-on Exercise #3: Customizing Your System

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >