INSTRUCTIONS COFFEE SALES Insert a column in between Month and Product and label it "Year" Enter "2019" in Year column for all months March-December, enter "2020" for January and February Change the format of the Monthly Sales $ to Currency without "$" and 2 decimals Make the Title Row BOLD Right justify all columns and adjust widths to show full cell contents Make nine new tabs making copies of this data set and label Coffee Sales 1, Coffee Sales 2, Coffee Sales 3....Coffee Sales 9 Coffee Sales 1 Add Total Row to bottom of data set and use SUM function to find Total Sales $ Sort the data by State and then by Month Coffee Sales 2 Create a new Column after Monthly Sales $ called "Profit" Create a formula in the "Profit" column that assumes Profit=50% of Sales Copy and paste the formula down the data set Coffee Sales 3 Convert data to Table Add Total Row to Table Use the Filter Button to filter by State and include just California Rename Table to "Coffee_Sales_California" Coffee Sales 4 Calculate the following: Total Sales for Oregon Use the Sort or Filter Method Use the Sumif Formula Use the Sumif Formula with an INPUT cell Coffee Sales 5 Calculate the following: Total Sales for Kona Koast Use the Sort or Filter Method Use the Sumif Formula Use the Sumif Formula with an INPUT cell Coffee Sales 6 Calculate the following: Number of times sales were over $500 Use the Sort or Filter Method Use the Countif Formula Use theCountif Formula with an INPUT cell Coffee Sales 7 Calculate the following: Total Sales of Volcano Blend in California Use Sumif Formula with two input cells Tip: Use filter to check your answer Coffee Sales 8 Add another Column titled "Commissions" Use If/then formula to calculate Commissions, assuming each sale above $100 has a 10% commission Format Commission column to Currency with 0 decimals Add Total Row to determine Total Commissions Coffee Sales 9 Add another Column titled "Commissions" Calculate the Commissions based on the following commission schedule: Sales Commission $0-99 0% $100-499 10% $500 + 20% Tip: Remember that the order of the conditions is KEY Format Commission column to Currency with 0 decimals Add Total Row to determine Total Commissions

Month Product State Monthly Sales $ AugustBest Blend of Arabia California 4.369714783 JuneBest Blend of Arabia Oregon 40.85755171 AprilBest Blend of Arabia Oregon 42.51505205 JanuaryBest Blend of Arabia Oregon 64.5027181 MarchBest Blend of Arabia California 146.1272049 MarchBest Blend of Arabia Oregon 227.0842938 JulyBest Blend of Arabia Washington276.5120189 MarchBest Blend of Arabia Washington320.7277321 MarchBest Blend of Arabia Oregon 324.5046182 SeptemberBest Blend of Arabia California 360.4272276 MarchBest Blend of Arabia Washington426.4487627 MayBest Blend of Arabia Washington428.5482851 AprilBest Blend of Arabia Washington450.0324134 MarchBest Blend of Arabia California 457.0765386 MarchBest Blend of Arabia California 462.0826339 AugustBest Blend of Arabia Washington532.9133588 FebruaryBest Blend of Arabia Washington541.3377662 AprilBest Blend of Arabia California 567.3847293 MarchBest Blend of Arabia Washington602.0356352 AugustBest Blend of Arabia Oregon 674.2870645 JulyBest Blend of Arabia California 676.7355756 MarchBest Blend of Arabia Washington680.7120179 MayBest Blend of Arabia Oregon 685.8418291 JanuaryBest Blend of Arabia California 709.8202184 SeptemberBest Blend of Arabia Washington743.1324919 MarchBest Blend of Arabia Oregon 744.9669343 JuneBest Blend of Arabia California 763.2230001 JuneBest Blend of Arabia Washington 810.140676 MayBest Blend of Arabia California 816.8391455 MarchBest Blend of Arabia Washington832.2841627 MarchBest Blend of Arabia California 841.9905909 MarchBest Blend of Arabia Oregon 864.9003149 SeptemberBest Blend of Arabia Oregon 869.2545755 MarchBest Blend of Arabia California 883.4350407 JulyBest Blend of Arabia Oregon 920.6084807 FebruaryBest Blend of Arabia California 962.6324034 FebruaryBest Blend of Arabia Oregon 962.9114933 MarchBest Blend of Arabia Oregon 997.6639272 March Breakfast Blastoff California 20.4022016 February Breakfast Blastoff Washington 99.9946254 September Breakfast Blastoff California 120.7311623 March Breakfast Blastoff California 150.3327616 March Breakfast Blastoff California 171.2718988 April Breakfast Blastoff Oregon 182.1466471 May Breakfast Blastoff California 191.4476456 April Breakfast Blastoff California 200.1425104 May Breakfast Blastoff Washington222.3426947 March Breakfast Blastoff Oregon 238.3433727 March Breakfast Blastoff Oregon 262.0642042 March Breakfast Blastoff Washington 272.550903 August Breakfast Blastoff Washington285.8465806 July Breakfast Blastoff Oregon 311.8537918 January Breakfast Blastoff Oregon 314.9429086 June Breakfast Blastoff Oregon 368.2515321 July Breakfast Blastoff Washington403.9534673 April Breakfast Blastoff Washington409.1449789 March Breakfast Blastoff Oregon 415.5438204 May Breakfast Blastoff Oregon 448.2294207 September Breakfast Blastoff Washington454.8676104 March Breakfast Blastoff Washington456.8565914 June Breakfast Blastoff California 517.7701031 June Breakfast Blastoff Washington523.5640132 July Breakfast Blastoff California 556.0830371 March Breakfast Blastoff Washington588.2881043 March Breakfast Blastoff California 598.7342811 February Breakfast Blastoff Oregon 603.6417932 March Breakfast Blastoff Oregon 640.3219076 September Breakfast Blastoff Oregon 681.5284735 March Breakfast Blastoff Washington755.6681052 March Breakfast Blastoff Washington827.7346809 March Breakfast Blastoff Oregon 869.8767322 February Breakfast Blastoff Washington918.0810296 August Breakfast Blastoff California 936.140909 August Breakfast Blastoff Oregon 956.1829421 March Breakfast Blastoff California 984.3878828 MayBreakfast Blastoff Decaf Washington22.88146562 MayBreakfast Blastoff Decaf Oregon 51.215476 JulyBreakfast Blastoff Decaf California 96.32066447 FebruaryBreakfast Blastoff Decaf Oregon 128.7191073 JuneBreakfast Blastoff Decaf Oregon 164.9081065 MarchBreakfast Blastoff Decaf Oregon 187.8402434 AugustBreakfast Blastoff Decaf Oregon 207.6375988 AugustBreakfast Blastoff Decaf California 286.281624 MarchBreakfast Blastoff Decaf Washington391.6430291 AprilBreakfast Blastoff Decaf Oregon 445.5661773 JulyBreakfast Blastoff Decaf Oregon 450.1186101 JanuaryBreakfast Blastoff Decaf Oregon 451.5056376 SeptemberBreakfast Blastoff Decaf Washington457.1274544 MarchBreakfast Blastoff Decaf Washington467.6670985 FebruaryBreakfast Blastoff Decaf Washington472.5384665 MarchBreakfast Blastoff Decaf Oregon 496.3650589 MarchBreakfast Blastoff Decaf Washington550.1832035 MarchBreakfast Blastoff Decaf California 580.9733226 SeptemberBreakfast Blastoff Decaf California 596.5891448 JuneBreakfast Blastoff Decaf Washington622.8074492 MarchBreakfast Blastoff Decaf California 623.3258948 AprilBreakfast Blastoff Decaf California 631.1434316 AugustBreakfast Blastoff Decaf Washington666.7488562 SeptemberBreakfast Blastoff Decaf Oregon 668.9701818 JuneBreakfast Blastoff Decaf California 709.9092847 MarchBreakfast Blastoff Decaf California 784.83382 AprilBreakfast Blastoff Decaf Washington 805.95527 MarchBreakfast Blastoff Decaf Oregon 810.1474811 MarchBreakfast Blastoff Decaf California 820.2142309 MarchBreakfast Blastoff Decaf Oregon 840.0620399 FebruaryBreakfast Blastoff Decaf Washington844.9262109 MarchBreakfast Blastoff Decaf Oregon 879.5337104 MarchBreakfast Blastoff Decaf Washington884.6780736 JulyBreakfast Blastoff Decaf Washington892.3636661 MarchBreakfast Blastoff Decaf Washington935.7097892 MarchBreakfast Blastoff Decaf California 967.7030517 MayBreakfast Blastoff Decaf California 979.2122971 September Kona Koast Oregon 37.0241235 May Kona Koast Oregon 58.84481324 March Kona Koast Oregon 79.78257473 March Kona Koast Washington149.0957787 August Kona Koast Washington194.3963306 March Kona Koast Washington197.7529887 September Kona Koast California 263.2927293 May Kona Koast California 299.5187202 March Kona Koast Washington305.3945029 July Kona Koast Washington320.1883404 June Kona Koast Washington336.8354817 March Kona Koast California 419.9077521 September Kona Koast Washington427.8322626 May Kona Koast Washington473.7029942 August Kona Koast California 484.773253 March Kona Koast Washington506.5323434 June Kona Koast Oregon 512.2336114 January Kona Koast California 512.9099166 March Kona Koast Oregon 521.4515378 February Kona Koast Washington584.5921218 April Kona Koast Oregon 611.7401337 June Kona Koast California 639.8894357 March Kona Koast California 677.516462 March Kona Koast Oregon 701.4846585 March Kona Koast Washington706.5682627 March Kona Koast California 713.5598566 February Kona Koast California 715.9429408 April Kona Koast California 739.03888 August Kona Koast Oregon 774.590615 April Kona Koast Washington795.2385805 March Kona Koast Oregon 801.3791282 February Kona Koast Oregon 852.4314716 March Kona Koast California 883.0352 March Kona Koast Oregon 946.8314157 July Kona Koast Oregon 958.5277499 July Kona Koast California 962.4977959 March Kona Koast California 991.3611496 JuneTurkish Delight Roast California 13.05137222 MarchTurkish Delight Roast Washington14.84816907 MayTurkish Delight Roast Oregon 15.06200991 JuneTurkish Delight Roast Washington52.86527935 SeptemberTurkish Delight Roast California 70.03611505 MarchTurkish Delight Roast Washington88.51076126 MarchTurkish Delight Roast Washington90.37670564 MarchTurkish Delight Roast California 99.37279142 AugustTurkish Delight Roast Oregon 99.51177638 MarchTurkish Delight Roast Oregon 175.7135804 JuneTurkish Delight Roast Oregon 190.5784141 JanuaryTurkish Delight Roast Oregon 242.9348471 JulyTurkish Delight Roast Washington310.0014822 MarchTurkish Delight Roast Oregon 344.6013288 MayTurkish Delight Roast California 345.6944882 JanuaryTurkish Delight Roast California 352.3410667 MarchTurkish Delight Roast California 361.3362323 MarchTurkish Delight Roast Oregon 401.5418985 SeptemberTurkish Delight Roast Oregon 456.404244 FebruaryTurkish Delight Roast Oregon 468.8323892 MarchTurkish Delight Roast Oregon 551.4726566 MarchTurkish Delight Roast Washington569.8586149 FebruaryTurkish Delight Roast California 598.9710512 FebruaryTurkish Delight Roast Washington621.6470466 AprilTurkish Delight Roast California 626.8267918 SeptemberTurkish Delight Roast Washington644.2435724 JulyTurkish Delight Roast California 649.9880709 MarchTurkish Delight Roast California 681.1981303 MarchTurkish Delight Roast Oregon 696.0089795 MarchTurkish Delight Roast California 741.9587132 MayTurkish Delight Roast Washington786.4182911 MarchTurkish Delight Roast Washington 787.483769 AugustTurkish Delight Roast Washington812.5261215 AprilTurkish Delight Roast Washington 880.27881 AprilTurkish Delight Roast Oregon 920.0433695 MarchTurkish Delight Roast California 942.2516024 JulyTurkish Delight Roast Oregon 951.4455588 AugustTurkish Delight Roast California 962.1953624 March Volcano Blend Oregon 20.80152175 May Volcano Blend Oregon 23.9241356 March Volcano Blend Washington43.45485069 August Volcano Blend California 63.28240664 March Volcano Blend California 116.3117077 July Volcano Blend Oregon 174.797926 March Volcano Blend California 200.4342586 July Volcano Blend California 205.5419654 May Volcano Blend Washington211.7796075 February Volcano Blend Washington256.7065643 March Volcano Blend California 300.4909396 February Volcano Blend California 352.9666484 August Volcano Blend Washington 466.711575 March Volcano Blend Washington491.4245139 April Volcano Blend Oregon 520.4027526 March Volcano Blend Washington573.7675915 May Volcano Blend California 599.2564927 March Volcano Blend Oregon 695.8131401 March Volcano Blend Oregon 704.5432282 February Volcano Blend Oregon 733.1482051 April Volcano Blend Washington764.5823101 July Volcano Blend Washington 785.180122 June Volcano Blend California 807.2980034 March Volcano Blend Washington815.6744945 August Volcano Blend Oregon 829.8903025 March Volcano Blend California 830.3051286 March Volcano Blend Oregon 849.7916651 September Volcano Blend Oregon 857.2578477 September Volcano Blend California 862.4547011 September Volcano Blend Washington 880.265967 January Volcano Blend California 894.3408599 April Volcano Blend California 919.1190018 March Volcano Blend Washington941.8687443 June Volcano Blend Oregon 948.2711955 June Volcano Blend Washington966.4267166 March Volcano Blend Oregon 993.0007595 March Volcano Blend California 995.1754807