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

1(a). Done formating find in below attachment.

2(b). In sheet AA to AC find below attachments

3(c). Find the answer in sheet as C Question

4(d). Find the screenshot in below attachment

5(e). Find the answer in attached sheet as E question

6(f). conditional formating not working in my Excel for this question

7(g). Chnaged the values as per question, please find in attached sheet

8(h). Find the answer in atteched sheet as H question

9(i). splited PRODUCTCODE using delimeter, find in the sheet

10(j).highlighted top10% values in Quantityorder ,find in below attactment.