Microsoft Office Tutorials and References

In Depth Information

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

Chapter 8

The Basics of Spreadsheets:

Numbers, Labels, and Formulas

In This Chapter

▶
Typing and formatting data

▶
Moving around a spreadsheet

▶
Searching a spreadsheet

▶
Editing a spreadsheet

▶
Printing

Everyone needs to perform simple math. Businesses need to keep track

of sales and profits, and individuals need to keep track of budgets. In the

old days, people not only had to write down numbers on paper, but they also

had to do all their calculations by hand (or with the aid of a calculator).

That’s why people use Excel. Instead of writing numbers on paper, they can

type numbers on the computer. Instead of adding or subtracting columns or

rows of numbers by hand, Excel can do it for you automatically. Basically,

Excel makes it easy to type and modify numbers and then calculate new

results accurately and quickly.

Besides calculating numbers, spreadsheets can also store lists of data

organized in rows and columns.

Understanding Spreadsheets

Excel organizes numbers in rows and columns. An entire page of rows and

columns is called a
spreadsheet
or a
worksheet.
(A collection of one or more

worksheets is stored in a file called a
workbook.
) Each row is identified by a