×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Microsoft Excel 2002 MOUS Core Level / Edition 1
     

Microsoft Excel 2002 MOUS Core Level / Edition 1

by Marianne Fox, Lawrence Metzelaar
 

ISBN-10: 0130497894

ISBN-13: 9780130497895

Pub. Date: 07/24/2002

Publisher: Prentice Hall

This book focuses on preparing the user to pass the associated Microsoft Office User Specialist (MOUS) certification exam. Its step-by-step tutorials show how to complete the required procedures in a clear, concise, and direct manner. The tutorials are organized to match the order of the skill sets and skills being measured as published on Microsoft's MOUS website.

Overview

This book focuses on preparing the user to pass the associated Microsoft Office User Specialist (MOUS) certification exam. Its step-by-step tutorials show how to complete the required procedures in a clear, concise, and direct manner. The tutorials are organized to match the order of the skill sets and skills being measured as published on Microsoft's MOUS website. Skill sets include working with cells and cell data, formatting and printing worksheets, modifying workbooks, creating and revising formulas, creating and modifying graphics, and workgroup collaboration. For MOUS certification.

Product Details

ISBN-13:
9780130497895
Publisher:
Prentice Hall
Publication date:
07/24/2002
Series:
Prentice Hall Test Prep Series
Edition description:
New Edition
Pages:
285
Product dimensions:
8.42(w) x 10.98(h) x 0.47(d)

Table of Contents

About Excel 20021
Explore the Excel Workspace2
Get Help7
Chapter 1Core Skill Set 1 Working with Cells and Cell Data13
Skill 1.1Insert, Delete and Move Cells14
Skill 1.2Enter and Edit Cell Data Including Text, Numbers, and Formulas25
Skill 1.3Check Spelling40
Skill 1.4Find and Replace Cell Data and Formats44
Skill 1.5Work with a Subset of Data by Filtering Lists50
Chapter 2Core Skill Set 2 Managing Workbooks69
Skill 2.1Manage Workbook Files and Folders70
Skill 2.2Create Workbooks Using Templates80
Skill 2.3Save Workbooks Using Different Names and File Formats85
Chapter 3Core Skill Set 3 Formatting and Printing Worksheets93
Skill 3.1Apply and Modify Cell Formats94
Skill 3.2Modify Row and Column Settings105
Skill 3.3Modify Row and Column Formats113
Skill 3.4Apply Styles116
Skill 3.5Use Automated Tools to Format Worksheets119
Skill 3.6Modify Page Setup Options for Worksheets120
Skill 3.7Preview and Print Worksheets and Workbooks124
Chapter 4Core Skill Set 4 Modifying Workbooks137
Skill 4.1Insert and Delete Worksheets138
Skill 4.2Modify Worksheet Names and Positions146
Skill 4.3Use 3-D References149
Chapter 5Core Skill Set 5 Creating and Revising Formulas155
Skill 5.1Create and Revise Formulas156
Skill 5.2Use Statistical, Date and Time, Financial, and Logical Functions in Formulas169
Chapter 6Core Skill Set 6 Creating and Modifying Graphics199
Skill 6.1Create, Modify, Position and Print Charts200
Skill 6.2Create, Modify and Position Graphics226
Chapter 7Core Skill Set 7 Workgroup Collaboration253
Skill 7.1Convert Worksheets into Web Pages254
Skill 7.2Create Hyperlinks258
Skill 7.3View and Edit Comments263
Glossary273
Index277

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews