Chapter 8. Building a Worksheet with Excel

What You'll Do

Create a Simple Formula

Edit and Copy a Formula

Name a Range

Simplify a Formula with Ranges

Understand Cell Referencing

Use Absolute Cell References

Perform Calculations Using Functions

Calculate Results

Correct Calculation Errors

Create and Edit a Chart

Change a Chart Type

Add and Delete a Data Series

Enhance a Data Series

Format a Chart

Enhance a Chart

Understand Lists

Create a List

Sort and Work with Data in a List