AutoSave OFF OFF HESU Copy of Practice Spreadsheet (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LG Insert v A Calibri (Body) v 11 2 Wrap Text Ceneral 7 0 Paste BIU Av = = = Y Merge & Center Delete Format B. Y Conditional Format Cell Formatting es Table Styles Ideas Sensitivity Sort Filter v Find & Select V F16 fx D E F G H . J L M N P Q R S U Y Your income and expenses 1 2 January Income 2000. Expenses: Rent 1100. Groceries 245.99;U6lities 49.51 February Income 2000. Expenses: Rent 1100: Groceries 110.1; Utilities 102.71 3 4 S March Income 2000. Expenses: Rent 1100: Groceries 200.76; Utilities 43.04 F 7 Instructions: 2. Createatable with the cata above, bolcen all the column Headings 9 27 Calculate totals for each type of expense and for each month 10 Include a grand total far all 3 manths of pers. 11 41 Add another column to calculate the percentage of total expenses for cach category by dividingsach category's total by the grand total 12 Sadd another row to calculate the percentage of total expenses for each month by civicing each monthly total by the grand total 13 6 Show how much is gaing inta savings for each month i... Total income minus total expenses 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 319 39 40 41 Sheet1 + # 2 - + 100%