McGraw-Hill Microsoft Excel 97

by O'Leary, Timothy J.; O'Leary, Linda I.

• ISBN13: 9780072282542
• ISBN10: 0072282541
• Format: Paperback
• Copyright: 1999-04-01
• Publisher: McGraw-Hill Higher Education

Table of Contents

Spreadsheet Overview	1	(1)
Definition of Electronic Spreadsheets	1	(1)
Advantages of Using an Electronic Spreadsheet	1	(2)
Electronic Spreadsheet Terminology	3	(1)
Case Study for Labs 1--6	3	(1)
Before You Begin	4	(1)
Office Shortcut Bar	5	(1)
Instructional Conventions	5	(1)
Creating a Worksheet: Part 1	6	(42)
Part 1	7	(1)
Loading Excel 97	7	(2)
The Workbook Window	9	(2)
Using Toolbars	11	(1)
Using the Office Assistant	11	(1)
Moving Around the Worksheet	12	(1)
Scrolling the Worksheet	13	(2)
Designing Worksheets	15	(1)
Entering Data	16	(1)
Clearing an Entry	17	(1)
Editing an Entry	18	(3)
Entering Numbers	21	(2)
Closing and Opening a Workbook	23	(2)
Part 2	25	(1)
Copying Data	25	(5)
Entering Formulas	30	(1)
Recalculating the Worksheet	31	(1)
Changing Cell Alignment	32	(2)
Documenting a Workbook	34	(2)
Saving a Workbook	36	(2)
Previewing and Printing a Workbook	38	(2)
Exiting Excel	40	(1)
Lab Review	40	(3)
Key Terms	40	(1)
Command Summary	41	(1)
Matching	41	(1)
Fill-In Questions	42	(1)
Discussion Questions	43	(1)
Hands-On Practice Exercises	43	(3)
Concept Summary	46	(2)
Creating a Worksheet: Part 2	48	(40)
Part 1	49	(1)
Entering Formulas Using Point Mode	49	(2)
Copying Formulas	51	(2)
Entering Functions	53	(4)
Using the Paste Function Feature	57	(3)
Using Absolute References	60	(3)
Adding Cell Comments	63	(1)
Part 2	64	(1)
Adjusting Column Widths	64	(2)
Using Undo	66	(1)
Zooming the Worksheet	67	(1)
Formatting Numbers	68	(3)
Applying Styles	71	(2)
Inserting Rows	73	(1)
Moving Cell Contents	74	(1)
Centering Across a Selection	74	(1)
Changing Fonts and Font Styles	75	(3)
Adding Predefined Headers and Footers	78	(1)
Changing Page Orientation	79	(2)
Lab Review	81	(1)
Key Terms	81	(1)
Command Summary	81	(1)
Matching	82	(1)
Fill-In Questions	82	(1)
Discussion Questions	82	(1)
Hands-On Practice Exercises	82	(4)
Concept Summary	86	(2)
Managing and Analyzing a Complex Workbook	88	(44)
Part 1	89	(1)
Copying a Sheet	89	(3)
Naming Sheets	92	(1)
Using AutoFill	92	(3)
Referencing Multiple Sheets	95	(1)
Splitting Windows	96	(5)
Freezing Panes	101	(3)
Using What-If Analysis	104	(1)
Using Solver	105	(4)
Moving a Sheet	109	(1)
Part 2	109	(1)
Opening a Second Workbook	109	(1)
Spell-Checking a Sheet	110	(2)
Linking Workbooks	112	(3)
Using Goal Seek	115	(2)
Adding Color and Borders	117	(3)
Aligning a Sheet on a Page	120	(1)
Previewing a Workbook	121	(1)
Creating Custom Headers and Footers	121	(2)
Lab Review	123	(2)
Key Terms	123	(1)
Command Summary	124	(1)
Matching	124	(1)
Fill-In Questions	125	(1)
Discussion Questions	125	(1)
Hands-On Practice Exercises	125	(5)
Concept Summary	130	(2)
Creating Charts	132	(38)
Part 1	133	(1)
Using Autoformats	133	(2)
About Charts	135	(2)
Selecting the Data to Chart	137	(6)
Moving and Sizing a Chart	143	(1)
Changing the Type of Chart	144	(1)
Creating a Chart with Multiple Data Series	144	(4)
Part 2	148	(1)
Moving the Legend	148	(2)
Adding Patterns	150	(3)
Adding a Text Box	153	(2)
Adding Arrows	155	(1)
Creating a Combination Chart	156	(2)
Adding Data Labels	158	(1)
Creating a Pie Chart	159	(2)
Changing Worksheet Data	161	(1)
Printing Charts	162	(1)
Lab Review	163	(2)
Key Terms	163	(1)
Command Summary	163	(1)
Matching	164	(1)
Fill-In Questions	164	(1)
Discussion Questions	164	(1)
Hands-On Practice Exercises	165	(3)
Concept Summary	168	(2)
Creating a Form Template	170	(30)
Naming a Range	171	(4)
Using the IF Function	175	(4)
Adding Controls	179	(3)
Improving the Appearance of the Form	182	(1)
Hiding Rows	183	(1)
Hiding Window Elements	184	(1)
Documenting a Form	185	(2)
Protecting a Worksheet	187	(2)
Creating a Template File	189	(5)
Lab Review	194	(1)
Key Terms	194	(1)
Command Summary	194	(1)
Matching	194	(1)
Fill-In Questions	195	(1)
Discussion Questions	195	(1)
Hands-On Practice Exercises	195	(3)
Concept Summary	198	(2)
Sharing Data Between Applications	200	(17)
Copying Between Applications	201	(3)
Linking an Object to Another Application	204	(2)
Updating a Linked Object	206	(2)
Embedding an Object in Another Application	208	(2)
Updating an Embedded Object	210	(2)
Deciding When to Link or Embed Objects	212	(1)
Lab Review	212	(1)
Key Terms	212	(1)
Command Summary	212	(1)
Matching	213	(1)
Discussion Questions	213	(1)
Hands-On Practice Exercises	213	(3)
Concept Summaryn	216	(1)
Case Project	217	(4)
Part 1	217	(1)
Part 2	218	(1)
Part 3	219	(2)
Glossary of Key Terms	221	(5)
Command Summary	226	(3)
Index	229
Appendix A: Additional Microsoft Office User Specialist Certification Topics	A1