Excel Pivot Table Exercise Solution

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

This preview shows pages 1–5. Sign up to view the full content.

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?

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
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 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

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.
• Spring '10
• Lewis
• Qtr, Clam chowder, Hot sauce, Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Bever

### Page1 / 17

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

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online