Transcribed Image Text from this Question
She Your income and expenses She Bach January Income 7000. Expenses: Rent 1600, Groceries 245.99; Utilities 49.57 February Income 5500. Expenses: Rent 1600; Groceries 110.1; Utilities 110.17 March Income 6700. Expenses: Rent 1600: Groceries 400.76; Utilities 41.74 April Income 6500. Expenses: Rent 1550, Groceries 145.91; Utilities 79.36 May Income 6700. Expenses: Rent 1400, Groceries 250.76; Utilities 67.14 June Income 7000. Expenses: Rent 1550, Groceries 148.39. Utilities 69.56 Instructions: you will need to inform students that for them to calculate percentage, they will need to enter the percentageformule into the cell where they want to calculate For example. If you have a column total that is located in all address B2 and a grand total located in B3, simply input the percentage calculation formula 32/3 1) Create a table with the data above, enbolden all the column headings 2) Calculate totals and averages 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 Note: When you finish creating your table on a blank worksheet, press the yellow button “CLICK HERE TO SAVE YOUR WORK” then return to Blackboard and paste what yo ate
(Visited 2 times, 1 visits today)
