Spread sheet

Spread sheet

1. Excel

   • Import Data
   • Export Data
   • Collect Formulas

2. Operating Systems Providers

   • Numbers (IOS)
   • Microsoft Excel

3. Data

   • import
   • Export
   • uses: data can be stored on the type of software
     • in a suitable format/for future use. spread sheets has a set of formats
       • time/date
       • number
       • text
       • fractions
       • accounting
       • 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, still colour .etc.
       • percentage
       • 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

4. Functions

   • =TODAY()
   • =MIN()
   • =MAX()
   • =AVE()
   • = if statement
   • =Mround
   • Autosum()

5. Uses

   • allows for calculation figures and results will change
   • from figures
     • that can be entered by the user
     • using formulas and/or functions
   • A singe page of a spread sheet is called a worksheet
   • Auto-update- allows users to change figures and results will change

6. modelling

   • goal seeking
     • graphing
       • so that results can be compared visually/trends identified
     • so that variables can be changed to achieves an outcome
   • you can change figures to predict results

7. operating systems have own spread sheet application

   • Microsoft Excel
   • Numbers (IOS)

8. information can be stored in a cell/rows/columns/tables

   • spread sheet software is an application, for storing, calculating and displaying data, is an organised files called spread sheet
   • storing means to arrange data in order, either ascending (going upin value) or descending (going down in value)