Data set:

2 Q2 - Using Data Set A, set up a summary to answer the following using formulas only Question 2 a. How much revenue did each Business Unit have every month? b. Add totals \& averages for each column \& row for Step A c. If Group B's approximate margin was 30% what is the total margin dollars in 2020 ? d. Add conditional formatting to any column that makes sense. Add a note as to why you did that e. Make any logical pivot table referencing the "Type" Note for conditional formating: 2 Q2 - Using Data Set A, set up a summary to answer the following using formulas only Question 2 a. How much revenue did each Business Unit have every month? b. Add totals \& averages for each column \& row for Step A c. If Group B's approximate margin was 30% what is the total margin dollars in 2020 ? d. Add conditional formatting to any column that makes sense. Add a note as to why you did that e. Make any logical pivot table referencing the "Type" Note for conditional formating