Question: I'm not sure why what I got doesnt look like the example when completing questions 4-6. Please explain your steps, I'm using Excel Version 16.18.


I'm not sure why what I got doesnt look like the example when completing questions 4-6. Please explain your steps, I'm using Excel Version 16.18. Thanks.
Diane and Glenn Smith is a couple, they asked you to create a worksheet for their family budget. The Smith family wants to purchase a new home. They are considering two houses with different mortgages. They want the budget worksheet you create to display the impact of monthly payments on the couple's cash flow. The couple has already designed the workbook and entered estimates of their take-home pay and expenses for the upcoming year. They want you to set up the formulas and add charts. Diane and Glenn Smith is a couple, they asked you to create a worksheet for their family budget. The Smith family wants to purchase a new home. They are considering two houses with different mortgages. They want the budget worksheet you create to display the impact of monthly payments on the couple's cash flow. The couple has already designed the workbook and entered estimates of their take-home pay and expenses for the upcoming year. They want you to set up the formulas and add charts
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
