Spreedsheets

Spreedsheets

1. Cell type

   • Text
   • Number
   • Currency
   • Date
   • Hyperlinks

2. Data stored in cell

   • Text
   • Numbers
   • Boolean
   • Formulas
     • Ways to used
       • Relative
         • change when a formula is moved to another cell.
       • Absolute
         • always refer to exactly the same cell, even if the entire formula is moved or copied to another cell.
     • Types
       • Logic function
         • help the spreadsheet decide how to act, e.g. the IF function.
       • Mathematical function
         • calculate numerical answers, e.g. the SUM function
   • Cells
   • Errors

3. Sorting, filtering and replicating data

4. Types of charts

   • Scatter plot graph
   • Bar graph
   • Line graph
   • Excel pie chart

5. Formatting and presentation

   • eg.
     • Background
     • Paragraph
     • Text (fonts)
     • Pages
       • -Formatting the toolbar -Formatting the cell -Copying the presentation format as a template -More advanced concepts -Conditional format -Autoformat

6. Data validation, verification and testing

   • Data validation
     • to reduce the number of errors made when entering data into a database and choosing the correct data types, by checking whether data is sensible
     • validation cannot stop the wrong data being entered
     • Types
       • Check digit Format check Length check Lookup table Presence check Range check Spell check
   • Data verification
     • to check the data that you have entered against the original source data.
     • Methods
       • Double entry
       • Proofreading data
   • Data testing

7. Functions

   • Basic
     • Maths
     • Text
     • Logic
     • Date
   • Advanced
     • Lookup
     • Pivot tables
     • Macros