Excel Practical Exercise Module 2 Note:Open a workbook and save as EX-PE2-YourName. Each exercise a worksheet Tab. Exercise 1: Analyzing Emergency Student Loans The Student Assistance office at your school provides emergency loans at simple interest. The data obtained from six types of loans and the desired report format arc shown in Table 2-9. The required formulas are shown in Table 2-10. Use the concepts and techniques presented in this chapter to create and format the worksheet. Include total, average, maximum, and minimum values for Principal, Interest, and Amount Due. Use conditional formatting to change the formatting to white font on a red background in any cell in of the Amount Due that contains a value greater than 20000. Create a 3-D Clustered Bar chart with the Amount Due of each Loan Type. Table 2-9 Emergency Student Loan Data and Worksheet Layout Loan Type Rate Time in Years Principal 540,000 $25,500 759 12% $12,750 Academic Supplies Medical Emergency Personal Emergency Room and Board Travel Expenses Tuition Reimbursement $27,000 34,550 $107.000 6% Table 2-10 Emergency Student Loan Formulas Interest - Principal x Rate x Time Amount Due = Principal + interest Average = AVERAGE function Minimum = MIN function Maximum = MAX function Change the name of the sheet tab to M2-Exercise i Table 2-9 Emergency Student Loan Data and Worksheet Layout Loan Type Principal Rate Time in Years in $40,000 $25,500 32 in 00 Academic Supplies Medical Emergency Personal Emergency Room and Board Travel Expenses Tuition Reimbursement 6.5% $27,000 $4550B $107.000 12% 6% Table 2-10 Emergency Student Loan Formulas Interest = Principal x Rate x Time Amount Due = Principal + Interest Average = AVERAGE function age=AVChAOLUC Minimum = MIN function Maximum = MAX function Change the name of the sheet tab to M2-Exercise 1 Exercise 1: Analyzing Emergency Student Loans The Student Assistance office at your school provides emergency loans at simple interest. The data obtained from six types of loans and the desired report format arc shown in Table 2-9. The required formulas are shown in Table 2-10. Use the concepts and techniques presented in this chapter to create and format the worksheet. Include total, average, maximum, and minimum values for Principal, Interest, and Amount Due. Use conditional formatting to change the formatting to white font on a red background in any cell in of the Amount Due that contains a value greater than 20000. Create a 3-D Clustered Bar chart with the Amount Due of each Loan Type. Table 2-9 Emergency Student Loan Data and Worksheet Layout Loan Type Principal Rate Time in Years Academic Supplies Medical Emergency Personal Emergency Room and Board Travel Expenses Tuition Reimbursement $40,000 $25,500 $12,750 7.5% 12% 8.25% 12% $4,550 $107.000 Table 2-10 Emergency Student Loan Formulas Interest = Principal x Rate x Time Amount Due = Principal + Interest Average = AVERAGE function Minimum = MIN function Maximum MAX function Change the name of the sheet tab to 12-Exercise
