iPmL8LWjaRQs1YWOLIVT9r2VHakKTSSTtPSansjdu6UqrRo... 1.00 Point: XL Step 2.1.1: Use SIMS 9 ShareRelative Cell References in a Formula Enter a formula in cell D8 that calculates the difference between the House Cost and the Down Payment using relative cell references. Copy the formula from cell D8 to the range D9:D12. l Format as Cell Insert Delete Formatting Table Styles ClipboardG Font 011 Townsend Mortgage Company Input Area 12 Date Payoff Period Years Periods Financed Financed Year House Down Amount Mortgage Rate Per #ofPmt % Loan # Cost Payment Financed Rate 5/1/2011 11/3/2011 4/10/2012 10/14/2012 2/4/2013 8 452786$ 400,000 80,000 453000 350,000 $ 60,000 3.940% 10 453025 175,500 30,000 11 452600 $ 265,950 $58,000 12 452638 $ 329,750 $ 65,000 13 2.500% 3.250% 14 Summary Statistics House Down Amount Statistics Cost Payment Financed 16 Total 17 Average 18 Median 20 Highest 21 # of Mortgages