×

Uh-oh, it looks like your Internet Explorer is out of date.

# Quick, Simple Microsoft Excel 2000 / Edition 1

ISBN-10: 0130813338

ISBN-13: 9780130813336

Pub. Date: 06/07/1999

Publisher: Pearson

## Product Details

ISBN-13:
9780130813336
Publisher:
Pearson
Publication date:
06/07/1999
Edition description:
SPIRAL
Pages:
240
Product dimensions:
8.27(w) x 10.87(h) x 4.33(d)

## Related Subjects

Preface vii
UNIT 1 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)
4(3)
 Toolbars
7(1)
 Worksheet
8(1)
 Formula Bar
9(1)
 Status Bar
9(1)
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)
29(2)
 Projects
31(2)
UNIT 2 Working with Workbooks 33(37)
 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)
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(6)
 Summary
64(1)
 Key Terms
65(1)
65(2)
 Projects
67(3)
CHECK POINT for Units 1-2 70(3)
UNIT 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)
84(1)
 Using the Mouse
84(2)
 Aligning Data in Cells
86(3)
86(2)
 Using the Toolbar
88(1)
89(3)
90(1)
 Adding a Border Using the Toolbar
90(1)
91(1)
92(3)
 Review
95(6)
 Summary
95(1)
 Key Terms
95(1)
95(2)
 Projects
97(4)
UNIT 4 Using Functions and Other Calculations 101(23)
 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 Auto Calculate
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(6)
 Summary
118(1)
 Key Terms
118(1)
119(2)
 Projects
121(3)
CHECK POINT for Units 3-4 124(3)
UNIT 5 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)
139(1)
 Projects
140(3)
UNIT 6 Using Date, Count, and IF Functions 143(16)
 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(5)
 Summary
154(1)
 Key Terms
154(1)
154(2)
 Projects
156(3)
CHECK POINT for Units 5-6 159(2)
UNIT 7 Working with Multiple Worksheets 161(20)
 Inserting, Deleting, and Selecting Worksheets
162(2)
 Renaming Worksheets
164(1)
 Moving and Copying Worksheets
165(4)
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)
174(1)
 Projects
175(6)
UNIT 8 Using Excel with Charts, Word, and the Web 181(24)
 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(4)
 Summary
201(1)
 Key Terms
201(1)
201(2)
 Projects
203(2)
CHECK POINT for Units 7-8 205(2)
WRAP-UP 207(8)
APPENDIX A
209(2)
APPENDIX B
 Toolbars and Buttons
211(4)
Glossary 215(3)
Index 218

Average Review: