Exploring Microsoft Office 97 Professional

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780130813343
• ISBN10: 0130813346
• Edition: 1st
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: Pearson College Div

Summary

For any course teaching application software using Microsoft Office 97 applications. This book will appeal to students in a variety of disciplines including liberal arts, business, and the sciences. All books in this series offer consistent presentationcommon design, pedagogy, writing style, and level. Concepts as well as key-strokes are emphasized. Hands-on exercises in every lesson provide just the right amount of practice time. This best-selling author team's hands-on approach and conceptual framework helps students master important concepts, as well as the features of the powerful Office 97 applications.

Table of Contents

Preface	xi
Getting Started: Essential Computing Concepts	1	(10)
Overview	2	(1)
What Is a Computer?	3	(5)
From Micro to Mainframe	6	(1)
Bits and Bytes	7	(1)
Inside the PC	8	(12)
The Microprocessor	10	(1)
Memory	11	(1)
Auxiliary Storage	12	(2)
Input Devices	14	(2)
The Monitor	16	(2)
The Printer	18	(2)
A PC Buying Guide	20	(2)
The PC Then and Now	22	(1)
Software	23	(9)
The Evolution of the Desktop	23	(4)
Antivirus Software	27	(1)
Backup	27	(1)
Application Software	28	(1)
Microsoft Office	29	(3)
Local Area Networks	32	(2)
The Internet and World Wide Web	34	(2)
TCP/IP---How the Internet Works	36	(2)
Connecting to the Internet	38	(1)
Downloading Software	39	(1)
Introduction to E-Mail	40	(2)
Summary	42	(1)
Key Words and Concepts	43	(1)
Multiple Choice	44	(1)
Internet Exercises	45
Exploring Microsoft® Word 97
Microsoft® Word 97: 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	(1)
Hands-On Exercise 2: Modifying An Existing Document	18	(8)
The Spell Check	26	(3)
AutoCorrect	28	(1)
Thesaurus	29	(1)
Grammar Check	30	(2)
Save Command	32	(2)
Backup Options	32	(2)
Hands-On Exercise 3: The Spell Check	34	(6)
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	(54)
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	(7)
Typography	66	(4)
Typeface	66	(2)
Type Size	68	(1)
Format Font Command	68	(2)
Page Setup Command	70	(2)
Page Breaks	72	(1)
An Exercise in Design	72	(1)
Hands-On Exercise 2: Character Formatting	73	(6)
Paragraph Formatting	79	(5)
Alignment	80	(1)
Indents	80	(3)
Tabs	83	(1)
Line Spacing	84	(1)
Format Paragraph Command	84	(2)
Borders and Shading	86	(1)
Hands-On Exercise 3: Paragraph Formatting	87	(8)
Summary	95	(1)
Key Words and Concepts	95	(1)
Multiple Choice	96	(2)
Practice with Microsoft Word	98	(5)
Case Studies	103	(2)
Enhancing a Document: The Web and Other Resources	105
Chapter Objectives	105	(1)
Overview	105	(1)
A Compound Document	106	(4)
Microsoft Clip Gallery	107	(1)
Insert Symbol Command	108	(1)
Microsoft WordArt	109	(1)
Hands-On Exercise 1: Object Linking And Embedding	110	(7)
Resources from the Internet and World Wide Web	117	(3)
Copyright Protection	119	(1)
Footnotes and Endnotes	119	(1)
Hands-On Exercise 2: The Internet As A Resource	120	(7)
Wizards and Templates	127
Hands-On Exercise 3: Wizards and Templates	131	(137)
Summary	137	(1)
Key Words and Concepts	138	(1)
Multiple Choice	138	(2)
Practice With Microsoft Word	140	(8)
Case Studies	148	(3)
Appendix A: Object Linking And Embedding	151	(18)
Appendix B: Toolbars	169
Exploring Microsoft® Excel 97
Introduction to Microsoft® Excel: What Is a Spreadsheet?	1	(38)
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	(2)
Toolbars	7	(1)
Entering Data	8	(1)
The File Menu	8	(3)
Learning by Doing	11	(1)
Hands-On Exercise 1: Introduction To Microsoft Excel	11	(8)
Modifying the Worksheet	19	(2)
Insert and Delete Commands	19	(2)
The Page Setup Command	21	(2)
Hands-On Exercise 2: Modifying A Worksheet	23	(9)
Summary	32	(1)
Key Words and Concepts	33	(1)
Multiple Choice	33	(2)
Practice with Excel 97	35	(2)
Case Studies	37	(2)
Gaining Proficiency: Copying, Formatting, and Isolating Assumptions	39	(42)
Chapter Objectives	39	(1)
Overview	39	(1)
A Better Grade Book	40	(1)
Cell Ranges	41	(1)
Copy Command	41	(2)
Move Operation	43	(1)
Learning by Doing	44	(1)
Hands-On Exercise 1: Creating A Worksheet	45	(5)
Formatting	50	(2)
Column Widths	52	(1)
Row Heights	52	(1)
Format Cells Command	52	(5)
Numeric Formats	52	(2)
Alignment	54	(1)
Fonts	54	(2)
Borders, Patterns, and Shading	56	(1)
Hands-On Exercise 2: Formatting A Worksheet	57	(9)
A Financial Forecast	66	(2)
Hands-On Exercise 3: A Financial Forecast	68	(4)
Summary	72	(1)
Key Words and Concepts	73	(1)
Multiple Choice	73	(2)
Practice with Excel 97	75	(4)
Case Studies	79	(2)
Spreadsheets in Decision Making: What If?	81	(52)
Chapter Objectives	81	(1)
Overview	81	(1)
Analysis of a Car Loan	82	(3)
PMT Function	84	(1)
The Goal Seek Command	84	(1)
Hands-On Exercise 1: Analysis Of A Car Loan	85	(4)
Home Mortgages	89	(3)
Relative versus Absolute Addresses	91	(1)
The Power of Excel	92	(2)
The Fill Handle	92	(1)
Pointing	92	(1)
Functions	92	(2)
Hands-On Exercise 2: Mortgage Analysis	94	(7)
The Grade Book Revisited	101	(10)
Statistical Functions	102	(1)
Arithmetic Expressions versus Functions	103	(1)
IF Functions	104	(2)
VLOOKUP Function	106	(1)
Scrolling	107	(1)
Freezing Panes	107	(2)
Scenario Manager	109	(1)
AutoFill	109	(2)
Hands-On Exercise 3: The Expanded Grade Book	111	(11)
Summary	122	(1)
Key Words and Concepts	123	(1)
Multiple Choice	123	(2)
Practice with Excel 97	125	(5)
Case Studies	130	(3)
Graphs and Charts: Delivering a Message	133
Chapter Objectives	133	(1)
Overview	133	(1)
Chart Types	134	(6)
Pie Charts	135	(2)
Column and Bar Charts	137	(3)
Creating a Chart	140	(5)
The Chart Wizard	142	(2)
Enhancing a Chart	144	(1)
Hands-On Exercise 1: The Chart Wizard	145	(8)
Multiple Data Series	153	(4)
Rows versus Columns	155	(2)
Hands-On Exercise 2: Multiple Data Series	157	(6)
Object Linking and Embedding	163	(2)
Hands-On Exercise 3: Object Linking And Embedding	165	(8)
Additional Chart Types	173	(2)
Line Chart	175	(1)
Combination Chart	175	(1)
Use and Abuse of Charts	175	(3)
Improper (Omitted) Labels	175	(1)
Adding Dissimilar Quantities	176	(2)
Summary	178	(1)
Key Words and Concepts	178	(1)
Multiple Choice	179	(2)
Practice with Excel 97	181	(2)
Case Studies	183	(4)
Appendix A: Toolbars	187
Exploring Microsoft® Access 97
Introduction to Microsoft® Access: What Is a Database?	1	(36)
Chapter Objectives	1	(1)
Overview	1	(1)
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	(9)
Looking Ahead: A Relational Database	26	(3)
Summary	29	(1)
Key Words and Concepts	29	(1)
Multiple Choice	30	(2)
Practice with Access 97	32	(3)
Case Studies	35	(2)
Tables and Forms: Design, Properties, Views, and Wizards	37	(50)
Chapter Objectives	37	(1)
Overview	37	(1)
Case Study: A Student Database	38	(3)
Include the Necessary Data	39	(1)
Store Data in Its Smallest Parts	39	(1)
Avoid Calculated Fields	40	(1)
Creating a Table	41	(3)
Primary Key	41	(1)
Views	42	(1)
Properties	43	(1)
Hands-On Exercise 1: Creating A Table	44	(9)
Forms	53	(5)
Controls	53	(2)
Properties	55	(1)
The Form Wizard	55	(2)
Modifying a Form	57	(1)
Hands-On Exercise 2: Creating A From	58	(9)
A More Sophisticated Form	67	(1)
Hands-On Exercise 3: A More Sophisticated Form	68	(9)
Summary	77	(1)
Key Words and Concepts	78	(1)
Multiple Choice	78	(2)
Practice with Access 97	80	(5)
Case Studies	85	(2)
Information from the Database: Reports and Queries	87
Chapter Objectives	87	(1)
Overview	87	(1)
Reports	88	(5)
Anatomy of a Report	90	(1)
The Report Wizard	90	(1)
Apply What You Know	90	(3)
Hands-On Exercise 1: The Report Wizard	93	(8)
Introduction to Queries	101	(5)
Query Window	102	(2)
Selection Criteria	104	(2)
Hands-On Exercise 2: Creating A Select Query	106	(7)
Grouping Records	113	(2)
Hands-On Exercise 3: Grouping Records	115	(11)
Summary	126	(1)
Key Words and Concepts	127	(1)
Multiple Choice	127	(3)
Practice with Access 97	130	(4)
Case Studies	134	(3)
Appendix A: Toolbars	137
Exploring Microsoft® PowerPoint 97
Introduction to PowerPoint: Presentations Made Easy	1	(48)
Chapter Objectives	1	(1)
Overview	1	(1)
A PowerPoint Presentation	2	(2)
Introduction to PowerPoint	4	(4)
Toolbars	5	(1)
The File Menu	5	(3)
Learning by Doing	8	(1)
Hands-On Exercise 1: Introduction To Powerpoint	8	(9)
Five Different Views	17	(2)
Adding and Deleting Slides	19	(1)
Hands-On Exercise 2: Powerpoint Views	20	(9)
Slide Show Tools	29	(2)
Rehearse Timings	29	(1)
Action Items	29	(2)
Hidden Slides	31	(1)
Hands-On Exercise 3: Slide Show Tools	31	(7)
Summary	38	(1)
Key Words and Concepts	38	(1)
Multiple Choice	39	(2)
Practice with PowerPoint 97	41	(5)
Case Studies	46	(3)
Creating a Presentation: Content, Formatting, and Animation	49
Chapter Objectives	49	(1)
Overview	49	(1)
Creating a Presentation	50	(2)
The Outline View	50	(2)
Templates	52	(1)
Hands-On Exercise 1: Creating A Presentation	53	(8)
Creating a Slide Show	61	(1)
AutoLayouts	61	(2)
Hands-On Exercise 2: Animating The Presentation	63	(6)
The AutoContent Wizard	69	(3)
Fine-Tuning a Presentation	72	(3)
The Color Scheme	72	(1)
The Background Shading	72	(1)
PowerPoint Masters	73	(2)
Hands-On Exercise 3: Fine-Tuning A Presentation	75	(7)
Summary	82	(1)
Key Words and Concepts	82	(1)
Multiple Choice	82	(3)
Practice with PowerPoint 97	85	(4)
Case Studies	89	(2)
Appendix A: Toolbars	91
Internet Explorer 4.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 4.0	15	(4)
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	(1)
Overview	37	(1)
Search Engines	38	(4)
Hands-On Exercise 1: Searching The Web	42	(5)
Finer Points of Searching	47	(5)
Logical (Boolean) Operators	47	(1)
The Find and Save Commands	47	(3)
Explore the URL	50	(1)
Using Specialized Engines	51	(1)
Copyright Protection	52	(1)
Hands-On Exercise 2: Finer Points Of Searching	52	(8)
Summary	60	(1)
Key Words and Concepts	60	(1)
Multiple Choice	61	(2)
Practice with the World Wide Web	63	(6)
Case Studies	69	(2)
Appendix A: How The Internet Works	71	(6)
Appendix B: Hot Web Sites	77
Prerequisites: Essentials of Windows 95
Chapter Objectives	1	(1)
Overview	1	(1)
The Desktop	2	(2)
Anatomy of a Window	4	(5)
Moving and Sizing a Window	5	(1)
Pull-Down Menus	6	(1)
Dialog Boxes	7	(2)
The Mouse	9	(1)
The Mouse versus the Keyboard	10	(1)
The Help Menu	10	(2)
Formatting a Floppy Disk	12	(1)
Learning by Doing	12	(1)
Hands-On Exercise 1: Welcome To Windows	13	(7)
Files and Folders	20	(4)
File Type	22	(1)
My Computer	22	(1)
The Exploring Windows Practice Files	22	(2)
Hands-On Exercise 2: The Practice Files (Via The Web)	24	(6)
The Windows Explorer	30	(3)
The Practice Files	32	(1)
Hands-On Exercise 3: The Practice Files (Via A Lan)	33	(6)
The Basics of File Management	39	(2)
Moving and Copying a File	39	(1)
Deleting Files	40	(1)
Backup	40	(1)
Write Protection	40	(1)
Our Last Exercise	41	(1)
Hands-On Exercise 4: The Windows Explorer	41	(11)
Appendix A: What's New In Windows 98?
A Desktop with Style	52	(6)
The Start Button	54	(1)
The Taskbar	55	(1)
The Quick Launch Toolbar	56	(1)
Properties Everywhere	56	(2)
Improved File Management	58	(5)
My Computer	59	(2)
Windows Explorer	61	(2)
Long File Names	63	(1)
A More Powerful Desktop	63	(3)
The Recycle Bin	63	(1)
The Undo Command	64	(1)
The Find Command	64	(2)
Shortcuts	66	(2)
Improved Control Panel	67	(1)
Internet Explorer 4.0	68
Channels and the Active Desktop	71
Index	11