Spreadsheets

Spreadsheets

1. Cells

   • A cell reference always starts with a letter and ends with a number Eg. L11
   • A range of cells is a set of cells in a row or column
   • Data entered can be different types
     • Text
     • Currency
     • Number
     • Date
     • Percentage
   • Each cell can contain:
     • Data
     • Label
     • Formulas and functions

2. Formulas

   • Must start with an =
   • Formulas perform calculations on cell content
   • Appear in the formula bar
   • The result is automatically recalculated every time the data changes
   • 4 main calculations
     • Add (+)
       • =B3+C6
     • Subtract (-)
       • =G7-D4
     • Multiply (*)
       • =A2*E5
     • Divide (/)
       • =F6/H8

3. Formatting

   • Data Can be formatted:
     • Font style
     • Font Size
     • Text Colour
     • Border style
     • Cell Colour
     • Alignment
     • Cell size

4. Cell Referencing

   • Relative
     • When the formula is copied down the age the cell references are adjusted as the replication pointer is dragged down.
     • Takes into consideration the formula's new position
   • Absoloute
     • Used when a part of the formula needs to stay the same
     • Fixes that value in the formula
     • $
       • Used to fix the cell reference
         • Becomes $C$4
       • Can be applied by pressing the f4 Button

5. Benefits

   • Automatic recalculation
     • Recalculates every time data is changed
   • Accurate
   • Graphs and charts
   • Replication
   • Long calculations with large numbers

6. Graphs

   • Allows patterns to be noticed easily
   • Bar Graph
     • Patterns and comparison
   • Pie chart
     • To show how a total is divided
   • Line Graph
     • Display trends