Exercise 1

Create an expense sheet to calculate how long you will have to save before you can buy what you want to buy.
  • start by looking over the
    How to ~ Start page for basic spreadsheet data entry
  • click on cell A1 and type
    If I could save, I could buy...
  • in cell A2 type Item cost
  • continue typing in cells A3 to A6 as shown at right

  • in cell B5 type the formula shown
  • in cell B6 type the formula shown
  • try entering different numbers in cells B2, B3, and B4 and see the power of a spreadsheet.
  • click to add the lines
ex2-1-2.jpg (26182 bytes)
  • save your work as ex1 in H: so that you can find it easily at marking time.