Applied Computers II
Excel Project 5 Assignments
1. Read Excel, Project 5 and complete the vocab assignment being sure to follow our class template.
2. Do the "SavU Bank Loan Analysis" exercise on pp. 5.7 -
5.48. Be sure to read the Excel, Project 5 Remarks
page first though.
3. Do the True/False, Multiple Choice, "Understanding Macro Functions", and "Understanding Functions, Data Analysis, and Worksheet Protection" sections on pp. 5.50 - 5.51.
4. Do Excel, Project 5 Worksheet #1. Staple together and hand in the worksheet as well as the Formulas version of the worksheet. Obtain a copy of the worksheet in the templates folder.
5. Do Excel, Project 5 Worksheet #2. Make sure that you create "interesting" VB macros. Obtain a copy of the worksheet in the templates folder.