ONLY PART K

i. Insert a function in cell H3 to calculated the total cost of each project. j. Insert a function in cell 13 to calculated the profit of each project. k. Create an IF statement in cell K3 where if the profit is greater than $50,000 it will display the text Yes, otherwise it will display the text No. File Home Insert Draw Page Layout Formulas Data Review View Help Cor Define Name fx Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & More Time Reference Trig Functions Name Use in Formula Manager Create from Selection Ey Trace Precedents x Show Formulas Fa Trace Dependents Error Checking FRemove Arrows Evaluate Formula Formula Auditing GO Watch Window Cal Or Function Library Defined Names L2 1 X fx B K Sq. ft. Bonus 4 4 2 4 5 5 2 NA 3 1 2 House Type # of Beds # of Baths 3 Colonial 3 4 Ranch 4 5 Ranch 4 6 Tudor 3 7 Colonial 2 8 Colonial 3 9 Split-level 4 10 Bungalow 2 11 Ranch 4 12 Ranch 2 13 Ranch 3 14 Tudor 4 15 Bungalow 4 16 Split-level 3 17 Colonial 3 18 Bungalow 5 19 Split-level 5 20 Tudor 4 Sales Data Sheet2 D E F H 2017 Sales Data Purchase Price Renovations Sale Price Total Cost Profit 1519 $ 205,019 $ 43,370 $ 263,292 $ 248,389 $ 14,903 1635 $ 222,583 $ 78,928 $ 340,707 $ 301,511 $ 39,196 2311 $ 328,659 $ 80,955 $ 425,999 $ 409,614 $ 16,385 2333 $ 270,002 $ 78,418 $ 435,525 $ 348,420 $ 87,105 2548 $ 319,768 $ 96,837 $ 441,601 $ 416,605 $ 24,996 2443 $ 317,017 $ 71,858 $ 435,540 $ 388,875 $ 46,665 1735 $ 223,238 $ 98,648 $ 376,607 $ 321,886 $ 54,721 2638 $ 245,470 $ 102,080 $ 413,585 $ 347,550 $ 66,035 2263 $ 395,157 $ 26,255 $ 518,337 $ 421,412 $ 96,925 2534 $ 290,485 $ 59,263 $ 405,708 $ 349,748 $ 55,960 2595 $ 243,056 $ 79,620 $ 416,252 $ 322,676 $ 93,576 1416 $ 375,966 $ 96,231 $ 561,914 $ 472,197 $ 89,717 2576 $ 288,893 $ 111,885 $ 488,949 $ 400,778 $ 88,171 1376 $ 300,383 $ 69,156 $ 410,188 $ 369,539 $ 40,649 2447 $ 239,903 $ 11,930 $ 289,608 $ 251,833 $ 37,775 2052 $ 380,975 $ 96,869 $ 544,742 $ 477,844 $ 66,898 2764 $ 350,479 $ 54,381 $ 441,297 $ 404,860 $ 36,437 1355 $ 314,415 $ 67,668 $ 443,216 $ 382,083 $ 61,133 5 Sale Date 1/28/2017 1/30/2017 2/2/2017 2/8/2017 2/21/2017 3/1/2017 3/1/2017 3/5/2017 3/10/2017 3/11/2017 3/28/2017 3/31/2017 4/2/2017 4/7/2017 4/18/2017 4/26/2017 5/1/2017 5/12/2017 2 5 5 2 5 5 2 4 2 i. Insert a function in cell H3 to calculated the total cost of each project. j. Insert a function in cell 13 to calculated the profit of each project. k. Create an IF statement in cell K3 where if the profit is greater than $50,000 it will display the text Yes, otherwise it will display the text No. File Home Insert Draw Page Layout Formulas Data Review View Help Cor Define Name fx Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & More Time Reference Trig Functions Name Use in Formula Manager Create from Selection Ey Trace Precedents x Show Formulas Fa Trace Dependents Error Checking FRemove Arrows Evaluate Formula Formula Auditing GO Watch Window Cal Or Function Library Defined Names L2 1 X fx B K Sq. ft. Bonus 4 4 2 4 5 5 2 NA 3 1 2 House Type # of Beds # of Baths 3 Colonial 3 4 Ranch 4 5 Ranch 4 6 Tudor 3 7 Colonial 2 8 Colonial 3 9 Split-level 4 10 Bungalow 2 11 Ranch 4 12 Ranch 2 13 Ranch 3 14 Tudor 4 15 Bungalow 4 16 Split-level 3 17 Colonial 3 18 Bungalow 5 19 Split-level 5 20 Tudor 4 Sales Data Sheet2 D E F H 2017 Sales Data Purchase Price Renovations Sale Price Total Cost Profit 1519 $ 205,019 $ 43,370 $ 263,292 $ 248,389 $ 14,903 1635 $ 222,583 $ 78,928 $ 340,707 $ 301,511 $ 39,196 2311 $ 328,659 $ 80,955 $ 425,999 $ 409,614 $ 16,385 2333 $ 270,002 $ 78,418 $ 435,525 $ 348,420 $ 87,105 2548 $ 319,768 $ 96,837 $ 441,601 $ 416,605 $ 24,996 2443 $ 317,017 $ 71,858 $ 435,540 $ 388,875 $ 46,665 1735 $ 223,238 $ 98,648 $ 376,607 $ 321,886 $ 54,721 2638 $ 245,470 $ 102,080 $ 413,585 $ 347,550 $ 66,035 2263 $ 395,157 $ 26,255 $ 518,337 $ 421,412 $ 96,925 2534 $ 290,485 $ 59,263 $ 405,708 $ 349,748 $ 55,960 2595 $ 243,056 $ 79,620 $ 416,252 $ 322,676 $ 93,576 1416 $ 375,966 $ 96,231 $ 561,914 $ 472,197 $ 89,717 2576 $ 288,893 $ 111,885 $ 488,949 $ 400,778 $ 88,171 1376 $ 300,383 $ 69,156 $ 410,188 $ 369,539 $ 40,649 2447 $ 239,903 $ 11,930 $ 289,608 $ 251,833 $ 37,775 2052 $ 380,975 $ 96,869 $ 544,742 $ 477,844 $ 66,898 2764 $ 350,479 $ 54,381 $ 441,297 $ 404,860 $ 36,437 1355 $ 314,415 $ 67,668 $ 443,216 $ 382,083 $ 61,133 5 Sale Date 1/28/2017 1/30/2017 2/2/2017 2/8/2017 2/21/2017 3/1/2017 3/1/2017 3/5/2017 3/10/2017 3/11/2017 3/28/2017 3/31/2017 4/2/2017 4/7/2017 4/18/2017 4/26/2017 5/1/2017 5/12/2017 2 5 5 2 5 5 2 4 2