Spreadsheet Software by Adam Williamson

Spreadsheet Software by Adam Williamson

1. Benefits of using spreadsheets

   • 'What If' Investigations
   • Automatic Recalculations
   • Easy to produce graphs and charts
   • Accurate Calculations.

2. Components of Spreadsheets

   • Labels
     • Used for titles, headings, names
   • Data
     • Text or numbers
   • Formulas
     • Perform calculations

3. Functions

   • Specialised calculation that the spreadsheet has memorized
   • AVERAGE(A3:A10)
   • SUM(E3:P3)

4. Relative

   • Will moved when copied

5. Absolute

   • Will stay the same when copied

6. Formatting Data

   • Data
   • Inter
   • Percentage
   • Currency
   • Text

7. Formatting your spreadsheet

   • Alignment (Left,right,centre)
   • Text (colour, font face, size)
   • Borders
   • Rotating text
   • Cell Merging