Please solve 9-15. Please

Home Insert Draw Share Comments Home Insert Draw Page Layout Formulas Data Wala Review View Tell me Share Comments H A- Design >> Tell me Ar Paragraph Styles Dictate Analysis Tools E How Puste Font Sensitivity Sart Get External Data Stoc Ceogra.. Filter Rafresh All de Data Tools What-11 If Analysis Outline 9 Ontha Advedis.coPan worksheet in oal F2, enter a function that will return the currant data. A1 fx A B C D F K L 1 2 Pointer Paradise New Budget Analysis Today's Date Cost per Guest Result Created On UTCG 2018 1 YO_Excel16_BUOD 5 Place Past Year, Monthly Advertising Cost Pat Guest Type Per Ad Ads Placed Results Amount Spant Magazine $ 1.200 3 Racio $300 $ 1 Television $ 5,000 1 Internet $ 1.100 2 Totals New Monthly Advertising Negotiation for Next Fiscal Year New Cost Ads To Amount Considera Anticipated Guest Now Budget Per Ad to Spend Change? ? Results $ 4,000 $ 1,300 $ 300 $ 325 S 12,000 $5,500 $ 2,200 $ 1,200 7 Rudiger. Guest Results 9 10 11 12 Grader Instruction Excel 201 13 14 Po 15 Step Instructions Poe 16 17 10 Incal Ds, reference the named range Axa Magazine toneum the value in cell 19 on the 18 GuestData worksheet Similarly, in cell D7 reference the named range AwaRadia. In cell D, 19 reference the ramed range AvaTalexisionIn cel D8, reference the ramned range 20 Ayglotomat 21 22 11 Incals E6.E9, calculate the Armount Spent - a fronty igure - by multiplying the Cost Per 23 Ad and the Ads Place 24 25 12 In cels F8:F10, calculate the cost per Guest Resul by dividing De Arourt Spent by the past 26 Guest Results 27 Type Notes Magazine Lowest Cost per Guest Result, yet same number Ads placed. Racia Budget rolonger supports even one Ad. Television Budget >than doubled, yet highest Cost per Guest Result Internet Budget rot increased thus Ads stayed the same. GuestData Advertising Plan Marketing Consultants + 13 In cels C10:E10. calculate the appropriate totals for each column. Ready 100% 14 Incala 16:9, calculate the Number of Ads that can be purchased based on the New Budget and the New Cost Per Ad in columns Gand H. Be sure to include a function (INT) that wil round the number down to the nearest integer since a partial ad cannot be purchased 15 In cels 6:19, calculate the amount to Spend - this is a monthly figure - hy multiplying the New Cool Per Ad and the Aus to Place. Page 2 of 3 12 Focus + 118% Home Insert Draw Share Comments Home Insert Draw Page Layout Formulas Data Wala Review View Tell me Share Comments H A- Design >> Tell me Ar Paragraph Styles Dictate Analysis Tools E How Puste Font Sensitivity Sart Get External Data Stoc Ceogra.. Filter Rafresh All de Data Tools What-11 If Analysis Outline 9 Ontha Advedis.coPan worksheet in oal F2, enter a function that will return the currant data. A1 fx A B C D F K L 1 2 Pointer Paradise New Budget Analysis Today's Date Cost per Guest Result Created On UTCG 2018 1 YO_Excel16_BUOD 5 Place Past Year, Monthly Advertising Cost Pat Guest Type Per Ad Ads Placed Results Amount Spant Magazine $ 1.200 3 Racio $300 $ 1 Television $ 5,000 1 Internet $ 1.100 2 Totals New Monthly Advertising Negotiation for Next Fiscal Year New Cost Ads To Amount Considera Anticipated Guest Now Budget Per Ad to Spend Change? ? Results $ 4,000 $ 1,300 $ 300 $ 325 S 12,000 $5,500 $ 2,200 $ 1,200 7 Rudiger. Guest Results 9 10 11 12 Grader Instruction Excel 201 13 14 Po 15 Step Instructions Poe 16 17 10 Incal Ds, reference the named range Axa Magazine toneum the value in cell 19 on the 18 GuestData worksheet Similarly, in cell D7 reference the named range AwaRadia. In cell D, 19 reference the ramed range AvaTalexisionIn cel D8, reference the ramned range 20 Ayglotomat 21 22 11 Incals E6.E9, calculate the Armount Spent - a fronty igure - by multiplying the Cost Per 23 Ad and the Ads Place 24 25 12 In cels F8:F10, calculate the cost per Guest Resul by dividing De Arourt Spent by the past 26 Guest Results 27 Type Notes Magazine Lowest Cost per Guest Result, yet same number Ads placed. Racia Budget rolonger supports even one Ad. Television Budget >than doubled, yet highest Cost per Guest Result Internet Budget rot increased thus Ads stayed the same. GuestData Advertising Plan Marketing Consultants + 13 In cels C10:E10. calculate the appropriate totals for each column. Ready 100% 14 Incala 16:9, calculate the Number of Ads that can be purchased based on the New Budget and the New Cost Per Ad in columns Gand H. Be sure to include a function (INT) that wil round the number down to the nearest integer since a partial ad cannot be purchased 15 In cels 6:19, calculate the amount to Spend - this is a monthly figure - hy multiplying the New Cool Per Ad and the Aus to Place. Page 2 of 3 12 Focus + 118%