1. Fill in the formulas to add up the expenses for each month (dark blue area). Fill in the sum of each expense as well (yellow area). You are free to use either formulas or functions to create these totals. (Hint: If you are going to use a function, your best choice here would be the SUM function.)
2. Now, fill (right/down) the formulas to add up the income for each month as well as the total from each income source (green and light blue areas). If you used a straight formula for the last step, try using a function this time. And, if you used a function last time, then try using a straight formula this time.
3. Now finish off the calculations and subtract the expenses from the income for each month, that is, the purple cellminus the red cell. This calculation should be located in cell B20 (grey cell).
4. Download the excel file at the google classroom and the link provided by your teacher then perform the following
formula and instructions above.
5. Save your file with the following format: (Ex. G11_STEM-A_LASTNAME_FIRSTNAME,xls)
6. Upload and TURNIN your created excel to the google classroom.
7. NOTE: Write your answer in the space provided in a colored cell on the left side of this paper.
Link of the Excel:
Preview:
.png)
Comments
Post a Comment