BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 21

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.