B . Adjust columns sizes to fit the data . C . Merge and center titles and size appropriately . D . Change font color to dark blue .
E . Add a small graphic appropriate for the purpose of the worksheet .
F . Separate sections of the worksheet and provide borders as appropriate .
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 .