spreadsheet software mind map

spreadsheet software mind map

1. benefits of using a spreadsheet

   • you can perform "what is"
   • it can complete automatic recalution
   • it can complete accurate calculation
   • it is easy to produce graphs and charts

2. components of spreadhseet

   • labels
   • data
   • formula

3. functions

   • is a specialzed calulations that the software memorizes
   • Average
     • fine a average number in a range of cells from A3 to A10 you could use: =AVERAGE(A3:A10)

4. Referencing

   • relatve reflecting
     • moves
   • absolute referencing
     • stays in position

5. formatting data

   • data
   • integer
   • percentage
   • currency
   • text

6. formatting spreadsheet

   • alignment
   • text
   • borders
   • rotating text
   • cell merging