Workbooks are a collection of worksheets.

Tables Tables organize and store data within worksheets.

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet, such as charting and Web support.

The recommended methodology for creating worksheets includes: (1) analyze requirements (supplied in a requirements document); (2) design solution; (3) validate design; (4) implement design; (5) test solution; and (6) document solution.

After carefully reviewing the requirements document

the next step is to design a solution or draw a sketch of the worksheet based on the requirements, including titles, column and row headings, location of data values, and

chart

The workbook

is like a notebook. Inside the workbook are sheets, each of which is called a worksheet. Excel opens a new workbook with three worksheets.

If necessary, you can add additional worksheets as long as your computer has enough memory to accommodate them.

A column letter above the grid, also called the column heading, identifies each column. A row number on the left side of the grid, also called the row heading, identifies each row.

The intersection of each column and row is a cell. A cell is the basic unit of a worksheet into which you enter data

A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.

You view the portion of the worksheet displayed on the screen through a worksheet window

The default (preset) view is normal view.

Below and to the right of the worksheet window are scroll bars, scroll arrows, and scroll boxes that you can use to move the worksheet window around to view different parts of the active worksheet

The status bar presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.

Mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel. When the mode is Ready, Excel is ready to accept the next command or data entry. When the mode indicator reads Enter, Excel is in the process of accepting data through the keyboard into the active cell.

Keyboard indicators, such as Scroll Lock, show which toggle keys are engaged. Keyboard indicators appear to the right of the mode indicator. Toward the right edge of the status bar are buttons and controls you can use to change the view of a document and adjust the size of the displayed document.

Reading or viewing a Downloadable eTextbook is limited to use on one computer