1 A WineryName B C D E F State 2 Andretti Winery CA WineID 6 Chardonnay, Carneros Desc. of Wine Retail Value Quantity on Hand G Alcohol % H J K L M N P $20.00 24 3 Andretti Winery CA 7 Chardonnay Old Vine $25.00 36 4 Cambria Winery CA 13 Syrah $22.00 36 Category Name 13.5 White Table Wines 13.2 White Table Wines 13.1 Red Table wines Class Description Chardonnay 5 Cambria Winery CA 14 Old Brandy Select $45.00 12 0.4 Distilled Products 6 Chateau St. Michaelle WA 17 Pinot Blanc Estate $26.00 36 11 White Table Wines 7 Duck Pond OR 15 Tempranillo Reserve $18.00 24 12.9 Red Table wines 8 Hess Collection Winery CA 4 Chardonnay Grand Reserve $32.00 24 11.87 White Table Wines Hess Collection Winery 10 King Estate King Estate 11 12 Stolpman Vineyards 13 Stolpman Vineyards 14 Sunstone Winery 15 Sunstone Winery 16 Widmer Wine Cellars 17 Widmer Wine Cellars 18 Widmer Wine Cellars 19 Woodbury Vineyards 20 Woodbury Vineyards J J J J J J J CA 5 Chardonnay, Family Selection $14.00 36 13.3 White Table Wines CA 8 Cabernet Sauv "Seven Oaks" $30.00 36 13.8 Red Table wines CA 16 Blush $15.00 36 11 Blush, Pink, and Rose Wines CA 18 Riesling Reserve $22.00 36 12 Late Harvest Wines CA 19 Syrah $60.00 45 13.4 Red Table wines CA 9 Zinfandel Reserve $28.00 48 13.1 Red Table wines CA 10 Chianti Classico $40.00 48 13.6 Red Table wines NY 1 Cannonau Di Sardenia $20.00 36 13.1 Red Table wines Chardonnay Syrah Brandy, Port Still Pinot Blanc Tempranillo Chardonnay Chardonnay Cabernet Sauvignon Zinfandel Rose White Riesling Syrah Zinfandel Chianti Grenache NY 2 Chianti Classico Riserva $25.00 38 13.4 Red Table wines Chianti NY 3 Viogner Vintner's Reserve $28.00 12 12 White Table Wines Viognier NY 11 Syrah Reserve $25.00 24 14.1 Red Table wines Syrah NY 12 Syrah $18.00 12 13.4 Red Table wines Syrah 21 22 Ready export query 90% 5. Use Analyze Data under the Analysis Tab to count how many Wineries have entered the competition. Use the field WineryName for this question. Hint: If a Wineries has three entries only count each winery one time. Save this in another tab. Rename the tab to: Count of Wineries and change the tab color to blue. 6. Use Analyze Data under the Analysis Tab to count how many Categories and Classifications there are. Hint: Counting unique occurrences. Save this in another tab. Rename the tab to: Count of Cat & Class and change the tab color to Green.