Comma Training Page 57

How Much Does It Cost?

AutoSum creates the equation: =Sum(B2:B5).

In real words, that means: add up all the numbers in cell B2 through B5 for the apples, basket, bow and box.

Before You Begin: Look on the Home Ribbon for the AutoSum button. It looks like the Greek letter S, or sigma. When you roll your mouse over the toolbar, the tool tip says, “Sum.”

1. Try This: Calculate the Wholesale Cost

Select Cell B6.

Go to Home -> Editing ->AutoSum.

The wholesale price should be $8.50.

2. Try This: Calculate the Retail Cost

Select Cell D6, and then click on the AutoSum.

Did you get $12.75?

Memo to Self: Click on the Enter key on your keyboard to finish the equation and see the results. Excel won’t calculate until you leave the Cell.