To help the bakery company improve its operation, please use the attached Excel File $$Bakery Data.xlsx$$ to answer the following questions by creating TWO Pivot Tables on new worksheets.

Questions:

Which customer has the highest amount of total sales? By what amount?

Based on the quantity sold, which products are the most popular items sold? Which product is the bestseller in Windsor, CO$?$

Students MUST submit one Excel file including the following $3$ worksheets:

the $1$st Pivot Table $($on a new worksheet of the excel file$)$ addresses the first question;

the $2$nd Pivot Table $($on a new worksheet of the excel file$)$ addresses the second question;

a new worksheet which you answer the two questions based on your findings. One short paragraph is OK$.$

Please name the Excel file $$your first $+$ last name$\_$Bakery$$ and submit it on Connect by the deadline.

No late submission will be accepted or graded.