Ch. 13: Spreadsheets

Many spreadsheet titles.
Same principles; usually similar interface.
Two-dimensional array of cells.
1. Click on one and enter what you like.
2. Various data types.
3. Rows are numbers, columns are lettered. Cells have names like B7.
4. Rows and columns can be re-sized.
5. Cells can be formatted like word-processor data.
Can select rectangles of cells and apply operations to them all.
1. Formatting operations.
2. Sorting the rows.
Computing in a spreadsheet.
1. Instead of entering data, you can enter a formula to compute the value from other cells.
2. Usually start typing with an =.
3. Refer to other cells by name, like C20.
4. Usual arithmetic, many special functions.
5. Copying and pasting.
  1. Can copy and paste a formula.
  2. Can paste into a selected range to reproduce many copies.
  3. References are changed.
    1. References are considered relative to the containing cell.
    2. Modified to denote the same position relative to the new location.
    3. Absolute references prevent: R$9, $R9 $R$9