Objectives

• Describe a spreadsheet.
  • Define Row, Column, cell
  • Describe how each is labeled
  • Suggest several potential applications
• Distinguish between a formula and a constant.
• Perform basic spreadsheet operations.
• Show how to print a spreadsheet in computed values or cell formula mode
• Print spreadsheets in various modes.

Introduction

• Ledger Book - think of Bob Cratchit , or a bill of sale.
  • 
  • Entries are made when things are purchased
  • Totals are calculated from these entries
  • We can set things up so that the machine does the totals for us.
  • And so much more.
• A spreadsheet is arranged in Rows and Columns
  • Columns go up and down (Hold up the roof on the Parthenon)
  • 
  • Rows go from left to right (row your boat)
  • 
• Columns are labeled with letters
• Rows are labeled with numbers
• A cell is a point where a row and column intersect, and are labeled with a letter and a number.
• 
• Into these cells we can put:
  • Constants - values that do not change automatically
  • formulas - calculations
  • 
• Instead of an insertion point, we have the "Active Cell"

More Work

• We discuss how to print out the page in this section
• Pay attention to this.

Please do hands on exercises 1.1 and 1.2 Pages 11-18 and 23-32. Please print out the final example on page 31 only. Make sure you put your name in cell A12 and Homework 14 in cell A13.