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’s spreadsheet is messy and needs some formatting applied to make it more presentable and easier to read.
He centres 'Day', 'Description', 'Incoming' and 'Outgoing', bolds them and fills the cells with light grey to make them stand out.
He also resizes the cells so the labels fit and increases the height of his rows to space them out.
He changes the type of dataValues, typically letters or numbers. in the cells beneath 'Incoming' and 'Outgoing' to ‘Currency’.
He applies borders to all of the cells.
He changes the vertical alignment of the cells in columns C and D to ‘Center’.
It looks much better now but it needs a formulaA combination of symbols that indicates the chemical composition of a substance. to work out how much money he’s left with at the end of the week.
Download a new version of with formatting applied.