A Guide to Microsoft Office Xp Professional for Windows

by Presley, Bruce; Brown, Beth; Malfas, Elaine; Marrelli, Jan

• ISBN13: 9781580030465
• ISBN10: 1580030467
• Format: Hardcover
• Copyright: 2002-05-01
• Publisher: Varsitybooks.Com

Table of Contents

Introducing the Computer
Mechanical Devices	1	(2)
Electro-Mechanical Devices	3	(1)
First Generation Computers	4	(1)
The Stored Program Computer	5	(1)
Second Generation Computers	6	(1)
High-Level Programming Languages	6	(1)
Third Generation Computers	7	(1)
Mainframes	7	(1)
Fourth Generation Computers	8	(1)
The Personal Computer	8	(1)
Memory	9	(1)
The CPU	10	(1)
Bits and Bytes	10	(1)
Storage Devices	11	(1)
Peripheral Devices	12	(1)
Networks	12	(2)
Transmission Media	14	(1)
Using a Network	15	(1)
The Internet	15	(1)
Internet Service Providers	15	(1)
Telecommunications	16	(1)
Internet Services	16	(1)
Computer Use Privacy Issues	17	(1)
Computers at Home	18	(1)
Computer-Related Careers	19	(2)
Chapter Summary	21	(1)
Vocabulary	22	(3)
Review Questions	25
Introducing Outlook
What is Outlook?	1	(1)
Calendar	2	(1)
Date Navigator	3	(1)
Calendar Views	4	(2)
Calendar Events	6	(2)
Calendar Appointments	8	(2)
Minimizing and Quitting Outlook	10	(2)
Outlook Tasks	12	(1)
Previewing and Printing the Calendar	13	(3)
Chapter Summary	16	(2)
Vocabulary	18	(1)
Outlook Commands and Buttons	18	(1)
Review Questions	19	(1)
Exercise	20
Advanced Outlook Features and E-mail
The Outlook Contacts Tool	1	(1)
Adding a Contact	2	(1)
Modifying a Contact	3	(2)
Contacts Views	5	(2)
Printing Contacts	7	(2)
What is E-mail?	9	(1)
The Address Book	10	(1)
Using Outlook to Send E-mail	10	(3)
Organizing E-mail Messages	13	(2)
Adding a Signature to E-mail Messages	15	(3)
Using Contacts to Create a vCard	18	(1)
E-mail Etiquette	19	(1)
E-mail Viruses	19	(1)
Sending Meeting Requests	20	(2)
Chapter Summary	22	(1)
Vocabulary	23	(1)
Outlook Commands and Buttons	24	(1)
Review Questions	25	(1)
Exercise	26
Introducing the Word Processor
What is a Word Processor?	1	(1)
Creating a New Word Document	1	(1)
Using the Keyboard with Word	2	(1)
Editing Text in a Document	3	(1)
Word Wrap	3	(1)
Using Menus	4	(3)
Saving a Document	7	(1)
Automatic Spelling and Grammar Checking	8	(1)
Using the Toolbar	9	(2)
Displaying Formatting Marks	11	(1)
Closing a Document and Quitting Word	12	(1)
Smart Tags	12	(2)
Opening a File	14	(1)
Printing a Document	15	(1)
Changing Views	16	(1)
Moving a Document in the Window	17	(2)
Chapter Summary	19	(2)
Vocabulary	21	(1)
Word Commands and Buttons	22	(1)
Review Questions	23	(1)
Exercises	24
Formatting Documents
What is Formatting?	1	(1)
The Undo Command and the Repeat Command	1	(1)
Selecting Text	2	(2)
Character Formats - Fonts	4	(1)
Character Formats - Size	5	(1)
Character Formats - Style	6	(1)
Previewing a Document	6	(2)
Character Formats - Superscripts and Subscripts	8	(2)
Paragraph Formats - Alignment	10	(1)
Paragraph Formats - Line Spacing	11	(2)
Page Formats - Margins	13	(3)
Page Formats - Headers and Footers	16	(1)
Adding Page Numbers	17	(2)
Page Formats - Pagination	19	(1)
Tabs and Tab Stops	20	(2)
Setting Individual Tab Stops	22	(1)
Selecting a Vertical Block of Text	23	(2)
Chapter Summary	25	(2)
Vocabulary	27	(1)
Word Commands and Buttons	28	(1)
Review Questions	29	(1)
Exercises	30
Word Processor Features
Copying and Moving Text	1	(1)
The Office Clipboard	2	(2)
Finding Text in a Document	4	(1)
Finding Special Characters	5	(2)
Replacing Text	7	(1)
Using the Thesaurus	8	(2)
Paragraph Formats - Indents	10	(1)
Copying and Pasting Paragraph Formats	11	(1)
The Reveal Formatting Task Pane	11	(3)
Paragraph Formats - Hanging and First Line Indents	14	(1)
Creating Lists	15	(2)
Creating Footnotes and Endnotes	17	(2)
Inserting Time Stamps	19	(1)
Displaying Document Information	20	(2)
Adding Clip Art to a Document	22	(2)
Formatting a Document in Columns	24	(2)
Chapter Summary	26	(1)
Vocabulary	27	(1)
Word Commands and Buttons	28	(1)
Review Questions	29	(1)
Exercises	30
Advanced Word Processor Features
Using Tables	1	(1)
Formatting Cell Contents	2	(2)
Inserting Symbols	4	(1)
Hyphenating a Document	5	(1)
Styles	5	(1)
Creating a Style	6	(3)
Using Outline View	9	(2)
Creating a Table of Contents	11	(1)
Creating Sections in a Document	12	(2)
Using Section Headers and Footers	14	(1)
Using Section Page Numbers	15	(2)
Creating a Hyperlink to a Web Page	17	(1)
Creating a Hyperlink to a Heading	18	(1)
Creating a Newsletter	18	(2)
E-mailing a Document	20	(1)
Creating Labels	21	(1)
Recording Macros	22	(2)
Where can you go from here?	24	(1)
Chapter Summary	24	(2)
Vocabulary	26	(1)
Word Commands and Buttons	26	(2)
Review Questions	28	(1)
Exercises	29
Introducing the Spreadsheet
What is a Spreadsheet?	1	(1)
Creating a New Excel Workbook	2	(1)
The Active Cell	3	(1)
Entering Data into a Worksheet	3	(1)
Editing Cell Contents	4	(2)
Saving, Closing, and Opening a Workbook and Quitting Excel	6	(1)
Previewing and Printing a Worksheet	6	(1)
Adding a Header and Footer	7	(2)
Changing the Width of a Column	9	(1)
Selecting Cells	10	(1)
Alignments and Fonts	10	(2)
Formatting Numeric Data	12	(2)
Using Formulas to Perform Calculations	14	(3)
Using Cell References in Formulas	17	(2)
Using Functions to Perform Calculations	19	(1)
Common Error Values	20	(1)
Entering Formulas - Pointing	21	(1)
Displaying Formulas	21	(2)
Copying Adjacent Cells	23	(1)
Copying Formulas	23	(1)
The ROUND Function	24	(2)
Chapter Summary	26	(2)
Vocabulary	28	(1)
Excel Commands and Buttons	29	(1)
Review Questions	30	(2)
Exercises	32
Spreadsheet Techniques
Planning a Worksheet	1	(1)
The Find and Replace Commands	2	(1)
Copying and Moving Data	3	(1)
The MAX and MIN Functions	4	(1)
Inserting a Function into a Formula	5	(2)
Absolute Cell References	7	(1)
Inserting and Deleting Rows and Columns	8	(2)
Printing a Large Worksheet	10	(1)
The IF Function	11	(3)
Using Text in the IF Function	14	(1)
Chapter Summary	15	(2)
Vocabulary	17	(1)
Excel Commands and Buttons	17	(1)
Review Questions	18	(1)
Exercises	19
Worksheets and Charts
Using Multiple Sheets	1	(1)
Copying and Moving Data Between Sheets	2	(1)
Using Cell References from Different Sheets	3	(1)
Linking Cells	4	(1)
Printing Sheets	5	(2)
Charts	7	(1)
Creating a Pie Chart	8	(5)
Moving, Sizing, and Deleting Charts	13	(1)
Printing a Chart	14	(1)
Creating Bar and Line Charts	15	(3)
Modifying a Chart	18	(1)
Adding Adjacent Series and Labels	19	(2)
Adding Nonadjacent Series and Labels	21	(2)
Formatting a Chart	23	(5)
Chapter Summary	28	(1)
Vocabulary	29	(1)
Excel Commands and Buttons	30	(1)
Review Questions	31	(1)
Exercises	32
Advanced Spreadsheet Techniques
Asking ``What If?''	1	(1)
Sorting Data	2	(2)
Adding a Picture	4	(2)
The CHOOSE Function	6	(2)
Naming a Cell or Range	8	(1)
The VLOOKUP Function	8	(2)
Freezing Cells	10	(2)
Using Text in the CHOOSE and VLOOKUP Functions	12	(2)
Amortization Tables and the PMT Function	14	(1)
Printing a Selected Worksheet Area	14	(3)
Creating a Hyperlink to a Worksheet Location	17	(2)
E-mailing a Worksheet	19	(1)
Saving Excel Data in HTML Format	20	(1)
Chapter Summary	21	(1)
Vocabulary	22	(1)
Excel Commands and Buttons	23	(1)
Review Questions	24	(1)
Exercises	25
Integrating Data Between Word and Excel
Working with Multiple Files in an Application	1	(1)
Saving and Closing Multiple Files	2	(1)
Copying Text Between Word Documents	2	(2)
Copying Data Between Excel Workbooks	4	(2)
Working with Multiple Applications	6	(1)
Copying Data Between Applications	6	(2)
Using the Office Clipboard to Copy Data	8	(2)
Copying a Chart Object into a Word Document	10	(2)
Creating a Hyperlink to a File	12	(1)
Embedding and Linking a Word Document Object	13	(2)
Embedding and Linking an Excel Worksheet Object	15	(3)
Embedding and Linking an Excel Chart Object	18	(2)
Chapter Summary	20	(1)
Vocabulary	21	(1)
Word and Excel Commands and Buttons	21	(1)
Review Questions	22	(1)
Exercises	23
Introducing the Relational Database
What is a Database?	1	(1)
Defining Fields	2	(1)
Tables and Records	3	(1)
Designing a Relational Database	4	(1)
Creating a New Relational Database	5	(1)
Creating Tables and Fields	6	(2)
Saving and Closing a Table	8	(1)
Closing and Opening a Database and Quitting Access	8	(3)
Creating a Form	11	(3)
Using Forms and Entering Records	14	(1)
Viewing Records in Datasheet View	15	(3)
Formatting Datasheet View	18	(1)
Printing Records	19	(2)
Filtering	21	(1)
Using Saved Filters	22	(1)
Advanced Filtering	23	(2)
Chapter Summary	25	(2)
Vocabulary	27	(1)
Access Commands and Buttons	28	(1)
Review Questions	28	(2)
Exercises	30
Relational Database Techniques
Modifying a Table and Updating a Form	1	(1)
Sorting Records	2	(1)
Modifying Records	3	(1)
Defining Relationships	4	(3)
Using Subdatasheets	7	(2)
Using Select Queries	9	(4)
Modifying and Deleting a Select Query	13	(1)
Sorting Select Query Results	14	(2)
Range Queries	16	(2)
Select Queries Involving ``And''	18	(2)
Select Queries Using ``Or''	20	(2)
Query Criteria Wildcards	22	(1)
Chapter Summary	23	(2)
Vocabulary	25	(1)
Access Commands and Buttons	26	(1)
Review Questions	27	(1)
Exercises	28
Relational Database Reports and Advanced Database Techniques
Reports	1	(1)
Creating a Report	2	(6)
Report Summaries	8	(2)
Using Fields in Query Criteria	10	(1)
Calculation Fields	11	(2)
Where can you go from here?	13	(1)
Chapter Summary	13	(1)
Vocabulary	14	(1)
Access Commands and Buttons	14	(1)
Review Questions	14	(1)
Exercises	15
Integrating Data Between Access, Word, and Excel
Copying Data From Access to Word	1	(2)
Inserting and Linking Access Data into a Word Document	3	(3)
Creating a Workbook From Access Data	6	(2)
Using Excel Data to Create an Access Table	8	(2)
Mail Merge - Form Letters	10	(7)
Mail Merge - Mailing Labels	17	(6)
Chapter Summary	23	(1)
Vocabulary	24	(1)
Access and Word Commands and Buttons	25	(1)
Review Questions	25	(1)
Exercises	26
PowerPoint Presentations
What is a Presentation?	1	(1)
Creating a New PowerPoint Presentation	2	(1)
PowerPoint Views	3	(1)
Displaying Slides	3	(1)
Viewing a Presentation	4	(1)
Editing Text	5	(1)
Adding and Deleting Slides	6	(2)
Adding a Picture to a Slide	8	(1)
Changing the Order of Slides	9	(1)
Printing a Presentation	9	(4)
Adding Footers to Slides	13	(1)
Slide Transitions	13	(1)
Animation	14	(2)
Adding a Chart to a Slide	16	(1)
Planning a Presentation	17	(1)
Presentation Design	18	(2)
Creating and Printing Speaker Notes	20	(1)
Where can you go from here?	21	(1)
Chapter Summary	21	(1)
Vocabulary	22	(1)
PowerPoint Commands and Buttons	23	(1)
Review Questions	24	(1)
Exercises	25
Appendix A Using Microsoft Office Help
A.1 The Assistant	1	(1)
A.2 Finding a Help Topic	1	(2)
A.3 Displaying the Contents of a Topic	3	(1)
A.4 Printing a Help Topic	4	(1)
A.5 Displaying Screen Tips	4	(1)
A.6 Where can you go from here?	4
Appendix B Functions and Keyboard Shortcuts
Functions	1	(2)
Keyboard Shortcuts	3
Appendix C Creating Customized Forms and Reports
C.1 Creating Forms in Design View	1	(1)
C.2 Customizing Forms in Design View	2	(1)
C.3 Creating Reports in Design View	3	(2)
C.4 Customizing Reports in Design View	5	(1)
C.5 Adding Summaries to a Report	5