Spreadsheets Software

Spreadsheets Software

1. Benefits

   • Can perform 'WHAT IF' investigations
   • Automatic re-calculations
   • Accurate calculations
   • Easy to produce graphs and charts

2. Components

   • Labels
     • Used for titles, heading, names, etc
   • Data
     • Values (text or numbers)
   • Formulas
     • Used to perform calculations

3. Functions

   • A specialised calculation
   • Average
     • Example: to find average of A3 to A10 you could use: '=AVERAGE(A3:A10)
   • Sum
     • Example: '=SUM(E3:P3)

4. Formatting

   • Alignment
     • Example: left, centre and right
   • Text
     • Example: colour,font face or size
   • Borders
   • Rotating text
   • Cell merging