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

a. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'sales_data'.

b. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'summary_of_products'.

c. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'c'.

d. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'd'. I have shown the steps i did to create new tab, ribbon and items.

e. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'e'.

f. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'f'.

g. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'g'. I have confusions about the question, because we cannot change the year by changing formatting options, formatting option for date is used to proper arrange of any date is in particular cell. Otherwise can you please elaborate the question and explain the meaning of question and answer for me.

h. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'h'.

i. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'i'.

j. Please check the file attached CHALLENGE 7sales_data.xlsx - sheet named 'j'.