spreadsheets

spreadsheets

1. formulas

   • =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 by B3
   • =A4/B4
     • the forward slash sign divides A4 by B4

2. formatting techniques

   • 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 the 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 or bold italics
   • the background fill tool can change the colour of the cells

3. labels are headings that explain the data

4. the text or numbers you type in

   • data

5. functions are more advanced calculations that the spread sheet can do.

6. computers do not make mathematical errors like humans but GIGO still applies

7. benefits

   • when data changes automatically recalculate
   • charts and graphs can be produced and customized very easily