1. (0.5 pt) Create three columns in the Data worksheet that calculate sales revenue, variable cost, and contribution margin for each sales record (each row.) Use the columns already named in the Data worksheet "sales revenue," "variable cost," and contribution margin, respectively. Format numbers in the three columns as Accounting with two decimal places. 2. (1.5 pt) Create a pivot table (on a new worksheet) that shows sales revenue by region for each of the four years. Correct any errors in the original dataset in the worksheet that are revealed in this initial pivot table (Hint: there are eight regions: Central, East coast, Midwest, Northeast, Northwest, South, West, and International). Once you have corrected the errors in the original data set, refresh the pivot table to reflect the corrected data. Format numbers as Accounting with two decimal places. Insert a pivot chart (below the pivot table) that shows the sales revenue trend by region over the four-year period. In the pivot chart, the x-axis should be years and the y-axis should be sales revenue. Below the pivot chart, please answer the following question: what trends do you see in the pivot table and pivot chart? Please name this worksheet: "Sales". 3. (0.5 pt) Create a pivot table on a new worksheet to answer the question "What was the most profitable brand in each year, as measured by contribution margin?" Please name this worksheet: "CM". 4.(0.5 pt) Arrange the worksheets in the following order: Sales, CM, and Data. Please save your Excel solution file using the following format: W AN 1. (0.5 pt) Create three columns in the Data worksheet that calculate sales revenue, variable cost, and contribution margin for each sales record (each row.) Use the columns already named in the Data worksheet "sales revenue," "variable cost," and contribution margin, respectively. Format numbers in the three columns as Accounting with two decimal places. 2. (1.5 pt) Create a pivot table (on a new worksheet) that shows sales revenue by region for each of the four years. Correct any errors in the original dataset in the worksheet that are revealed in this initial pivot table (Hint: there are eight regions: Central, East coast, Midwest, Northeast, Northwest, South, West, and International). Once you have corrected the errors in the original data set, refresh the pivot table to reflect the corrected data. Format numbers as Accounting with two decimal places. Insert a pivot chart (below the pivot table) that shows the sales revenue trend by region over the four-year period. In the pivot chart, the x-axis should be years and the y-axis should be sales revenue. Below the pivot chart, please answer the following question: what trends do you see in the pivot table and pivot chart? Please name this worksheet: "Sales". 3. (0.5 pt) Create a pivot table on a new worksheet to answer the question "What was the most profitable brand in each year, as measured by contribution margin?" Please name this worksheet: "CM". 4.(0.5 pt) Arrange the worksheets in the following order: Sales, CM, and Data. Please save your Excel solution file using the following format: W AN
