1. ============================================== BIS 155 iLab 3: Luke Liberty Realty( New)
For more course tutorials visit www. uophelp. com
Step 4: Create an Excel Application With Macro and Macro Button A. Add a new worksheet to the workbook, and name it Loan calculator. B. Create a user input section that asks users to input the following: 1. What is the price of the home? 2. Do you wish to put any additional money down? 3. Pay at the beginning of the month? C. Create an Output section that uses the user-provided data and calculates the mortgage payments for a 15-year loan, a 20-year loan, and a 30-year loan. D. Add user input validation to ensure that users input at least $ 50,000 for the cost of the home and answer Yes / No to the payment question. E. Unlock the cells in which users will input data so that you may protect the sheet to keep users from changing other areas. F. Create a Macro. G. Use Insert Shapes to add a Macro button that will allow users to clear values and start over. Name the button Enter New Values. H. Protect the worksheet, but do NOT require a password. I. Format the worksheet so that it is easy to understand and use. The following is a sample of what your final worksheet might look like: Save your file as an xlsm file and submit to the Dropbox. Make sure you post a comment about what you learned when submitting the file.
1. ============================================== BIS 155 iLab 3: Luke Liberty Realty( New)
For more course tutorials visit www. uophelp. com
You are an intern with the Regional Realty Association and are analyzing the claim made by Luke Liberty Realty that " we get your price." You have prepared a spreadsheet that shows data relating to 3