Products List Order

Select a Category:

ProductID 3 4 5 6 8 15 44 61 63 65 66 77

ProductName Aniseed Syrup Chef Anton's Cajun Seasoning Chef Anton's Gumbo Mix Grandma's Boysenberry Spread Northwoods Cranberry Sauce Genen Shouyu Gula Malacca Sirop d'érable Vegie-spread Louisiana Fiery Hot Pepper Sauce Louisiana Hot Spiced Okra Original Frankfurter grüne Soße

Condiments

CategoryName Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments

UnitPrice $10.00 $22.00 $21.35 $25.00 $40.00 $15.50 $19.45 $28.50 $43.90 $21.05 $17.00 $13.00

click a cell in column G to copy the row to the order form Price1 $407.00 $322.00 $558.00 $2.00 $686.00 $962.00 $6.00 $333.00 $438.00 $389.00 $883.00 $558.00

Price2 $347.00 $226.00 $210.00 $688.00 $491.00 $191.00 $400.00 $800.00 $8.00 $851.00 $791.00 $697.00

Move X X

X

ProductsList

ProductID ProductName 1 Chai 2 Chang This24table Guaraná is namedFantástica Database, and is Ale 34 Sasquatch used as the list for 35 Steeleye Stout the Advanced Filter. 38 Côte de Blaye 39 Chartreuse verte 43 Ipoh Coffee 67 Laughing Lumberjack Lager 70 Outback Lager 75 Rhönbräu Klosterbier 76 Lakkalikööri 3 Aniseed Syrup 4 Chef Anton's Cajun Seasoning 5 Chef Anton's Gumbo Mix 6 Grandma's Boysenberry Spread 8 Northwoods Cranberry Sauce 15 Genen Shouyu 44 Gula Malacca 61 Sirop d'érable 63 Vegie-spread 65 Louisiana Fiery Hot Pepper Sauce 66 Louisiana Hot Spiced Okra 77 Original Frankfurter grüne Soße 16 Pavlova 19 Teatime Chocolate Biscuits 20 Sir Rodney's Marmalade 21 Sir Rodney's Scones 25 NuNuCa Nuß-Nougat-Creme 26 Gumbär Gummibärchen 27 Schoggi Schokolade 47 Zaanse koeken 48 Chocolade 49 Maxilaku 50 Valkoinen suklaa 62 Tarte au sucre 68 Scottish Longbreads 11 Queso Cabrales 12 Queso Manchego La Pastora 31 Gorgonzola Telino 32 Mascarpone Fabioli 33 Geitost 59 Raclette Courdavault 60 Camembert Pierrot 69 Gudbrandsdalsost 71 Fløtemysost 72 Mozzarella di Giovanni 22 Gustaf's Knäckebröd 23 Tunnbröd 42 Singaporean Hokkien Fried Mee

CategoryName Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Condiments Confections Confections Confections Confections Confections Confections Confections Confections Confections Confections Confections Confections Confections Dairy Products Dairy Products Dairy Products Dairy Products Dairy Products Dairy Products Dairy Products Dairy Products Dairy Products Dairy Products Grains/Cereals Grains/Cereals Grains/Cereals

Page 3

UnitPrice Price1 $18.00 $111.00 $19.00 $186.00 $4.50 $300.00 $14.00 $984.00 $18.00 $727.00 $263.50 $479.00 $18.00 $214.00 $46.00 $581.00 $14.00 $935.00 $15.00 $718.00 $7.75 $864.00 $18.00 $419.00 $10.00 $407.00 $22.00 $322.00 $21.35 $558.00 $25.00 $2.00 $40.00 $686.00 $15.50 $962.00 $19.45 $6.00 $28.50 $333.00 $43.90 $438.00 $21.05 $389.00 $17.00 $883.00 $13.00 $558.00 $17.45 $446.00 $9.20 $206.00 $81.00 $451.00 $10.00 $546.00 $14.00 $476.00 $31.23 $873.00 $43.90 $121.00 $9.50 $630.00 $12.75 $324.00 $20.00 $149.00 $16.25 $98.00 $49.30 $395.00 $12.50 $685.00 $21.00 $360.00 $38.00 $239.00 $12.50 $72.00 $32.00 $864.00 $2.50 $889.00 $55.00 $68.00 $34.00 $646.00 $36.00 $310.00 $21.50 $408.00 $34.80 $363.00 $21.00 $13.00 $9.00 $309.00 $14.00 $958.00

ProductsList 52 56 57 64 9 17 29 53 54 55 7 14 28 51 74 10 13 18 30 36 37 40 41 45 46 58 73

Filo Mix Gnocchi di nonna Alice Ravioli Angelo Wimmers gute Semmelknödel Mishi Kobe Niku Alice Mutton Thüringer Rostbratwurst Perth Pasties Tourtière Pâté chinois Uncle Bob's Organic Dried Pears Tofu Rössle Sauerkraut Manjimup Dried Apples Longlife Tofu Ikura Konbu Carnarvon Tigers Nord-Ost Matjeshering Inlagd Sill Gravad lax Boston Crab Meat Jack's New England Clam Chowder Røgede sild Spegesild Escargots de Bourgogne Röd Kaviar

Grains/Cereals Grains/Cereals Grains/Cereals Grains/Cereals Meat/Poultry Meat/Poultry Meat/Poultry Meat/Poultry Meat/Poultry Meat/Poultry Produce Produce Produce Produce Produce Seafood Seafood Seafood Seafood Seafood Seafood Seafood Seafood Seafood Seafood Seafood Seafood

Page 4

$7.00 $38.00 $19.50 $33.25 $97.00 $39.00 $123.79 $32.80 $7.45 $24.00 $30.00 $23.25 $45.60 $53.00 $10.00 $31.00 $6.00 $62.50 $25.89 $19.00 $26.00 $18.40 $9.65 $9.50 $12.00 $13.25 $15.00

$470.00 $459.00 $98.00 $942.00 $505.00 $766.00 $986.00 $617.00 $143.00 $347.00 $780.00 $507.00 $895.00 $571.00 $799.00 $821.00 $673.00 $813.00 $967.00 $762.00 $672.00 $739.00 $808.00 $658.00 $456.00 $167.00 $622.00

ProductsList

Price2 $671.00 $772.00 $700.00 $364.00 $935.00 $590.00 $129.00 $808.00 $733.00 $936.00 $343.00 $804.00 $347.00 $226.00 $210.00 $688.00 $491.00 $191.00 $400.00 $800.00 $8.00 $851.00 $791.00 $697.00 $840.00 $717.00 $175.00 $694.00 $683.00 $730.00 $175.00 $134.00 $21.00 $739.00 $430.00 $711.00 $77.00 $684.00 $534.00 $58.00 $153.00 $534.00 $373.00 $418.00 $34.00 $189.00 $320.00 $830.00 $369.00 $205.00

Move

CategoryName Condiments This is the Criteria Area for the Advanced Filter. Cell G2 contains a link to the Data Validation cell on the Data Entry sheet.

Categories (All) Beverages Condiments Confections Dairy Products Grains/Cereals Meat/Poultry Produce Seafood

These cells are used as the source for the Data Validation dropdown list on the Data Entry sheet.

Page 5

ProductsList $177.00 $540.00 $745.00 $115.00 $56.00 $93.00 $669.00 $907.00 $43.00 $575.00 $79.00 $279.00 $639.00 $813.00 $565.00 $808.00 $708.00 $205.00 $690.00 $998.00 $814.00 $8.00 $491.00 $488.00 $34.00 $866.00 $481.00

Page 6

ProductID 4 6 61

ProductName Chef Anton's Cajun Seasoning Grandma's Boysenberry Spread Sirop d'érable

CategoryName Condiments Condiments Condiments

UnitPrice Col05 Col06 $22.00 $322.00 $226.00 $25.00 $2.00 $688.00 $28.50 $333.00 $800.00

Move X X X