Analyze "Air World's" Sponsored Search Campaign

Instructions:

Based on the dataset for Air World's sponsored search advertising campaign in the "Air World $-$ Sponsored Search Campaign Data.xIsx" file, you will prepare and analyze a table summarizing the data in the Air World spreadsheet by the "Search Engine Name" field according to the following specifications. Use the pivot table feature in Excel to create this table. The goal of this project part is to make you more capable of analyzing a large data set from a search engine campaign.

There should be a row for each unique entry in the "Search Engine Name" field.

There should be a column for each of the following variables: Impressions, Clicks, Transactions, Click Charges $($Cost$),$ and Revenue.

Each cell of the table should be the sum of that value for that search engine name.

Include a Grand Total row which sums each of the five variables across all search engine names.

Overall, you need to complete this table:

$($you also need to generate the same table in Excel$)$

$\backslash$table$[[\backslash$table$[[$Search Engine$],[$Name$]],,,,\backslash$table$[[$Click$],[$Iharges$],[($cost$)]],$Revenue$],[$Google Search$-$ US$,,,,,],[$MSN Bing $-$ US$,,,,,],[$Google$-$Europe,,,,,$],[$MSN Bing$-$Europe,,,,,$]]$