For more course tutorials visit www . uophelp . com
For more course tutorials visit www . uophelp . com
Scenario / Summary You are an intern at First National Bank working in the loan department , and your boss has asked you to prepare the monthly " New Loan Report " for the Board of Directors . This analysis report will clearly list and summarize all new loans for residential housing in the past month . The summary area includes the loan statistics as labeled data in the data file . The format of the report should be appropriate for the Board of Directors for the First National Bank . Be sure to watch the tutorials at the end of the Lesson page . Deliverables Step 1 : Open , Save , and Document the Workbook A . Download the Week2 _ iLab _ FirstNatlBank _ Students . xlsx Workbook . Open the file in Excel , and save it as the file name as describe above ( i . e ., Doe _ J _ Week2 iLab . xlxsm ). [ Note : You may get a popup message that asks you to " Enable Saving ". Simply click " Yes " to Enable and you will be able to save the file ] B . It is recommended that as you progress through this assignment , that you work on what you have learned so far , in terms of readability . Be sure to keep your worksheet professional with easy to read column headings , shading , spacing , boxes , logos , and so on . Remember to label your worksheets with appropriate labels ( i . e ., not sheet1 , sheet2 , etc .). C . Add a documentation sheet that provides a spreadsheet title , author , date , and purpose . Format the documentation sheet . The bank ' s logo is dark blue , so use a color scheme that reflects that logo . Select complementary Font and Fill colors for the documentation sheet . Ensure that the sheet tab is named Documentation and that the documentation sheet is the first sheet in the workbook . Step 2 : Create Calculations Functions are used to calculate the interest rate , down payment , monthly payment , and average selling price for each residential home in the worksheet . You need to create a formula to determine the down