Question: Start Excel. Download and open the file named Exp 2 2 _ Excel _ Ch 0 2 _ ML 2 _ Vacation Property.xIsx. Grader has

Start Excel. Download and open the file named Exp22_Excel_Ch02_ML2_Vacation Property.xIsx. Grader has automatically added your last name to the beginning of the filename.
Write an IF function in cell D9 that calculates the down payment for the mortgage. The down payment is 15% of the purchase price if the customer is considered high risk or 5% of the purchase price if considered low risk. The criteria to assess the risk of the loan is based on the credit score value in cell B6. Be sure to use the appropriate absolute or mixed cell references when referencing the input values in the range B4:B6. Then use the fill handle to copy the
 Start Excel. Download and open the file named Exp22_Excel_Ch02_ML2_Vacation Property.xIsx. Grader

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!