Office 2000 Level 1 Core: A Tutorial to Accompany Peter Norton Introduction to Computers Student Edition

by Norton, Peter

• ISBN13: 9780028049298
• ISBN10: 0028049292
• Edition: 3rd
• Format: Paperback
• Copyright: 1999-12-20
• Publisher: MCG

Summary

Peter Norton'sOffice 2000 Tutorialhelps students learn to create, process, and present information using Microsoft Office 2000.

Table of Contents

Preface	xi
Objectives of the Office 2000 Tutorial	xi
MOUS Certification Program	xi
Organization of the Office 2000 Tutorial	xii
Structure and Format of the Office 2000 Tutorial	xiii
About Peter Norton	xv
Reviewers	xv
SECTION 1: COMPUTER BASICS	1	(30)
Objectives	2	(2)
The Multipurpose Tool	4	(1)
An Overview of the Computer System	5	(1)
Looking Inside the Machine	6	(2)
The Computer at a Glance	8	(5)
Software Brings the Machine to Life	13	(2)
The Shapes of Computers Today	15	(5)
What to Expect in the Future	20	(1)
Self Check	21	(1)
On the Web: Computer Pricing Online	22	(2)
Section Summary and Exercises	24	(7)
SECTION 2: WINDOWS 98 BASICS	31	(46)
Objectives	32	(2)
The Windows 98 Operating System	34	(1)
Starting the Computer with Windows 98	34	(2)
Using the Windows 98 Desktop	36	(1)
Using the Mouse	37	(3)
Working with Windows	40	(6)
Running Programs	46	(2)
Choosing Program Options from the Menu Bar	48	(1)
Using Dialog Boxes	49	(2)
Printing Your Work	51	(1)
Getting Help Onscreen	52	(3)
Using Windows Explorer	55	(6)
File Attributes	61	(2)
Shutting Down Your Computer	63	(1)
Self Check	63	(1)
On the Web: Getting Online Help	64	(2)
Section Summary and Exercises	66	(11)
SECTION 3: EXPLORER 5 BASICS	77
Objectives	78	(2)
What is Internet Explorer 5?	80	(1)
Starting the Internet Explorer 5 Browser	81	(1)
Exploring the Internet Explorer Browser Window	82	(4)
Navigating the World Wide Web	86	(4)
Returning to Favorite Places	90	(1)
Searching the Web	91	(2)
Using Channels and the Active Desktop	93	(1)
Using Outlook Express	93	(5)
Exploring Internet News	98	(1)
Exiting the Browser	98	(1)
Self Check	99	(1)
Section Summary and Exercises	100
INTEGRATION LESSON 1: Introducing Office 2000	1	(20)
Objectives	4	(2)
Office Applications	6	(3)
Starting an Office Program	9	(2)
Manipulating the Office Shortcut Bar	11	(2)
Opening a File with the Office Shortcut Bar	13	(3)
Creating a New File with the Office Shortcut Bar	16	(1)
Self Check	17	(1)
Lesson Summary and Exercises	18
Word 2000
Word Basics	4	(60)
Objectives	4	(2)
Introducing Microsoft Word	6	(1)
Using the Mouse	6	(2)
Starting Microsoft Word	8	(1)
Exploring the Word Window	9	(7)
Opening Documents	16	(2)
Getting Help with Word	18	(6)
Scrolling Documents	24	(2)
Viewing Documents	26	(3)
Inserting Text	29	(1)
Finding and Editing Text	30	(6)
Saving Documents	36	(3)
Previewing Documents	39	(3)
Printing Documents	42	(1)
Closing Documents and Exiting Word	43	(2)
Self Check	45	(1)
On the Web: Exploring the Web Toolbar	46	(4)
Lesson Summary and Exercises	50	(14)
Creating, Editing, and Formatting Documents	64	(54)
Objectives	64	(2)
Creating Documents from Templates	66	(3)
Checking Spelling and Grammar	69	(5)
Selecting and Deleting Sentences, Lines, and Paragraphs	74	(1)
Moving and Copying Text	75	(6)
Reformatting Text	81	(11)
Enhancing the Appearance of Documents	92	(9)
Self Check	101	(1)
On the Web: Inserting Hyperlinks	102	(2)
Lesson Summary and Exercises	104	(14)
Inserting Tables, Graphics, and Hyperlinks	118	(50)
Objectives	118	(2)
Creating and Formatting Tables	120	(18)
Inserting and Formatting Graphics	138	(4)
Creating Objects with Drawing Tools	142	(10)
Inserting and Editing Graphic Hyperlinks	152	(1)
Self Check	153	(1)
On the Web: Navigating and Naming Favorites	154	(2)
Lesson Summary and Exercises	156	(12)
Processing Long Documents	168	(48)
Objectives	168	(2)
Navigating Long Documents	170	(5)
Assuring Quality in Long Documents	175	(9)
Adding Reference Features	184	(12)
Formatting in Newspaper Columns	196	(3)
Self Check	199	(1)
On the Web: Searching the Internet	200	(2)
Lesson Summary and Exercises	202	(14)
Creating Web Pages	216
Objectives	216	(2)
Saving a Word Document as a Web Page	218	(1)
Planning and Creating a Web Page	219	(4)
Developing a Personal Web Page	223	(10)
Using the Web Page Wizard	233	(5)
Viewing a Web Site in Explorer	238	(1)
Self Check	239	(1)
On the Web: Publishing a Web Page	240	(2)
Lesson Summary and Exercises	242
Case Study	254
INTEGRATION LESSON 2: Integrating Windows 98 Accessories and Word	21	(16)
Objectives	22	(2)
Using a Notepad File in a Word Document	24	(2)
Using Paint	26	(5)
Copying a Paint Picture into a Word Document	31	(2)
Self Check	33	(1)
Lesson Summary and Exercises	34
Excel 2000
Excel Basics	4	(42)
Objectives	4	(2)
Introducing Microsoft Excel	6	(1)
Using the Mouse	7	(2)
Starting Microsoft Excel	9	(2)
Exploring the Excel Window	11	(5)
Opening Workbook Files	16	(1)
Exploring the Worksheet Area	17	(3)
Getting Help with Excel	20	(8)
Printing a Worksheet	28	(1)
Closing Workbook Files	29	(1)
Exiting Excel	30	(1)
Self Check	31	(1)
On the Web: Exploring the Web Toolbar	32	(4)
Lesson Summary and Exercises	36	(10)
Entering and Editing Data	46	(52)
Objectives	46	(2)
Entering Data	48	(3)
Editing Single Cells	51	(3)
Finding and Replacing Data	54	(1)
Saving Your Work	55	(1)
Selecting Groups of Cells	56	(5)
Erasing Data	61	(1)
Undoing and Redoing Changes	62	(1)
Rearranging Your Worksheet	63	(8)
Filling Ranges with Values	71	(4)
Self Check	75	(1)
On the Web: Adding Hyperlinks to a ∼ Worksheet	76	(6)
Lesson Summary and Exercises	82	(16)
Performing Calculations and Affecting Multiple Worksheets	98	(70)
Objectives	98	(2)
Understanding Formulas	100	(6)
Using the SUM Function	106	(2)
Copying Formulas and Understanding Relative References	108	(5)
Using Absolute and Relative References	113	(5)
Displaying and Printing Formulas	118	(2)
Using Statistical Functions	120	(3)
Using Date and Time Functions	123	(2)
Making Decisions with the IF Function	125	(2)
Using Financial Functions	127	(4)
Using Natural-Language Formulas	131	(3)
Working with Multiple Worksheets	134	(5)
Affecting Several Worksheets at Once	139	(6)
Self Check	145	(1)
On the Web: Visiting Web Sites and Designating Favorite Places	146	(2)
Lesson Summary and Exercises	148	(20)
Formatting and Printing Worksheets	168	(66)
Objectives	168	(2)
Aligning Data	170	(3)
Formatting Numbers and Dates	173	(5)
Modifying Font Characteristics	178	(4)
Adding Borders and Color	182	(3)
Using Auto Formats and Conditional Formatting	185	(3)
Copying and Clearing Cell Formats	188	(2)
Using Templates	190	(8)
Manipulating Columns and Rows	198	(6)
Learning More about Printing	204	(7)
Self Check	211	(1)
On the Web: Searching for Information on the Web	212	(2)
Lesson Summary and Exercises	214	(20)
Charting Your Data	234
Objectives	234	(2)
Using Charts in Excel	236	(1)
Creating Charts with the Chart Wizard	237	(5)
Creating a Default Chart	242	(2)
Modifying Charts	244	(12)
Inserting, Moving, and Deleting Objects	256	(5)
Printing Charts	261	(2)
Self Check	263	(1)
On the Web: Creating a Web Page from an Excel Workbook	264	(4)
Lesson Summary and Exercises	268
Case Study	286
INTEGRATION LESSON 3: Integrating Word and Excel Data	37	(16)
Objectives	38	(2)
Cutting and Pasting Between Word and Excel	40	(2)
Copying an Excel Object into a Word Document	42	(2)
Embedding and Linking Data	44	(2)
Self Check	46	(1)
Lesson Summary and Exercises	47
Access 2000
Access Basics	4	(52)
Objectives	4	(2)
Introducing Microsoft Access	6	(1)
Using the Mouse	7	(1)
Starting Microsoft Access	8	(2)
Exploring Access	10	(8)
Opening Databases	18	(2)
Objects: The Components of Access	20	(9)
Getting Help with Access	29	(7)
Printing Objects	36	(1)
Compacting Databases	37	(1)
Closing Databases and Exiting Access	38	(1)
Self Check	39	(1)
On the Web: Exploring the Web Toolbar	40	(4)
Lesson Summary and Exercises	44	(12)
Designing and Creating Databases	56	(48)
Objectives	56	(2)
Planning Ahead	58	(3)
Creating a Database	61	(1)
Creating Tables	62	(17)
Saving the Table Design	79	(2)
Modifying Tables Using Design View	81	(6)
Self Check	87	(1)
On the Web: Navigating and Returning to Favorite Sites	88	(2)
Lesson Summary and Exercises	90	(14)
Adding and Maintaining Data in Tables	104	(58)
Objectives	104	(2)
Entering Records Using a Datasheet	106	(4)
Retrieving Data from Another Table	110	(4)
Importing Data	114	(2)
Editing and Viewing Records in the Datasheet	116	(9)
Searching for Records Based on their Contents	125	(4)
Changing the Datasheet Display	129	(7)
Establishing and Defining Table Relationships	136	(5)
Self Check	141	(1)
On the Web: Accessing the Search Page	142	(2)
Lesson Summary and Exercises	144	(18)
Retrieving Data	162	(44)
Objectives	162	(2)
Sorting and Selecting Data	164	(1)
Using the Sort Commands	164	(2)
Filtering Your Data	166	(11)
Designing Basic Queries	177	(6)
Querying Multiple Tables	183	(4)
Self Check	187	(1)
On the Web: Creating Hyperlinks	188	(4)
Lesson Summary and Exercises	192	(14)
Using Forms and Reports	206
Objectives	206	(2)
When and Why to Use Forms	208	(2)
Creating an AutoForm	210	(2)
Creating a Form with the Form Wizard	212	(4)
Adding and Editing Data by Using Forms and Subforms	216	(2)
Modifying Controls in Forms	218	(5)
Using Sections in Forms	223	(1)
Previewing and Printing Forms	224	(1)
When and Why to Use Reports	225	(1)
Creating an AutoReport	225	(3)
Using the Report Wizard	228	(7)
Creating Totals in Reports	235	(3)
Modifying Controls in Reports	238	(5)
Using Sections in Reports	243	(1)
Printing Reports	244	(1)
Self Check	245	(1)
On the Web: Creating Your Own Web Page	246	(4)
Lesson Summary and Exercises	250
Case Study	268
INTEGRATION LESSON 4: Integrating Word, Excel, and Access Data	53	(17)
Objectives	54	(2)
Defining an Integrated Mail Merge Document	56	(2)
Adding an Excel Chart	58	(2)
The Final Integration	60	(1)
Merging Selected Records	61	(1)
Integrating Excel and Access Data	62	(2)
Self Check	64	(1)
Lesson Summary and Exercises	65
PowerPoint 2000
PowerPoint Basics	4	(58)
Objectives	4	(2)
Introducing Microsoft PowerPoint	6	(1)
Using the Mouse	7	(2)
Starting Microsoft PowerPoint	9	(2)
Exploring the PowerPoint Window	11	(9)
Opening Presentations	20	(2)
Navigating Among Different PowerPoint Views	22	(3)
Getting Help with PowerPoint	25	(6)
Navigating Slides	31	(2)
Editing Text	33	(5)
Moving and Deleting Slides	38	(1)
Previewing Presentations	39	(1)
Printing Presentations	40	(2)
Saving Presentations	42	(1)
Closing Files and Exiting PowerPoint	43	(2)
Self Check	45	(1)
On the Web: Exploring the Web Toolbar	46	(4)
Lesson Summary and Exercises	50	(12)
Creating a Presentation	62	(46)
Objectives	62	(2)
Beginning with a Template	64	(2)
Adding Slides, Text, and Notes	66	(4)
Importing and Formatting Text	70	(8)
Inserting Clip Art	78	(4)
Drawing and Enhancing Objects	82	(2)
Inserting Graphs	84	(4)
Creating and Enhancing Tables	88	(5)
Self Check	93	(1)
On the Web: Creating Hyperlinks	94	(2)
Lesson Summary and Exercises	96	(12)
Customizing Design Templates with Slide Masters	108	(32)
Objectives	108	(2)
Using the Slide Master to Change Formatting	110	(4)
Repeating An Element on Every Slide	114	(4)
Working with Labeled Objects	118	(3)
Overriding the Slide Master	121	(4)
Self Check	125	(1)
On the Web: Naming Favorites and Searching the Web	126	(2)
Lesson Summary and Exercises	128	(12)
Producing Presentations	140
Objectives	140	(2)
Developing Presentations	142	(10)
Delivering Presentations	152	(2)
Printing Presentations	154	(5)
Self Check	159	(1)
On the Web: Previewing, Creating, and Publishing Web Pages	160	(2)
Lesson Summary and Exercises	162
Case Study	174
INTEGRATION LESSON 5: Integrating Word, Excel, Access, and PowerPoint Data	70	(21)
Objectives	70	(2)
Sharing Information Between Word and PowerPoint	72	(4)
Linking an Excel Chart to a PowerPoint Slide	76	(2)
Copying an Access Table to a PowerPoint Slide	78	(1)
Grouping Documents in a Binder	79	(6)
Self Check	85	(1)
Lesson Summary and Exercises	86	(5)
INTEGRATION LESSON 6: Using Outlook	91	(40)
Objectives	92	(2)
Starting Outlook and Exploring the Outlook Window	94	(2)
Using the Inbox	96	(5)
Scheduling with the Calendar	101	(6)
Creating Contacts	107	(5)
Tracking Tasks	112	(3)
Organizing with Notes	115	(5)
Using Outlook Today	120	(1)
Using the Journal	121	(4)
Self Check	125	(1)
Lesson Summary and Exercises	126	(5)
INTEGRATION LESSON 7: Integrating Office 2000	131	(34)
Objectives	132	(2)
Integrating Calendar Data into a Worksheet	134	(2)
Creating a Word Letter from an Outlook Contact Entry	136	(3)
Integrating Access Data with Outlook	139	(1)
Sharing Text Between Word and Outlook	140	(2)
Using Mail Merge Through Outlook	142	(3)
Self Check	145	(1)
On the Web: Adding a Web Page Shortcut to Your Outlook Bar	146	(2)
Lesson Summary and Exercises	148	(17)
APPENDICES	165	(43)
Appendix A: Portfolio Builder	166	(3)
Appendix B: Command Summary	169	(16)
Appendix C: Toolbar Summary	185	(10)
Appendix D: Answers to Self Check	195	(1)
Appendix E: The History of Microcomputers	196	(12)
Glossary	208	(17)
Index	225