Spreadsheets

Spreadsheets

1. Benefits

   • When data changes, formulas automatically recalculate.
   • Computers do not make mathematical errors like humans, but GIGO (Garbage In Garbage Out) still applies.
   • Charts and graphs can be produced and customized very easily.
   • You can change information in a spread sheet model to make and test predictions (what IF investigations).

2. Formatting

   • Coloured borders, or lines, can be added to the edge of each cell.
   • Cells can be formatted according to their data type e.g cells with money can automatically have a pound (£) sign placed at the front by assigning a currency data type.
   • Cells can be merged or combined together, e.g cells A1:C1 can merge to form one big cell of A1.
   • The font can be changed, e.g font style, colour, bold or italics.
   • The background fill tool can change the colour of the cells.

3. Formulas

   • =A1=B1 - The plus sign here adds up cells A1 and B1.
   • =A1-B2 - The minus sign takes away B2 from A2.
   • =A3*B3 - The asterisk sign multiples A3 by B3.
   • =A4/B4 - The forward slash sign divides A4 by B4