Exploring Microsoft Office XP Professional, Vol. 1

by Grauer, Robert T.; Barber, Maryann T.

• ISBN13: 9780130342652
• ISBN10: 0130342653
• Edition: 1st
• Format: Paperback
• Copyright: 2002-01-01
• Publisher: Prentice Hall

Summary

The most complete coverage of the Office XP curriculum available, so you can go beyond the basics, and get certified! When learning how to use Office XP just isn't enough... Exploring Office XP by Grauer and Barber teaches you "when" and "why" to perform tasks in XP! Grauer and Barber's text is a superior Office XP reference tool for you to use in class, on personal projects, or on the job! Hands-on exercises in each chapter! Step-by-step, in chapter reviews of the topics covered! New integrated exercises! Practice using multiple applications together! In-text boxes! Get tips on pitfalls and shortcuts to make using Office XP easier! www.prenhall.com/grauer Your on-line resource to Explore Microsoft® Office XP Use the interactive study guide Use the student data files Use the on-line exercises

Table of Contents

Preface	xi
Essentials of Microsoft® Windows®
Objectives	1	(1)
Overview	1	(1)
The Desktop	2	(3)
The Common User Interface	5	(5)
Moving and Sizing a Window	7	(1)
Pull-Down Menus	7	(1)
Dialog Boxes	8	(2)
The Mouse	10	(1)
The Mouse versus the Keyboard	10	(1)
The Help Command	11	(1)
Formatting a Floppy Disk	11	(2)
Hands-On Exercise 1: Welcome to Windows 2000	13	(7)
Files and Folders	20	(2)
My Computer	22	(1)
The Exploring Windows Practice Files	22	(2)
Hands-On Exercise 2: The Practice Files Via the Web	24	(9)
Windows Explorer	33	(3)
Expanding and Collapsing a Drive or Folder	35	(1)
Hands-On Exercise 3: The Practice Files Via a Local Area Network	36	(5)
The Basics of File Management	41	(2)
Moving and Copying a File 41 Deleting a File	41	(1)
Renaming a File 42 Backup 42 Write Protection	42	(1)
Our Next Exercise	42	(1)
Hands-On Exercise 4: File Management	43	(8)
Summary	51	(1)
Key Terms	52	(1)
Multiple Choice	52	(2)
Practice with Windows	54	(8)
On Your Own	62
Microsoft® Word 2002
Microsoft Word 2002: What Will Word Processing Do for Me?	1	(48)
Objectives	1	(1)
Overview	1	(1)
The Basics of Word Processing	2	(3)
The Insertion Point	2	(1)
Word Wrap	2	(1)
Toggle Switches	3	(1)
Insert versus Overtype	4	(1)
Deleting Text	5	(1)
Introduction to Microsoft Word	5	(3)
The File Menu	8	(1)
Learning by Doing	9	(1)
Hands-On Exercise 1: My First Document	10	(7)
Troubleshooting	17	(2)
Hands-On Exercise 2: Modifying an Existing Document	19	(5)
The Spell Check	24	(3)
AutoCorrect and AutoText	26	(1)
Thesaurus	27	(1)
Grammar Check	28	(2)
Save Command	30	(2)
Backup Options	30	(2)
Hands-on Exercise 3: The Spell Check, Thesaurus, and Grammar Check	32	(7)
Summary	39	(1)
Key Terms	39	(1)
Multiple Choice	40	(2)
Practice with Word	42	(5)
On Your Own	47	(2)
Gaining Proficiency: Editing and Formatting	49	(54)
Objectives	49	(1)
Overview	49	(1)
Select-Then-Do	50	(1)
Moving and Copying Text	50	(1)
Find, Replace, and Go To Commands	51	(2)
Scrolling	53	(2)
View Menu	55	(1)
Hands-on Exercise 1: Editing a Document	56	(8)
Typography	64	(3)
Type Size	65	(1)
Format Font Command	65	(2)
Page Setup Command	67	(2)
Page Breaks	69	(1)
An Exercise in Design	69	(1)
Hands-on Exercise 2: Character Formatting	70	(7)
Paragraph Formatting	77	(4)
Alignment	77	(1)
Indents	77	(3)
Tabs	80	(1)
Hyphenation	81	(1)
Line Spacing	81	(1)
Formatting Paragraph Command	81	(3)
Borders and Shading	83	(1)
Column Formatting	84	(1)
Hands-on Exercise 3: Paragraph Formatting	85	(7)
Summary	92	(1)
Key Terms	92	(1)
Multiple Choice	93	(2)
Practice with Word	95	(6)
On Your Own	101	(2)
Enhancing a Document: The Web and Other Resources	103	(50)
Objectives	103	(1)
Overview	103	(1)
Enhancing a Document	104	(4)
The Media Gallery	105	(1)
The Insert Symbol Command	106	(1)
Microsoft WordArt	107	(1)
The Drawing Toolbar	108	(1)
Hands-on Exercise 1: Clip Art and Wordart	109	(7)
Microsoft Word and the Internet	116	(2)
Copyright Protection	117	(1)
Hands-on Exercise 2: Microsoft Word and the Web	118	(9)
Wizards and Templates	127	(3)
Mail Merge	130	(3)
Hands-on Exercise 3: Mail Merge	133	(9)
Summary	142	(1)
Key Terms	142	(1)
Multiple Choice	143	(2)
Practice with Word	145	(7)
On Your Own	152	(1)
Advanced Features: Outlines, Tables, Styles, and Selections	153	(1)
Objectives	153	(1)
Overview	153	(1)
Bullets and List	154	(1)
Creating an Outline	154	(2)
Hands-on Exercise 1: Bullets, Lists, and Outlines	156	(6)
Tables	162	(2)
Hands-on Exercise 2: Tables	164	(7)
Styles	171	(2)
The Outline View	173	(2)
The AutoFormat Command	174	(1)
Hands-on Exercise 3: Styles	175	(8)
Working in Long Documents	183	(4)
Page Numbers	183	(1)
Headers and Footers	183	(1)
Sections	184	(1)
Table of Contents	184	(1)
Creating an Index	185	(1)
The Go to Command	185	(2)
Hands-on Exercise 4: Working in Long Documents	187	(11)
Summary	198	(1)
Key Terms	198	(1)
Multiple Choice	199	(2)
Practice with Word	201	(6)
On Your Own	207
Microsoft® Excel 2002
Introduction to Microsoft Excel: What Is a Spreadsheet?	1	(64)
Objectives	1	(1)
Overview	1	(1)
Introduction to Spreadsheets	2	(4)
The Professor's Grade Book	3	(1)
Row and Column Headings	4	(1)
Formulas and Constants	5	(1)
Introduction to Microsoft Excel	6	(3)
Toolbars	7	(2)
The File Menu	9	(2)
Hands-on Exercise 1: Introduction to Microsoft Excel	11	(8)
Modifying the Worksheet	19	(2)
The Page Setup Command	21	(1)
Hands-on Exercise 2: Modifying the Worksheet	22	(9)
A Better Grade Book	31	(1)
Cell Range	32	(1)
Copy Command	32	(2)
Move Operation	34	(1)
Learning by Doing	35	(1)
Hands-on Exercise 3: Creating a Workbook	36	(6)
Formatting	42	(1)
Format Cells Command	43	(4)
Alignment	44	(1)
Fonts	44	(2)
Borders, Patterns, and Shading	46	(1)
Hands-on Exercise 4: Formatting a Worksheet	47	(6)
Summary	53	(1)
Key Terms	53	(1)
Multiple Choice	54	(2)
Practice with Excel	56	(7)
On Your Own	63	(2)
Gaining Proficiency: The Web and Business Applications	65	(44)
Objectives	65	(1)
Overview	65	(1)
Employee Payroll	66	(3)
Pointing	68	(1)
The Fill Handle	68	(1)
Comments	68	(1)
Hands-on Exercise 1: Payroll	69	(7)
Excel and the Internet	76	(2)
Hands-on Exercise 2: Creating a Web Page	78	(9)
Web Queries	87	(2)
Hands-on Exercise 3: Web Queries	89	(6)
Summary	95	(1)
Key Terms	95	(1)
Multiple Choice	96	(2)
Practice with Excel	98	(10)
On Your Own	108	(1)
Spreadsheets in Decision Making: What If?	109	(58)
Objectives	109	(1)
Overview	109	(1)
Analysis of a Car Loan	110	(5)
PMT Function	112	(1)
FV Function	112	(1)
Inserting a Function	113	(1)
The Goal Seek Command	114	(1)
Hands-on Exercise 1: Basic Financial Functions	115	(6)
Home Mortgages	121	(3)
Relative versus Absolute Address	122	(1)
Mixed References	123	(1)
Hands-on Exercise 2: Advanced Financial Functions	124	(10)
The Grade Book Revisited	134	(5)
Statistical Functions	135	(1)
Arithmetic Expressions versus Functions	136	(1)
IF Function	137	(1)
VLOOKUP Function	138	(1)
Working with Large Spreadsheets	139	(4)
Freezing Panes	139	(1)
Hiding Rows and Columns	139	(1)
Printing a Large Worksheet	139	(3)
AutoFilter Command	142	(1)
Hands-on Exercise 3: The Expanded Grade Book	143	(10)
Summary	153	(1)
Key Terms	153	(1)
Multiple Choice	154	(2)
Practice with Excel	156	(9)
On Your Own	165	(2)
Graphs and Charts: Delivering a Message	167	(1)
Objectives	167	(1)
Overview	167	(1)
Chart Types	168	(6)
Pie Charts	169	(2)
Column and Bar Charts	171	(3)
Creating a Chart	174	(5)
The Chart Wizard	176	(2)
Modifying a Chart	178	(1)
Hands-on Exercise 1: The Chart Wizard	179	(9)
Multiple Data Series	188	(3)
Hands-on Exercise 2: Multiple Data Series	191	(6)
Object Linking and Embedding	197	(1)
Hands-on Exercise 3: Object Linking and Embedding	198	(7)
Summary	205	(1)
Key Terms	205	(1)
Multiple Choice	206	(2)
Practice with Excel	208	(8)
On Your Own	216
Microsoft® Access 2002
Introduction to Microsoft Access: What is a Database?	1	(48)
Objectives	1	(1)
Overview	1	(1)
Case Study: The College Bookstore	2	(1)
Introduction to Microsoft Access	3	(4)
The Database Window	3	(1)
Tables	4	(1)
Forms, Queries, and Reports	5	(2)
Hands-on Exercise 1: Introduction to Access	7	(12)
Filters and Sorting	19	(2)
Pivot Tables and Pivot Charts	21	(2)
Hands-on Exercise 2: Filters, Sorting, Pivot Tables, and Pivot Charts	23	(7)
Looking Ahead: a Relational Database	30	(2)
Hands-on Exercise 3: A Look Ahead	32	(7)
Summary	39	(1)
Key Terms	39	(1)
Multiple Choice	40	(2)
Practice with Access	42	(6)
On Your Own	48	(1)
Tables and Forms: Designs, Properties, Views, and Wizards	49	(52)
Objectives	49	(1)
Overview	49	(1)
Case Study: A Student Database	50	(3)
Include Necessary Data	51	(1)
Store Data in Its Smallest Parts	51	(1)
Avoid Calculated Fields	52	(1)
Creating a Table	53	(3)
Primary Key	53	(1)
Views	54	(1)
Properties	55	(1)
Hands-on Exercise 1: Creating a Table	56	(9)
Forms	65	(5)
Properties	66	(2)
AutoForms and the Form Wizard	68	(1)
Modifying a Form	68	(2)
Hands-on Exercise 2: Creating a Form	70	(8)
A More Sophisticated Form	78	(1)
Hands-on Exercise 3: A More Sophisticated From	79	(9)
Summary	88	(1)
Key Terms	88	(1)
Multiple Choice	89	(2)
Practice with Access	91	(8)
On Your Own	99	(2)
Information from the Database: Reports and Queries	101	(56)
Objectives	101	(1)
Overview	101	(1)
Reports	102	(5)
Anatomy of a Report	104	(1)
The Report Wizard	104	(1)
Apply What You Know	104	(3)
Hands-on Exercise 1: The Report Wizard	107	(8)
Introduction to Queries	115	(5)
Query Window	116	(2)
Selection Criteria	118	(2)
Hands-on Exercise 2: Creating a Selection Query	120	(6)
Grouping Records	126	(2)
Hands-on Exercise 3: Grouping Records	128	(10)
Crosstab Queries	138	(1)
Actions Queries	138	(1)
Hands-on Exercise 4: Crosstab and Action Queries	139	(8)
Summary	147	(1)
Key Terms	147	(1)
Multiple Choice	148	(2)
Practice with Access	150	(6)
On Your Own	156	(1)
Proficiency: Relational Databases, External Data, Charts, and the Switchboard	157	(1)
Objectives	157	(1)
Overview	157	(1)
The Investment Database	158	(3)
Multiple-Table Queries	159	(1)
Maintaining the Database	160	(1)
The Import Spreadsheet Wizard	161	(1)
Hands-on Exercise 1: Importing and Exporting Access Objects	162	(9)
Total Queries	171	(3)
Microsoft Graph	171	(3)
Hands-on Exercise 2: Total Queries and Charts	174	(7)
The User Interface	181	(3)
The Switchboard Manager	183	(1)
Other Access Utilities	183	(1)
Hands-on Exercise 3: The Switchboard Manager	184	(7)
Summary	191	(1)
Key Terms	191	(1)
Multiple Choice	192	(2)
Practice with Access	194	(6)
On Your Own	200
Microsoft® PowerPoint® 2002
Introduction to PowerPoint: Presentations Made Easy	1	(64)
Objectives	1	(1)
Overview	1	(1)
A PowerPoint Presentation	2	(2)
Introduction to PowerPoint	4	(5)
PowerPoint Views	5	(2)
The File Menu	7	(2)
Hands-on Exercise 1: Introduction to PowerPoint	9	(9)
Creating a Presentation	18	(3)
Slide Layouts	20	(1)
Templates	21	(1)
Hands-on Exercise 2: Creating a Presentation	22	(8)
Creating a Slide Show	30	(2)
Delivering the Presentation	30	(2)
Hands-on Exercise 3: Animating the Presentation	32	(6)
Enhancing a Presentation	38	(3)
Office Art	39	(1)
Microsoft WordArt	40	(1)
Hands-on Exercise 4: Enhancing a Presentation	41	(11)
Summary	52	(1)
Key Terms	52	(1)
Multiple Choice	53	(2)
Practice with PowerPoint	55	(9)
On Your Own	64	(1)
Gaining Proficiency: Slide Show Tools, the Web, and Slide Masters	65	(1)
Objectives	65	(1)
Overview	65	(1)
Slide Show Tools	66	(2)
Reviewing a Presentation	68	(1)
Hands-on Exercise 1: Slide Show Tools	69	(10)
PowerPoint and the Internet	79	(1)
Copyright Protection	79	(2)
Hands-on Exercise 2: The Internet as a Resource	81	(8)
Presentations on the Web	89	(1)
Uploading a Presentation	90	(1)
The AutoContent Wizard	91	(3)
Hands-on Exercise 3: Presentations on the Web	94	(7)
Fine-Tuning a Presentation	101	(1)
The Color Scheme	101	(1)
Background Shading	102	(1)
PowerPoint Masters	103	(1)
Hands-on Exercise 4: Fine-Tuning a Presentation	104	(6)
Summary	110	(1)
Key Terms	110	(1)
Multiple Choice	111	(2)
Exploring PowerPoint	113	(7)
On Your Own	120
The Internet and World Wide Web: Welcome to Cyberspace
Objectives	1
Overview	1	(1)
The Internet	2	(1)
The World Wide Web	3	(4)
The Uniform Resource Locator (URL)	7	(1)
Connecting to the Internet	8	(1)
Learning by Doing	8	(1)
Hands-on Exercise 1: Introduction to the World Wide Web	9	(7)
Search Engines	16	(3)
Logical (Boolean) Operators	19	(1)
Explore the URL	19	(1)
Copyright Protection	20	(1)
Hands-on Exercise 2: Searching the Web	21	(7)
The Commercialization of Cyberspace	28	(1)
Security	29	(1)
Privacy	29	(2)
Returning to a Previous Site	31	(1)
Our Next Exercise	32	(1)
Hands-on Exercise 3: Shopping in Cyberspace	33	(8)
Introduction to HTML	41	(2)
Microsoft Word	43	(1)
Hands-on Exercise 4: Introduction to HTML	44	(8)
Summary	52	(1)
Key Terms	53	(1)
Multiple Choice	54	(2)
Practice with the Internet	56	(8)
On Your Own	64
Getting Started: Essential Computing Concepts
Objectives	1	(1)
Overview	1	(1)
What Is a Computer?	2	(2)
From Micro to Mainframe	4	(1)
Bits and Bytes	5	(1)
Inside the PC	6	(2)
The Microprocessor	8	(1)
Memory	9	(1)
Auxiliary Storage	10	(2)
Input Devices	12	(2)
The Monitor	14	(2)
The Printer	16	(2)
A PC Buying Guide	18	(2)
The Rise of the Personal Computer	20	(1)
Software	21	(3)
Antivirus Software	24	(1)
Backup	25	(1)
Application Software	26	(1)
Microsoft Office	27	(3)
Local Area Networks	30	(2)
The Internet and World Wide Web	32	(2)
The Commercialization of Cyberspace	34	(1)
Connecting to the Internet	35	(1)
File Compression	36	(2)
TCP/IP---How the Internet Works	38	(2)
Introduction to E-mail	40	(1)
An Internet Address	40	(2)
Anatomy of an E-mail Message	42	(1)
The Address Book	42	(1)
Summary	43	(1)
Key Terms	44	(1)
Multiple Choice	45	(2)
On Your Own	47
Glossary
Index