Kaplan University IT Spreadsheet application Recording and Running Macros Project
Question Description
Unit Outcomes:
Add the developer tab to a workbook.
Create a basic macro.
Use the VBA command to determine a monthly payment.
Create a print button.
Course Outcome:
IT153-4: Create macros to automate worksheets.
Purpose
In this assignment, you will practice what you learned about creating macros using Visual Basic Application (VBA).
Assignment Instructions
Scenario:
Richie’sSubprime provides financing for customers who lack the usual downpayments for a loan. The chief financial officer has asked you toautomate the entry of financing data into a worksheet that computes themonthly payment and total cost of a loan.
Assignment Requirements
Preliminary Steps:
Start Excel. If the Developer tab does not display on the Ribbon complete the following steps:
Select File | Options. The Excel Option dialog box appears.
Click on Customize Ribbon. The Customize Ribbon dialog box appears.
Check the Developer Option check box in the right pane.
Press the OK button. The Developers tab now appears on the Ribbon.
Enable macros by completing the following steps:
Click on the Developer tab.
Click the Macro Security button. The Trust Center dialog box appears.
Click “˜Enable all macros’.
Press the OK button.
Please see the attached data file also.

“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
Attachments
20190706013303it_spreadsheet (23 kB)