use excel or a similar software to create a pivot table of the following data.

answer should look like this

Aa June 6, 2021 at 10:46 PM 1. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivot Table that shows the total revenue and quantity for each combination of country and year. a. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivot Table that shows the total revenue for each combination of Year, Sales Outlet, and Distribution Channel. Use proper number formatting. b. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivottable that answers the following question: In 2011, what sales revenue did each product category generate through each distribution channel? Use proper number formatting. C. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivot Table that shows how many bikes in each category were sold by each sales outlet. Create the PivotTable so that you can show one year at a time. Use proper number formatting. d. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a PivotTable that shows the revenue and quantity for each combination of sales outlet, product category and distribution channel. Use proper number formatting. el . For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivottable that shows the quantity sold of each product. Create the PivotTable so that you can show one country at a time. Use proper number formatting Bike Sales () Protected View - Excel Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay B D E F G ar 2014 w Labels Internet Childrens Bike (CB) Mountain bike (M8) Racing bike (RB) Touring Bike (TB) Urban Bike (UB) Wholesale Childrens Bike (CB) Mountain bike (MB) Racing bike (RB) Touring Bike (TB) Urban Bike (UB) md Total Sum of Revenue $14,342,B37.49 $571,850.15 $4,741,043.09 $4,605,238,47 $2,014 254.01 $2.410.451.77 $13,199,702.89 $604.381.69 $4.291,799.45 $3,393,054 10 $2.751,719.68 $2,158 747.97 $27,542,540.38 1. 2. 3. 4. 5. Bike Sales.xdsx Type here to search B Aa June 6, 2021 at 10:46 PM 1. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivot Table that shows the total revenue and quantity for each combination of country and year. a. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivot Table that shows the total revenue for each combination of Year, Sales Outlet, and Distribution Channel. Use proper number formatting. b. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivottable that answers the following question: In 2011, what sales revenue did each product category generate through each distribution channel? Use proper number formatting. C. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivot Table that shows how many bikes in each category were sold by each sales outlet. Create the PivotTable so that you can show one year at a time. Use proper number formatting. d. For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a PivotTable that shows the revenue and quantity for each combination of sales outlet, product category and distribution channel. Use proper number formatting. el . For this learning activity, use the "Bike_Sales.xlsx" file. Use the file to create a Pivottable that shows the quantity sold of each product. Create the PivotTable so that you can show one country at a time. Use proper number formatting Bike Sales () Protected View - Excel Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay B D E F G ar 2014 w Labels Internet Childrens Bike (CB) Mountain bike (M8) Racing bike (RB) Touring Bike (TB) Urban Bike (UB) Wholesale Childrens Bike (CB) Mountain bike (MB) Racing bike (RB) Touring Bike (TB) Urban Bike (UB) md Total Sum of Revenue $14,342,B37.49 $571,850.15 $4,741,043.09 $4,605,238,47 $2,014 254.01 $2.410.451.77 $13,199,702.89 $604.381.69 $4.291,799.45 $3,393,054 10 $2.751,719.68 $2,158 747.97 $27,542,540.38 1. 2. 3. 4. 5. Bike Sales.xdsx Type here to search B