Cover image for Microsoft Excel 2002 MOUS. Core level
Microsoft Excel 2002 MOUS. Core level
Fox, Marianne B.
Personal Author:
Publication Information:
Upper Saddle River, N.J. : Prentice Hall, [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.
Added Author:
Format :


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

On Order



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