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

b. Make summary of Products Sales by providing

1. Total Sum of Sales
2. Average of Sales
3. Standard Deviation of Sales
4. Variance of Sales
5. Maximum Sales
6. Minimum Sales

Solution: Please find the answer in first sheet of the workbook.

d. Make Customized Ribbon by naming ABC and keep all data formatting commands in the newly created Ribbon.

Solution: Find the attached screenshots from different laptop, as these features are not available from online excel app in my laptop.