- Click in cell B7.
- Type:=
- Click in cell B4.
4.
- Type:+
- Click in cell B5.
- Type:+
- Click in cell B6.
Look in the Formula Bar.
It should read:
=B4+B5+B6
TIP: You just created a formula that adds up the per-frog costs for the tadpole, food, and tank.
Formulas always begin with an =.
- In the Ribbon, click the
icon.
- Click in cell D3.
- Type
- Price
- Type:+
- Click in cell E6.
- In the Ribbon, click the
icon.
The worksheet should look like this:- Press the ENTER key.The total in E6 should be 3.
- Click in cell E6.
The Formula Bar should show:
=SUM(E4:E5)
TIP: This is just a different way of adding numbers. By clicking the
icon, you told Excel to SUM, or add, the numbers from E4 through E5.
- Press the ENTER key.The total in E6 should be 3.
- Click in cell E6.
- In the Ribbon, click the
icon.
The worksheet should look like this:TUTORIAL EXCEL 2007
- Click in cell E6.