Open the Problem_Data_CH11.xlsx EXCEL workbook. Review the four worksheets, then a create table for the data in each worksheet (Hint: Insert > Tables > Table. Name each table the same as the worksheet. )

A. Then, establish relationships between Sales and the other three worksheets (Hint: Data > Data Tools > Relationships). Create relationships. Note that the table with the foreign key should be listed first and the table with the primary key is listed as the Related Lookup Table.

B. Summarize the data with a pivot table using the workbooks data model (Hint: Design > Tools > Summarize with PivotTable; select the box related to use of data model on the dialog box).

C. Drag ChannelName to the Rows box and SalesAmount to the Values box. Format Sum of SalesAmount as currency. Change the custom name to Channel Sales.

D. Add a PivotChart. Accept the default clustered column chart. Click Analyze > Tools > PivotChart.

E. Change the title of the pivot chart

F. Change the name of the worksheet to Problem 1.

In the same spreadsheet after completing problem 1, return to the Sales worksheet.

A. Summarize the data with a pivot table using the workbooks data model (Hint: Design > Tools > Summarize with PivotTable; select the box related to use of data model on the dialog box).

B. Drag ChannelName to the Rows box and SalesAmount to the Values box. Go to Value Field Settings. Select the Show Values As tab in the middle of the dialog box, use the pull-down menu to select Percent of Column Total. Close the Value Field Settings dialog box.