Spreadsheets

Spreadsheets

1. benefits

   • can preform complex calculations
   • when data is changed it automatically recalculates
   • computers don't make mathematical errors unlike humans making them great for long complex calculations
   • charts and graphs can be made and customized with ease
   • they made working with numbers a lot easier

2. formulas

   • are automatic calculations that update as you enter data
   • some type of formula are used to add, divide, subtract and multiple
   • =SUM(A1:E1) can be used to add multiple cells together quickly
   • =AVERAGE(A1:E1) can be used to find the average of multiple cells

3. formatting

   • a spreadsheet is made up of cells that have a corresponding letter and number
   • you can put border on your cells to make them stand out
   • you can also colour your cells to make them stand out is it is critical data

Bilder und Dateien der Mindmap