Spreadsheets

Spreadsheets

1. formatting

   • Formatting is the design of there spread sheet, this includes borders and background fill for cells
   • cells can be merged or combined together, eg. cells A1:C1 can be merged to make a big cell A1

2. Formulas

   • Formulas are automatic calculations
   • commonly used formula; =A1+B1, this adds up cells A1 and B1. =A3*B3, the asterisk sign multiplies A3 by B3
   • To use 'sum' you need to enter the equals sign first. then type the equation

3. Benefits

   • Can automatically recalculate
   • Computers do not make mathematical errors
   • Charts and graphs can be produced and customized very easily
   • You can change information in Spread sheet model to make and test predictions.