Microsoft Office Tutorials and References

In Depth Information

**Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas**

number such as 1 or 249; and each column is identified by letters, such as A,

G, or BF. The intersection of each row and column defines a
cell,
which

contains one of three items:

✓

Numbers

✓

Text (labels)

✓

Formulas

Numbers provide the data, and
formulas
calculate that data to produce a

useful result, such as adding sales results for the week. Of course, just

displaying numbers on the screen may be confusing if you don’t know what

those numbers mean, so labels simply identify what numbers represent.

Figure 8-1 shows the parts of a typical spreadsheet.

Formulas usually appear as numbers, so at first glance, it may be difficult to

tell the difference between ordinary numbers and numbers that represent a

calculation by a formula.

The strength of spreadsheets comes by playing “What-if?” games with your

data, such as “What if I gave myself a $20-per-hour raise and cut everyone

else’s salary by 25%? How much money would that save the company every

month?” Because spreadsheets can rapidly calculate new results, you can

experiment with different numbers to see how they create different answers.

Labels

Figure 8-1:

The parts

of a typical

spreadsheet.

Formulas

Numbers