Spreadsheet

Spreadsheet

1. Formulas

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

2. Data

   • inport
   • export
   • Information can be stored in a cell/rows/columns/tables
   • 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
       • Text
       • Fractions
       • Accounting
       • Number
       • 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.
   • Create a table out of
   • 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

3. Formatting

   • Change the font
   • Change colour
   • Change font size
   • Conditional Formatting

4. Worksheets

   • Column
   • Cells
   • Rows
   • A single page of worksheet is called a spreadsheet

5. operating systems have own spread sheet application

   • Microsoft excel
   • Numbers (IOS)

6. Modelling

   • Goal seek
   • Graphing
   • So that results can be compared visually/trends identified
   • You can change figures to predict results
   • Results can be compared visually

7. USES

   • Auto-update: Allows users to change figures and results will chchange
   • Allows for calulations to be made
     • From figures
       • that can be entered by the user
       • using formulas and/or functions