BIS 155 Endless Education /uophelp.com BIS 155 Endless Education /uophelp.com | Page 16

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