Topic 10 - Spreadsheets

Topic 10 - Spreadsheets

1. Cells

   • A cell reference always starts with a letter and ends with a number
     • A5
     • H28
   • A range of cells is a set of cells in a row or column
   • Data entered into cells can be different data types
     • Text
     • Currency
     • Date
   • Each cell can contain..
     • Labels
       • Any text in a cell describing data
     • Data
       • Any values entered for the use of calculation
     • Formulas and functions
       • Mathematical calculations carried out automatically

2. Formulas

   • Must start with an =
   • Formulas perform calculations on cell contents
   • Formulas appear in the formula bar
   • The result of a formula is automatically recalculated every time the data on a spread sheet changes
   • Mathematical operations
     • Add
       • +
     • Subtract
       • -
     • Multiply
       • *
     • Divide
       • /

3. Replicating Cells

   • When you position the mouse in the bottom right hand corner of the cell and drag down, the spread sheet applies that formula to all the cells included

4. Formatting

5. Graphs and Charts

6. Cell Referencing

   • Relative cell referencing
   • Absolute cell referencing

7. 'What if?'

8. Benefits of using a spreadsheet

9. Functions

   • Must start with an =
   • Part of spread sheet software
   • Specialised built in calculations
   • Examples
     • SUM
     • COUNT
     • AVERAGE