Spreadsheet

Spreadsheet

1. Functions

   • =sum
     • =average
     • goal seek
   • Calculations
     • cells
       • rows
         • columns

2. Formatting

   • text font
     • colour

3. what IF statement

4. produce graphs and charts

5. Data

   • output
     • input
   • uses:data can be used from this type of software
     • in a suitable format/the future use spreadsheets has a set of formulas
       • accounting
         • time data
           • percentages
             • text
               • currency
                 • functions
                   • number

6. modelling

   • goal seek
     • graphing
       • results can be compared visually
         • USES
           • Allow calculations to be made
             • from figures
               • that can be entered by the user
                 • using formulas or functions

7. operating system have own spreadsheet application

   • number (ios)
   • Microsoft excel