Data Analysis with Microsoft Excel: Updated for Office 2007

14 Excel

Clearly, the Park workbook is complex. Its sheets contain many pieces of

information, much of it interrelated. This book will not cover all the tech-

niques used to create a workbook like this one, but you should be aware of

the formatting possibilities that exist.

Worksheet Cells

Each worksheet can be thought of as a grid of cells, where each cell can

contain a numeric or text entry. Cells are referenced by their location on

the grid. For example, the total number of visitors at the park is shown in

cell F17 of the Total Usage worksheet (see Figure 1-11.) As you’ll see later

in Chapter 2, if you were to use this value in a function or Excel command,

you would use the cell reference F17.

Active cell

Figure 1-11

Excel cell

references

cell address

appears in the

Name box

Selecting a Cell

When you want to enter data or format a particular value, you must fi rst

select the cell containing the data or value. To do this, you simply click

on the cell in the worksheet. Try this now with cell F17 in the Total Usage

worksheet.