Spreadsheet

Spreadsheet

1. Functions

   • IF Statement =(yes,no)
     • =SUM
     • Goal seek
       • The rule
         • =(A1*A2)
       • =AVERAGE
       • the operating system has its own spread sheet, application
       • using formulas and or functions
     • =MROUND
       • =TODAY
         • =MAXIMUM
           • =MINUMINUM

2. modelling

   • you can change the figures to predict results
     • so that variables can be changed to achieved on aoutcome

3. Formating

   • Colour chose
     • Font
     • Fill
       • background colour
         • percentages
           • fractions
             • accounting
       • text size
       • boarders
         • graphs and charts
           • in a sutiable format/for future use/spread sheets has a set of formats
         • currency
         • date and time
   • FORMATING TOOLS allows the user to present data professionaly and so that it is easier to read.

4. Data

   • Output
   • Input
     • Microsoft (Excel)
       • numbers (IOS)
     • Informations can be stored in (columbs, rows,cells)

5. storing means to arrange data in order, either ascending going up in value) or descending ( going down in value)

6. Uses

   • allows for calculations to be made
     • that can be entered by them self
       • using formulas and/or functions

7. a new page is called a worksheet