Exel Spread sheet

Exel Spread sheet

1. Data

   • Import
   • Export
   • Each cell has a unique cell address which acts like a pair of co-ordinates. It tells you which row or column the cell is in.
   • Uses: Data can be stored on this type of software
     • In a suitable format/for future use, spread sheet has a set of formats.
       • Number
         • Tme and Data
       • Accounting
       • Fractions
       • Text
       • Formatting tools allow the user to present data professionally and so that it is easier to read

2. Operating System

   • Numbers(IOS)
   • Microsoft Exel
   • Operating Systems have own spread sheet application

3. Functions

   • =Sum()
   • =Today()
   • =Max()
   • =Ave()
   • =IF statement
   • =Min()
     • =AutoSum()
   • =MRound

4. Information can be stored in a cell row/columns/tables

   • Spread sheet software is an application for storing, calculating and displaying data in a organised files called spreadsheets
     • Storing means to arrange in order, either ascending (going up) or ascending (going down) in value.

5. Modelling

   • Goal Seek
     • you can change figure to predict results
     • so that the variable can be changed to achieve an outcome
   • Graphing
     • So that the result can be compared visually and trends identified

6. Uses

   • Information can be stored in a cell/row/columns/tables
     • Allows for calculations to be made
       • From figures
         • Using formulas and/or functions