using technology.
Language Obj:SWBAT use content vocabulary correctly
Today I will show you how to create Sum functions ,(formulas) and how to use the fill feature to complete a spreadsheet. You will use these to create a spreadsheet that calculates a simple budget.
Today's assignment is called Huskie Jo's Budget:
In this activity you will create a budget spreadsheet to keep track of income and expenses on a monthly basis. The formulas that you will use are addition, however the final one is not.
1. open a new spreadsheet file and name it Huskie Jo.
2. Huskie Jo wants to go on a weekend camping trip. The cost of the trip is $50.00. Can she afford to go? She decides to set up a budget to keep track of her income and expenses, which will help her determine if she has enough money to go on the trip. Set up your spreadsheet so it matches the example.
3. Sum Function
A. What should be typed in cell H4 to add the contents of cells B4 through G4?
B. Type this function and press enter.
C. Fill down to cells H5 and H6
D. What should be typed in cell B7 to add the contents of cells B4 through B6?
E. Type this function and press enter.
F. Fill Right to cells C7 through H7.
G. What should be typed in cell H10 to add the contents of cells B10 through G10?
H. Type this function and press enter.
I. Fill Down to cells H11 through H15.
J. What should be typed in cell B16 to add the contents of cells B10 through B15?
K. Type this function and press enter.
L. Fill Right to cells C16 through H16.
4. Monthly Savings
A. What formula should be typed in Cell B18 to calculate Huskie Jo’s savings for January
Hint: Look at the cell containing the total amount she earned for January, B7 and the cell containing the total amount she spent for January, B16. Use these cell locations in the formula.
B. Type this formula and press enter.
C. Then fill Right to cells C18 through H18. The value in cell H18 is Huskie Jo’s total savings over the six month period.
Answer the following questions:
1. Does Huskie Jo have enough money in savings to go on the camping trip? Enter your answer in cell H19
2. How were Fill Down and Fill Right helpful in completing this spreadsheet? Use cell A20 for your answer.
5. Upload your file to edmodo.