1. Excel PIVOT TABLES. For each question, create a new pivotable:
   1. Find during each month the percentage of sales generated by each salesperson
   2. Determine the units sold by each salesperson of each product. Use a Slicer to summarize sales during January-March. Create a Chart to determine the revenue brought in by each salesperson for each location. You may create a PivotTable with a PivotChart or use the regular Excel Chart functions. Your chart must show a title, and labels on both axis.

   3. Product	Salesperson	Month	Location	Units	Revenue
      Napoleon (piece)	Charlene	November	East	99	$ 346.50
      Napoleon (piece)	Charlene	January	East	32	$ 112.00
      Fresh fruit tart--tropical	Charlene	December	East	35	$ 630.00
      Sacher torte	Charlene	February	East	37	$ 1,110.00
      Napoleon (piece)	Charlene	August	East	38	$ 133.00
      Vanilla éclair	Charlene	December	East	84	$ 294.00
      Pear Charlotte	Charlene	October	East	60	$ 1,500.00
      Tahiti (vanilla-rum) cake	Charlene	June	East	86	$ 2,752.00
      Raspberry Charlotte	Charlene	August	East	60	$ 1,500.00
      Caramel éclair	Charlene	March	East	30	$ 105.00
      Petits fours, per 12	Damon	January	East	84	$ 1,344.00
      Vanilla éclair	Damon	September	East	75	$ 262.50
      Petits fours, per 12	Damon	November	East	85	$ 1,360.00
      Raspberry Charlotte	Damon	August	East	77	$ 1,925.00
      Orange-passion flan	Damon	February	East	17	$ 391.00
      Tahiti (vanilla-rum) cake	Damon	November	East	79	$ 2,528.00
      Tahiti (vanilla-rum) cake	Damon	January	East	100	$ 3,200.00
      Opéra torte	Damon	December	East	76	$ 2,432.00
      Napoleon (piece)	Damon	August	East	21	$ 73.50
      Napoleon (piece)	Damon	March	East	89	$ 311.50
      Chocolate éclair	Hong	October	East	66	$ 231.00
      Praliné torte	Hong	May	East	29	$ 870.00
      Orange-passion flan	Hong	July	East	64	$ 1,472.00
      Sacher torte	Hong	November	East	82	$ 2,460.00
      Napoleon (piece)	Hong	August	East	45	$ 157.50
      Pear Charlotte	Hong	September	East	55	$ 1,375.00

Answer rating: 100% (QA)

a The percenta... View the full answer