Spreadsheet

Spreadsheet

1. Formatting

   • Decorating the cells and background.
     • Text font
       • Colour of the font can be changed
   • Change of font size
   • Type style
   • Sheet background
     • Apply or remove cell borders

2. Formula

   • =sum
     • =max
       • =min
       • =Mround
   • Calculations
     • Cells
       • Colour
         • Add colours onto font
       • Can move shift or imput.
   • Autosum()
     • =Today()
       • =if =statements

3. Modelling

   • Goal seek
     • Graphing
       • So that results can compare visually.
   • Results can be compared visually
   • USES
     • Allow calculations made
     • From figures
       • That can be entered by the user
         • Using formulas and/or functions

4. Data

   • Import
     • Export
   • Uses:Data can be used from this type of software
     • In a suitable format/for future use spread sheets has a set of formulas
       • percentages
       • currency
       • functions
         • number
       • text
       • Accounting
         • Time/Date
       • Fractions

5. Functions

6. Operating System have own spreadsheet application

   • Microsoft Excel
   • Numbers (IOS)