spread sheet

spread sheet

1. DATA

   • Import
   • Export
   • USES: Data can be stored on this type of software
     • in a suitable format/for future use, spread sheets has a set of formats
       • currency
       • text
       • fractions
       • number
       • time/date
       • accounting
       • percentages
       • 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.
   • information can be stored in a cell/rows/columns/tables
     • 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
     • spread sheet software is an APPLICATION, for STORING, CALCULATING and DISPLAYING DATA in an organised files called spread sheets
       • STORING means to arrange data in order, either ascending (going up in value) or descending (going down in value)

2. Operating Systems have own spread sheet application

   • Microsoft Excel
   • Numbers (IOS)

3. Functions

   • AutoSum()
   • =Today()
   • =Max()
   • = Min()
   • =AVE()
   • =if statements
   • =Mround

4. USES

   • allows for calculations to be made
     • from figures
       • that can be entered by the user
       • using formulas and/or functions
   • 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
     • a single page of a spread sheet is called a worksheet
   • Auto-update - allows users to change figures and results will change