By using the MS Excel spreadsheet GB Data for Pivot Table shared in this drive: https://docs.google.com/spreadsheets/d/10eRyBD_Xt3ADfI_qdezkaBvtr0ALAaGE/edit?usp=sharing&ouid=101152936309966519094&rtpof=true&sd=true,

please answer the following questions.

Answer Sheet / Using Excel Pivot Tables for Analytics Provide screenshots to support your answers. Question 1: What was the overall revenue for all years? Which year had the highest revenue, and what was the revenue during that year?

Question 2: What is the Revenue for E-Bike in 2018?

Question 3: What is the Revenue for E-Bike in 2017?

Question 4: What is the Sales Quantity of T-shirts for Airport Bikes in 2015?

Question 5: What year had the highest Sales Quantity?

Question 6: What year had the lowest Revenue?

Question 7: Which material had the lowest revenue overall?

Question 8: In the year that had the highest Net Sales, what division had the highest Net Sales?

Question 9: For the division and year in Question 9, which customer had the highest Net Sales?

Question 10: In the year with the lowest Net Sales, what division had the highest Net Sales?

Question 11: For the division in Question 11, which customer had the highest Net Sales for all years?

Question 12: What customer provided the highest Net Sales for Accessories (Division AS) in 2017?

Question 13: In 2019, for Bicycles (Division is BI), what is the total Revenue for the top three customers?

Question 14: What is the average Revenue per customer?

Question 15: What is the average Revenue per customer each year?

Question 16: What is the average Revenue per customer per year per division?

Question 17: What is the average Revenue per customer for each of the years? Which year has the highest average Revenue per customer? How much is that amount?

Question 18: Which customer has the highest average Revenue during the year?

Question 19: Are the historical (year by year) Revenue trends for the US and Germany (DE) similar or dissimilar?

Question 20: Did GB ever gain or lose a customer (based on revenue)? Explain.

Question 21: Is there seasonality in revenue during the year? If so, what month has the highest revenue? Is the seasonality similar from year to year?

Question 22: Which product shows dramatic change in revenue over time (years)? Does it have the same change by country?

Question 23: Which material does not display significant seasonality?

Question 24: What customer has the highest percentage contribution to revenue? What has been the trend of that customers percentage contribution over the years?

Question 25: What year had the highest overall gross margin? What was the gross margin during that year?

Question 26: What was the gross margin (as a percentage of sales) for Germany for the year with the highest gross margin? What was the gross margin (as a percentage of sales) for the US during the same year?