Spreadsheets

Spreadsheets

1. benefits

   • graphs and charts can be drawn using the data selected replication
   • automatic recalculations
   • replication

2. spread sheets are used for calculations

   • they can help with real life situations

3. functions

   • =SUM(A1:E1)
   • =AVERAGE(A1:E1
   • =IF(A1>49,"PASS","FAILS"
   • =MIN(A1:E1)
   • =MAX(A1:E1)

4. data is in the text or numbers you type in.

5. formulas are automatic calculations

6. labels are headings explaining the data

7. The font type can be changed e.g size font colour style

8. cells can be merged or combined together

9. the background fill tool can change the colour of a cell

10. coloured borders, or lines can be added to the edge of each cell.