wood-spreadsheetcalculations

Hello Everyone!

We are going to learn about spreadsheet calculations today. This will help us learn to let our spreadsheets do the math for us. We really just have to input the numbers.

1. Go to [|docs.google.com] 2. Login using: ewargo@bridgeton.k12.nj.us (username) 01170701 (password)

3. Like in the picture below, type in wood in the search box:

4. Click on **Search Docs & Spreadsheets**

5. Find your spreadsheet on the list from the returned search.

6. Open your spreadsheet by clicking on it.

7. In Column C next to cost, type the word **monthly cost. Your spreadsheet should look like: **

8. In the Monthly Cost column, copy the following costs: Mortgage Car Payment Cell Monthly Your spreadsheet should look like:

9. In the Clothes and Electronics cells we are going to figure out how much these will cost us on a monthly basis. We do that by using a formula to do the math for us. We start by click in the clothes row under the monthly costs like in the picture below

10. We type in =Sum(C6/12) and press enter.