Excel 2000
The Excel Window
Introduction
Microsoft Excel 2000 is a spreadsheet application in the Microsoft Office Suite. A spreadsheet is an accounting program for the computer. Spreadsheets are primarily used to work with numbers much like Microsoft Word is used to work with text. Spreadsheets calculate and analyze information by using mathematical formulas.
By the end of this lesson, learners should be able to:
- Identify the parts of the Excel window
The Excel Window
When you open Excel, many items you see are standard in most Windows 95 or 98 programs. A few things are specific to Excel 2000.
Toolbars
Toolbars can be customized and offer a series of commonly used Excel features
Column Headings
Each Excel spreadsheet has 256 columns
Row Headings
Each spreadsheet has 65,536 rows
Name Box
Shows the address and name of the current selection
Formula Bar
Displays the current entry (as you are typing or editing) or the contents of the current cell
Cell
An intersection of a column and row. Each cell has a cell address. In the above picture, the cell address of the selected cell is A1. The heavy border around the selected cell is called the cell pointer.
Navigation Buttons
Allow you to move to another worksheet in an Excel workbook easily
Sheet Tabs
Allow you to move around the workbook easily
The Excel Workbook
When you open Microsoft Excel, a workbook automatically shows in the workspace.
Important Terms
- A workbook is made up of three worksheets.
- The worksheets are labeled Sheet1, Sheet2, and Sheet3.
- Each Excel worksheet is made up of columns and rows.
- In order to access a worksheet, click on the tab that says Sheet#.
To Change the Number of Worksheets:
- Choose Tools
Options. - In the Options dialog box, click the General tab.
- Click on the spin box controls (up and down arrows) to change the number of worksheets in a new workbook.
The Cell
The Excel worksheet is made up of columns and rows.When these columns and rows intersect, they form little boxes called cells.
Important Terms
- Each cell has a unique cell address composed of a cell's column and row.
- The active cell is the cell that receives the data or command you give it.
- A darkened border, called the cellpointer, identifies it.
Moving the Cell Pointer
- To activate any cell, click the cell.
- To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys.
- To see other areas of the worksheet, use the scroll bars. To scroll large distances, hold the Shift key while dragging the scroll bar.
Some frequently used keyboard commands:
PgDn: Down one screen
PgUp: Up one screen
Home: To column A in the current row
Ctrl + Home: To cell A1
Challenge!
- Use the horizontal and vertical scroll bars to explore the Excel worksheet.
- Now, explore using PgUp, PgDn, Home, and Ctrl + Home.
- To see other areas of the worksheet, use the scroll bars. To scroll large distances, hold the Shift key while dragging the scroll bar.