Spreadsheets

Spreadsheets

1. Benefits of using spreadsheets

   • Perform "What If" Investigations
   • Complete Automatic Recalculation
   • Complete Accurate Calculations
   • Easy to produce Graphs and charts

2. Components of Spreadsheets

   • Labels
     • Titles
     • Headings
     • Names
     • Identifying rows or columns of data
   • Data
     • Value that you enter into the spreadsheet
   • Formulas
     • Used to perform calculations on the cell content

3. Functions

   • A specialized calculation that the spreadsheet memorized
   • Averages
     • Find the averages of the number in the range of cells
   • SUM
     • Adds/Subtracts everything in selected cells

4. Formatting

   • Formatting Data
     • Data
     • integer
     • Percentage
     • Currency
     • Text
   • Formatting spreadsheets
     • Alignment
       • Left
       • Right
       • Centre
     • Text
       • Colour
       • Font Face
       • size
     • Border
     • Rotating text
     • Cell merging