The database Tissue.xlsx contains a transaction history describing more than 3,700 purchases of facial tissues at a number of stores in a grocery chain over a period of several weeks.
a. Compile a pivot table that gives a tabulation of the number of units sold by brand.
b. Compile a pivot table that gives a tabulation of sales units broken down by brand and by week.
c. Compile a pivot table that gives a tabulation of sales units broken down by brand, by week, and by store.
d. Compile a pivot table that gives a tabulation of sales units broken down by brand and by size of container. What is the sales volume in ounces for each brand?