Spreadsheets can be used in the finance department to produce graphs and charts of financial information. The formulae function within the spreadsheet can be used to carry out instant calculations accurately. Formulae will also amend calculations automatically when the spreadsheet is updated.