Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
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
He labels column A 'Day', column B 'Description', column C 'Incoming' and column D 'Outgoing'.
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.
In the three cells beneath the label 'Description' he writes 'Paper round', 'Allowance' and 'Magazine subscription'.
To the right of 'Paper round' and 'Allowance' he types the amount into the column labeled 'Incoming'.
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 formatThe appearance of a document, including the fonts, colours, size and rotation. it so it’s easier to read.