Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help to do those problems of Excel and show the right solutions as follows. New House Mortgage Calculator In cell I10, insert a formula
Need help to do those problems of Excel and show the right solutions as follows.
New House Mortgage Calculator In cell I10, insert a formula using the FV function and the monthly interest rate (cell I5), the loan period in months (cell I7), the monthly payment (cell I9), and the loan amount (cell I3) to calculate the future value of the loan with Bank 3. 13. Miranda plans to print parts of the Mortgage Calculator workbook. Prepare for printing as follows: a. Set row 2 as the print titles for the worksheet. b. Set the range F2I13 as the print area. 14. Hide the Listings worksheet, which contains data Miranda wants to keep private. 15. Go to the Car Loan worksheet, which contains details about a loan Miranda and Ricardo took out for a new car. The worksheet contains two errors. Make sure Excel is set to check all types of errors, and then resolve the ones on the Car Loan worksheet as follows: a. Display the possible errors and solutions for cell B2, and then ignore the error. b. Trace the precedents to the formula in cell H T, which should multiply the optional extra payments by the scheduled number of payments. Correct the error. 16. Draw attention to the optional extra payments in the range B10:D10 by adding a thick outside border using the Tan, Accent 4 shape outline color. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. New House Mortgage Calculator In cell I10, insert a formula using the FV function and the monthly interest rate (cell I5), the loan period in months (cell I7), the monthly payment (cell I9), and the loan amount (cell I3) to calculate the future value of the loan with Bank 3. 13. Miranda plans to print parts of the Mortgage Calculator workbook. Prepare for printing as follows: a. Set row 2 as the print titles for the worksheet. b. Set the range F2I13 as the print area. 14. Hide the Listings worksheet, which contains data Miranda wants to keep private. 15. Go to the Car Loan worksheet, which contains details about a loan Miranda and Ricardo took out for a new car. The worksheet contains two errors. Make sure Excel is set to check all types of errors, and then resolve the ones on the Car Loan worksheet as follows: a. Display the possible errors and solutions for cell B2, and then ignore the error. b. Trace the precedents to the formula in cell H T, which should multiply the optional extra payments by the scheduled number of payments. Correct the error. 16. Draw attention to the optional extra payments in the range B10:D10 by adding a thick outside border using the Tan, Accent 4 shape outline color. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed projectStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started