Spread Sheet

Spread Sheet

1. Operating System Providers

   • Microsoft Excel
   • Numbers (105)

2. Excel

   • Import Data
   • Export Data
   • Collect Formuls

3. Functions

   • =Mround
   • AutoSum()
   • =Max()
   • =Min()
   • =AVE()
   • =Today()
   • =IF Statements

4. Data

   • Import
   • Export
   • USES: Data can be stored on this type of software
     • In suitable format/for future use , spread sheets has a set of formats
       • Time/Date
       • Accounting
       • Number
       • Fractions
       • Text
       • FORMATTING TOOLS allows the user to present data professionally and so that it is easier to read e.g Font Style/ Colour/ Size/Cell Borders/ Fill Colour etc.
       • Percentages
       • Currency
   • Each cell has a unique cell address which acts like a pair of coordinates , it tells you which row (number) or column (letter) the cell is in.

5. USES

   • Allows for calculation figures and results changed
     • From Figures
       • That can be entered by the user
       • Using formulas and / functions

6. Operating systems have own spread sheet application

   • Numbers (105)
   • Microsoft Excel

7. Modelling

   • You can change figures to predict results
   • Goal Seek
     • So that variables can be changed to achieve an outcome
     • Graphing
       • So that results can be compared visually / trends identified