Microsoft Office Tutorials and References

In Depth Information

**Understanding formulas**

the number 12 refers to employees, enter
into a cell and then type
Employees
into the
12

cell to the right.

Understanding formulas

Formulas are what make a spreadsheet a spreadsheet. Excel enables you to enter ﬂ exible

formulas that use the values (or even text) in cells to calculate a result. When you enter

a formula into a cell, the formula’s result appears in the cell. If you change any of the cells

used by a formula, the formula recalculates and shows the new result.

Formulas can be simple mathematical expressions, or they can use some of the powerful

functions that are built into Excel. Figure 13.1 shows an Excel worksheet set up to calculate

a monthly loan payment. The worksheet contains values, text, and formulas. The cells in

column A contain text. Column B contains four values and two formulas. The formulas are

in cells B6 and B10. Column D, for reference, shows the actual contents of the cells in

column B.

FIGURE 13.1

You can use values, text, and formulas to create useful Excel worksheets.

13

You can i nd out much more about formulas in Chapter 15, “Introducing Formulas and Functions.”

Entering Text and Values into Your Worksheets

To enter a numeric value into a cell, move the cell pointer to the appropriate cell, type the

value, and then press Enter or one of the navigation keys. The value is displayed in the

cell and also appears in the Formula bar when the cell is selected. You can include decimal