Tom Kelliher, CS14F
Oct. 24, 1996
- The first killer app --- VisiCalc for the Apple II.
- Lotus 123 for the IBM PC.
- Simple personal finances: check book, loans, etc.
- ``Number processor'' --- grinding out results from data.
- Charts, graphs --- making data understandable.
- Simple databases.
- ``What if'' questions.
- Much of Excel's window is similar to Word's window.
- Columns --- lettered.
- Rows --- numbered.
- Cell --- intersection of row and column. Can contain:
- Text (label): Monthly sales.
- Formula. 3 examples:
- Active cell.
- Mathematical operators: addition, subtraction, multiplication,
- Mathematical functions: statistical, financial, logical, database,
- Specified by upper-left: lower-right.
- Row, part of a row.
- Column, part of a column.
- Rectangular region.
Copying/moving cells with formulas --- what happens to the formulas?
- Business graphics vs. presentation graphics.
- Types of graphics:
- Bar graphs --- compare values.
- Pie charts --- see relationship to whole.
- Line graphs --- trends over time.
Do projects one and two in Excel Essentials. When completed, print
and turn-in each project. The project files are on the R: drive, in
Thomas P. Kelliher
Tue Oct 22 22:20:49 EDT 1996