A - (TCO 2) You have set up an Excel worksheet to determine the loan payment. It
ID: 2367710 • Letter: A
Question
A - (TCO 2) You have set up an Excel worksheet to determine the loan payment. It is set up so that you enter the customer's status, and it finds and returns the correct interest rate. Then, you enter the interest rate and other required information to get the actual payment. Describe the Excel tools used for these tasks, and the information required to obtain the payment. B - (TCO 10) You know that your list of information on the loans will quickly become very long and that much of the data on the customers will be repeated for multiple loans. Customers will often pay off one loan and quickly request another. You want to be able to pull up an individual record by customer name and see the final payment date for the current loan. A friend has suggested that you build your list in Access. What would be the benefit of doing this, particularly in the banking environment? Would this meet your needs? C - (TCO 10) You want to use the Access form wizard to create an input form for your list. Describe the process of creating the form, and the special tools you might use to make it easier to use and less prone to errors. D - (TCO 10) You have decided that you would like to be able to pull a list of all loans past and present for any particular customer. Explain how you would obtain such a list, and then print the information. Be specific!Explanation / Answer
If the excel spreadsheet is setup as a calculator to process a single quote at a time, then you wont need any VB Macros in place to complete this, unless you are going to use combo boxes or more complicated forumlas that cant be handeled using the 1 line provided by excel by default. You would have to setup your excel spread sheet so that your values line up in the same column, with the information you are asking for next to it, either on the left or right side of the value's you will be entering and calculating. There would be a row that asks the term of the note, with a cell next to it where you enter the value. The cell after it could be used to enter possible values for the end user to input so they know what they can and can not use, to prevent the user from using invalid values, you would need to use a drop down box, in this case you would have to enable the developer tab, add the combo box, and assign a VB Macro to add the values and calculate the end results later after all the values have been entered. So the tools you would use are the function bar to enter forumulas, the cells provided by default in excel, most likely you would be using some of the Font tools to modify font color, size, and other attributes like Bold, Italics, etc... You would potentially use form controls off of the developer tab (Combo Box, and Button) to fancy things up a bit. If you used those controls, you would then be using Macro's to create Visual Basic code to process the formula.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.