Part 7. Getting Started with Excel

When you start the application, Excel displays a blank workbook. A workbook is a file in which you store your data, similar to a three-ring binder. Within a workbook are worksheets, chart sheets, and macro sheets. A new workbook contains three sheets, named Sheet1 through Sheet3. You can add sheets, up to 255 per workbook, depending on your computer's available memory.

Multiple sheets help you organize, manage, and consolidate your data. For example, you might want to create a sales forecast for the first quarter of the year. Sheet1, Sheet2, and Sheet3 could contain worksheet data for January, February, and March; Sheet4 could be a summary for the three months of sales data; and Sheet5 could be a chart showing sales over the three-month period.

A worksheet is a grid of columns and rows. The intersection of any column and row is called a cell. Each cell in a worksheet has a unique cell reference the designation formed by combining the row and column headings. For example, A8 refers to the cell at the intersection of column A and row 8.

The cell pointer is a cross-shaped pointer that appears over cells in the worksheet. You use the cell pointer to select any cell in the worksheet. The selected cell is called the active cell, and you always have at least one cell selected.

A range is a specified group of cells. A range can be a single cell; a column; a row; or any combination of cells, columns, and rows. Range coordinates identify a range. The first element in the range coordinates is the location of the upper-left cell in the range; the second element is the location of the lower-right cell. A colon (:) separates these two elements. The range A1:C3, for example, includes the cells A1, A2, A3, B1, B2, B3, C1, C2, and C3.



Easy Microsoft Office 2003
Easy Microsoft Office 2003
ISBN: 0789729628
EAN: 2147483647
Year: 2003
Pages: 281
Authors: Nancy Lewis

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net