Exploring Microsoft Office 2000, Volume I Revised

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780130620989
• ISBN10: 013062098X
• Edition: Revised
• Format: Spiral Bound
• Copyright: 2001-01-01
• Publisher: Pearson College Div

Table of Contents

Preface	xi
Essentials of Windows® 2000
Chapter 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 Office 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	(1)
Deleting a File	41	(1)
Renaming a File	42	(1)
Backup	42	(1)
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	(9)
On Your Own	63
Exploring Microsoft® Word 2000
Microsoft® Word 2000: What Will Word Processing Do for Me?	1	(50)
Chapter 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)
Insertion 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	(6)
The Spell Check	25	(3)
AutoCorrect and Auto Text	27	(1)
Thesaurus	28	(1)
Grammar Check	29	(2)
Save Command	31	(2)
Backup Options	31	(2)
Hands-On Exercise 3: The Spell Check	33	(7)
Summary	40	(1)
Key Words and Concepts	40	(1)
Multiple Choice	41	(2)
Practice with Microsoft Word	43	(5)
Case Studies	48	(3)
Gaining Proficiency: Editing and Formatting	51	(58)
Chapter Objectives	51	(1)
Overview	51	(1)
Select-Then-Do	52	(1)
Moving and Copying Text	53	(1)
Undo and Redo Commands	53	(1)
Find, Replace, and Go To Commands	54	(1)
Scrolling	55	(3)
View Menu	58	(1)
Hands-On Exercise 1: Editing a Document	59	(8)
Typography	67	(4)
Typeface	67	(2)
Type Size	69	(1)
Format Font Command	69	(2)
Page Setup Command	71	(2)
Page Breaks	73	(1)
An Exercise in Design	73	(1)
Hands-On Exercise 2: Character Formatting	74	(6)
Paragraph Formatting	80	(5)
Alignment	81	(1)
Indents	81	(3)
Tabs	84	(1)
Hyphenation	85	(1)
Line Spacing	85	(1)
Format Paragraph Command	85	(3)
Borders and Shading	87	(1)
Column Formatting	88	(1)
Hands-On Exercise 3: Paragraph Formatting	89	(9)
Summary	98	(1)
Key Words and Concepts	98	(1)
Multiple Choice	99	(2)
Practice with Microsoft Word	101	(5)
Case Studies	106	(3)
Enhancing a Document: The Web and Other Resources	109	(46)
Chapter Objectives	109	(1)
Overview	109	(1)
A Compound Document	110	(4)
Microsoft Clip Gallery	111	(1)
Insert Symbol Command	112	(1)
Microsoft WordArt	113	(1)
The Drawing Toolbar	114	(1)
Hands-On Exercise 1: Creating a Compound Document	115	(8)
Word 2000 and the Internet	123	(3)
Copyright Protection	124	(1)
Footnotes and Endnotes	125	(1)
Hands-On Exercise 2: Word 2000 and the Web	126	(8)
Wizards and Templates	134	(3)
Hands-On Exercise 3: Wizards and Templates	137	(5)
Summary	142	(1)
Key Words and Concepts	143	(1)
Multiple Choice	143	(2)
Practice with Microsoft Word	145	(8)
Case Studies	153	(2)
Advanced Features: Outlines, Tables, Styles, and Sections	155
Chapter Objectives	155	(1)
Overview	155	(1)
Bullets and Lists	156	(1)
Creating an Outline	156	(2)
Hands-On Exercise 1: Bullets, Lists, and Outlines	158	(7)
Tables	165	(2)
Hands-On Exercise 2: Tables	167	(8)
Styles	175	(2)
The Outline View	177	(2)
The AutoFormat Command	178	(1)
Hands-On Exercise 3: Styles	179	(8)
Working in Long Documents	187	(4)
Page Numbers	187	(1)
Headers and Footers	187	(1)
Sections	188	(2)
Table of Contents	190	(1)
Creating an Index	191	(1)
The Go To Command	191	(1)
Hands-On Exercise 4: Working in Long Documents	191	(12)
Summary	203	(1)
Key Words and Concepts	203	(1)
Multiple Choice	204	(2)
Practice with Microsoft Word	206	(2)
Case Studies	208
Exploring Microsoft® Excel 2000
Introduction to Microsoft® Excel: What Is a Spreadsheet?	1	(40)
Chapter 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	(2)
Hands-On Exercise 2: Modifying a Worksheet	23	(10)
Summary	33	(1)
Key Words and Concepts	33	(1)
Multiple Choice	33	(3)
Practice with Excel 2000	36	(3)
Case Studies	39	(2)
Gaining proficiency: Copying, Formatting, and Isolating Assumptions	41	(44)
Chapter Objectives	41	(1)
Overview	41	(1)
A Better Grade Book	42	(1)
Cell Ranges	43	(1)
Copy Command	43	(2)
Move Operation	45	(1)
Learning by Doing	46	(1)
Hands-On Exercise 1: Creating a Workbook	47	(6)
Formatting	53	(1)
Column Widths	54	(1)
Row Heights	54	(1)
Format Cells Command	54	(5)
Numeric Formats	54	(2)
Alignment	56	(1)
Fonts	56	(2)
Borders, Patterns, and Shading	58	(1)
Hands-On Exercise 2: Formatting a Worksheet	59	(9)
Excel 2000 and the Internet	68	(2)
Hands-On Exercise 3: Excel 2000 and The Internet	70	(5)
Summary	75	(1)
Key Words and Concepts	75	(1)
Multiple Choice	76	(2)
Practice with Excel 2000	78	(6)
Case Studies	84	(1)
Spreadsheets in Decision Making: What If?	85	(52)
Chapter Objectives	85	(1)
Overview	85	(1)
Analysis of a Car Loan	86	(3)
PMT Function	88	(1)
The Goal Seek Command	88	(1)
Hands-On Exercise 1: Analysis of a Car Loan	89	(4)
Home Mortgages	93	(3)
Relative versus Absolute Addresses	95	(1)
The Power of Excel	96	(2)
The Fill Handle	96	(1)
Pointing	96	(1)
Functions	96	(2)
Hands-On Exercise 2: Mortgage Analysis	98	(7)
The Grade Book Revisited	105	(6)
Statistical Functions	106	(1)
Arithmetic Expressions versus Functions	107	(1)
AutoFill	107	(1)
IF Function	108	(2)
VLOOKUP Function	110	(1)
Working with Large Spreadsheets	111	(4)
Freezing Panes	111	(2)
Grouping and Outlines	113	(1)
Scenario Manager	114	(1)
Hands-On Exercise 3: The Expanded Grade Book	115	(10)
Summary	125	(1)
Key Words and Concepts	125	(1)
Multiple Choice	126	(2)
Practice with Excel 2000	128	(6)
Case Studies	134	(3)
Graphs and Charts: Delivering a Message	137
Chapter Objectives	137	(1)
Overview	137	(1)
Chart Types	138	(6)
Pie Charts	139	(2)
Column and Bar Charts	141	(3)
Creating a Chart	144	(5)
The Chart Wizard	146	(2)
Enhancing a Chart	148	(1)
Hands-On Exercise 1: The Chart Wizard	149	(9)
Multiple Data Series	158	(4)
Rows versus Columns	160	(2)
Hands-On Exercise 2: Multiple Data Series	162	(6)
Object Linking and Embedding	168	(2)
Hands-On Exercise 3: Object Linking and Embedding	170	(8)
Additional Chart Types	178	(2)
Line Chart	180	(1)
Combination Chart	180	(1)
Use and Abuse of Charts	180	(3)
Improper (Omitted) Labels	180	(1)
Adding Dissimilar Quantities	181	(2)
Summary	183	(1)
Key Words and Concepts	183	(1)
Multiple Choice	184	(2)
Practice with Excel 2000	186	(3)
Case Studies	189
Exploring Microsoft® Access 2000
Introduction to Microsoft® Access: What Is a Database?	1	(48)
Chapter Objectives	1	(1)
Overview	1	(1)
Case Study: The College Bookstore	2	(1)
Introduction to Microsoft Access	3	(3)
The Database Window	3	(1)
Tables	4	(2)
Hands-On Exercise 1: Introduction to Microsoft Access	6	(7)
Maintaining the Database	13	(1)
Find and Replace Commands	13	(1)
Data Validation	14	(1)
Forms, Queries, and Reports	14	(3)
Hands-On Exercise 2: Maintaining the Database	17	(8)
Filters and Sorting	25	(2)
Hands-On Exercise 3: Filters and Sorting	27	(5)
Looking Ahead: A Relational Database	32	(2)
Hands-On Exercise 4: A Look Ahead	34	(7)
Summary	41	(1)
Key Words and Concepts	41	(1)
Multiple Choice	42	(2)
Practice with Access 2000	44	(4)
Case Studies	48	(1)
Tables and Forms: Design, Properties, Views, and Wizards	49	(52)
Chapter Objectives	49	(1)
Overview	49	(1)
Case Study: A Student Database	50	(3)
Include the 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)
Controls	65	(2)
Properties	67	(1)
The Form Wizard	67	(2)
Modifying a Form	69	(1)
Hands-On Exercise 2: Creating a Form	70	(9)
A More Sophisticated Form	79	(1)
Hands-On Exercise 3: A More Sophisticated Form	80	(9)
Summary	89	(1)
Key Words and Concepts	90	(1)
Multiple Choice	90	(2)
Practice with Access 2000	92	(7)
Case Studies	99	(2)
Information from the Database: Reports and Queries	101
Chapter 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 Select Query	120	(7)
Grouping Records	127	(2)
Hands-On Exercise 3: Grouping Records	129	(11)
Crosstab Queries	140	(1)
Action Queries	140	(1)
Hands-On Exercise 4: Crosstab and Action Queries	141	(8)
Summary	149	(1)
Key Words and Concepts	149	(1)
Multiple Choice	150	(2)
Practice with Access 2000	152	(7)
Case Studies	159
Exploring Microsoft® PowerPoint® 2000
Introduction to PowerPoint: Presentations Made Easy	1	(1)
Chapter Objectives	1	(1)
Overview	1	(1)
A PowerPoint Presentation	2	(2)
Introduction to PowerPoint	4	(5)
Six Different 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)
Summary	38	(1)
Key Words and Concepts	38	(1)
Multiple Choice	39	(2)
Practice with PowerPoint 2000	41	(6)
Case Studies	47
Internet Explorer 5.0
Welcome to Cyberspace: The Internet and World Wide Web	1	(36)
Chapter Objectives	1	(1)
Overview	1	(1)
The Internet	2	(1)
The World Wide Web	3	(6)
HyperText Transfer Protocol (http)	3	(5)
Uniform Resource Locator (URL)	8	(1)
Connecting to the Internet	9	(1)
Learning by Doing	9	(1)
Hands-On Exercise 1: Introduction to the World Wide Web	10	(5)
Internet Explorer 5.0	15	(4)
Returning to a Previous Site	19	(1)
Hands-On Exercise 2: Finer Points of Internet Explorer	19	(7)
Summary	26	(1)
Key Words and Concepts	27	(1)
Multiple Choice	28	(2)
Practice with the Internet	30	(5)
Case Studies	35	(2)
Search Engines: Finding Information on the Web	37
Chapter Objectives	37
Overview	37
Search Engines	38
Hands-On Exercise 1: Searching The Web	42
Finer Points of Searching	47
Logical (Boolean) Operators	47
The Find and Save Commands	47
Explore the URL	50
Use Specialized Engines	51
Copyright Protection	52
Learning by Doing	50
Hands-On Exercise 2: Finer Points of Searching	52
Summary	60
Key Words and Concepts	60
Multiple Choice	61
Practice with the World Wide Web	63
Case Studies	69
Appendix A: How the Internet Works	71
Appendix B: Hot Web Sites	77
Getting Started: Essential Computing Concepts
Objectives	1
Overview	1
What Is a Computer?	2
From Micro to Mainframe	4
Bits and Bytes	5
Inside the PC	6
The Microprocessor	8
Memory	9
Auxiliary Storage	10
Input Devices	12
The Monitor	14
The Printer	16
A PC Buying Guide	18
The Rise of the Personal Computer	20
Software	21
The Evolution of the Desktop	21
Antivirus Software	24
Backup	25
Application Software	26
Microsoft Office	27
Local Area Networks	30
The Internet and World Wide Web	32
The Commercialization of Cyberspace	34
Connecting to the Internet	35
File Compression	36
TCP/IP---How the Internet Works	38
Introduction to E-Mail	40
An Internet Address	40
Anatomy of an E-Mail Message	42
The Address Book	42
Summary	43
Key Terms	44
Multiple Choice	45
On Your Own	47
Microsoft Outlook® 2000: A Desktop Information Manager
Objectives and Overview	1
Introduction to Outlook	2
Hands-On Exercise 1: Introduction to Outlook	6
Introduction to E-Mail	16
Mail Folders	17
Anatomy of an E-Mail Message	18
Learning by Doing	19
Hands-On Exercise 2: Welcome to E-Mail	20
Summary and Exercises	32
Extended Problem Set
To the Student	1
Exploring Microsoft Word 2000
Introduction to Microsoft Word	3
Gaining Proficiency	7
Enhancing a Document	11
Advanced Features	15
Exploring Microsoft Excel 2000
Introduction to Microsoft Excel	19
Gaining Proficiency	23
Spreadsheets in Decision Making	29
Graphs and Charts	35
Exploring Microsoft Access 2000
Introduction to Microsoft Access	41
Tables and Forms	45
Information from the Database	49
Proficiency	53
Exploring Microsoft Powerpoint 2000
Introduction to Microsoft PowerPoint	57
Gaining Proficiency	61
Index