Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

NOTE : I have Created a excel Project name "Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring" in one excel with different sheet so I'm mentioning the answers of the project here where I done this answer in which sheets and I have attached the file in the same way I'm mentioning the sheet name so that it get easy to find it.

- Answer " A-B-F-G-I " (This is the first sheet where all this five answers has been done which is Ans-A, Ans-B, Ans-F, Ans-G, Ans-I).

- Answer " C " (This is the second sheet where you can find answer "C" - Q C. Make worksheet from the given Data for categorical representation of table based on fields Status, ProductLine and Sales using Pivot Table).

- Answer " D " Create Customized Ribbon by naming AC and take Screenshot and paste in sheet. (This is the Third sheet where you can find answer "D" - Q D. Make Customized Ribbon by naming ABC and keep all data formatting commands in the newly created Ribbon).

- Answer " E " (This is the Fourth sheet where you can find answer "E" - Q E. Analyse the Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarters using Pivot Table).

- Answer " H " (This is the Fifth sheet where you can find answer "H" - Q H. Calculate the total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products).