Spreadsheet

Spreadsheet

1. Data

   • Import
   • Export
   • Uses data can stored on this type of software
     • In a suitable format/for future use, spread sheets has a set of formats
       • Number
       • Time/Date
       • percentages
       • Currency
       • Accounting

2. Function

   • =MIN()
   • =MAX()
   • =SUM()
   • =AVERAGE()
   • =IF()
   • =TODAY()
   • =Mround()

3. Formatting

   • Text Colour
   • Fill Colour
   • Background Colour
   • Front Size
   • Outline Box or Shape or Logo

4. Worksheet

   • Cells
   • Coloum
   • Rows

5. Operation Systems has their own spread sheet application.

   • Number (IOS)
   • Microsoft Excel (Windows)

6. Modelling

   • Goal Seek
   • Graphing
     • So that results can be compared visually/trends indentified
   • Uses
     • allows for calculations to be made
       • that can be entered by the user
         • using formulas or function

7. Auto update - allows users to change facts and figures and it will update automatically