Spreadsheets T10

Spreadsheets T10

1. A spreadsheet application such a excel can store its data in a single file. This is called a workbook

   • A work book Is made up of one or more 'Worksheets@

2. Cells

   • A cell reference always starts with a letter and finish's with a number
   • Labels
     • any text in a cell describing the data in a row or column
   • Data
     • Any values that are entered for the use of calculation
   • Formulas and functions
     • mathematical calculations carried out automatically

3. Formulas

   • must start with =
   • perform calculations on cell contents
   • =(B3*C6) +E12
   • + Add
   • - Subtract
   • * Multiply
   • / Divide

4. Functions

   • must start with =
   • are part of the spreadsheet software
   • SUM
   • AVERAGE
   • MIN
   • MAX
   • IF

5. Formatting

   • Content of the cell can be formatted
   • font style
   • Colour
   • Border style
   • cell colour
   • Size
   • Data Types
     • Currency
     • Number
     • Real/ Integer
     • Date
     • Text

6. Replicating cells

   • when you position the mouse pointer in the bottom right hand corner of the cell and drag down

7. Graphs and Charts

   • allow you to notice patterns
   • Bar Charts
     • Compare values
   • Pie Charts

8. Cell referencing

   • Relative Cell Referencing
     • when you drag down a formula the cell references change . this is because it uses relative address of the cell based on the position of the worksheet
   • Absolute Cell references
     • use the $ character in front of the letter and number that are required to stay the same (glued)

9. What if calculations

   • allow you to see what would happen if certain figures were changed
   • allow you to make and test predictions

10. Benefits of a spreadsheet

    • Automatic recalculations
    • Accurate calculations
    • Graphs and charts
    • Replication
    • What if calculations
    • Calculations involving large numbers are possible