Microsoft

3 Working with Formulas and Functions

What You’ll Do

Understand Formulas

Create and Edit Formulas

Understand Cell Referencing

Use Absolute Cell References

Use Mixed and 3-D Cell References

Name Cells and Ranges

Enter and Manage Names

Simplify a Formula with Ranges

Display Calculations with the Status Bar

Calculate Totals with AutoSum

Perform One Time Calculations

Convert Formulas and Values

Correct Calculation Errors

Correct Formulas

Audit a Worksheet

Locate Circular References

Perform Calculations Using Functions

Create Functions and Nested Functions

Calculate Multiple Results

Use Constants and Functions in Names

Introduction

Once you enter data in a worksheet, you’ll want to add formulas to perform calculations. Microsoft Excel can help ...