Review Materials for Quiz 4

Tom Kelliher, CS14A

Mar. 24, 1997

The purpose of these materials is to clarify that material which will be covered by the upcoming quiz which you might not be very sure about. Some areas will not be mentioned here, because I was clear in my coverage; nonetheless these areas are covered by the quiz. Here are some examples:

1. The outline of The Paperback Computer.

2. The questions listed on each of the exercise (PowerPoint and Excel) handouts.

3. In-class Excel demonstrations.

Here are the clarifications:

1. Important ideas from Unit 4B of Computers in Your Future:
   1. ``What if'' questions; advantages of a spreadsheet. Visicalc, 1-2-3.

   2. Spreadsheet features:
      1. Control panel, icons, work area, status line.

      2. Rows, columns, cells, cell address, active cell.

      3. Contents of cells: labels, formulas, values. Functions.

      4. Cell ranges.

   3. Spreadsheet graphics:
      1. Advantages of graphs.

      2. Types of graphs: bar, pie, line