Transcribed Image Text from this Question
View Zoom Add Category Insert Table Chart Text Shape Media Sheet1 Your income and expenses January Income 2000. Expenses: Rent 1100, Groceries 245.99; Utilities 49.51 February Income 2000. Expenses: Rent 1100; Groceries 110.1; Utilities 102.71 March Income 2000. Expenses: Rent 1100; Groceries 200.76; Utilities 43.04 Instructions: 1) Create a table with the data above, enbolden all the column headings 2) Calculate totals for each type of expense and for each month. 3) Include a grand total for all 3 months of expenses. 4) Add another column to calculate the percentage of total expenses for each category by dividing each category’s total by the grand total. 5) Add another row to calculate the percentage of total expenses for each month by dividing each monthly total by the grand total. 6) Show how much is going into savings for each month i.e. Total income minus total expenses.
(Visited 1 times, 1 visits today)