There are two (2) parts to this assignment: 1 3 Part 1 . Create the following three (3) pivot tables (Label tabs as Pivot #1, Pivot #2 and Pivot #3): 4 A. Sum of Total Cost and Quantity by Category by Product (Label Worksheet Pivot 1) 5 B. Count of Customers (hint Customer field needs to be in the Row and Value Box Areas) and Sum of Total Costs (Label Worksheet Pivot 2) 6 C. Sum of Total Cost by Category by Shipped Country (Label Worksheet Pivot 3) 8 Part 2 - Use Vlookup formulas in cells B11, C11, D11, E11, F11, G11, & H11 that complete the table below when an order number is typed into A11 Quanti 10 Order Product Catego Total Cost Customer Ship Ci Ship Count 13 14 NOTE -Test your Vlookup formulas by typing 50 into cell A11, the other cells will change as follows 16 Order 17 18 19 Part 3 Save your file using First Name Last Name Excel #10 filename 20 21 Product Alice Mutton Catego Meat/Poultry Quanti Total Cost 936 Customer Ship Ci Ship Count 50 30 Blondesddsl pre et fils Strasbourg France 23 24