Exploring Microsoft Excel 2003 Comprehensive
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Results 1-3 of 36
Consumer Loans: The worksheet in Figure 7.22 displays selected loans (those
with a loan type of "A") from a comprehensive set of loan records. Your
assignment is to open the partially completed Chapter 7 Practice 6 workbook in
the Exploring Excel folder to create the worksheet in our figure. a. Open the
workbook, then go to cell H4, the cell containing the ending date for the first loan.
Enter the formula to compute the ending date, based on the starting date and the
term of the loan.
One significant item is what you do not see — the payments in the body of the
worksheet will not appear until all of the loan parameters have been entered, and
further the worksheet will display and print only as many rows (payments) as are
necessary. A 30 -year loan, for example, requires 360 payments, whereas a 15-
year loan takes only 180. Data validation is also built into the worksheet. For
example, the worksheet will reject any loans greater than 30 years or any loans
Check that your loan parameters match those in Figure 9.10e. □ Pull down the
Tools menu, click Macro, click Macros . . ., then run the PeriodicExtraPayment
procedure that you completed in the previous step. Enter $1,500 and a date two
months after the first payment as the amount of the extra payment and the date
the payments are to begin. □ The macro executes, and if all goes well, you will
see the summary information in our figure. The actual number of payments has
What people are saying - Write a review
10 other sections not shown