Calibri (Body) 11 A A = 10 ab General uste BIU $ % 9 00 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? fix Question A 8 C D E G Question Answer What is the total sales for the Coupon Campaign? How many Direct Mail Campaigns are there? What was the total profit for Atlanta? What was the total profit for New Yorkin July How many items are in the Local Ads campaign for New York? Similar to what we did in class and homework. Enter the appropriate functions in cells B3 through B7 to answer the questions in column A. The table for this problem is on the sheet named "info". You will need to define the range names for this problem related to the information that is on the info sheet (10 points) 6 7 8 9 20 21 22 24 25 26 27 Do Not Hard code Precese Show work Calibr (Body 11 A A 10 General B Conditional Form Formatting as Tau Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? B C D E H K L M N Using the information on the info sheet, the data for this problem is labeled, create a pivot table as a new sheet. The pivot table should show the total profit by campaign and month Name the sheet Pivot Table" 15 points) 1 2 3 25 26 27 28 29 31 33 Hul V General Paste BIU % ) Conditional Format Cell Formatting as Table Styles K Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? AL Sx Table for Problema 10 and 11 B D E F . 1 Table for Problema 10 and 11 2 City Campaign Month Cost Items Sales Profit 4 Atlanta Coupon April 12,000 299 35,581 23,581 5 Atlanta Direct Mail April 9,500 17 2,023 (7,477) 6 Atlanta Radio Spot April 12,000 299 35,581 23,581 7 Atlanta Direct Mail January 22,000 78 9,282 (12,718) B Atlanta Direct Mail January 22,000 78 9,282 (12,718) 9 Atlanta Coupon July 3,300 276 32.844 29,544 10 Atlanta Local Ads July 3,300 276 32,844 29,544 11 Atlanta Direct Mail October 12,500 61 7259 15,241) 12 Atlanta Direct Mail October 8,800 455 54,145 45,345 13 Columbus Coupon April 12,000 299 35,581 23,581 14 Columbus Direct Mail April 9,500 17 2.023 (7.4771 15 Columbus Local Ads April 9,500 17 2,023 (7.477) 16 Columbus Radio Spot April 8,000 345 41,055 33,055 17 Columbus Coupon January 12,500 80 9,520 (2.980) 18 Columbus Coupon January 8,800 25 2.975 15,825) 19 Columbus Coupon January 12,500 80 9.520 12,980) 20 Columbus Coupon January 8,800 25 2,975 (5.8251 21 Columbus Coupon January 12,500 BO 9,520 (2,980) 22 Columbus Coupon January 8,800 25 2,975 (5.825) 23 Columbus Direct Mall January 22.000 7R 9,282 (12,718) 24 Columbus Radio Spot January 17,500 56 6,664 110,836) 25 Columbus Radio Spot January 17,500 56 6,664 110236 26 Columbus Coupon July 9.500 93 1,567 27 Columbus Coupon July 4,000 Ha 10,472 6,472 28 Columbus Direct Mail July 7,000 100 11,900 4.200 29 Columbus Direct Mail July 7.000 100 11,900 4,900 TOD 1 Pro2 Pronto Proba Prob. Prob Probo Pro Prob Info 11,067 Proba
