Microsoft Excel 2002 : Microsoft Office Specialist

by Clemens, Barbara

• ISBN13: 9781592000258
• ISBN10: 1592000258
• Edition: CD
• Format: Paperback
• Copyright: 2002-12-04
• Publisher: Cengage Learning Ptr

Summary

Microsoft Excel 2002: Microsoft Office Specialist is designed with one thing in mind: preparing you to pass the Microsoft Office Specialist exam. Follow along as you cover a series of Skill Sets specific to the Excel 2002 exam. Then test your understanding of each Skill Set by completing the hands-on projects at the end of the book. Target the skills you need to be successful. With this book as your guide, you won't need to study anything extra--it's like getting a peek at the exam before you take it!

Table of Contents

Preface	iv
Getting Started with Excel 2002	1	(320)
Start and Exit the Excel Program	2	(2)
Explore the Excel Window	4	(2)
Open and Close an Excel Workbook	6	(2)
Navigate an Excel Workbook	8	(2)
Explore Task Panes	10	(2)
Copy Workbook Files	12	(2)
Save Workbooks	14	(2)
Preview and Print a Worksheet	16	(2)
Get Help	18	(3)
Skill Set 1	21	(30)
Insert, Delete, and Move Cells	22	(6)
Enter and Edit Cell Data Including Text, Numbers, and Formulas	28	(8)
Enter and Edit Formulas	36	(2)
Enter and Edit Cell Data Including Text, Numbers, and Formulas	38	(2)
Check Spelling	40	(2)
Find and Replace Cell Data and Formats	42	(6)
Work with a Subset of Data by Filtering Lists	48	(3)
Skill Set 2	51	(14)
Manage Workbook Files and Folders	52	(4)
Create Workbooks Using Templates	56	(2)
Save Workbooks Using Different Names and File Formats	58	(7)
Skill Set 3	65	(34)
Apply and Modify Cell Formats	66	(4)
Modify Row and Column Settings	70	(8)
Modify Row and Column Formats	78	(6)
Apply Styles	84	(2)
Use Automated Tools to Format Worksheets	86	(2)
Modify Page Setup Options for Worksheets	88	(6)
Preview and Print Worksheets and Workbooks	94	(5)
Skill Set 4	99	(16)
Insert and Delete Worksheets	100	(4)
Modify Worksheet Names and Positions	104	(6)
Use 3-D References	110	(5)
Skill Set 5	115	(22)
Create and Revise Formulas	116	(10)
Use Statistical, Date and Time, Financial, and Logical Functions in Formulas	126	(11)
Skill Set 6	137	(22)
Create, Modify, Position, and Print Charts	138	(16)
Create, Modify, and Position Graphics	154	(5)
Skill Set 7	159	(10)
Convert Worksheets into Web Pages	160	(4)
Create Hyperlinks	164	(4)
View and Edit Comments	168	(1)
Skill Set 8	169	(24)
Import Data to Excel	170	(10)
Export Data from Excel	180	(6)
Publish Worksheets and Workbooks to the Web	186	(7)
Skill Set 9	193	(16)
Create, Edit, and Apply Templates	194	(6)
Create Workspaces	200	(4)
Use Data Consolidation	204	(5)
Skill Set 10	209	(10)
Create and Apply Custom Number Formats	210	(6)
Use Conditional Formats	216	(3)
Skill Set 11	219	(10)
Use Named Ranges in Formulas	220	(6)
Use Lookup and Reference Functions	226	(3)
Skill Set 12	229	(16)
Customize Toolbars and Menus	230	(4)
Create, Edit, and Run Macros	234	(11)
Skill Set 13	245	(12)
Audit Formulas	246	(4)
Locate and Resolve Errors	250	(2)
Identify Dependencies in Formulas	252	(5)
Skill Set 14	257	(24)
Use Subtotals with Lists and Ranges	258	(6)
Define and Apply Filters	264	(4)
Add Group and Outline Criteria to Ranges	268	(2)
Use Data Validation	270	(2)
Retrieve External Data and Create Queries	272	(6)
Create Extensible Markup Language (XML) Web Queries	278	(3)
Skill Set 15	281	(20)
Create PivotTable Reports and PivotChart Reports	282	(10)
Forecast Values with What-If Analysis	292	(6)
Create and Display Scenarios	298	(3)
Skill Set 16	301	(20)
Modify Passwords, Protections, and Properties	302	(10)
Create a Shared Workbook	312	(2)
Track, Accept, and Reject Changes to Workbooks	314	(4)
Merge Workbooks	318	(3)
Core Projects List	321	(16)
Sales Projection for Alaska Adventures	322	(2)
Invoice for Art Rentals to Movies	324	(2)
Budget for Into Thin Air Balloon Tours	326	(2)
Price Lists for Keeping the Beat Drum Shop	328	(2)
Maui Resorts Time Share Vacation Options	330	(2)
Sales Information for Fanfloratastic Flowers	332	(2)
Sales Report for Splashdown Rafting	334	(3)
Expert Projects List	337	(19)
E-Commerce Conference Itinerary	338	(2)
Expense Reports for Quito Imports	340	(2)
Tours Sales for Extreme Adventures	342	(2)
Inventory Sheets for Vintage Records	344	(2)
Payroll Register for Tapestries Bistro	346	(2)
Purchase Orders for Saguaro Art Academy	348	(2)
Guest Information for Clacier Cruises	350	(2)
Analysis of Web Design 101 Class Grades	352	(2)
Sales Projections for Big Sky Campgrounds	354	(2)
Glossary	356	(12)
Index	368