Spreadsheet Programs

1
Spreadsheet Programs

• By John SullivanFall 2000

2
Microsoft Excel 2000

• Worksheets
• Charts
• Databases
• Web Support

3
The Excel Worksheet

• Column heading
• Row heading
• Cell
• Cell reference
• Range
• Active cell
• Gridlines
• Block plus sign

4
Worksheet Window

• Menu Bar
• Standard Toolbar and Formatting Toolbar
• Formula Bar
• Status Bar
• Speech Recognition and Playback
• Selecting a Cell
• Entering Text

5
Entering Numbers

• Can only contain
• 0 1 2 3 4 5 6 7 8 9 - ( ) , / . E e
• Enter Numeric Data
• Calculating a sum
• Sum function
• Auto sum

6
Using the Fill Handle to Copy a Cell to Adjacent
Cells

• Copy area
• Relative reference
• Fill handle

7
Formatting the Worksheet

• Font, Font Size, and Font Style
• Formatting Toolbar
• Auto format
• Put a Title across columns

8
Adding a 3-D Column Chart

• Chart Wizard
• Chart Location
• Y-axis
• X-axis
• Legend
• Default chart type

9
Other commands

• Saving a Workbook
• Printing
• Quitting
• Auto Calculate
• Correcting Errors
• Overtype
• Clearing a cell or range of cells
• Never use the space bar.
• Help

10
The End

• John Sullivan, Ph.D.