A Guide to Microsoft Office 97 Professional: For Windows 95

by Presley, Bruce; Brown, Beth; Malfas, Elaine; Grassman, Vickie; Presley, Bruce

• ISBN13: 9781879233874
• ISBN10: 1879233878
• Format: Hardcover
• Copyright: 1997-09-01
• Publisher: Lawrenceville Pr

Table of Contents

Chapter One - The History of Computers
1.1 What is a Computer?	1-1	(1)
1.2 Ancient Counting Machines	1-2	(1)
1.3 Arabic Numerals	1-2	(1)
1.4 The Pascaline	1-3	(1)
1.5 The Stepped Reckoner	1-3	(1)
1.6 The Punched Card	1-4	(1)
1.7 Babbage's Difference and Analytical Engines	1-4	(1)
1.8 The Electronic Tabulating Machine	1-5	(1)
1.9 The Mark I	1-6	(1)
1.10 ENIAC: The First Electronic Computer	1-7	(1)
1.11 The Stored Program Computer	1-8	(1)
1.12 The Transistor	1-8	(1)
1.13 Programming Languages	1-9	(1)
1.14 Integrated Circuits	1-10	(1)
1.15 Mainframes	1-10	(1)
1.16 The Microprocessor and the Microcomputer	1-11	(1)
1.17 The Personal Computer	1-11	(1)
1.18 The Components of a Microcomputer	1-12	(1)
1.19 Memory	1-12	(1)
1.20 The Central Processing Unit	1-13	(1)
1.21 Bits and Bytes	1-13	(1)
1.22 Storage Devices	1-14	(1)
1.23 Applications Software	1-15	(1)
1.24 Advantages of a Computer	1-16	(1)
Chapter Summary	1-16	(1)
Vocabulary	1-17	(2)
Review Questions	1-19
Chapter Two - Introducing Windows 95
2.1 Operating Systems	2-1	(1)
2.2 Using the Mouse	2-2	(1)
2.3 The Windows 95 Desktop	2-3	(2)
2.4 Using Windows	2-5	(1)
2.5 Using Dialog Boxes	2-6	(1)
2.6 Using Diskettes	2-7	(1)
2.7 Using My Computer	2-7	(4)
2.8 Using Windows Explorer	2-11	(1)
2.9 File and Folder Management	2-12	(2)
2.10 Recovering Deleted Files	2-14	(1)
2.11 Using Windows 95 Tools	2-15	(2)
Chapter Summary	2-17	(1)
Vocabulary	2-18	(3)
Review Questions	2-21
Chapter Three - Introducing the Word Processor
3.1 What is a Word Processor?	3-1	(1)
3.2 How To Use This Text	3-1	(1)
3.3 Creating a New Word Document	3-2	(1)
3.4 The Word Screen	3-3	(1)
3.5 Using the Keyboard with Word	3-4	(1)
3.6 Word Wrap	3-4	(1)
3.7 The Assistant	3-5	(2)
3.8 Using Menus	3-7	(1)
3.9 Saving a Document	3-8	(2)
3.10 Automatic Spell Checking and Grammer Checking	3-10	(1)
3.11 Moving the Cursor	3-11	(1)
3.12 Closing Files	3-12	(1)
3.13 Existing Word	3-13	(1)
3.14 Opening a File	3-13	(1)
3.15 Using the Tool Bar	3-14	(1)
3.16 Showing Nonprinting Characters	3-15	(1)
3.17 Printing a Document	3-15	(2)
3.18 Changing Views	3-17	(1)
3.19 Screen Scroll	3-18	(2)
Chapter Summary	3-20	(2)
Vocabulary	3-22	(3)
Review Questions	3-25	(2)
Exercises	3-27
Chapter Four - Formatting Documents
4.1 Using Windows	4-1	(1)
4.2 Previewing a Document	4-2	(2)
4.3 The Undo Command and the Repeat Command	4-4	(1)
4.4 Selecting and Deleting Blocks of Text	4-4	(2)
4.5 Formatting Documents	4-6	(1)
4.6 Character Formats - Style	4-6	(3)
4.7 When to Apply Formats	4-9	(1)
4.8 Character Formats - Fonts	4-9	(2)
4.9 Character Formats - Size	4-11	(1)
4.10 Character Formats - Superscripts and Subscripts	4-12	(2)
4.11 Paragraph Formats - Alignment	4-14	(2)
4.12 Paragraph Formats - Line Spacing	4-16	(2)
4.13 Page Formats - Margins	4-18	(2)
4.14 Page Formats - Headers and Footers	4-20	(2)
4.15 Adding Page Numbers	4-22	(1)
4.16 Page Formats - Pagination	4-23	(2)
4.17 Tabs and Tab Stops	4-25	(1)
4.18 Setting Individual Tab Stops	4-26	(3)
Chapter Summary	4-29	(1)
Vocabulary	4-30	(3)
Review Questions	4-33	(2)
Exercises	4-35
Chapter Five - Word Processor Features
5.1 Copying and Pasting Text	5-1	(1)
5.2 Moving Text	5-1	(1)
5.3 Using the Control Key	5-2	(2)
5.4 Finding Text in a Document	5-4	(1)
5.5 Going to a Specific Page	5-5	(1)
5.6 Finding Special Characters	5-6	(1)
5.7 Replacing Text	5-7	(2)
5.8 Using the Thesaurus	5-9	(2)
5.9 Paragraph Formats - Indents	5-11	(2)
5.10 Paragraph Formats - Special Indents	5-13	(1)
5.11 Creating Lists	5-14	(2)
5.12 Creating Footnotes and Endnotes	5-16	(2)
5.13 Inserting Time Stamps	5-18	(1)
5.14 Displaying Document Information	5-19	(1)
5.15 Adding Graphics to a Document	5-20	(1)
5.16 Creating Columns	5-21	(2)
Chapter Summary	5-23	(1)
Vocabulary	5-24	(2)
Review Questions	5-26	(1)
Exercises	5-27
Chapter Six - Advanced Word Processor Features
6.1 Using Tables	6-1	(1)
6.2 Formatting Tables	6-2	(3)
6.3 Inserting Special Characters	6-5	(1)
6.4 Hyphenating Documents	6-5	(1)
6.5 Applying Built-In Styles	6-6	(2)
6.6 Using Outline View	6-8	(3)
6.7 Creating a Table of Contents	6-11	(1)
6.8 Creating Sections in a Document	6-12	(1)
6.9 Using Section Headers and Footers	6-13	(1)
6.10 Using Section Page Numbers	6-14	(2)
6.11 Creating Hyperlinks to the Internet	6-16	(1)
6.12 Newsletter Design	6-17	(2)
6.13 Creating Labels	6-19	(2)
6.14 Recording Macros	6-21	(2)
6.15 Where can you go from here?	6-23	(1)
Chapter Summary	6-23	(1)
Vocabulary	6-24	(3)
Review Questions	6-27	(2)
Exercises	6-29
Chapter Seven - Introducing the Spreadsheet
7.1 What is a Spreadsheet?	7-1	(1)
7.2 The Excel Window	7-2	(1)
7.3 Types of Data	7-3	(1)
7.4 Moving Through the Spreadsheet	7-3	(1)
7.5 Entering Data into the Spreadsheet	7-4	(1)
7.6 Saving, Viewing, and Printing a Spreadsheet	7-5	(1)
7.7 Creating Headers and Footers	7-5	(3)
7.8 Using Formulas to Perform Calculations	7-8	(2)
7.9 Using Cell Names in Formulas	7-10	(1)
7.10 Editing Entries	7-11	(2)
7.11 Using Functions to Perform Calculations	7-13	(2)
7.12 Highlighting	7-15	(1)
7.13 Filling Adjacent Cells	7-15	(1)
7.14 Relative Copying	7-16	(1)
7.15 The ROUND Function	7-17	(1)
7.16 Changing a Column's Width	7-18	(1)
7.17 Formatting a Spreadsheet	7-19	(3)
Chapter Summary	7-22	(2)
Vocabulary	7-24	(3)
Review Questions	7-27	(2)
Exercises	7-29
Chapter Eight - Spreadsheet Techniques
8.1 Planning a Spreadsheet	8-1	(1)
8.2 Entering Formulas - Pointing	8-2	(1)
8.3 Inserting a Function	8-2	(2)
8.4 Displaying Formulas	8-4	(2)
8.5 Editing Commands	8-6	(1)
8.6 The MAX and MIN Functions	8-7	(1)
8.7 Expanding a Spreadsheet	8-8	(1)
8.8 Absolute Copying	8-9	(1)
8.9 Copy, Cut, and Paste	8-10	(2)
8.10 Inserting and Deleting Rows and Columns	8-12	(1)
8.11 Using the IF Function	8-13	(1)
8.12 Printing a Large Spreadsheet	8-14	(2)
8.13 Charts	8-16	(1)
8.14 Creating Pie Charts	8-17	(3)
8.15 Selecting, Moving, Sizing, and Deleting Charts	8-20	(2)
8.16 Bar and Line Charts	8-22	(2)
8.17 Printing a Chart	8-24	(1)
8.18 Modifying Chart Titles	8-25	(1)
8.19 Adding Series and Labels	8-25	(3)
Chapter Summary	8-28	(2)
Vocabulary	8-30	(2)
Review Questions	8-32	(2)
Exercises	8-34
Chapter Nine - Advanced Spreadsheet Techniques
9.1 Asking "What If?"	9-1	(2)
9.2 Using Sort to Organize a Spreadsheet	9-3	(2)
9.3 Using Text in Functions	9-5	(1)
9.4 CHOOSE	9-6	(2)
9.5 VLOOKUP	9-8	(2)
9.6 Freezing Titles	9-10	(2)
9.7 Using Text in CHOOSE and VLOOKUP	9-12	(2)
9.8 Amortization Tables	9-14	(1)
9.9 Printing a Selected Spreadsheet Area	9-15	(2)
9.10 Where can you go from here?	9-17	(1)
Chapter Summary	9-18	(1)
Vocabulary	9-18	(2)
Review Questions	9-20	(1)
Exercises	9-21
Chapter Ten - Integrating the Word Processor and Spreadsheet
10.1 Working with Multiple Files	10-1	(1)
10.2 Removing Files from Memory - Close	10-2	(1)
10.3 Copying Data Between Files	10-3	(1)
10.4 Copying Text Between Word Documents	10-3	(2)
10.5 Copying Data Between Excel Spreadsheets	10-5	(1)
10.6 Copying Data Between Excel Spreadsheets and Word Documents	10-6	(2)
10.7 Copying Data into a New File	10-8	(1)
10.8 Copying a Chart into a Word Document	10-9	(1)
10.9 Creating Hyperlinks to Files	10-9	(2)
Chapter Summary	10-11	(1)
Vocabulary	10-11	(1)
Review Questions	10-12	(1)
Exercises	10-13
Chapter Eleven - Introducing the Relational Database
11.1 What is a Relational Database?	11-1	(1)
11.2 The Relational Database Table	11-1	(1)
11.3 Defining Fields	11-2	(1)
11.4 Designing a Relational Database	11-3	(2)
11.5 Creating a New Relational Database	11-5	(1)
11.6 Creating a Table	11-6	(2)
11.7 Saving a Table	11-8	(2)
11.8 The Relational Database Management System	11-10	(1)
11.9 Using Forms	11-11	(1)
11.10 Entering Records	11-12	(2)
11.11 Formatting Datasheet View	11-14	(1)
11.12 Printing a Table	11-15	(1)
11.13 Querying a Table	11-16	(1)
11.14 Complex Queries	11-17	(2)
Chapter Summary	11-19	(1)
Vocabulary	11-20	(2)
Review Questions	11-22	(2)
Exercises	11-24
Chapter Twelve - Relational Database Techniques
12.1 Modifying a Table	12-1	(1)
12.2 Modifying Records	12-2	(1)
12.3 Sorting a Table	12-3	(1)
12.4 Using Select Queries	12-4	(4)
12.5 Defining Relationships	12-8	(4)
12.6 Modifying and Deleting a Select Query	12-12	(1)
12.7 Sorting Select Query Results	12-13	(2)
12.8 Using Ranges in Criteria	12-15	(2)
12.9 Select Queries Using Or	12-17	(3)
12.10 Select Queries using And	12-20	(2)
12.11 Query Guidelines	12-22	(1)
Chapter Summary	12-22	(1)
Vocabulary	12-23	(2)
Review Questions	12-25	(1)
Exercises	12-26
Chapter Thirteen - Relational Database Reports and Advanced Techniques
13.1 Reports	13-1	(1)
13.2 Creating a Report	13-2	(6)
13.3 Report Summaries	13-8	(3)
13.4 Using Fields in Query Criteria	13-11	(1)
13.5 Calculation Fields	13-12	(3)
13.6 Where Can you go from here?	13-15	(1)
Chapter Summary	13-15	(1)
Vocabulary	13-16	(1)
Review Questions	13-17	(1)
Exercises	13-18
Chapter Fourteen - Integrating the Database with the Word Processor and Spreadsheet
14.1 Copying Database Entries into a Word Document	14-1	(1)
14.2 Techniques for Copying Database Entries	14-1	(2)
14.3 Copying Database Entries into an Excel Spreadsheet	14-3	(2)
14.4 Creating an Access Table from Excel Spreadsheet Data	14-5	(2)
14.5 Mail Merge - Form Letters	14-7	(4)
14.6 Mail Merge - Mailing Labels	14-11	(5)
Chapter Summary	14-16	(1)
Vocabulary	14-16	(2)
Review Questions	14-18	(1)
Exercises	14-19
Chapter Fifteen - Making Presentations
15.1 What is a Presentation?	15-1	(1)
15.2 Creating a PowerPoint Presentation	15-1	(1)
15.3 Viewing Powerpoint Presentations	15-2	(1)
15.4 Displaying Individual Slides - Slides View	15-3	(1)
15.5 Viewing the Slide Show	15-3	(2)
15.6 Editing Text - Outline View	15-5	(1)
15.7 Deleting a Slide	15-5	(2)
15.8 Adding Clip Art Images to a Slide	15-7	(1)
15.9 Displaying All Slides - Slide Sorter View	15-8	(1)
15.10 Printing a Presentation	15-8	(1)
15.11 Adding Footers on Slides	15-9	(1)
15.12 Slide Transitions	15-10	(1)
15.13 Preset Animation	15-10	(2)
15.14 Adding a New Slide	15-12	(1)
15.15 Adding Charts from Spreadsheets	15-12	(2)
15.16 Planning a Presentation	15-14	(1)
15.17 Presentation Design	15-14	(3)
15.18 Displaying Speaker Notes - Notes Pages View	15-17	(1)
15.19 Where can you go from here?	15-18	(1)
Chapter Summary	15-19	(1)
Vocabulary	15-20	(2)
Review Questions	15-22	(1)
Exercises	15-23
Chapter Sixteen - Telecommunications and the Social and Ethical Implications of Computing
16.1 Telecommunications	16-1	(1)
16.2 Bulletin Board Systems and E-Mail	16-2	(1)
16.3 Networks	16-3	(1)
16.4 The Internet	16-4	(1)
16.5 Internet Addresses	16-5	(1)
16.6 Surfing the Internet	16-5	(1)
16.7 Web Pages	16-6	(2)
16.8 Improved Microprocessors and Software	16-8	(1)
16.9 Super Computers and Neural Networks	16-9	(1)
16.10 Database Marketing	16-9	(1)
16.11 Computer Generated Motion Picture Effects	16-10	(1)
16.12 Artificial Intelligence	16-10	(1)
16.13 Expert Systems	16-11	(1)
16.14 Speech Recognition Software	16-12	(1)
16.15 Robotics	16-12	(1)
16.16 Virtual Reality	16-13	(1)
16.17 Multimedia/Hypermedia	16-14	(1)
16.18 Advanced Storage Devices	16-14	(1)
16.19 Computing at Home	16-15	(1)
16.20 Mobile Computing	16-16	(1)
16.21 Careers in Computing	16-17	(2)
16.22 The Social and Ethical Consequences of Computers	16-19	(1)
16.23 The Right to Privacy	16-20	(1)
16.24 Protecting Computer Software and Data	16-21	(1)
16.25 The Ethical Responsibilities of the Programmer	16-22	(1)
16.26 Printers	16-23	(1)
16.27 Desktop Publishing	16-23	(1)
16.28 Graphics and Illustration Software	16-24	(1)
16.29 Graphics and Illustration Equipment	16-25	(1)
16.30 Where can you go from here?	16-25	(1)
Chapter Summary	16-25	(2)
Vocabulary	16-27	(4)
Review Questions	16-31
Appendix A - Microsoft Office Keyboard Shortcuts and Functions
Word Processor Keyboard Shortcuts	A-1	(2)
Spreadsheet Keyboard Shortcuts	A-3	(1)
Database Keyboard Shortcuts	A-4	(2)
Functions	A-6
Appendix B - Creating Customized Forms and Reports
Form Layout	B-1	(1)
Creating Forms in Design View	B-2	(1)
Customizing Forms in Design View	B-3	(1)
Creating Reports in Design View	B-4	(1)
Customizing Reports in Design View	B-5	(2)
Adding Summaries and Subsummaries to a Report	B-7
Appendix C - Keyboarding Skills
Learning to Touch Type	C-1	(1)
Lesson 1 - The Home Row: ASDF JKL;	C-1	(2)
Lesson 2 - RTYU	C-3	(2)
Lesson 3 - EGHI	C-5	(2)
Lesson 4 - CVB MNO	C-7	(2)
Lesson 5 - WQZX P,?	C-9	(2)
Lesson 6 - :"/	C-11	(1)
Lesson 7	C-11	(2)
Lesson 8	C-13	(2)
Lesson 9	C-15