Open the Problem_Data_CH11.xlsx Excel workbook. Review the four worksheets, then a create table for the data in each worksheet  Name each table the same as the worksheet.
a. Then, establish relationships between Sales and the other three worksheets
b. Summarize the data with a pivot table using the workbook’s data model
c. Drag Channel Name to the Rows box and Sales Amount to the Values box. Format Sum of Sales Amount as currency. Change the custom name to Channel Sales.
d. Add a PivotChart. Accept the default clustered column chart.
e. Change the title of the pivot chart to “Channel Sales 2020.”
f. Change the name of the worksheet to Problem 1.