Microsoft Office 2000

by Hutchinson, Sarah E.; Coulthard, Glen J.; Hutchinson-Clifford, Sarah

• ISBN13: 9780072337938
• ISBN10: 0072337931
• Edition: Spiral
• Format: Paperback
• Copyright: 1999-07-01
• Publisher: McGraw Hill College Div

Summary

The Advantage Series presents the Why, What and How of computer application skills to today's students. Each lab in this series is built upon an efficient learning model, which provides students and faculty with complete coverage and enhances critical thinking skills.

Table of Contents

Contents --- Word
Creating A Document
Case Study	3	(1)
Getting Started with Word	3	(7)
Loading and Exiting Word	3	(2)
Touring Word	5	(2)
Customizing Menus and Toolbars	7	(3)
Creating Your First Document	10	(7)
Inserting and Deleting Text	11	(3)
Inserting the Date and Time	14	(2)
Putting ``Word Wrap'' to Work	16	(1)
Editing Your Work	17	(4)
Using the Undo, Redo, and Repeat Commands	17	(2)
Correcting Mistakes As You Type	19	(2)
Managing Files	21	(9)
Beginning a New Document	22	(3)
Saving and Closing	25	(3)
Opening an Existing Document	28	(2)
Previewing and Printing	30	(3)
Previewing a Document	30	(2)
Printing a Document	32	(1)
Chapter Review	33	(2)
Review Questions	35	(3)
Hands-On Projects	38	(4)
Case Problems	42	(7)
Changing the Look of Text
Case Study	49	(1)
Moving Through a Document	49	(4)
Positioning the Insertion Point	50	(3)
Selecting Text	53	(4)
Selecting Text Using the Mouse	54	(3)
Enhancing Text	57	(6)
Bolding, Italicizing, and Underlining	58	(2)
Changing Fonts, Font Sizes, and Colors	60	(3)
Formating Paragraphs	63	(16)
Displaying Paragraph Marks	63	(2)
Changing Paragraph Alignment	65	(1)
Indenting Paragraphs	66	(4)
Creating Bulleted and Numbered Lists	70	(3)
Changing Line Spacing	73	(3)
Setting Tabs	76	(3)
Chapter Review	79	(3)
Review Questions	82	(2)
Hands-On Projects	84	(4)
Case Problems	88	(7)
Modifying A Document
Case Study	95	(1)
Customizing Your Work Area	95	(5)
Selecting a View	96	(2)
Zooming the Display	98	(2)
Finding and Replacing Text	100	(5)
Finding Text	100	(3)
Replacing Text	103	(2)
Copying and Moving Information	105	(9)
Copying Formatting Attributes	106	(2)
Using the Clipboards	108	(3)
Using Drag and Drop	111	(3)
Proofing a Document	114	(6)
Checking Spelling and Grammar	114	(3)
Using the Thesaurus	117	(1)
Highlighting Text for Review	118	(2)
Using AutoCorrect	120	(4)
Applying AutoCorrect Entries	120	(1)
Adding and Deleting AutoCorrect Entries	121	(3)
Chapter Review	124	(2)
Review Questions	126	(2)
Hands-On Projects	128	(4)
Case Problems	132	(7)
Finalizing Your Work
Case Study	139	(1)
Adjusting the Layout of Your Document	139	(8)
Changing Margins	140	(2)
Changing Page Orientation	142	(2)
Aligning Text Vertically	144	(1)
Forcing a Page Break	145	(2)
Inserting Headers and Footers	147	(6)
Inserting Page Numbers	148	(2)
Creating Headers and Footers	150	(3)
Adding Shading and Page Borders	153	(4)
Shading Words and Paragraphs	153	(3)
Creating a Page Border	156	(1)
Publishing to the Web	157	(4)
Saving a Document to HTML	158	(3)
Chapter Review	161	(2)
Review Questions	163	(3)
Hands-On Projects	166	(5)
Case Problems	171
Contents --- Excel
Creating A Worksheet
Case Study	5	(1)
Getting Started with Excel	5	(7)
Loading and Exiting Excel	7	(1)
Touring Excel	8	(2)
Customizing Menus and Toolbars	10	(2)
Creating Your First Worksheet	12	(9)
Moving the Cell Pointer	13	(2)
Entering Text	15	(1)
Entering Dates	16	(2)
Entering Numbers	18	(1)
Entering Formulas	19	(2)
Editing Your Work	21	(6)
Editing a Cell's Contents	21	(2)
Erasing a Cell	23	(2)
Using Undo and Redo	25	(2)
Managing Files	27	(7)
Beginning a New Workbook	28	(2)
Saving and Closing	30	(2)
Opening an Existing Workbook	32	(2)
Chapter Review	34	(3)
Review Questions	37	(3)
Hands-On Project	40	(7)
Case Problems	47	(6)
Modifying A Worksheet
Case Study	53	(1)
Entering and Reviewing Data	53	(10)
Selecting Cells and Ranges	53	(3)
Entering Data Using AutoComplete	56	(3)
Using AutoCalculate and AutoSum	59	(2)
Inserting and Deleting Cells	61	(2)
Copying and Moving Data	63	(11)
Using the Clipboards	64	(4)
Using Drag and Drop	68	(2)
Creating a Series Using AutoFill	70	(2)
Extending a Cell's Contents	72	(2)
Modifying Rows and Columns	74	(9)
Changing Column Widths	74	(3)
Changing Row Heights	77	(1)
Inserting and Deleting Rows and Columns	78	(3)
Hiding and Unhiding Rows and Columns	81	(2)
Chapter Review	83	(2)
Review Questions	85	(3)
Hands-On Projects	88	(6)
Case Problems	94	(7)
Formatting and Printing
Case Study	101	(1)
Enhancing a Worksheet's Appearance	101	(11)
Applying Fonts, Font Styles, and Colors	102	(2)
Formatting Numbers and Dates	104	(3)
Aligning and Merging Cells	107	(3)
Adding Borders and Shading	110	(2)
Applying and Removing Formatting	112	(9)
Using Format Painter	113	(3)
Removing Formatting Attributes	116	(1)
Using the Paste Special Command	117	(2)
Using the AutoFormat Command	119	(2)
Printing and Web Publishing	121	(5)
Previewing and Printing a Worksheet	122	(2)
Previewing and Publishing to the Web	124	(2)
Customizing Print Options	126	(7)
Adjusting Page and Margin Settings	127	(1)
Inserting Headers and Footers	128	(2)
Selecting Worksheet Content to Print	130	(3)
Chapter Review	133	(2)
Review Question	135	(3)
Hands-On Projects	138	(13)
Case Problems	145	(6)
Analyzing Your Data
Case Study	151	(1)
Working with Named Ranges	151	(12)
Naming Cell Ranges	152	(3)
Managing Range Names	155	(2)
Using References in Formulas	157	(2)
Entering Natural Language Formulas	159	(4)
Using Built-In Functions	163	(10)
Adding Values (Sum)	163	(1)
Calculating Averages (Average)	164	(2)
Counting Values (Count)	166	(1)
Analyzing Values (Min and Max)	167	(2)
Calculating Dates (Now and Today)	169	(4)
Creating an Embedded Chart	173	(6)
Creating a Chart Using the Chart Wizard	173	(4)
Previewing and Printing an Embedded Chart	177	(2)
Chapter Review	179	(2)
Review Questions	181	(3)
Hands-On Projects	184	(6)
Case Problems	190
Contents --- PowerPoint
Creating A Presentation
Case Study	5	(1)
Getting Started with PowerPoint	5	(6)
Loading PowerPoint	5	(2)
Touring PowerPoint	7	(1)
Customizing Menus and Toolbars	8	(3)
Creating a New Presentation	11	(14)
Creating a Presentation Using the AutoContent Wizard	12	(3)
Creating a Presentation From a Design Template	15	(2)
Adding Text	17	(3)
Inserting and Deleting Slides	20	(2)
Switching PowerPoint Views	22	(3)
Managing Files	25	(6)
Saving and Closing	26	(3)
Opening an Existing Presentation	29	(2)
Previewing and Printing	31	(4)
Previewing a Presentation in Black and White	31	(2)
Printing a Presentation	33	(2)
Chapter Review	35	(2)
Review Questions	37	(3)
Hands-On Projects	40	(13)
Case Problems	44	(9)
Developing A Presentation
Case Study	53	(1)
Managing Existing Slides	53	(4)
Inserting Slides from Other Presentations	53	(2)
Changing Slide Order	55	(2)
Changing Slide Layout and Design	57	(6)
Applying a Different Layout	57	(3)
Modifying an Existing Layout	60	(1)
Changing an Existing Design Template	61	(2)
Inserting Graphics Objects	63	(17)
Inserting Clip Art	64	(6)
Inserting Pictures	70	(2)
Inserting Graphs	72	(4)
Inserting Organization Charts	76	(4)
Delivering Online Presentations	80	(4)
Starting and Running Slide Shows	80	(4)
Chapter Review	84	(2)
Review Questions	86	(3)
Hands-On Projects	89	(3)
Case Problems	92
Contents --- Access
Working with Access
Case Study	5	(1)
Getting Started with Access	5	(10)
Loading and Exiting Access	6	(2)
Opening a Database File at Startup	8	(2)
Touring Access	10	(2)
Selecting Database Objects	12	(3)
Viewing and Printing Your Data	15	(9)
Moving Around a Datasheet	15	(4)
Adjusting Column Widths and Row Heights	19	(2)
Previewing and Printing	21	(3)
Manipulating Table Data	24	(8)
Selecting and Editing Data	24	(3)
Using the Undo Command	27	(1)
Adding Records	28	(2)
Deleting Records	30	(2)
Chapter Review	32	(2)
Review Questions	34	(3)
Hands-on Projects	37	(6)
Case Problems	43	(8)
Creating A Database
Case Study	51	(1)
Designing Your First Database	51	(8)
Employing the Database Wizard	52	(3)
Planning a Database	55	(2)
Starting a New Database	57	(2)
Creating a Simple Table	59	(4)
Creating a Table Using the Table Wizard	59	(2)
Creating a Table in Datasheet View	61	(2)
Using the Table Design View	63	(9)
Creating a Table in Design View	63	(4)
Assigning a Primary Key	67	(2)
Defining and Removing Indexes	69	(3)
Modifying a Table	72	(6)
Inserting and Deleting Fields	72	(2)
Renaming and Moving Fields	74	(2)
Printing a Table's Design Structure	76	(2)
Chapter Review	78	(2)
Review Questions	80	(3)
Hands-On Projects	83	(5)
Case Problems	88	(3)
Organizing And Retrieving Data
Case Study	91	(1)
Customizing Datasheet View	91	(10)
Formatting a Datasheet	91	(5)
Changing the Field Column Order	96	(2)
Hiding and Unhiding Columns	98	(2)
Freezing and Unfreezing Columns	100	(1)
Sorting and Finding Data	101	(7)
Sorting Records in a Datasheet	101	(2)
Performing a Simple Search	103	(2)
Specifying Search Patterns	105	(1)
Performing a Find and Replace	106	(2)
Using Filters	108	(7)
Filtering for Input	108	(2)
Filtering By Selection	110	(2)
Filtering By Form	112	(3)
Creating a Simple Query	115	(3)
Creating a Query Using the Query Wizard	115	(3)
Chapter Review	118	(2)
Review Questions	120	(3)
Hands-On Projects	123	(6)
Case Problems	129	(6)
Presenting and Managing Data
Case Study	135	(1)
Creating a Simple Form	135	(11)
Creating a Form Using the AutoForm Wizards	136	(3)
Creating a Form Using the Form Wizard	139	(2)
Navigating Data Using a Form	141	(3)
Working With a Form	144	(2)
Creating a Simple Report	146	(10)
Creating a Report Using the AutoReport Wizards	146	(2)
Creating a Report Using the Report Wizard	148	(4)
Previewing and Printing a Report	152	(2)
Publishing a Report to the Web	154	(2)
Generating a Mailing Labels Report	156	(2)
Creating a Report Using the Label Wizard	156	(2)
Managing Database Objects	158	(4)
Renaming, Copying, and Deleting Objects	159	(2)
Compacting and Repairing a Database	161	(1)
Chapter Review	162	(2)
Review Questions	164	(2)
Hands-On Projects	166	(6)
Case Problems	172
Contents --- Integrating
Integrating Word and Excel
Case Study	3	(1)
Using the Office Clipboard	3	(5)
Activating the Office Clipboard	3	(3)
Pasting and Clearing Clipboard Items	6	(2)
Pasting, Linking, and Embedding	8	(8)
Pasting Data from Word to Excel	9	(1)
Linking Excel Data to a Word Document	10	(4)
Embedding Excel Data in a Word Document	14	(2)
Manipulating Shared Objects	16	(4)
Moving, Resizing, and Deleting Shared Objects	16	(2)
Editing Shared Objects	18	(2)
Inserting New Worksheets and Charts in Word	20	(4)
Inserting a New Worksheet in Word	20	(3)
Inserting a New Chart in Word	23	(1)
Chapter Review	24	(3)
Review Questions	27	(2)
Hands-On Projects	29	(5)
Case Problems	34	(5)
Performing More Integration Tasks
Case Study	39	(1)
Creating a Presentation from a Word Document	39	(5)
Creating an Outline in Word	39	(3)
Converting a Word Outline to PowerPoint	42	(2)
Integrating PowerPoint with Word and Excel	44	(5)
Copying PowerPoint Slides to Word	44	(2)
Copying an Excel Chart to PowerPoint	46	(3)
Integrating Access with Word and Excel	49	(7)
Exporting Access Reports to Word	49	(3)
Exporting a Worksheet List to Access	52	(4)
Chapter Review	56	(2)
Review Questions	58	(3)
Hands-On Projects	61	(5)
Case Problems	66	(5)
Extending Microsoft Office To The Web
Case Study	71	(1)
Using Hyperlinks	71	(6)
Inserting Hyperlinks in Office Documents	71	(3)
Browsing with the Web Toolbar	74	(3)
Saving Existing Documents to HTML	77	(8)
Saving Word, Excel, and PowerPoint Documents to HTML	77	(4)
Displaying an Access Table on the Web	81	(4)
Preparing Web Pages Using Office	85	(11)
Applying Web Themes to Word Documents	85	(2)
Creating a Framed Table of Contents in Word	87	(3)
Creating an Interactive Worksheet Page	90	(3)
Customizing a Web Presentation	93	(3)
Posting Files to Web Servers	96	(5)
Creating a Web Folder	96	(2)
Saving a File to a Web Folder	98	(3)
Chapter Review	101	(2)
Review Questions	103	(3)
Hands-On Projects	106	(4)
Case Problems	110