5 There are two (2) parts to this assignment: 1 Part 1 -Create the following three (3) pivot tables (Label tabs as Pivot #1. Pivot #2 and Pivot #3): A. Sum of Total Cost and Quantity by Category by Product (Label Worksheet Pivot 1) 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) C. Sum of Total Cost by Category by Shipped Country (Label Worksheet Pivot 3) 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 Product 0 Order Cate Total Cost Customer Ship C Ship Count Quantit 4 NOTE - Test your Vlookup formulas by typing 50 into cell A11, the other cells will change as follows Product Alice Mutton Cate Meat/Poultry Quant 30 Total Cost 936 Customer Ship Ci Strasbourg Ship Count 6 Order 50 Blondesddsl pre et fils France 9 Part 3 . Save your file using First Name Last Name Excel #10 filename