Excel HW $5$: Sales Data$\backslash$

Directions:$\backslash$

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$)\backslash$

Questions:$\backslash$

$1$ What is the best selling product based on total quantity sold?$\backslash$

$2$ What is the most profitable product based on the total Net Revenue?$\backslash$

$4$ What is the date for the Purchase Number that returned smallest Net Revenue?$\backslash$

Based on total Net Revenue for each customer location, which customer location is the most profitable?$\backslash$

Which month is responsible for the most number of purchases $($Note: the year does not matter$)?\backslash$

Which quarter for the year $2013$ produced the most $($Gross$)$ Total Revenue?$\backslash$

Which preduct in $2012$ had the greatest total quantity sold?$\backslash$

How many products labeled as bicycles in the Product Group were sold in the years $2012-2013$ combined?$\backslash$

How much Total Revenue, via mail and internet orders, was generated in Northem and Southern Germany combined for all Products Categeries classified as "Ort Roud