Quick, Simple Microsoft Office 2000 / Edition 1

Quick, Simple Microsoft Office 2000 / Edition 1

by Linda Ericksen
     
 

ISBN-10: 013011054X

ISBN-13: 9780130110541

Pub. Date: 06/22/1999

Publisher: Pearson Education

Product Details

ISBN-13:
9780130110541
Publisher:
Pearson Education
Publication date:
06/22/1999
Edition description:
New Edition
Pages:
880
Product dimensions:
9.40(w) x 10.90(h) x 1.40(d)

Table of Contents

Preface xii
OFFICE 2000 Introduction to Microsoft® Office 2000 1(1)
Microsoft® Word 2000
2(2)
Microsoft® Excel 2000
4(1)
Microsoft® PowerPoint 2000
5(2)
Microsoft® Access 2000
7(2)
Microsoft® Outlook 2000
9(2)
Microsoft® Publisher 2000
11
USING COMPUTERS 1(1)
A Personal Computer Guide
1(9)
Defining the Parts of a Personal Computer
2(1)
The System Unit
2(2)
Input Devices
4(1)
Output Devices
5(2)
Input/Output Devices
7(1)
Storage Devices
8(2)
Learning How Computers Work
10(5)
Motherboard
11(1)
Central Processing Unit
11(1)
Random Access Memory
12(1)
Cache
12(1)
Ports
13(1)
Power Supply
13(1)
BIOS and ROM
13(1)
Expansion Cards and Slots
13(2)
Defining Your Needs
15(2)
Purchasing and Setting Up a Computer
17(3)
Warranty
18(1)
Tips
19(1)
Setting Up the System
19(1)
Review
20(5)
Summary
20(1)
Key Terms
20(1)
Test Your Skills
21(2)
Projects
23(2)
Using Internet Explorer to Explore the World Wide Web
25(1)
Connecting to the Internet and Using the World Wide Web
26(3)
Choosing an Internet Service Provider
27(2)
Using Microsoft Internet Explorer
29(7)
Entering a Web Address
31(2)
Favorites
33(3)
Searching the World Wide Web
36(9)
Searching Strategy
39(2)
Using Internet Explorer to Search
41(4)
Review
45(1)
Summary
45(1)
Key Terms
45(1)
Test Your Skills
46(2)
Projects
48
WINDOWS 98
Getting Started
1(30)
Using the Mouse
2(1)
Becoming Familiar with the Windows 98 Interface
3(13)
The Desktop
3(3)
Icons
6(1)
Taskbar
6(1)
Shortcut Menus
7(1)
Windows
8(1)
Title Bar
9(1)
Menu Bar
10(2)
Dialog Boxes
12(1)
Toolbars
13(2)
Scroll Bars
15(1)
Status Bar
15(1)
Moving and Sizing a Window
16(2)
Switching Between Open Windows
18(1)
Arranging Windows
19(3)
Getting Help
22(3)
Shutting Down Windows 98
25(2)
Review
27(4)
Summary
27(1)
Key Terms
27(1)
Test Your Skills
28(1)
Projects
29(2)
Using Programs
31(26)
Starting a Program
32(2)
Using the Calculator
34(2)
Using WordPad
36(3)
Using Cut, Copy, and Paste
39(3)
Saving and Printing a Document
42(5)
Organizing Files
43(1)
Naming Files
44(1)
Printing Files
45(2)
Using the Print Screen Key
47(2)
Exiting from Programs
49(1)
Opening a File
49(3)
Closing Programs That Aren't Working Properly
52(2)
Review
54(3)
Summary
54(1)
Key Terms
54(1)
Test Your Skills
54(2)
Projects
56(1)
Working with Disks
57(24)
Viewing the Contents of Disks
58(4)
Changing the Display of Disk Contents
62(3)
Sorting the Disk Contents
65(3)
Formatting a Disk
68(3)
What Formatting Does
68(1)
Formatting a Disk
69(2)
Copying a Floppy Disk
71(2)
Creating a Folder on a Disk
73(3)
Review
76(5)
Summary
76(1)
Key Terms
76(1)
Test Your Skills
76(1)
Projects
77(2)
Check Point for Units 1-3
79(2)
Working with Files
81(1)
Selecting Files
82(2)
Copying and Moving Files
84(8)
Drag with the Right Button
84(1)
Drag with the Left Button
85(1)
Copy (or Cut) and Paste
86(4)
Move or Copy Using My Computer
90(2)
Renaming Files
92(1)
Deleting and Restoring Files
93(3)
Using the Recycle Bin
96(3)
Finding Files
99(2)
Previewing Files
101(1)
Using the Classic Desktop
102(3)
Changing the Desktop Background
105(4)
Review
109(1)
Summary
109(1)
Key Terms
109(1)
Test Your Skills
109(1)
Projects
110
WORD 2000
Getting Started
1(26)
Starting Microsoft Word 2000
2(1)
Becoming Familiar with the Word Interface
3(8)
Title Bar
4(1)
Menu Bar
4(2)
Dialog Boxes
6(2)
Toolbars and Ruler
8(1)
Text-Editing Window
9(1)
Status Bar
9(1)
Taskbar
10(1)
Shortcut Menu
10(1)
Getting Help
11(4)
Using a Wizard
15(3)
Saving a Document
18(3)
Choosing a File Name
19(1)
Choosing a Drive and Folder
19(2)
Printing a Document
21(2)
Exiting from Word
23(1)
Review
23(4)
Summary
23(1)
Key Terms
24(1)
Test Your Skills
24(2)
Projects
26(1)
Creating and Editing Documents
27(26)
Creating a Document from a Blank Document
28(3)
Moving Around a Document
31(1)
Deleting Characters
32(2)
Inserting and Typing Over Text
34(2)
Undoing an Action
36(1)
Checking Spelling and Grammar
37(4)
Opening and Closing Documents
41(2)
Switching Between Documents
43(1)
Previewing a Document
44(2)
Review
46(7)
Summary
46(1)
Key Terms
46(1)
Test Your Skills
47(2)
Projects
49(2)
Check Point for Units 1-2
51(2)
More Creating and Editing Documents
53(28)
Creating an Envelope
54(3)
Creating Mailing Labels
57(3)
Printing a Single Label from a Sheet
58(1)
Selecting a Label Type
58(2)
Creating a Document Using a Word Template
60(2)
Selecting Text and Deleting Selected Text
62(3)
Cutting, Copying, and Pasting Text
65(5)
The Office Clipboard
66(4)
Using Find and Replace
70(3)
Changing the View and the Zoom
73(3)
Review
76(5)
Summary
76(1)
Key Terms
76(1)
Test Your Skills
76(2)
Projects
78(3)
Formatting Documents
81(26)
Formatting Characters Using the Toolbar
82(2)
Formatting Characters Using the Font Dialog Box
84(4)
Aligning Paragraphs of Text
88(2)
Changing the Line Spacing of Paragraphs
90(3)
Indenting Paragraphs
93(3)
Setting Tabs
96(4)
Review
100(7)
Summary
100(1)
Key Terms
100(1)
Test Your Skills
100(2)
Projects
102(2)
Check Point for Units 3-4
104(3)
Automating Tasks
107(26)
Formatting Text Using Built-in Styles
108(2)
Using AutoCorrect
110(1)
Editing AutoCorrect Entries
111(2)
Using AutoText
113(4)
Using AutoFormat
117(3)
Creating Bulleted and Numbered Lists
120(3)
Using Borders and Shading
123(4)
Including Special Symbols
127(2)
Review
129(4)
Summary
129(1)
Key Terms
129(1)
Test Your Skills
129(2)
Projects
131(2)
Formatting Pages and Enhancing Documents
133(34)
Inserting Breaks
134(2)
Changing the Page Margins
136(3)
Inserting Page Numbers
139(1)
Including Headers and Footers
140(4)
Including Footnotes
144(3)
Inserting a Table
147(3)
Creating a Chart from Table Data
150(3)
Inserting WordArt Objects
153(4)
Inserting a Graphic
157(2)
Review
159(8)
Summary
159(1)
Key Terms
160(1)
Test Your Skills
160(1)
Projects
161(2)
Check Point for Units 5-6
163(4)
Merging Documents
167(22)
Starting the Mail Merge Helper
168(2)
Creating and Editing the Data Source
170(6)
Creating the Data Source
171(1)
Editing the Data Source
171(5)
Editing the Main Document
176(3)
Merging the Documents
179(2)
Creating Merged Labels
181(3)
Review
184(5)
Summary
184(1)
Key Terms
185(1)
Test Your Skills
185(1)
Projects
186(3)
Using Word with the World Wide Web
189(1)
Creating Hyperlinks
190(6)
Linking to an Existing Document
191(1)
Linking Within the Same Document
192(1)
Linking to a New Document
192(1)
Link to an E-Mail Address Document
192(1)
Editing and Removing Links
193(3)
Creating Web Documents Using the Web Page Wizard
196(3)
Creating a Web Page Using a Template
199(2)
Creating a Web Page from an Existing Word Document
201(1)
Review
202(1)
Summary
202(1)
Key Terms
202(1)
Test Your Skills
202(2)
Projects
204(1)
Check Point for Units 7-8
205(2)
Wrap-Up
207
EXCEL 2000
Getting Started
1(32)
Starting Microsoft Excel 2000
2(1)
Becoming Familiar with the Excel Interface
3(7)
Worksheets and Workbooks
4(1)
Title Bar
4(1)
Menu Bar
4(3)
Toolbars
7(1)
Worksheet
8(1)
Formula Bar
9(1)
Status Bar
9(1)
Windows Taskbar
9(1)
Getting Help
10(4)
Moving Around a Worksheet
14(2)
Creating a Worksheet Using Text, Numbers, and the AutoSum Function
16(4)
Saving a Workbook
20(3)
Choosing a File Name
21(1)
Choosing a Drive and Folder
22(1)
Printing a Worksheet
23(2)
Exiting from Excel
25(1)
Opening and Closing Workbooks
26(2)
Review
28(5)
Summary
28(1)
Key Terms
28(1)
Test Your Skills
29(2)
Projects
31(2)
Working with Workbooks
33(40)
Creating a New Workbook and Entering Data in a Series
34(2)
Creating Formulas
36(6)
Creating a Formula by Typing It
37(1)
Creating a Formula by Selecting Cells
38(1)
The Order of Operations
38(4)
Specifying Ranges with AutoSum
42(3)
Ranges
42(1)
The Syntax of a Function
43(1)
Using AutoSum
43(2)
Editing Worksheets
45(6)
Editing Cell Contents
46(1)
Deleting Cell Contents
46(1)
Undoing an Action
47(1)
Inserting and Deleting Rows and Columns
48(3)
Checking Spelling in the Worksheet
51(2)
Using the Page Setup Dialog Box
53(5)
Page Tab
53(1)
Margins Tab
54(1)
Header/Footer Tab
55(1)
Sheet Tab
56(2)
Viewing and Printing Formulas
58(1)
Copying and Moving Data
59(5)
Copying by Filling
59(2)
Moving by Dragging
61(1)
Copying or Moving Using the Clipboard
61(3)
Review
64(9)
Summary
64(1)
Key Terms
65(1)
Test Your Skills
65(2)
Projects
67(3)
Check Point for Units 1-2
70(3)
Formatting the Worksheet
73(28)
Using AutoFormat
74(2)
Using Bold, Italic, and Underline
76(2)
Formatting Text Using the Font Dialog Box
78(2)
Formatting Numbers
80(3)
Changing Column Widths
83(3)
Using the Menus
84(1)
Using the Mouse
84(2)
Aligning Data in Cells
86(3)
Using the Menus
86(2)
Using the Toolbar
88(1)
Adding a Border and Shading
89(3)
Adding a Border Using the Menu
90(1)
Adding a Border Using the Toolbar
90(1)
Adding Shading and Patterns
91(1)
Adding a Graphic
92(3)
Review
95(6)
Summary
95(1)
Key Terms
95(1)
Test Your Skills
95(2)
Projects
97(4)
Using Functions and Other Calculations
101(26)
Using the MIN Function
102(3)
The Paste Function Dialog Box
102(1)
The Formula Palette
103(1)
Constructing the MIN Function
103(2)
Using the MAX Function
105(1)
Using the AVERAGE Function
106(2)
Using AutoCalculate
108(1)
Using the PRODUCT Function
109(2)
Copying Functions and Formulas
111(3)
Using Edit Fill
111(1)
Using the Fill Handle
111(1)
Relative Cell References
112(2)
Using Absolute Cell References
114(3)
Performing What-If Analysis
117(1)
Review
118(9)
Summary
118(1)
Key Terms
118(1)
Test Your Skills
119(2)
Projects
121(3)
Check Point for Units 3-4
124(3)
Using Financial Functions
127(16)
Using the PMT Function
128(4)
Constructing the Function
129(3)
Using the PPMT Function
132(2)
Using the IPMT Function
134(1)
Using the FV Function
135(2)
Using the SLN Function
137(1)
Review
138(5)
Summary
138(1)
Key Terms
138(1)
Test Your Skills
139(1)
Projects
140(3)
Using Date, Count, and IF Functions
143(18)
Using the Today Function
144(2)
Using the IF Function
146(4)
Using the SUMIF Function
150(1)
Using the Count, Counta, and Countblank Functions
151(2)
Using the Countif Function
153(1)
Review
154(7)
Summary
154(1)
Key Terms
154(1)
Test Your Skills
154(2)
Projects
156(3)
Check Point for Units 5-6
159(2)
Working with Multiple Worksheets
161(20)
Inserting, Deleting, and Selecting Worksheets
162(2)
Renaming Worksheets
164(1)
Moving and Copying Worksheets
165(4)
Using the Menus
165(1)
Using the Mouse
166(1)
Why Copy?
167(2)
Calculating Between Sheets
169(3)
Creating a Consolidation Worksheet
172(1)
Review
173(8)
Summary
173(1)
Key Terms
174(1)
Test Your Skills
174(1)
Projects
175(6)
Using Excel with Charts, Word, and the Web
181(1)
Creating Charts
182(7)
Chart Elements and Types
183(1)
Creating a Chart
184(5)
Enhancing a Chart
189(2)
Copying Worksheet Data to a Microsoft Word Document
191(2)
Linking Worksheet Data to a Microsoft Word Document
193(3)
Linking to the World Wide Web
196(3)
Saving a Workbook as a Web Document
199(2)
Review
201(1)
Summary
201(1)
Key Terms
201(1)
Test Your Skills
201(2)
Projects
203(2)
Check Point for Units 7-8
205(2)
Wrap-Up
207
ACCESS 2000
Getting Started
1(24)
Starting Microsoft Access 2000
2(4)
Relational Databases
3(1)
Starting Access 2000
4(2)
Becoming Familiar with Access Interface
6(2)
Tables
7(1)
Becoming Familiar with Access Tables
8(5)
Becoming Familiar with Forms and Reports
13(2)
Forms
13(1)
Reports
14(1)
Saving Database Objects and Closing a Database
15(1)
Designing Databases
16(3)
Determine All Fields
17(1)
Group Related Fields
17(1)
Create Tables
17(1)
Normalize the Data
17(1)
Define the Primary Key
18(1)
Review
19(6)
Summary
19(1)
Key Terms
19(1)
Test Your Skills
20(2)
Projects
22(3)
Creating a Database
25(40)
Creating a Database
26(2)
Creating a Table Using Datasheet View
28(4)
Creating a Table in Design View
32(5)
Field Names
33(1)
Data Types
34(3)
Defining a Primary Key
37(2)
Switching Between Design and Datasheet View
39(1)
Set Field Properties
40(6)
Using the Input Mask Field Property
42(1)
Using the Validation Rule Field Property and the Validation Text Field Property
43(3)
Changing the Table Design
46(3)
Inserting a Field
46(1)
Deleting a Field
47(2)
Using the Table Wizard
49(5)
Adding Fields to Your Design
50(1)
Removing a Field
50(1)
Renaming a Field
50(1)
Naming the Table
51(1)
Relating the Table
52(2)
Documenting the Table
54(3)
Review
57(8)
Summary
57(1)
Key Terms
57(1)
Test Your Skills
57(2)
Projects
59(2)
Check Point for Units 1-2
61(4)
Relating Tables and Working with Data
65(26)
Creating Relationships Between Tables in the Database
66(7)
Relational Design
66(1)
Creating a Relationship
67(6)
Adding Records to Tables
73(2)
Using the Lookup Wizard
75(2)
Editing Record Contents
77(2)
Deleting a Record
79(1)
Finding a Record
80(2)
Find Options
81(1)
Replacing Field Contents
82(1)
Sorting the Table
83(2)
Moving and Copying Records to Another Table
85(1)
Review
86(5)
Summary
86(1)
Key Terms
87(1)
Test Your Skills
87(2)
Projects
89(2)
Querying the Database
91(1)
Using Filter by Selection
92(2)
Using Filter by Form
94(3)
Using the Simple Query Wizard
97(3)
Editing a Query
100(5)
Adding a Field to the Query
100(1)
Deleting a Field from the Query
101(1)
Sorting Query Results
102(1)
Adding a Criteria
102(2)
Saving the Changes to a Query
104(1)
Creating a Query in Design View
105(7)
More Complex Criteria
107(5)
Using Linked Tables in a Query
112(3)
Review
115(1)
Summary
115(1)
Key Terms
115(1)
Test Your Skills
115(2)
Projects
117(1)
Check Point for Units 3-4
118
POWERPOINT 2000
Getting Started
1(28)
Starting PowerPoint 2000
2(2)
Creating a Presentation Using the AutoContent Wizard
4(5)
Understanding the PowerPoint Interface
9(7)
Title Bar
10(1)
Menu Bar
10(2)
Dialog Boxes
12(1)
Toolbars and Ruler
12(2)
Normal View
14(1)
Status Bar
15(1)
Taskbar
15(1)
Shortcut Menu
15(1)
Getting Help
16(4)
Printing the Slides and the Outline
20(3)
Exiting PowerPoint
23(1)
Review
24(5)
Summary
24(1)
Key Terms
24(1)
Test Your Skills
25(2)
Projects
27(2)
Creating and Viewing Presentations
29(24)
Creating a Presentation Using a Template
30(2)
Inserting and Deleting Text
32(2)
Changing Views
34(4)
Checking the Spelling and Style of the Presentation
38(4)
Checking the Style
38(3)
Checking Spelling
41(1)
Saving the Presentation
42(2)
Closing and Opening a Presentation
44(3)
Closing Presentations
44(1)
Opening Saved Presentations
45(2)
Review
47(6)
Summary
47(1)
Key Terms
47(1)
Test Your Skills
47(2)
Projects
49(1)
Check Point for Units 1-2
50(3)
Edit the Presentation
53(18)
Adding a New Slide to the Presentation
54(3)
Deleting a Slide from the Presentation
57(1)
Changing the Order of Slides
58(1)
Changing the Layout of a Slide
59(1)
Moving and Copying Text
60(1)
Changing the Bullets in a List
61(5)
Creating Subtopics in a Bulleted List
66(2)
Review
68(3)
Summary
68(1)
Key Terms
68(1)
Test Your Skills
68(2)
Projects
70(1)
Change the Look of the Presentation
71(1)
Changing the Color of the Presentation
72(4)
Changing the Presentation Design
76(2)
Using the Slide Master
78(3)
Changing the Font, Font Size, and Color
81(2)
Formatting Text Using the Formatting Toolbar
83(1)
Changing Text Alignment on Slides
84(1)
Adding AutoShapes to Slides
85(3)
Adding Clip Art to Slides
88(4)
Review
92(1)
Summary
92(1)
Key Terms
92(1)
Test Your Skills
92(2)
Projects
94(2)
Check Point for Units 3-4
96
INTEGRATING THE PARTS 1(1)
Merging Documents and Linking to the World Wide Web
1(12)
Merging Files
2(1)
Pasting, Embedding, and Linking
2(1)
Creating Hyperlinks
3(1)
Integrating Files
3(10)
Wrap-Up for Integrating the Parts
13
Appendix A Alphabetized List of Tasks 1(1)
Appendix B Toolbars and Buttons 1(1)
Glossary 1(1)
Index 1

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >