GO! with Excel 2007 Comprehensive

by Gaskin, Shelley; Jolly, Karen

• ISBN13: 9780132255592
• ISBN10: 0132255596
• Edition: 1st
• Format: Paperback
• Copyright: 2007-12-31
• Publisher: Prentice Hall

Summary

The primary goal of theGO!Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package.GO!rs"s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features.Ideal for students and individuals seeking an introduction to Internet Explorer.

Author Biography

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Table of Contents

Creating a Worksheet and Charting Data Project

Seattle Payroll Objective 1 Start Excel and Navigate a Worksheet Activity

Starting Excel and Naming and Saving a Workbook Activity

Navigating a Worksheet Objective 2 Select Parts of a Worksheet Activity

Selecting Cells and Ranges and Entering Data 1 Objective 3 Enter Data, Construct a Formula, and Use the SUM Function Activity

Opening an Existing Workbook, Entering Text, and Using AutoComplete Activity

Entering Numbers and Adjusting Column Width Activity

Entering a Formula and Using the Sum Function Objective 4 Format Data, Cells, and Worksheets Activity

Using Font Styles and Centering Text Activity

Using Merge and Center Objective 5 Insert a Footer into a Worksheet Activity

Adding a Footer to a Worksheet Objective 6 Delete Unused Worksheets and Preview and Print a Worksheet Activity

Deleting Unused Worksheets Activity

Previewing and Printing a Worksheet Objective 7 Print Formulas, Close a Workbook, and Exit Excel Activity

Displaying and Printing Formulas, Closing a Workbook, and Exiting Excel Project

Annual Income Objective 8 Check Spelling and Edit a Worksheet Activity

Opening and Saving an Existing Workbook Activity

Using Wrap Text and the Undo Command Activity

Checking for Spelling Errors in a Worksheet Activity

Editing Text in a Worksheet Objective 9 Enter Data by Range Activity

Selecting Cells and Entering Data by Range Objective 10 Create and Copy Formulas Activity

Using the Point-and-Click Method and Calculation Operators to Create a Formula Activity

Using the Fill Handle to Copy a Formula Activity

Determining Percentages Objective 11 Use Format Painter and Chart Data Activity

Using Format Painter Activity

Charting Data Activity

Printing the Worksheet and its Formulas Activity

Using Help

Using Multiple-Sheet Workbooks Project

Income From Lodging Objective 1 Use a Multiple-Sheet Workbook Activity

Inserting a Worksheet and Entering and Formatting Data in a Multiple Sheet Workbook Activity

Changing the Format of Worksheet Tabs and Using the Tab Scrolling Buttons Objective 2 Enter a Series Activity

Entering a Series Objective 3 Copy and Paste Cell Contents Activity

Using Copy and Paste Activity

Copying Data Between Worksheets Objective 4 Use the Office Clipboard Activity

Using the Office Clipboard to Collect and Paste Data Between Workbooks Objective 5 Total the Worksheet Range and Enter a Grand Total Activity

Totaling the Worksheet in One Step and Correcting Formula Errors Activity

Creating a Grand Total in One Step Objective 6 Format a Multiple-Sheet Workbook Group Activity

Formatting a Worksheet Group and Using Print Preview Objective 7 Insert Columns and Rows in Multiple Worksheets Activity

Inserting Columns in a Worksheet Activity

Inserting Rows That Adjust Relative References and Reviewing Error Messages Project 2B Hotel Taxes Objective 8 Copy a Worksheet Activity

Copying a Worksheet within a Workbook Objective 9 Create Formulas with Absolute Cell References and Copy Formats Activity

Creating and Copying a Formula That Uses an Absolute Cell Reference Objective 10 Find and Replace Text and Hide and Unhide Columns Activity

Using Find and Replace Activity

Hiding

Table of Contents provided by Publisher. All Rights Reserved.