Directions: Use the data found on the Sales Data worksheet to answer the following questions. Before your begin making your pivot tables, you will need to create a column that calculates the Net Revenue for each transaction (Total Revenue - Total Cost) Questions: 1 What is the best selling product based on total quantity sold? 2 What is the most profitable product based on the total Net Revenue? 3 What is the average Net Revenue for February 2012 orders? 4 What is the date for the Purchase Number that returned smallest Net Revenue? 5 Based on total Net Revenue for each customer location, which customer location is the most profitable? 6 Which month is responsible for the most number of purchases (Note: the year does not matter)? 7 Which quarter for the year 2013 produced the most (Gross) Total Revenue? 8 Which product in 2012 had the greatest total quantity sold? 9 How many products labeled as bicycles in the Product Group were sold in the years 2012-2013 combined? 10 How much Total Revenue, via mail and internet orders, was generated in Northern and Southern Germany combined for all Products Categories classified as "Off Road