Spreadsheet software

Spreadsheet software

1. structure

   • Data
     • Raw facts and figures
   • Labels
     • Text entries such as a heading
   • Formulas
     • Numbers that can be used to calculate important figures

2. Functions

   • Are specialist calculations
     • Financial calculations
   • AVERAGE
     • finds out the average of a selection of numbers
   • COUNT
     • counts how many of a specific item there is

3. Cell Referencing

   • Relative
     • adjusts formulars to fit with the cell
   • Absolute
     • doesn't adjust the formular to fit in the cell

4. Formats

   • Font type/size/colour
     • makes text look more appeling
   • Bold italic underline
     • makes it easier to make a glossery
   • To hold certain types of data
     • dosent have to contain just text

5. Advantages

   • Accurate calculations
   • Automatic recalculation
   • "What if" investigations
   • Easy to produce graphs and charts