Cover image for Certification circle MOUS: Microsoft Excel 2002 : core
Title:
Certification circle MOUS: Microsoft Excel 2002 : core
Author:
Clemens, Barbara.
Personal Author:
Publication Information:
Boston, Mass. : Course Technology/Thomson Learning, [2002]

©2002
Physical Description:
viii, 200 pages : illustrations ; 24 cm.
General Note:
Includes index.
Language:
English
ISBN:
9780619056704
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
HF5548.4.M523 C595 2002 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Part of the Certification Circle series created to allow students to focus on the skills that will appear on the MOUS certification exams. This textbook covers all basic areas of Excel including integrating Excel and the Web.


Table of Contents

Prefacep. IV
Instructor's Resourcep. VI
Getting Started with Excel 2002p. 1
Start and Exit the Excel Programp. 2
Explore the Excel Windowp. 4
Open and Close an Excel Workbookp. 6
Navigate an Excel Workbookp. 8
Explore Task Panesp. 10
Copy Workbook Filesp. 12
Save Workbooksp. 14
Preview and Print a Worksheetp. 16
Get Helpp. 18
Skill Set 1 Working with Cells and Cell Datap. 21
Insert, Delete, and Move Cellsp. 22
Enter and Edit Cell Data Including Text, Numbers, and Formulasp. 28
Enter and Edit Formulasp. 36
Enter and Edit Cell Data Including Text, Numbers, and Formulasp. 38
Check Spellingp. 40
Find and Replace Cell Data and Formatsp. 42
Work with a Subset of Data by Filtering Listsp. 48
Skill Set 2 Managing Workbooksp. 51
Manage Workbook Files and Foldersp. 52
Create Workbooks Using Templatesp. 56
Save Workbooks Using Different Names and File Formatsp. 58
Skill Set 3 Formatting and Printing Workbooksp. 65
Apply and Modify Cell Formatsp. 66
Modify Row and Column Settingsp. 70
Modify Row and Column Formatsp. 78
Apply Stylesp. 84
Use Automated Tools to Format Worksheetsp. 86
Modify Page Setup Options for Worksheetsp. 88
Preview and Print Worksheets and Workbooksp. 94
Skill Set 4 Modifying Workbooksp. 99
Insert and Delete Worksheetsp. 100
Modify Worksheet Names and Positionsp. 104
Use 3-D Referencesp. 110
Skill Set 5 Creating and Revising Formulasp. 115
Create and Revise Formulasp. 116
Use Statistical, Date and Time, Financial, and Logical Functions in Formulasp. 126
Skill Set 6 Creating and Modifying Graphicsp. 137
Create, Modify, Position, and Print Chartsp. 138
Create, Modify, and Position Graphicsp. 154
Skill Set 7 Workbook Collaborationp. 159
Convert Worksheets into Web Pagesp. 160
Create Hyperlinksp. 164
View and Edit Commentsp. 168
Projects Listp. 169
Sales Projection for Alaska Adventuresp. 170
Invoice for Art Rentals to Moviesp. 172
Budget for Into Thin Air Balloon Toursp. 174
Price Lists for Keeping the Beat Drum Shopp. 176
Maui Resorts Time Share Vacation Optionsp. 178
Sales Information for Fanfloratastic Flowersp. 180
Sales Report for Splashdown Raftingp. 182
Glossaryp. 185
Indexp. 193