Spreadsheets

Spreadsheets

1. Benefits

   • Automatic Recalculation - When data changes, formulas automatically.
   • GIGO - Computers do not make mathematical errors like humans, but GIGO (Garbage In, Garbage Out) still applies.
   • Charts And Graphs - Charts and graphs can be produced and customized very easily.
   • What-IF - You can change information in a spreadsheet 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 could automatically have a pound (£) sign placed on 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

   • There are four main types of formula used in spreadsheets: =A1+B1 - the plus sign here ADDS UP cells A1 and B1 // =A2-B2 - the minus sign TAKES AWAY B2 from A2 // =A3*B3 - the asterisk sign MULTIPLIES A3 to B3 // =A4/B4 - the forward slash sign DIVIDES A4 by B4.

Images and files in the map