So you have created your basic spreadsheet for the party and have formatted it.  One of the really useful tools of a spreadsheet is having the ability to do calculations.  It can do almost everything a calculator can do if you know how to create a formula.  All formulas start with an equal sign.  Let's calculate how many people will be coming to your party! 

Using a Formula to Add a Column

Sample Image - Spreadsheet Formulas  

Step 1 - Put an addition formula in the cell B10 adding the # of people invited. The formula should look like one of these:
  

=B3+B4+B5+B6+B7+B8  or  = SUM(B3:B8) 

 

Step 2 - Put an addition formula in the cell C10 adding the # of people attending.  The process is the same as above.  You may also experiment with using the FUNCTIONS button on the toolbar.

Step 3 - When you click off of the formula it should automatically add the numbers.  To see the formula again go to VIEW in the menu and select ALL FORMULAS.  This shows you all of the formulas on the sheet. 

Step 4 - Take a screen shot of your spreadsheet with ALL FORMULAS showing.  Ask your SSI chief if they want you to share it with them.

Step 5 - To not see all of the formulas go back to VIEW in the menu and select ALL FORMULAS and it will return to numbers in the columns. 

Resources:

    Spreadsheet Help From Google

    Formula Help From Google

    Using Google Spreadsheets from About.com 

    Using Formulas from About.com (Hint: Look at all 6 steps of the tutorial for help)

 Check this Quest off your Tracking Document