Making a basic spreadsheet

 

Making a basic spreadsheet

Paul uses a spreadsheet to keep track of his money.

  • He does a paper round and gets paid £15 for it every Monday.
  • He receives a £7 allowance on Tuesday.
  • He pays £3 for his weekly magazine subscription on Wednesday.

Making his spreadsheet

  1. He labels column A 'Day', column B 'Description', column C 'Incoming' and column D 'Outgoing'.
  2. He types 'Monday' into the cell beneath the row labeled 'Day'. He selects the cell’s fill handle and drags it down two cells. The spreadsheet completes the series and enters 'Tuesday' and 'Wednesday' for him.
  3. In the three cells beneath the label 'Description' he writes 'Paper round', 'Allowance' and 'Magazine subscription'.
  4. To the right of 'Paper round' and 'Allowance' he types the amount into the column labeled 'Incoming'.
  5. To the right of 'Magazine subscription' he types the amount into the column labeled 'Outgoing'.

It isn’t perfect, but it helps him keep track of his money. Next he needs to format it so it’s easier to read.

Cell B4 is being edited in the spreadsheet