BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 23

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.