Excel Spread sheets

Excel Spread sheets

1. Data

   • Import
   • Export
   • Each cell has a unique cell address which acts like a pair of cor-ordinates, it tells you which row (number)or column (letter)the cell is in.
   • USES: Data can be stored on this type of software
     • In a suitable format/for future use, spread sheets have a set of formats.
       • PERCENTAGES
       • CURRENCY
       • TIME/DATE
       • NUMBER
       • ACCOUNTING
       • 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 border +fill colour

2. Operating System

   • Numbers (IOS)
   • Microsoft Excel

3. Functions

   • =MAX()
   • =AUTOSUM()
   • =MIN()
   • =Today()
   • =AVE()
   • =IF STATEMENTS
   • =Mround

4. information can be stored in a cell row/coloumn/tables

   • spread sheet software is an application for stroing, calculationg and displaying data in organised files called spreadsheets.
     • Storing means to arrange in order., either ascending ( going up ) or descending ( going down ) in value.

5. Modelling

   • Goal seeking
     • Graphing
       • So that the result can be compared visually and trends identified.
     • So that the variable can be changed to achieve an outcome
       • You can change figures to predict results.
   • USES
     • Allows for calculations to be made
       • From figures
         • That can be entered by the users
         • Using formulas and/or functions
     • AUTO- UPDATE allows users to change figures and results will change.