McGraw-Hill Microsoft Excel 97

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

Write a Review

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780072282542 | 0072282541
Cover: Paperback
Copyright: 4/1/1999

Rent

(Recommended)

$34.82

Term

Due

Price

Semester

Aug 2

$34.82

Quarter

Jul 19

$33.08

Short Term

Jun 21

$31.34

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy New

Usually Ships in 3-4 Business Days

$47.58

Supplemental Materials

Spreadsheet Overview

(1)

Definition of Electronic Spreadsheets

(1)

Advantages of Using an Electronic Spreadsheet

(2)

Electronic Spreadsheet Terminology

(1)

Case Study for Labs 1--6

(1)

Before You Begin

(1)

Office Shortcut Bar

(1)

Instructional Conventions

(1)

Creating a Worksheet: Part 1

(42)

Part 1

(1)

Loading Excel 97

(2)

The Workbook Window

(2)

Using Toolbars

(1)

Using the Office Assistant

(1)

Moving Around the Worksheet

(1)

Scrolling the Worksheet

(2)

Designing Worksheets

(1)

Entering Data

(1)

Clearing an Entry

(1)

Editing an Entry

(3)

Entering Numbers

(2)

Closing and Opening a Workbook

(2)

Part 2

(1)

Copying Data

(5)

Entering Formulas

(1)

Recalculating the Worksheet

(1)

Changing Cell Alignment

(2)

Documenting a Workbook

(2)

Saving a Workbook

(2)

Previewing and Printing a Workbook

(2)

Exiting Excel

(1)

Lab Review

(3)

Key Terms

(1)

Command Summary

(1)

Matching

(1)

Fill-In Questions

(1)

Discussion Questions

(1)

Hands-On Practice Exercises

(3)

Concept Summary

(2)

Creating a Worksheet: Part 2

(40)

Part 1

(1)

Entering Formulas Using Point Mode

(2)

Copying Formulas

(2)

Entering Functions

(4)

Using the Paste Function Feature

(3)

Using Absolute References

(3)

Adding Cell Comments

(1)

Part 2

(1)

Adjusting Column Widths

(2)

Using Undo

(1)

Zooming the Worksheet

(1)

Formatting Numbers

(3)

Applying Styles

(2)

Inserting Rows

(1)

Moving Cell Contents

(1)

Centering Across a Selection

(1)

Changing Fonts and Font Styles

(3)

Adding Predefined Headers and Footers

(1)

Changing Page Orientation

(2)

Lab Review

(1)

Key Terms

(1)

Command Summary

(1)

Matching

(1)

Fill-In Questions

(1)

Discussion Questions

(1)

Hands-On Practice Exercises

(4)

Concept Summary

(2)

Managing and Analyzing a Complex Workbook

(44)

Part 1

(1)

Copying a Sheet

(3)

Naming Sheets

(1)

Using AutoFill

(3)

Referencing Multiple Sheets

(1)

Splitting Windows

(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

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

McGraw-Hill Microsoft Excel 97

Table of Contents

Supplemental Materials