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’s Subprime provides financing for customers who lack the usual down payments for a loan. The chief financial officer has asked you to automate the entry of financing data into a worksheet that computes the monthly payment and total cost of a loan.

Assignment Requirements

Preliminary Steps:

1. Start Excel. If the Developer tab does not display on the Ribbon complete the following steps:
   1. Select File | Options. The Excel Option dialog box appears.
   2. Click on Customize Ribbon. The Customize Ribbon dialog box appears.
   3. Check the Developer Option check box in the right pane.
   4. Press the OK button. The Developers tab now appears on the Ribbon.
2. Enable macros by completing the following steps:
   1. Click on the Developer tab.
   2. Click the Macro Security button. The Trust Center dialog box appears.
   3. Click ‘Enable all macros’.
   4. Press the OK button.

Please see the attached data file also.

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.