Microsoft Excel 2007: A Professional Approach

Title
Contents
LESSON 1: GETTING STARTED WITH EXCEL
	Starting Excel
		Exercise 1-1: Work with the Excel Interface
	Navigating in a Workbook
		Exercise 1-2: Move Between Worksheets
		Exercise 1-3: Go to a Specific Cell
		Exercise 1-4: Scroll Through a Worksheet
		Exercise 1-5: Change the Zoom Size
		Exercise 1-6: Close a Workbook
	Opening an Existing Workbook
		Exercise 1-7: Open a Workbook
	Editing a Worksheet
		Exercise 1-8: View Worksheets and Cell Contents
		Exercise 1-9: Replace Cell Contents
		Exercise 1-10: Edit Cell Contents
		Exercise 1-11: Clear Cell Contents
		Exercise 1-12: Use Undo and Redo
	Managing Files
		Exercise 1-13: Create a New Folder and Use Save As
	Printing Excel Files
		Exercise 1-14: Preview and Print a Worksheet
		Exercise 1-15: Print a Workbook
		Exercise 1-16: Save an XPS File
		Exercise 1-17: Exit Excel
	Lesson 1 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 1-18
		Exercise 1-19
		Exercise 1-20
		Exercise 1-21
	Lesson Applications
		Exercise 1-22
		Exercise 1-23
		Exercise 1-24
		Exercise 1-25
	On Your Own
		Exercise 1-26
		Exercise 1-27
		Exercise 1-28
LESSON 2: CREATING A WORKBOOK
	Entering Labels
		Exercise 2-1: Enter Labels in a Worksheet
	Changing the Document Theme
		Exercise 2-2: Change the Theme
		Exercise 2-3: Change the Font, Font Size, and Style
		Exercise 2-4: Use the Format Painter
	Selecting Cell Ranges
		Exercise 2-5: Select Ranges with the Mouse
		Exercise 2-6: Select Ranges with Keyboard Shortcuts
	Modifying Column Width and Row Height
		Exercise 2-7: Modify Column Width
		Exercise 2-8: Modify Row Height
	Entering Values and Dates
		Exercise 2-9: Enter Dates and Values
		Exercise 2-10: Apply Number Formats from the Ribbon
		Exercise 2-11: Apply Date Formats from the Dialog Box
		Exercise 2-12: Change the Font Color
		Exercise 2-13: Rename a Worksheet and Change the Tab Color
	Saving a Workbook
		Exercise 2-14: Save a Workbook
	Entering Basic Formulas
		Exercise 2-15: Key a Basic Formula
		Exercise 2-16: Enter a Formula by Pointing
		Exercise 2-17: Copy a Formula by Using the Copy and Paste Buttons
		Exercise 2-18: Use AutoSum, Average, and Max
		Exercise 2-19: Check Results with AutoCalculate
	Lesson 2 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 2-20
		Exercise 2-21
		Exercise 2-22
		Exercise 2-23
	Lesson Applications
		Exercise 2-24
		Exercise 2-25
		Exercise 2-26
		Exercise 2-27
	On Your Own
		Exercise 2-28
		Exercise 2-29
		Exercise 2-30
LESSON 3: USING EDITING AND STYLE TOOLS
	Using AutoCorrect and Error Checking
		Exercise 3-1: Use AutoCorrect to Correct Errors
		Exercise 3-2: Set AutoCorrect Options
		Exercise 3-3: Review Error Checking
	Checking Spelling
		Exercise 3-4: Spell-Check a Worksheet
	Using Find and Replace
		Exercise 3-5: Find Data
		Exercise 3-6: Use Wildcards
		Exercise 3-7: Replace Data
		Exercise 3-8: Replace a Function in a Formula
		Exercise 3-9: Correct Errors with Replace
		Exercise 3-10: Find and Replace Formats
		Exercise 3-11: Reset Find and Replace Formats
	Using Series and AutoFill
		Exercise 3-12: Create Month and Week Series
		Exercise 3-13: Create a Number Series
		Exercise 3-14: Copy Data with the Fill Handle
		Exercise 3-15: Copy a Formula with the Fill Handle
	Applying Table and Cell Styles
		Exercise 3-16: Create a Table
		Exercise 3-17: Change the Table Style
		Exercise 3-18: Apply a Cell Style
		Exercise 3-19: Print a Selection
	Preparing Headers and Footers
		Exercise 3-20: Set Headers and Footers
		Exercise 3-21: Print Gridlines and Row and Column Headings
		Exercise 3-22: Change Margins and Column Widths in Page Layout View
	Lesson 3 Summary
		Concepts Review
		True/False Questions
		Short Answer Questions
		WD1.
		Critical Thinking
		Skills Review
			Exercise 3-23
			Exercise 3-24
			Exercise 3-25
			Exercise 3-26
		Lesson Applications
			Exercise 3-27
			Exercise 3-28
			Exercise 3-29
			Exercise 3-30
		On Your Own
			Exercise 3-31
			Exercise 3-32
			Exercise 3-33
LESSON 4: EXPLORING HOME TAB COMMANDS
	Inserting and Deleting Sheets and Cells
		Exercise 4-1: Insert Worksheets
		Exercise 4-2: Move and Delete Worksheets
		Exercise 4-3: Insert Cells
		Exercise 4-4: Delete Cells
	Using AutoComplete and Pick From Drop-Down List
		Exercise 4-5: Use AutoComplete
		Exercise 4-6: Use Pick From Drop-Down List
	Copying, Cutting, and Pasting Cell Contents
		Exercise 4-7: Cut and Paste Cell Contents
		Exercise 4-8: Copy and Paste Cell Contents
		Exercise 4-9: Use Drag and Drop
		Exercise 4-10: Use the Office Clipboard
	Working with Columns and Rows
		Exercise 4-11: Insert Rows
		Exercise 4-12: Delete Rows
		Exercise 4-13: Insert and Delete Rows
		Exercise 4-14: Hide and Unhide Columns and Rows
		Exercise 4-15: Freeze and Split the Window
	Working with Cell Alignment
		Exercise 4-16: Change the Horizontal Alignment
		Exercise 4-17: Use Center Across Selection
		Exercise 4-18: Change the Vertical Alignment
		Exercise 4-19: Wrap Text and Change Indents
		Exercise 4-20: Use Merge and Center
		Exercise 4-21: Change Cell Orientation
	Applying Borders and Fill
		Exercise 4-22: Apply Borders Using the Borders Button
		Exercise 4-23: Apply Borders Using the Dialog Box
		Exercise 4-24: Add Solid Fill
		Exercise 4-25: Use Pattern Fill
		Exercise 4-26: Complete the Number Formatting
	Using Data Bars
		Exercise 4-27: Use Data Bars
		Exercise 4-28: Edit the Data Bar Rule
	Lesson 4 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 4-29
		Exercise 4-30
		Exercise 4-31
		Exercise 4-32
	Lesson Applications
		Exercise 4-33
		Exercise 4-34
		Exercise 4-35
		Exercise 4-36
	On Your Own
		Exercise 4-37
		Exercise 4-38
		Exercise 4-39
	UNIT 1 APPLICATIONS
	Unit Application 1-1
	Unit Application 1-2
	Unit Application 1-3
	Unit Application 1-4
LESSON 5: EXPLORING FORMULA BASICS
	Using a Template to Create a Workbook
		Exercise 5-1: Create a Workbook from a Template
	Building Addition and Subtraction Formulas
		Exercise 5-2: Create and Copy Addition Formulas
		Exercise 5-3: Create and Copy Subtraction Formulas
	Building Multiplication and Division Formulas
		Exercise 5-4: Create Multiplication Formulas
		Exercise 5-5: Edit a Formula in the Formula Bar
		Exercise 5-6: Create Division Formulas
		Exercise 5-7: Apply the Percent Style and Increase Decimal Positions
	Using Order of Precedence in a Formula
		Exercise 5-8: Use Multiplication and Addition in a Formula
		Exercise 5-9: Set Order of Precedence
	Using Relative, Absolute, and Mixed References
		Exercise 5-10: Use a Line Break
		Exercise 5-11: Copy a Formula with a Relative Reference
		Exercise 5-12: Create a Formula with an Absolute Reference
		Exercise 5-13: Use a Color Scale
		Exercise 5-14: Use Mixed References
		Exercise 5-15: Add Borders and Fill for Printing
	Working with the Page Layout Tab
		Exercise 5-16: Change Page Orientation
		Exercise 5-17: Change Scaling and Page Margins
		Exercise 5-18: Copy a Worksheet and Display Formulas
		Exercise 5-19: Add a Background
		Exercise 5-20: Save a Workbook as a Web Page
	Lesson 5 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 5-21
		Exercise 5-22
		Exercise 5-23
		Exercise 5-24
	Lesson Applications
		Exercise 5-25
		Exercise 5-26
		Exercise 5-27
		Exercise 5-28
	On Your Own
		Exercise 5-29
		Exercise 5-30
		Exercise 5-31
LESSON 6: WORKING WITH FUNCTIONS
	Using Math and Trig Functions
		Exercise 6-1: Use SUM and the Formula Bar
		Exercise 6-2: Use Insert Function
		Exercise 6-3: Use TRUNC
		Exercise 6-4: Use SUMIF
	Using Statistical Functions
		Exercise 6-5: Use the AVERAGE Function
		Exercise 6-6: Use AVERAGEIF
		Exercise 6-7: Use the MIN and MAX Functions
		Exercise 6-8: Use COUNT and COUNTBLANK
		Exercise 6-9: Use the COUNTA Function
	Using Icon Sets
		Exercise 6-10: Apply Icon Sets
		Exercise 6-11: Edit the Icon Formatting Rule
	Grouping Worksheets
		Exercise 6-12: Group and Delete Worksheets
		Exercise 6-13: Manage Worksheets WD1.1
	Using Date and Time Functions
		Exercise 6-14: Use the TODAY() Function
		Exercise 6-15: Key and Format Dates
		Exercise 6-16: Use Fill Across Worksheets
		Exercise 6-17: Create a Custom Date Format
		Exercise 6-18: Key and Format Times
		Exercise 6-19: Use the NOW() Function
		Exercise 6-20: Create a Custom Time Format
		Exercise 6-21: Add a Header to Grouped Sheets
	Lesson 6 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 6-22
		Exercise 6-23
		Exercise 6-24
		Exercise 6-25
	Lesson Applications
		Exercise 6-26
		Exercise 6-27
		Exercise 6-28
		Exercise 6-29
	On Your Own
		Exercise 6-30
		Exercise 6-31
		Exercise 6-32
LESSON 7: USING LOGICAL AND FINANCIAL FUNCTIONS
	Using the IF Function
		Exercise 7-1: Use IF to Show Text
		Exercise 7-2: Use IF to Calculate a Value
	Using AND, OR, and NOT Functions
		Exercise 7-3: Use the AND Function
		Exercise 7-4: Use the OR Function
		Exercise 7-5: Use the NOT Function
	Working with Cell Styles
		Exercise 7-6: Use Cell Styles
		Exercise 7-7: Clear and Reapply Cell Styles
		Exercise 7-8: Create a Style
		Exercise 7-9: Edit a Style
	Working with Page Breaks
		Exercise 7-10: Preview and Change Page Breaks
		Exercise 7-11: Remove and Insert Page Breaks
		Exercise 7-12: Set Print Titles
		Exercise 7-13: Center a Page
		Exercise 7-14: Change the Footer Font and Print Page Numbers
		Exercise 7-15: Remove a Page Break
	Using the PMT and FV Functions
		Exercise 7-16: Use the PMT Function
		Exercise 7-17: Key a PMT Function
		Exercise 7-18: Use the FV Function
		Exercise 7-19: Format Negative Numbers
	Using Depreciation Functions
		Exercise 7-20: Use the DB Function
		Exercise 7-21: Copy and Edit the DB Function
	Lesson 7 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 7-22
		Exercise 7-23
		Exercise 7-24
		Exercise 7-25
	Lesson Applications
		Exercise 7-26
		Exercise 7-27
		Exercise 7-28
		Exercise 7-29
	On Your Own
		Exercise 7-30
		Exercise 7-31
		Exercise 7-32
LESSON 8: ROUNDING AND NESTING FUNCTIONS
	Using the INT Function
		Exercise 8-1: Use INT with a Cell Reference
		Exercise 8-2: Compare Values with INT
	Using the ROUND Function
		Exercise 8-3: Use ROUND
		Exercise 8-4: Compare Rounded Values
		Exercise 8-5: Change Colors and Borders
	Using Date and Time Arithmetic
		Exercise 8-6: Determine Ages and Dates
		Exercise 8-7: Determine Time Passed
		Exercise 8-8: Group Sheets to Add Footers
		Exercise 8-9: Hide and Unhide a Worksheet
	Creating Nested Functions
		Exercise 8-10: Nest SUM and ROUND
		Exercise 8-11: Create a Nested IF Function
		Exercise 8-12: Set Top/Bottom Conditional Formatting
	Creating a Hyperlink
		Exercise 8-13: Create a Hyperlink
		Exercise 8-14: Run the Compatibility Checker
	Lesson 8 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 8-15
		Exercise 8-16
		Exercise 8-17
		Exercise 8-18
	Lesson Applications
		Exercise 8-19
		Exercise 8-20
		Exercise 8-21
		Exercise 8-22
	On Your Own
		Exercise 8-23
		Exercise 8-24
		Exercise 8-25
	UNIT 2 APPLICATIONS
	Unit Application 2-1
	Unit Application 2-2
	Unit Application 2-3
	Unit Application 2-4
LESSON 9: BUILDING CHARTS
	Viewing and Printing a Chart
		Exercise 9-1: View a Chart Object
		Exercise 9-2: Print a Chart Object
	Working with Chart Elements
		Exercise 9-3: Change the Chart Layout
		Exercise 9-4: Change the Chart Style
		Exercise 9-5: Edit and Format the Chart Title
		Exercise 9-6: Set Shape Fill and Effects
		Exercise 9-7: Set and Format Data Labels
		Exercise 9-8: Format the Axes
		Exercise 9-9: Format the Plot and Chart Areas
	Creating Charts
		Exercise 9-10: Create and Edit a Chart Sheet
		Exercise 9-11: Create a Chart Object
		Exercise 9-12: Move and Size a Chart Object
		Exercise 9-13: Change the Layout and Styles
		Exercise 9-14: Create a Bar Chart Sheet
		Exercise 9-15: Add Gridlines and a Data Table
	Editing Chart Data
		Exercise 9-16: Edit Chart Data
		Exercise 9-17: Add a Data Point
		Exercise 9-18: Add and Rename Data Series
		Exercise 9-19: Delete Data Points and a Data Series
	Using Images, Gradients, and Textures for a Data Series
		Exercise 9-20: Use an Image for a Data Series
		Exercise 9-21: Use a Gradient for a Data Series
		Exercise 9-22: Use a Texture for a Data Point
	Creating a Combination Chart
		Exercise 9-23: Create a Chart with Two Chart Types
		Exercise 9-24: Build a Chart with Two Series
		Exercise 9-25: Add a Secondary Axis
	Lesson 9 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 9-26
		Exercise 9-27
		Exercise 9-28
		Exercise 9-29
	Lesson Applications
		Exercise 9-30
		Exercise 9-31
		Exercise 9-32
		Exercise 9-33
	On Your Own
		Exercise 9-34
		Exercise 9-35
		Exercise 9-36
LESSON 10: INSERTING SHAPES
	Adding and Formatting a Callout
		Exercise 10-1: Add a Callout to a Worksheet
		Exercise 10-2: Format and Move a Callout
		Exercise 10-3: Use the Format Shape Dialog Box
	Using Text Boxes
		Exercise 10-4: Add a Text Box
		Exercise 10-5: Format and Move a Text Box
		Exercise 10-6: Choose a Shape Style
	Inserting Basic Shapes and Arrows
		Exercise 10-7: Add a Shape and an Arrow
		Exercise 10-8: Resize the Name Box
		Exercise 10-9: Use the Selection and Visibility Pane
	Using the Drawing Tools Format Tab
		Exercise 10-10: Format Multiple Shapes
		Exercise 10-11: Copy and Move Objects
		Exercise 10-12: Size Shapes
		Exercise 10-13: Align and Nudge Shapes
		Exercise 10-14: Change a Shape
		Exercise 10-15: Use the Adjustment Handle
		Exercise 10-16: Rotate Shapes
		Exercise 10-17: Style Multiple Shapes
	Using Comments
		Exercise 10-18: Edit a Comment
		Exercise 10-19: Insert a Comment
			WD1.
		Exercise 10-20: Print Comments
		Exercise 10-21: Use Document Inspector
	Inserting WordArt
		Exercise 10-22: Insert WordArt
		Exercise 10-23: Edit WordArt
	Lesson 10 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 10-24
		Exercise 10-25
		Exercise 10-26
		Exercise 10-27
	Lesson Applications
		Exercise 10-28
		Exercise 10-29
		Exercise 10-30
		Exercise 10-31
	On Your Own
		Exercise 10-32
		Exercise 10-33
		Exercise 10-34
LESSON 11: USING IMAGES AND SMARTART GRAPHICS
	Inserting a Picture
		Exercise 11-1: Insert a Picture from a File
		Exercise 11-2: Check Properties and Scale the Picture
		Exercise 11-3: Format and Copy an Image
		Exercise 11-4: Insert Clip Art
		Exercise 11-5: Crop, Size, and Style an Image
	Adding a Picture to a Header/Footer
		Exercise 11-6: Insert an Image in a Footer
		Exercise 11-7: Size an Image in a Footer
		Exercise 11-8: Create a Watermark
	Creating a Hierarchy SmartArt Shape
		Exercise 11-9: Create and Style an Organization Chart
		Exercise 11-10: Add a Shape to an Organization chart
		Exercise 11-11: Add Text to the Shapes
	Building a Cycle SmartArt Shape
		Exercise 11-12: Create a Cycle Diagram
		Exercise 11-13: Move Text in the Text Pane
		Exercise 11-14: Choose a New Layout
	Using the Research Tool
		Exercise 11-15: Find Synonyms
		Exercise 11-16: Translate Words
		Exercise 11-17: Use a Special Symbol
		Exercise 11-18: Set Document Properties
	Lesson 11 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 11-19
		Exercise 11-20
		Exercise 11-21
		Exercise 11-22
	Lesson Applications
		Exercise 11-23
		Exercise 11-24
		Exercise 11-25
		Exercise 11-26
	On Your Own
		Exercise 11-27
		Exercise 11-28
		Exercise 11-29
	UNIT 3 APPLICATIONS
	Unit Application 3-1
	Unit Application 3-2
	Unit Application 3-3
	Unit Application 3-4
LESSON 12: USING 3-D REFERENCES
	Working with Multiple Sheets
		Exercise 12-1: Edit a Marked-as-Final Workbook
		Exercise 12-2: Group Sheets for Editing
	Creating a 3-D Reference
		Exercise 12-3: Create a Single-Cell 3-D Reference
		Exercise 12-4: Edit Referenced Data
	Using a Formula in a 3-D Reference
	Exercise 12-5: Use Addition in a 3-D WD1.1 Reference
		Exercise 12-6: Use Multiplication in a 3-D Reference
		Exercise 12-7: Copy and Scroll Multiple Worksheets
	Using a Function in a 3-D Reference
		Exercise 12-8: Key Data in a Selected Range
		Exercise 12-9: Use AVERAGE in a 3-D Reference
		Exercise 12-10: Use MAX in a 3-D Reference
	Creating a Digital Signature
		Exercise 12-11: Add a Digital Signature
		Exercise 12-12: Remove a Digital Signature
	Lesson 12 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 12-13
		Exercise 12-14
		Exercise 12-15
		Exercise 12-16
	Lesson Applications
		Exercise 12-17
		Exercise 12-18
		Exercise 12-19
		Exercise 12-20
	On Your Own
		Exercise 12-21
		Exercise 12-22
		Exercise 12-23
LESSON 13: WORKING WITH TABLES
	Preparing a List as a Table
		Exercise 13-1: Prepare a List
		Exercise 13-2: Create a Table
	Working with the Table Tools Design and Data Tabs
		Exercise 13-3: Restyle a Table
		Exercise 13-4: Name a Table and Remove Duplicates
		Exercise 13-5: Sort Records in a Table
		Exercise 13-6: Sort by Multiple Columns
	Adding and Filtering Records
		Exercise 13-7: Add a Record to a Table
		Exercise 13-8: Resize a Table
		Exercise 13-9: Use the Filter Arrow Lists
		Exercise 13-10: Filter Dates
		Exercise 13-11: Show Totals in a Table
	Using COUNTIFS and SUMIFS
		Exercise 13-12: Create a 3-D Formula with COUNTIFS
		Exercise 13-13: Use SUMIFS
		Exercise 13-14: Use the TEXT Function
	Setting Print Areas
		Exercise 13-15: Set and Clear a Print Area
		Exercise 13-16: Print Noncontiguous Selections
	Creating Custom Views
		Exercise 13-17: Convert a Table to a Range
		Exercise 13-18: Create Custom Views
		Exercise 13-19: Display Views
	Lesson 13 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 13-20
		Exercise 13-21
		Exercise 13-22
		Exercise 13-23
	Lesson Applications
		Exercise 13-24
		Exercise 13-25
		Exercise 13-26
		Exercise 13-27
	On Your Own
		Exercise 13-28
		Exercise 13-29
		Exercise 13-30
LESSON 14: USING NAMED RANGES AND STRUCTURED REFERENCES
	Using Named Ranges
		Exercise 14-1: Use Ranges for Navigation
		Exercise 14-2: Name a Defined Range
		Exercise 14-3: Use Named Ranges in a Formula
		Exercise 14-4: Insert Data within a Named Range
		Exercise 14-5: Create Range Names Automatically
		Exercise 14-6: Delete Range Names
		Exercise 14-7: Suppress Errors for Printing
		Exercise 14-8: Setting the Scope for a Named Range
		Exercise 14-9: Modify Defined Names
	Naming a Constant
		Exercise 14-10: Name a Constant
		Exercise 14-11: Use a Constant in a Formula
	Documenting Range Names
		Exercise 14-12: Create a Range Name List
	Working with Structured References
		Exercise 14-13: Review Structured References
		Exercise 14-14: Use Structured References in Formulas
	Using Lookup Functions
		Exercise 14-15: Use VLOOKUP
		Exercise 14-16: Transpose Data While Copying
		Exercise 14-17: Use HLOOKUP
		Exercise 14-18: Edit an HLOOKUP Function
		Exercise 14-19: Create and Remove a Circular Reference
	Lesson 14 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 14-20
		Exercise 14-21
		Exercise 14-22
		Exercise 14-23
	Lesson Applications
		Exercise 14-24
		Exercise 14-25
		Exercise 14-26
		Exercise 14-27
	On Your Own
		Exercise 14-28
		Exercise 14-29
		Exercise 14-30
	UNIT 4 APPLICATIONS
	Unit Application 4-1
	Unit Application 4-2
	Unit Application 4-3
	Unit Application 4-4
LESSON 15: USING AUDITING TOOLS
	Evaluating a Formula
		Exercise 15-1: Evaluate a Formula
	Setting a Data Validation List
		Exercise 15-2: Create a Data Validation List
		Exercise 15-3: Set an Error Message for Data Validation
		Exercise 15-4: Use and Copy Data Validation Settings
		Exercise 15-5: Circle Invalid Data
	Tracing Precedents, Dependents, and Error Messages
		Exercise 15-6: Trace Precedents
		Exercise 15-7: Trace Dependents and Error Messages
	Finding and Correcting Errors
		Exercise 15-8: Use Go to Special
		Exercise 15-9: Use Multiple Windows
	Troubleshooting Errors
		Exercise 15-10: Look for Errors
		Exercise 15-11: Correct Errors
	Using the Watch Window
		Exercise 15-12: Use the Watch Window
		Exercise 15-13: Delete a Watch
		Exercise 15-14: Correct Division by Zero
		Exercise 15-15: Mark a Workbook as Final
	Using IFERROR
		Exercise 15-16: Use IFERROR
	Lesson 15 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 15-17
		Exercise 15-18
		Exercise 15-19
		Exercise 15-20
	Lesson Applications
		Exercise 15-21
		Exercise 15-22
		Exercise 15-23
		Exercise 15-24
	On Your Own
		Exercise 15-25
		Exercise 15-26
		Exercise 15-27
LESSON 16: USING WHAT-IF ANALYSIS
	Creating a Scenario
		Exercise 16-1: Enable and Run a Macro
		Exercise 16-2: Create a Scenario
		Exercise 16-3: Add Scenarios to the Worksheet
	Setting Highlight Cells Rules
		Exercise 16-4: Set a Highlight Cells Rule
		Exercise 16-5: Create a New Formatting Rule
		Exercise 16-6: Set Two Highlight Cells Rules
	Managing Scenarios
		Exercise 16-7: Show Scenarios
		Exercise 16-8: Edit a Scenario
		Exercise 16-9: Print a Scenario Summary Report
		Exercise 16-10: Save a Macro-Free Workbook
	Forecasting with a Trendline
		Exercise 16-11: Create and Format a Chart
		Exercise 16-12: Add a Trendline to a Chart
		Exercise 16-13: Format a Trendline
	Using Goal Seek
		Exercise 16-14: Use Goal Seek to Determine a Price
		Exercise 16-15: Use Goal Seek to Determine Units Sold
	Using Solver
		Exercise 16-16: Use Solver to Determine Units Sold
		Exercise 16-17: Add Solver Constraints
		Exercise 16-18: Edit a Scenario Report
		Exercise 16-19: Save a Document with a Thumbnail Preview
	Lesson 16 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 16-20
		Exercise 16-21
		Exercise 16-22
		Exercise 16-23
	Lesson Applications
		Exercise 16-24
		Exercise 16-25
		Exercise 16-26
		Exercise 16-27
	On Your Own
		Exercise 16-28
		Exercise 16-29
		Exercise 16-30
LESSON 17: CONSOLIDATING AND LINKING WORKBOOKS
	Creating a Static Data Consolidation
		Exercise 17-1: Prepare a Worksheet for Consolidation
		Exercise 17-2: Create a Static Consolidation
		Exercise 17-3: Edit Underlying Data
	Creating a Dynamic Data Consolidation
		Exercise 17-4: Create a Dynamic Consolidation
		Exercise 17-5: Display Formulas in an Outline
	Consolidating Data by Category
		Exercise 17-6: Set Up Data to Be Consolidated
		Exercise 17-7: Use AVERAGE to Consolidate by Category
		Exercise 17-8: Consolidate Data by Using MAX
	Linking Workbooks
		Exercise 17-9: Link Workbooks by Pointing
	Examining and Editing Links
		Exercise 17-10: Examine Links
		Exercise 17-11: Move a Source Workbook
		Exercise 17-12: Edit Links
		Exercise 17-13: Break Links
		Exercise 17-14: Restrict Permission to a Workbook
	Lesson 17 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 17-15
		Exercise 17-16
		Exercise 17-17
		Exercise 17-18
	Lesson Applications
		Exercise 17-19
		Exercise 17-20
		Exercise 17-21
		Exercise 17-22
	On Your Own
		Exercise 17-23
		Exercise 17-24
		Exercise 17-25
	UNIT 5 APPLICATIONS
	Unit Application 5-1
	Unit Application 5-2
	Unit Application 5-3
	Unit Application 5-4
LESSON 18: USING EXTERNAL DATA SOURCES
	Using Text Sources
		Exercise 18-1: Copy and Paste from Word
		Exercise 18-2: Review Data and Smart Tags
		Exercise 18-3: Create a Custom Format
		Exercise 18-4: Drag and Drop a Word Document
		Exercise 18-5: Use Copy and Paste Special
		Exercise 18-6: Get a Text File
	Managing Imported Data
		Exercise 18-7: Set Import Options
		Exercise 18-8: Create Theme Fonts and Colors
		Exercise 18-9: Save a Document Theme
		Exercise 18-10: Remove Duplicate Data
		Exercise 18-11: Convert Text to Columns
		Exercise 18-12: Use PROPER and SUBSTITUTE
	Using Web Sources
		Exercise 18-13: Copy from the Web by Dragging
		Exercise 18-14: Create a Web Query
		Exercise 18-15: Manage Connections
	Using Database Sources
		Exercise 18-16: Import an Access Table
		Exercise 18-17: Use Microsoft Query
	Exporting Excel Data
		Exercise 18-18: Copy Data to Word
		Exercise 18-19: Save a Workbook as a Text File
		Exercise 18-20: Delete a Document Theme
	Lesson 18 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 18-21
		Exercise 18-22
		Exercise 18-23
		Exercise 18-24
	Lesson Applications
		Exercise 18-25
		Exercise 18-26
		Exercise 18-27
		Exercise 18-28
	On Your Own
		Exercise 18-29
		Exercise 18-30
		Exercise 18-31
LESSON 19: EXPLORING LIST RANGES
	Sorting and Filtering a List Range
		Exercise 19-1: Name and Format a List Range
		Exercise 19-2: Sort by Conditional Formatting
		Exercise 19-3: Filter by Cell Attributes
		Exercise 19-4: Create Custom Filters
	Creating Advanced Filters
		Exercise 19-5: Set the Criteria Range
		Exercise 19-6: Filter Data in Place
		Exercise 19-7: Create an Output Range
		Exercise 19-8: Filter Data to an Output Range
	Using Subtotals
		Exercise 19-9: Use Subtotal
		Exercise 19-10: Subtotal with AVERAGE
	Using Database Functions
		Exercise 19-11: Use DMIN
		Exercise 19-12: Use DCOUNT
	Creating and Editing Outlines
		Exercise 19-13: Use the SUBTOTAL function
		Exercise 19-14: Add Grand Totals
		Exercise 19-15: Create an Auto Outline
		Exercise 19-16: Create a Row Outline Manually
		Exercise 19-17: Expand and Hide Details
	Lesson 19 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 19-18
		Exercise 19-19
		Exercise 19-20
		Exercise 19-21
	Lesson Applications
		Exercise 19-22
		Exercise 19-23
		Exercise 19-24
		Exercise 19-25
	On Your Own
		Exercise 19-26
		Exercise 19-27
		Exercise 19-28
LESSON 20: USING DATA TABLES AND PIVOTTABLES
	Building a One-Variable Data Table
		Exercise 20-1: Prepare Formulas and Input Values
		Exercise 20-2: Create a Data Table
		Exercise 20-3: Format the Data Table
		Exercise 20-4: Insert an En Dash and a Pointer
		Exercise 20-5: Delete, Edit, and Copy a Data Table
	Building a Two-Variable Data Table
		Exercise 20-6: Set Up Input Values and the Formula
		Exercise 20-7: Create and Format the Data Table
	Analyzing Data in a PivotTable
		Exercise 20-8: View Data in a PivotTable
		Exercise 20-9: Pivot Fields in the PivotTable Field List Pane
	Creating a PivotTable
		Exercise 20-10: Create a PivotTable
		Exercise 20-11: Use PivotTable Tools Options
		Exercise 20-12: Edit Field Settings
	Using Multiple Calculations
		Exercise 20-13: Use Multiple Fields and Functions
		Exercise 20-14: Add a Calculated Field
		Exercise 20-15: Set How Values are Shown
		Exercise 20-16: Refresh Data
	Creating a PivotChart
		Exercise 20-17: Create a PivotChart for an Existing PivotTable
		Exercise 20-18: Create a PivotChart from the List
	Lesson 20 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 20-19
		Exercise 20-20
		Exercise 20-21
		Exercise 20-22
	Lesson Applications
		Exercise 20-23
		Exercise 20-24
		Exercise 20-25
		Exercise 20-26
	On Your Own
		Exercise 20-27
		Exercise 20-28
		Exercise 20-29
	UNIT 6 APPLICATIONS
	Unit Application 6-1
	Unit Application 6-2
	Unit Application 6-3
	Unit Application 6-4
LESSON 21: WORKING WITH MACROS
	Running and Viewing a Macro
		Exercise 21-1: Run a Macro
		Exercise 21-2: Open the Visual Basic Editor
	Editing and Printing a Macro
		Exercise 21-3: Edit a Macro
		Exercise 21-4: Use a Macro Keyboard Shortcut
		Exercise 21-5: Add a Comment and Print a Macro
	Recording a Macro
		Exercise 21-6: Record a Macro with Absolute References
		Exercise 21-7: Delete a Macro
		Exercise 21-8: Use Relative References in a Macro
		Exercise 21-9: Review Macro Code
	Assigning a Macro to a Button
		Exercise 21-10: Display the Developer Tab
		Exercise 21-11: Draw a Button
		Exercise 21-12: Delete a Button
	Creating a Macro Workbook
		Exercise 21-13: Record Macros
		Exercise 21-14: Save, Hide, and Use a Macro Workbook
	Lesson 21 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 21-15
		Exercise 21-16
		Exercise 21-17
		Exercise 21-18
	Lesson Applications
		Exercise 21-19
		Exercise 21-20
		Exercise 21-21
		Exercise 21-22
	On Your Own
		Exercise 21-23
		Exercise 21-24
		Exercise 21-25
LESSON 22: USING TEMPLATES
	Using an Installed Template
		Exercise 22-1: Create a Workbook Based on an Installed Template
		Exercise 22-2: Edit and Save a Workbook Based on a Template
	Adding Worksheet Protection
		Exercise 22-3: Edit an Installed Template
		Exercise 22-4: Change the Locked Property
		Exercise 22-5: Protect the Worksheet
		Exercise 22-6: Update Properties
		Exercise 22-7: Save a Template
		Exercise 22-8: Use View Side by Side
		Exercise 22-9: Delete a Template
	Using an Online Template
		Exercise 22-10: Download an Online Template
		Exercise 22-11: Edit and Save a Template
		Exercise 22-12: Use and Delete a Template
	Creating a User Template
		Exercise 22-13: Build a Template
		Exercise 22-14: Add a Formula and Hide Zeros
		Exercise 22-15: Add Data Validation
		Exercise 22-16: Use a Validation Input Message
		Exercise 22-17: Add Conditional Formatting and a Comment
		Exercise 22-18: Protect the Sheet with a Password
		Exercise 22-19: Create a Templates Folder
		Exercise 22-20: Create a Workbook from a Template
		Exercise 22-21: Remove Protection and the Password
	Using Workbook Protection
		Exercise 22-22: Create a Workbook Template
		Exercise 22-23: Add Sheet and Workbook Protection
		Exercise 22-24: Delete a Folder and Files
	Lesson 22 Summary
	Concepts Review
	True/False Questions
	Short Answer Questions
	Critical Thinking
	Skills Review
		Exercise 22-25
		Exercise 22-26
		Exercise 22-27
		Exercise 22-28
	Lesson Applications
		Exercise 22-29
		Exercise 22-30
		Exercise 22-31
		Exercise 22-32
	On Your Own
		Exercise 22-33
		Exercise 22-34
		Exercise 22-35
LESSON 23: USING WORKGROUP FEATURES
	Creating a Shared Workbook
		Exercise 23-1: Create a Shared Workbook
	Tracking Changes
		Exercise 23-2: Set Change History Options
		Exercise 23-3: Activate Change Highlighting
		Exercise 23-4: Track and Highlight Changes
		Exercise 23-5: Add Comments in a Shared Workbook
	Printing a Change History Sheet
		Exercise 23-6: Display and Print a History Worksheet
	Comparing and Merging Workbooks
		Exercise 23-7: Display the Compare and Merge Button
		Exercise 23-8: Compare and Merge Workbooks
	Accepting or Rejecting Changes
		Exercise 23-9: Accept or Reject Changes
		Exercise 23-10: Reset the User Name and Quick Access Toolbar
	Lesson 23 Summary
		Concepts Review
		True/False Questions
		Short Answer Questions
		Critical Thinking
	Skills Review
		Exercise 23-11
		Exercise 23-12
		Exercise 23-13
		Exercise 23-14
	Lesson Applications
		Exercise 23-15
		Exercise 23-16
		Exercise 23-17
		Exercise 23-18
	On Your Own
		Exercise 23-19
		Exercise 23-20
		Exercise 23-21
	UNIT 7 APPLICATIONS
	Unit Application 7-1
	Unit Application 7-2
	Unit Application 7-3
	Unit Application 7-4
APPENDIX
GLOSSARY
INDEX