Question: ASK ONE - INSTRUCTIONSAction #1: In cell B31 , calculate the total expenses for April using the SUM function. Copy this calculation into cells C31
ASK ONE - INSTRUCTIONSAction #1: In cell B31 , calculate the total expenses for April using the SUM function. Copy this calculation into cells C31 and D31 .Action #2: In cell B33 enter a formula that will take the Opening Bank Balancefor April, add it to the Total Income for April and then deduct the Total Expenses for April. You will need to write a formula that shows your understanding of using brackets within formulas. This will give you the End of month Bank Balance.Action #3: Link the End of Month Bank Balance in cell B33 to cell C8. This will give you the Opening Bank Balance for May.Action # 4: Repeat Actions # 2 and # 3 to calculate the End of Month Bank Balancesfor May and June, and the Opening Bank Balancefor June.Select cell B34. Using the Savings Goal amount held in cell B5 and the Action # 5: End of month Bank Balance held in cell B33, calculate what percentage the End of month Bank Balance is of the $5,000 savings goal. To do this you will need to divide cell B33 by cell B5. Be sure to write the formula so that it includes absolute addressing as you will be copying this into cells C34 and D34. Format the cell as a Percentage with no decimal places.Action # 6: Copy the formula in cell B34 into cells C34 and D34. Save the file
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
