Prepare a personal budget for one month in the blank worksheet named Budget. Be sure to think through your sources of income and expenses. Be as detailed as you wish; but include cells that calculate the following: total income (which calculates the sum of all income sources), total expenses (which calculates the sum of all expenses), and monthly savings (which calculates the difference between the total income and expenses). After completing your budget, complete the tasks to create named ranges that reference the important cells outlined above. Task # Points Task Description 5
1 5 Ceate a named range caled, Income that references the cel that calculates the total Income in your budget
2 5 Create a named rage called, Expenses" that refeences the cell ht calculaes the total expenses in your budget.
3 10 Create a named range called, "Savings" that references the cell that calculates the monthly savings in your budget. The savings calculation should be the difference between the total income and total expenses in your budget. Be sure to reference the named ranges for income and expenses in your calculations.