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 payment . Finish the calculations by using the appropriate functions to complete the Loan Statistics summary area of the worksheet .
A . Use a VLOOKUP function to determine the interest rates in column D . There is a tutorial video on creating and using VLookup tables at the end of the Lesson page .
B . Calculate the down payment by multiplying the results of a VLOOKUP function by the selling price . Enter the formula in column E .