Microsoft Office Tutorials and References

In Depth Information

**Understanding Excel functions**

6

Click inside cell B5, located to the right of the words
SALES TOTAL
, and then type an

equal sign (
). Excel displays the equal sign in the formula bar.
=

When you type a formula into a cell, it also appears in the formula bar.

You can type the formula directly into the formula bar or into a particular cell.

7

In the worksheet, click cell B2. Excel inserts the cell address into the formula.

8

Type a plus sign (
) to begin adding the data from B2 with other cell contents.
+

Type the formula in the cell.

9
In the active cell, we will continue to create the formula; click cell B3 and type another

plus sign (+) and then click cell B4. The formula bar should now appear as follows:

=B2+B3+B4.

10
Press Enter and Excel displays the total of the cells in column B, which represents the

sales total for January.

11
Click File > Save, and then click File > Close.

If you need to change a formula, you can click the formula result. In this example, you would

click cell B5. Excel redisplays the formula in the formula bar. After you make edits, press Enter.

Understanding Excel functions

To build powerful formulas, you may need to include one or more Excel functions as

operands.