Spread Sheet

Spread Sheet

1. Functions

   • =Min()
   • =Average()
   • =Max()
   • =Today()
   • =Sum()
   • =MROUND()
   • =If Statement

2. Information can be stored in a cell/rows/columns and tables

   • Modelling
     • Goal Seek
       • You can change predictions results so that variables that can be changed to get an outcome
       • You can change figures to predict results
     • Graphing
       • So that the result can be compared between each other and visually identified.

3. Data

   • Import
   • Export
     • Each cell has unique cell address so if you type in which number and letter and will take to the spot you like or chose.
   • USES: The uses of data
     • Formatting
       • Time/Date
       • Number
       • Accounting
       • Fractions
       • Text
       • Percentages
       • Currency
       • Formatting Tools: allows the user tp present data professionally and so that ut is easier to read

4. Uses

   • You are able to calculate
     • From Figures
       • That can be entered by the user
       • Using formulas and/or it can be functions
   • Auto-update - allows users to change figures and results will change

5. Storing means to arrange data within order, either it will be ascending (Going up in value ) or descending ( Going down in value)

6. Spread sheet software is an application and for storing, calculating and displaying data called spread sheet