Spreadsheets

Spreadsheets

1. Benifits

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

2. Formulas

   • =A4/B4 this forward slash divides A4 by B4
   • =A1+B1 this plus sign adds up cell A1 and B1.
   • =A2-B2 this minus sign takes away B2 from A2.
   • =A3*B3 this asterisk sigh multiplies A3 by B3.

3. Fromatting

   • 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 be merged 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

Bilder und Dateien der Mindmap