Excel Pivot Table Exercise Solution - Questions What was...

Excel Pivot Table Exercise Solution
Download Document
Showing pages : 1 - 4 of 17
This preview has blurred sections. Sign up to view the full version! View Full Document
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?
Background image of page 1
Quarter 1 Grains/Cereals Above y Products es? ales in the 2nd quarter of 2005?
Background image of page 2
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 Côte de Blaye $25,127.36 Qtr 1 2005 Beverages Côte de Blaye $12,806.10 Qtr 2 2005 Beverages Côte de Blaye $7,312.12 Qtr 3 2005 Beverages Côte de Blaye $1,317.50 Qtr 4 2005 Beverages Guaraná Fantástica $529.20 Qtr 1 2005 Beverages Guaraná Fantástica $467.55 Qtr 2 2005 Beverages Guaraná Fantástica $219.37 Qtr 3 2005 Beverages Guaraná Fantástica $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 Lakkalikööri $1,141.92 Qtr 1 2005 Beverages Lakkalikööri $1,774.08 Qtr 2 2005 Beverages Lakkalikööri $3,261.60 Qtr 3 2005 Beverages Lakkalikööri $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 Rhönbräu Klosterbier $214.52 Qtr 1 2005 Beverages Rhönbräu Klosterbier $1,508.92 Qtr 2 2005 Beverages Rhönbräu Klosterbier $1,233.80 Qtr 3 2005 Beverages Rhönbräu 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
Background image of page 3
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
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.