Special Edition Using Microsoft® Excel™ 2002 > Using Formulas and Functions > Function Fundamentals - Pg. : Creative Edge

Table of Contents

This Book

Special Edition Using Microsoft® Excel™ 2002

Special Edition Using Microsoft® Excel™ 2002

Search

Contents

About the Authors

Acknowledgments

Tell Us What You Think!

Pt. I. Getting Started with Excel 2002

Pt. II. Formatting and Printing Excel Worksheets

Pt. III. Using Formulas and Functions

Ch. 6. Function Fundamentals

The Basic Parts of a Formula

Using the New AutoSum Feature

Editing Formulas

Writing Multiple Copies of a Formula

Using AutoCalculate for Quick Totals

Using Arithmetic Operators for Simple Math

Relative Versus Absolute Referencing

Using the Watch Window

Referencing Values in Other Worksheets and Workbooks

Troubleshooting

Excel in Practice

Ch. 7. Database Functions

Ch. 8. Date and Time Functions

Ch. 9. Engineering Functions

Ch. 10. Financial Functions

Ch. 11. Information Functions

Ch. 12. Logical Functions

Ch. 13. Lookup and Reference Functions

Ch. 14. Math and Trigonometry Functions

Ch. 15. Text Functions

Ch. 16. Statistical Functions

Pt. IV. Using Excel's Analysis Tools

Pt. V. Creating and Modifying Charts

Pt. VI. Using Excel to Manage Your Business

Pt. VII. Integrating Excel with Other Applications

URL

Help

Chapter 6. Function Fundamentals

In this chapter

The Basic Parts of a Formula
Using the New AutoSum Feature
Editing Formulas
Writing Multiple Copies of a Formula
Using AutoCalculate for Quick Totals
Using Arithmetic Operators for Simple Math
Relative Versus Absolute Referencing
Using the Watch Window
Referencing Values in Other Worksheets and Workbooks

PREVIEW

Not a subscriber?

Start A Free Trial