read the instructions and find the appropriate formula for the fiirst exercise and plot the bar graph for the second one

. Gill Sans MT 10 A Genera HOH na Paste BI U A Ce v Q15 A B D E G H 1 L M You have decided to purchase a new house; the seller gave you two options: 2 3 a) You can pay immediately US$ 200,000 cash. 4 5 10 years b) Or you can pay US 5,000 each two months for the coming 6 7 Knowing that the rate i 9% 8 9 Write the function that would allow you to choose either option 1 or option 2 10 12. 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Insert Draw Page Layout Formulas Data Review View Tell me X Gill Sans MT - A A ab General Insert 5 PA DX Delete B 1 a Av % % Conditional Format Cell Formatting as Table Styles L! Format Sort Filte . fx exercise 5: Draw a stand alone column chart representing the number of catches each play has scored B F G H K M N P 5 exercise 4: Based on the assumptions given in Table 2 Write the function that would allow you to find the corresponding conference each player is in American Table 1 Table 2: Assumptions Player Position Team Catches Yards Conference! Team Conference Santana Moss WR WAS 67 950 ARI National Drew Bennett WA TEN 72 1114 ATL National Michael Clayto WR TB 84 1253 BA! American BUF CAR Nacional CHI National exercise 5: Draw a stand alone column chart representing the number of catches each play hCIN American CLE American DAL National DEN America DET Nadonal GB National HOU American IND American JAC America KC American MIA American MIN Nacional NE American NO Nationa NYG National NY) American OAK American PHI National PIT American SD American SEA National SF National STL National National TEN American WAS Nana MY 42 44 Exercise 7 Exercises 4 & 5 CondFormat Exercise 6 Exercise 3 GPA Calculator Exercise 2 Space Weight Fxercise1 Formula functions