Excel pivot table exercise solution

Excel Pivot Table Exercise Solution
Download Document
Showing pages : 1 - 5 of 17
This preview has blurred sections. Sign up to view the full version! View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Questions What was the total sales in 2005? $608,846.76 $2,272.00 Dairy Which quarter of 2005 was the best for the beverage category in terms of total sale Which product category registered sales on all products in each quarter of 2005? What was the 2nd quarter 2005 sales of Boston Crab Meat ? Was Jack's New England Clam Chowder above or below the average seafood sa Which was the best selling product category in 2005 in terms of total sales? Quarter 1 Grains/Cereals Above y Products es? ales in the 2nd quarter of 2005? Category Product Sales Quarter Year Beverages Chai $705.60 Qtr 1 2005 Beverages Chai $878.40 Qtr 2 2005 Beverages Chai $1,174.50 Qtr 3 2005 Beverages Chai $2,128.50 Qtr 4 2005 Beverages Chang $2,720.80 Qtr 1 2005 Beverages Chang $228.00 Qtr 2 2005 Beverages Chang $2,061.50 Qtr 3 2005 Beverages Chang $2,028.25 Qtr 4 2005 Beverages Chartreuse verte $590.40 Qtr 1 2005 Beverages Chartreuse verte $360.00 Qtr 2 2005 Beverages Chartreuse verte $1,100.70 Qtr 3 2005 Beverages Chartreuse verte $2,424.60 Qtr 4 2005 Beverages Cte de Blaye $25,127.36 Qtr 1 2005 Beverages Cte de Blaye $12,806.10 Qtr 2 2005 Beverages Cte de Blaye $7,312.12 Qtr 3 2005 Beverages Cte de Blaye $1,317.50 Qtr 4 2005 Beverages Guaran Fantstica $529.20 Qtr 1 2005 Beverages Guaran Fantstica $467.55 Qtr 2 2005 Beverages Guaran Fantstica $219.37 Qtr 3 2005 Beverages Guaran Fantstica $337.50 Qtr 4 2005 Beverages Ipoh Coffee $1,398.40 Qtr 1 2005 Beverages Ipoh Coffee $4,496.50 Qtr 2 2005 Beverages Ipoh Coffee $1,196.00 Qtr 3 2005 Beverages Ipoh Coffee $3,979.00 Qtr 4 2005 Beverages Lakkalikri $1,141.92 Qtr 1 2005 Beverages Lakkalikri $1,774.08 Qtr 2 2005 Beverages Lakkalikri $3,261.60 Qtr 3 2005 Beverages Lakkalikri $1,705.50 Qtr 4 2005 Beverages Laughing Lumberjack Lager $518.00 Qtr 2 2005 Beverages Laughing Lumberjack Lager $350.00 Qtr 3 2005 Beverages Laughing Lumberjack Lager $42.00 Qtr 4 2005 Beverages Outback Lager $1,508.40 Qtr 1 2005 Beverages Outback Lager $384.00 Qtr 2 2005 Beverages Outback Lager $1,252.50 Qtr 3 2005 Beverages Outback Lager $2,683.50 Qtr 4 2005 Beverages Rhnbru Klosterbier $214.52 Qtr 1 2005 Beverages Rhnbru Klosterbier $1,508.92 Qtr 2 2005 Beverages Rhnbru Klosterbier $1,233.80 Qtr 3 2005 Beverages Rhnbru Klosterbier $1,233.80 Qtr 4 2005 Beverages Sasquatch Ale $179.20 Qtr 1 2005 Beverages Sasquatch Ale $1,037.40 Qtr 2 2005 Beverages Sasquatch Ale $750.40 Qtr 4 2005 Beverages Steeleye Stout $1,742.40 Qtr 1 2005 Beverages Steeleye Stout $1,008.00 Qtr 2 2005 Beverages Steeleye Stout $1,683.00 Qtr 3 2005 Beverages Steeleye Stout $1,273.50 Qtr 4 2005 Condiments Aniseed Syrup $544.00 Qtr 1 2005 Condiments Aniseed Syrup $600.00 Qtr 2 2005 Condiments Aniseed Syrup $140.00 Qtr 3 2005 Condiments Aniseed Syrup $440.00 Qtr 4 2005 Condiments Chef Anton's Cajun Seasoning $225.28 Qtr 1 2005 Condiments Chef Anton's Cajun Seasoning $2,970.00 Qtr 2 2005 Condiments Chef Anton's Cajun Seasoning $1,337.60 Qtr 3 2005...
View Full Document