2. Worksheet Basics

How Worksheets Work

Microsoft Excel is most commonly used to create worksheets. A worksheet is a collection of information laid out in columns and rows. As illustrated in Figure 1, each worksheet cell can contain one of two kinds of input:

• A value is a piece of information that does not change. Values can be text, numbers, dates, or times. A cell containing a value usually displays the value.

• A formula is a collection of values, cell references, operators, and predefined functions that, when evaluated by Excel, produces a result. A cell containing a formula displays the results of the formula.

Figure 1. This very simple worksheet illustrates how a spreadsheet program like Excel works with values and formulas.

Although ...

Get Microsoft Office Excel 2007 for Windows: Visual QuickStart Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.