Spreadsheets

Spreadsheets

1. Functions

   • =Sum
   • =if statement
   • =MAX
   • =MIN
   • =AVERAGE
   • Mround
   • =Today

2. Data

   • Input
   • Output
   • Uses: data can be stored on this type of software
     • In a suitable format/for future uses, spread sheets has a set of formats
       • number
       • text
       • accounting
       • time/date

3. Formatting

   • colour
   • Conditional formatting
   • Changing text size
   • Changing font
   • =AVE
   • =if statement

4. Worksheets

   • Rows
   • Cells
   • Collum
   • A single page of worksheets are called a spreadsheet

5. Operating system have own spreadsheet application

   • Microsoft excel
   • IOS

6. In a suitable formation/for future uses, the spread sheet has a set of formats

   • Percentages
   • currency
   • Date/Time
   • Fractions
   • Text

7. USES

   • A single page of a spread sheet is called a worksheet
   • allows for calculations to be made
     • From figures
       • That can be entered by the user
       • using formulas and/or functions
   • Auto-update -allows user to change figures and results will change