Question

1 Approved Answer

Posted on Jul 16, 2024

Excel File Edit View Insert Format Tools Data Window Help Final AutoSave ABES Insert Draw Page Layout Formulas Data Review View Tell Home Calibri (Body)

Excel File Edit View Insert Format Tools Data Window Help Final AutoSave ABES Insert Draw Page Layout Formulas Data Review View Tell Home Calibri (Body) 11 General Paste BIV $ % wa H3 C D E F G H -NM 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) 10 12 12 13 14 15 36 17 18 15 20 21 22 23 24 25 26 27 Probs 7 Info Prob 8 Probo Prob 10 Pro 11 Pivot table Info 22 16 cel File Edit View Insert Window Help Format Tools Data Final Data Review View Tell me Insert AutoSave ABES Draw Page Layout Formulas Arial 10 A A BIU A 2 Condit General Format $ % Cell Sty G H A B Table for Problema 10 and 11 City Atlanta Atlanta Atlanta Atlanta Atlanta Atlanta 10 Atlanta 1 Adana 12 Atlanta 13 Columbus 14 Columbus 15 Columbus 16 Columbus 17 Columbus 18 Columbus 19 Columbus 20 Columbus 21 Columbus 22 Columbus 92 Campaign Coupon Direct Mail Radio Spot Direct Mail Direct Mail Coupon Local Ads Direct Mail Direct Mail Coupon Direct Mail Local Ads Radio Spot Coupon Coupon Couson Coupon Coupon Coupon Month April April April January January July July October October April April April April January January January January January January Cost 12 000 9.500 12,000 22,000 22,000 3,300 3,300 12.500 8,800 12.000 9,500 9,500 8,000 12.500 1800 12.500 3,800 12.500 100 Items City 299 Atlanta 17 Atlanta 299 Atlanta 78 Atlanta 78 Atlanta 276 Atlanta 276 Atlanta 61 Atlanta 455 Atlanta 299 Columbus 17 Columbus 17 Columbus 345 Columbus 30 Columbus 25 Columbus 80 Columbus 25. Columbus 80 Columbus 25 Columbus Campaign Coupon Direct Mall Radio Spot Direct Mai Direct Mail Coupon Local Ads Direct Mail Direct Mail Coupon Direct Mail Local Ads Radio Spot Coupon Coupon Coupon Coupon Coupon Coupon 7 Indo Probs Probo Proh 10 Prob 11 Pivollable info + Peace pacifist GO cel File Edit View Insert Format Tools Data Window Help Autolave Final Insert Draw Page Layout Formulas Data Review View Tell me Share X Calibri (Bodyl 11 A A . BIU Accounting $% % Conditional Formatting EP Formatas Table Cell Styles Celle A Question 8 D E 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 York in 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 83 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. 0 1 L2 13 14 15 16 17 110 points) Pro P10 peste symbols pacifim... peace-symbole allout.jpg 09 % S 4 3 Show work use teuble for both Problems Excel File Edit View Insert Format Tools Data Window Help Final AutoSave ABES Insert Draw Page Layout Formulas Data Review View Tell Home Calibri (Body) 11 General Paste BIV $ % wa H3 C D E F G H -NM 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) 10 12 12 13 14 15 36 17 18 15 20 21 22 23 24 25 26 27 Probs 7 Info Prob 8 Probo Prob 10 Pro 11 Pivot table Info 22 16 cel File Edit View Insert Window Help Format Tools Data Final Data Review View Tell me Insert AutoSave ABES Draw Page Layout Formulas Arial 10 A A BIU A 2 Condit General Format $ % Cell Sty G H A B Table for Problema 10 and 11 City Atlanta Atlanta Atlanta Atlanta Atlanta Atlanta 10 Atlanta 1 Adana 12 Atlanta 13 Columbus 14 Columbus 15 Columbus 16 Columbus 17 Columbus 18 Columbus 19 Columbus 20 Columbus 21 Columbus 22 Columbus 92 Campaign Coupon Direct Mail Radio Spot Direct Mail Direct Mail Coupon Local Ads Direct Mail Direct Mail Coupon Direct Mail Local Ads Radio Spot Coupon Coupon Couson Coupon Coupon Coupon Month April April April January January July July October October April April April April January January January January January January Cost 12 000 9.500 12,000 22,000 22,000 3,300 3,300 12.500 8,800 12.000 9,500 9,500 8,000 12.500 1800 12.500 3,800 12.500 100 Items City 299 Atlanta 17 Atlanta 299 Atlanta 78 Atlanta 78 Atlanta 276 Atlanta 276 Atlanta 61 Atlanta 455 Atlanta 299 Columbus 17 Columbus 17 Columbus 345 Columbus 30 Columbus 25 Columbus 80 Columbus 25. Columbus 80 Columbus 25 Columbus Campaign Coupon Direct Mall Radio Spot Direct Mai Direct Mail Coupon Local Ads Direct Mail Direct Mail Coupon Direct Mail Local Ads Radio Spot Coupon Coupon Coupon Coupon Coupon Coupon 7 Indo Probs Probo Proh 10 Prob 11 Pivollable info + Peace pacifist GO cel File Edit View Insert Format Tools Data Window Help Autolave Final Insert Draw Page Layout Formulas Data Review View Tell me Share X Calibri (Bodyl 11 A A . BIU Accounting $% % Conditional Formatting EP Formatas Table Cell Styles Celle A Question 8 D E 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 York in 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 83 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. 0 1 L2 13 14 15 16 17 110 points) Pro P10 peste symbols pacifim... peace-symbole allout.jpg 09 % S 4 3 Show work use teuble for both Problems