Chapter 1-Creating a Worksheet and Charting Data
Project 1A-Create a Worksheet and Chart Data
Objective 1: Create, Save, and Navigate an Excel Workbook
Activity 1.1 Starting Excel and Naming and Saving a Workbook
Activity 1.2 Navigating a Worksheet and a Workbook
Activity 1.3 Selecting Parts of a Worksheet
Objective 2: Enter and Edit Date in a Worksheet
Activity 1.4 Entering Text, Using AutoComplete, Filling a Series with AutoFill,
and Using Spelling Checker and Undo to Correct Typing Errors
Activity 1.5 Aligning Text and Adjusting the Size of Columns and Rows
Activity 1.6 Entering Numbers
Activity 1.7 Inserting and Deleting Rows and Columns and Using the Insert
Options Button
Objective 3: Construct and Copy Formulas, Use the Sum Function, and Edit Cells
Activity 1.8 Constructing a Formula, Using the Sum Function and Editing
Numbers in Cells
Activity 1.9 Copying a Formula by Using the Fill Handle
Objective 4: Format Data, Cells, and Worksheets
Activity 1.10 Formatting Financial Numbers, Using Column AutoFit, and Using
Format Painter
Activity 1.11 Formatting Text and Using Merge and Center
Objective 5: Close and Reopen a Workbook
Activity 1.12 Closing and Reopening an Existing Workbook
Objective 6: Chart Data
Activity 1.13 Charting Data
Objective 7: Use Page Layout View, Prepare a Worksheet for Printing and Close Excel
Activity 1.14 Changing Views, Creating a Footer and Using Print Preview
Activity 1.15 Deleting Unused Sheets in a Workbook
Activity 1.16 Printing a Worksheet
Activity 1.17 Displaying, Printing, and Hiding Formulas
Project 1B-Perform Calculations and Make Comparisons by Using a Pie Chart
Objective 8: Design a Worksheet
Activity 1.18 Setting Column Widths and Creating Row and Column Titles
Activity 1.19 Entering Data by Range
Objective 9: Construct Formulas for Mathematical Operations
Activity 1.20 Using Arithmetic Operators
Activity 1.21 Copying Formulas Containing Absolute Cell References
Objective 10: Format Percentages and Move Formulas
Activity 1.22 Formatting Cells with the Percent Style Button
Activity 1.23 Inserting Rows in a Worksheet Containing Formulas and Wrapping
Text in a Cell
Objective 11: Create a Pie Chart and Chart Sheet
Activity 1.24 Creating a Pie Chart and a Chart Sheet
Objective 12: Use the Excel Help System
Activity 1.25 Using the Excel Help System
Chapter 2-Managing Workbooks and Analyzing Data
Project 2A Create a Summary Sheet from Multiple Worksheets
Objective 1: Create and Save a Workbook from an Existing Workbook
Activity 2.1 Creating and Saving a Workbook from an Existing Workbook
Objective 2: Navigate a Workbook and Rename Worksheets
Activity 2.2 Navigating Among Worksheets, Renaming Worksheets, and
Changing the Tab Color of a Worksheet
Objective 3: Enter Dates, Clear Contents, and Clear Formats
Activity 2.3 Entering and Formatting Dates
Activity 2.4 Clearing Cell Contents and Formats
Objective 4: Move, Copy, and Paste Cell Contents
Activity 2.5 Copying, Pasting, and Moving Cell Contents
Objective 5: Edit and Format Multiple Worksheets at the Same Time
Activity 2.6 Wrapping Text in a Cell in Several Worksheets at the Same Time
Activity 2.7 Entering Data and Constructing Formulas on Multiple Worksheets
Objective 6: Create a Summary Sheet
Activity 2.8 Constructing Formulas that Refer to Cells in Another Worksheet
Objective 7: Format and Print Multiple Worksheets in a Workbook
Activity 2.9 Moving and Formatting Worksheets in a Workbook
Activity 2.10 Printing All the Worksheets in a Workbook
Project 2 B Growth Projection
Objective 8: Design a Worksheet for What-If Analysis
Activity 2.11 Using Parentheses in a Formula
Activity 2.12 Formatting as You Type
Activity 2.13 Calculating a Value After an Increase
Objective 9: Perform What-If Analysis
Activity 2.14 Performing What-If Analysis and Using Paste Special
Objective 10: Compare Data with a Line Chart
Activity 2.15 Creating a Line Chart
Chapter 3-Using Functions and Tables
Project 3A-Track Inventory by Using Math, Logical, and Statistical Functions and by Creating an Excel Table
Objective 1: Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
Activity 3.1 Using the SUM, AVERAGE, and MEDIAN Functions
Activity 3.2 Using the MIN and MAX Functions
Activity 3.3 Moving Data, Adding Borders, and Rotating Text
Objective 2: Use COUNTIF and IF Functions, and Apply Conditional Formatting
Activity 3.4 Using the COUNTIF Functions
Activity 3.5 Using the IF Function and Applying Conditional Formatting
Activity 3.6 Applying Conditional Formatting Using Custom Formats and Data
Bars
Activity 3.7 Using Find and Replace
Objective 3: Use a Date Function
Activity 3.8 Using the NOW Function
Objective 4: Freeze Panes and Create an Excel Table
Activity 3.9 Freezing and Unfreezing Panes
Activity 3.10 Sorting and Filtering in an Excel Table
Activity 3.11 Inserting a Second Table in a Worksheet
Activity 3.12 Converting a Table to a Range of Data
Objective 5: Format and Print a Large Worksheet
Activity 3.13 Printing Large Worksheets
Project 3B-Make Financial Decisions by Using Financial Functions and What-If
Analysis
Objective 6: Use Financial Functions
Activity 3.14 Designing a Loan Worksheet
Activity 3.15 Inserting the PMT Financial Function
Objective 7: Use Goal Seek
Activity 3.16 Using Goal Seek to Produce the Desired Result
Activity 3.17 Using Goal Seek to Find an Increase Period
Objective 8: Create a Data Table
Activity 3.18 Designing a Two-Variable Data Table
Activity 3.19 Using a Data Table to Calculate Options
