spreadsheets

spreadsheets

1. benefits of using spreadsheets

   • IF investigation
   • automatic recalculation
   • automation calculator
   • easy to produce charts and graphs

2. components of a spreadsheet

   • labels
   • data
   • formulas

3. functions

   • average
     • creates an average by adding them all up then dividing them by how many is added together
   • sum
   • min
   • max

4. formatting data

   • data
   • interger
   • percentage
   • currency
   • text

5. formatting your spreadsheet

   • alignment of text
   • text
   • boaders
   • rotating text
   • cell merging