Cover image for Microsoft Excel 2002 MOUS. Core level
Title:
Microsoft Excel 2002 MOUS. Core level
Author:
Fox, Marianne B.
Personal Author:
Publication Information:
Upper Saddle River, N.J. : Prentice Hall, [2003]

©2003
Physical Description:
xv, 285 pages : color illustrations ; 28 cm.
General Note:
A variety of instructor resources are also available: a companion website; an Instructor's Resource CD-ROM (IRCD), which includes PowerPoints, test manager, student data files, instructor's manuals, and solutions files.

Includes index.
Language:
English
Added Author:
ISBN:
9780130497895
Format :
Book

Available:*

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

On Order

Summary

Summary

The 25 tutorials in this study guide match the order of the Excel skill sets measured by the Microsoft office user specialist (MOUS) certification exam. Step-by-step procedures accompanied by screenshots walk through how to work with cells, manage workbooks, format worksheets, enter formulas, create


Table of Contents

About Excel 2002p. 1
Explore the Excel Workspacep. 2
Get Helpp. 7
Chapter 1 Core Skill Set 1 Working with Cells and Cell Datap. 13
Skill 1.1 Insert, Delete and Move Cellsp. 14
Skill 1.2 Enter and Edit Cell Data Including Text, Numbers, and Formulasp. 25
Skill 1.3 Check Spellingp. 40
Skill 1.4 Find and Replace Cell Data and Formatsp. 44
Skill 1.5 Work with a Subset of Data by Filtering Listsp. 50
Chapter 2 Core Skill Set 2 Managing Workbooksp. 69
Skill 2.1 Manage Workbook Files and Foldersp. 70
Skill 2.2 Create Workbooks Using Templatesp. 80
Skill 2.3 Save Workbooks Using Different Names and File Formatsp. 85
Chapter 3 Core Skill Set 3 Formatting and Printing Worksheetsp. 93
Skill 3.1 Apply and Modify Cell Formatsp. 94
Skill 3.2 Modify Row and Column Settingsp. 105
Skill 3.3 Modify Row and Column Formatsp. 113
Skill 3.4 Apply Stylesp. 116
Skill 3.5 Use Automated Tools to Format Worksheetsp. 119
Skill 3.6 Modify Page Setup Options for Worksheetsp. 120
Skill 3.7 Preview and Print Worksheets and Workbooksp. 124
Chapter 4 Core Skill Set 4 Modifying Workbooksp. 137
Skill 4.1 Insert and Delete Worksheetsp. 138
Skill 4.2 Modify Worksheet Names and Positionsp. 146
Skill 4.3 Use 3-D Referencesp. 149
Chapter 5 Core Skill Set 5 Creating and Revising Formulasp. 155
Skill 5.1 Create and Revise Formulasp. 156
Skill 5.2 Use Statistical, Date and Time, Financial, and Logical Functions in Formulasp. 169
Chapter 6 Core Skill Set 6 Creating and Modifying Graphicsp. 199
Skill 6.1 Create, Modify, Position and Print Chartsp. 200
Skill 6.2 Create, Modify and Position Graphicsp. 226
Chapter 7 Core Skill Set 7 Workgroup Collaborationp. 253
Skill 7.1 Convert Worksheets into Web Pagesp. 254
Skill 7.2 Create Hyperlinksp. 258
Skill 7.3 View and Edit Commentsp. 263
Glossaryp. 273
Indexp. 277