Excel 2002 Book

	Introduction to Microsoft Office XP
	What Is Office XP?
	Word 2002
	Excel 2002
	Access 2002
	PowerPoint 2002
	Common Office XP Features
	Starting an Office Application
	Using Menus
	Using the Office Assistant
	Using Help
	Using the Contents Tab
	Using a Hyperlink
	Using the Index Tab
	Using the Answer Wizard
	Getting Help on the Web
	Using Toolbars
	Exiting an Office Application
	Lab Review
	Key Terms
	Command Summary
	Excel: Overview of Excel 2002
	What is an Electronic Spreadsheet?
	Excel 2002 Features
	Case Study for Excel 2002 Labs
	Before You Begin
	Microsoft Office Shortcut Bar
	Instructional Conventions
Lab 1	Creating and Editing a Worksheet
	Exploring Excel 2002
	Starting Excel 2002
	Exploring the Excel Window
	Exploring the Workbook Window
	Moving around the Worksheet
	Creating New Workbooks
	Using the Default Workbook Template
	Developing a Workbook
	Entering and Editing Data
	Entering Text
	Clearing an Entry
	Editing an Entry
	Using AutoCorrect
	Entering Numbers
	Changing Column Widths
	Dragging the Column Boundary
	Using AutoFit
	Saving, Closing, and Opening Workbooks
	Saving a New Workbook
	Closing a Workbook
	Opening an Existing Workbook
	Duplicating Cell Contents
	Using Copy and Paste
	Selecting a Range
	Using the Fill Handle
	Inserting Copied Cells
	Moving Entries
	Working with Formulas
	Entering Formulas
	Copying Formulas
	Entering Functions
	Using Pointing to Enter a Formula
	Recalculating the Worksheet
	Inserting Rows
	Formatting the Worksheet
	Changing Cell Alignment
	Indenting Entries
	Centering across a Selection
	Changing Fonts and Font Styles
	Applying Character Effects
	Using Undo
	Using Format Painter
	Formatting Numbers
	Using Styles
	Adding Color
	Working with Graphics
	Inserting Graphics
	Sizing Graphics
	Entering the Date
	Previewing and Printing a Workbook
	Exiting Excel 2002
	Concept Summary
	Lab Review
	Key Terms
	MOUS Skills
	Command Summary
	Lab Exercises
	Terminology
	Screen Identification
	Matching
	Multiple Choice
	True/False
	Concepts
	Fill-In
	Discussion Questions
	Hands-On Exercises
	Step-by-Step
	On Your Own
	On the Web
Lab 2	Charting Worksheet Data
	Learning About Charts
	Creating a Single Data Series Chart
	Selecting the Data to Chart
	Using Chart Wizard
	Moving and Sizing a Chart
	Changing the Chart Location
	Creating a Multiple Data Series Chart
	Changing the Chart Type
	Adding Chart Titles
	Moving the Legend
	Formatting Chart Elements
	Changing Orientation
	Creating a New Chart from an Existing Chart
	Copying a Chart
	Creating a Combination Chart
	Adding Data Labels
	Changing Data Series Fill Colors
	Changing Plot Area Colors
	Changing Worksheet Data
	Adding a Text Box
	Adding Arrows
	Creating and Formatting a Pie Chart
	Selecting the Pie Chart Data
	Formatting the Pie Chart
	Exploding and Rotating the Pie
	Applying Patterns and Color
	Documenting a Workbook
	Preparing the Workbook for Printing
	Previewing the Workbook
	Sizing the Worksheet
	Aligning a Sheet on a Page
	Adding Predefined Headers and Footers
	Printing the Workbook
	Concept Summary
	Lab Review
	Key Terms
	MOUS Skills
	Command Summary
	Lab Exercises
	Terminology
	Screen Identification
	Matching
	Multiple Choice
	True/False
	Concepts
	Fill-In
	Discussion Questions
	Hands-On Exercises
	Step-by-Step
	On Your Own
Lab 3	Managing and Analyzing a Workbook
	Correcting Worksheet Errors
	Checking Spelling
	Correcting Formula Errors
	Using Absolute References
	Working with Sheets
	Copying Between Sheets
	Renaming Sheets and Coloring Sheet Tabs
	Filling a Series
	Referencing Multiple Sheets
	Deleting and Moving Sheets
	Managing Large Sheets
	Zooming the Worksheet
	Going to a Specific cell
	Splitting Windows
	Freezing Panes
	Watching Cells
	Forecasting Values
	Performing What-If Analysis Manually
	Using Goal Seek
	Changing Values Using a Chart
	Customizing Print Settings
	Changing Page Orientation
	Displaying Gridlines and Centering on Page
	Adding Custom Headers and Footers
	Printing Selected Sheets
	Concept Summary
	Lab Review
	Key Terms
	MOUS Skills
	Command Summary
	Lab Exercises
	Terminology
	Screen Identification
	Matching
	Multiple Choice
	True/False
	Concepts
	Fill-In
	Discussion Questions
	Hands-On Exercises
	Step-by-Step
	On Your Own
	On the Web
	Working Together: Linking, Embedding, and E-mailing
	Copying Between Applications
	Copying a Worksheet to a Word Document
	Linking Between Applications
	Linking a Chart Object to a Word Document
	Updating a Linked Object
	Editing Links
	Embedding an Object in Another Application
	Embedding a Worksheet in a Word Document
	Updating an Embedded Object
	E-Mailing the Memo
	Deciding When to Link or Embed Objects
	Lab Review
	Key Terms
	Command Summary
	Lab Exercises
	Hands-On Exercises
	Step-by-Step
	Command Summary
	Glossary of Key Terms
Reference 1	Data File List
Reference 2	MOUS Skills
	Index