**Tom Kelliher, CS14F**

**Oct. 24, 1996**

- The first
**killer app**--- VisiCalc for the Apple II. - Lotus 123 for the IBM PC.
- Uses:
- Simple personal finances: check book, loans, etc.
- ``Number processor'' --- grinding out results from data.
- Charts, graphs --- making data understandable.
- Simple databases.

- Simple personal finances: check book, loans, etc.
- ``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`. - Number.
- Formula. 3 examples:
=A1*B1 =C2+C3 =SUM(A1:A10)

- Active cell.
- Mathematical operators: addition, subtraction, multiplication,
division, exponentiation.
- Mathematical functions: statistical, financial, logical, database,
scientific, etc.

- Text (label):
- Range:
- Specified by
*upper-left*:*lower-right*. - Row, part of a row.
- Column, part of a column.
- Rectangular region.

- Specified by

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.

- Bar graphs --- compare values.

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
the directory `CS14F\PROFNOTE\EXCEL`

.

Tue Oct 22 22:20:49 EDT 1996