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 fl 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
 
Search JabSto ::




Custom Search