Spreadsheets

Spreadsheets

1. Benefits

   • Formulas automatically recalculate when data changes
   • Doesn't make maths errors
   • Charts/graphs are easy to produce
   • Change information to make and test predictions
   • Easily works with numbers

2. Formulas

   • Adding cells, =A1+B1
   • Subtracting cells, =A2-B2
   • Multiplying cells, =A3*B3
   • Dividing cells, =A4/B4

3. Formatting

   • Coloured borders
   • Merged cells
   • Background fill
   • Can be formatted by data type
   • Font (colour, style, bold, italics)