Excel 2002 Basics: Workbook, Worksheet, Cells

1. Microsoft Excel 2002—The Basics Presented by: Kyle Kuehler Instructional Technology Specialist kkuehler@esc17.net (806) 281-5805

2. Some Definitions 􀂾A workbookis an Excel file that includes one or more worksheets. 􀂾 A worksheetis the grid of columns and rows where you enter information. (Some people refer to a worksheet as a spreadsheet.) 􀂾 A worksheetcontains 256 columns and 65,536 rows. 􀂾 A columnis a vertical collection of cells represented by alphabetical letters. 􀂾 A rowis a horizontal collection of cells represented by numbers. 􀂾 A cellis the intersection of a column and a row. The active cellis marked with a dark outline border around the cell. 􀂾 A cell’s addressis its column letter followed by its row number, as in cell B3.

6. Commonly Used Buttons (cont.)

7. Activity: Try the following ways to move from cell to cell: • • Press the Return/Enter key to move down to the row below • • Hold down the Shift key, then hit the Return/Enter key to move up to • the row above • • Press the Tab key to move over to the column to the right • • Hold down the Shift key, hit the Tab key to move back to the column to • the left • • Move the mouse to any cell and click there • • Use the arrow keys to move up, down, left, or right. • • Click in the Name Box and type the cell you want to move to. • • Choose EditGo ToType in the cell you want to move to/OK • • Choose Ctrl + G/Same as EditGo To • • Choose Home and it will move you to the first cell in current row • • Choose Ctrl + Home to move to the first cell in the worksheet • • Choose Ctrl + End to move to the last used cell in the worksheet • • Choose F5Go ToType cell reference in Reference text box then • Click OK

8. Entering Data • Excel recognizes two basic kinds of data in a cell • Label-text data • Value-numbers or +-.=$ entered as first character in the cell • To enter text in a cell: • Type the text in the appropriate cell • Press enter, press an arrow key, click on a different cell, or click the enter box

9. Deleting Text • To completely erase the contents of a cell, click on the cell and press delete. • To erase part of the text in a cell, click on the cell and double click on the cell or click once to select the cell and make changes in the formula bar.

10. Borders • To show specific borders • Select the area where you want to add borders • click the arrow by the borders button and choose the appropriate border selection.

11. Adjusting Row and Column Width • Click on the line between the row or column headings and drag to the appropriate width (or) • Double click the line between the row or column headings to automatically size the column or row to the necessary width

12. Inserting Rows and Columns • Click the row or column heading • Right Click and select insert • All information is shifted down or to the right and a new row or column is inserted • Select a cell and click InsertRows (or Columns)

13. Websites for Training Documents • http://go.cas.psu.edu/howto/HowToList.cfm?Cat=Excel • http://www.lubbockisd.org/technology/InstructionalCompMatrix.htm