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

a.Ans- In Excel Sheet

b.Ans-In Excel Sheet at Cell Address E2827

c.Ans-In Excel Sheet

d.Ans-I have customised the ribbon name ABC and kept all the data formatting commands in that. I'm attaching Screenshot of that ribbon.

e.Ans-In Excel Sheet

f.Ans-In Excel Sheet

g.Ans-In Excel Sheet-Date by proper date formatting isn't working but I changed values of 2003 to 2019, 2004 to 2020 and 2005 to 2021 by replace option.

h.Ans-In Excel Sheet

i.Ans-In Excel Sheet at Cell Address Z1.

j.Ans-In Excel Sheet

For Pivot tables or Summary the Answer is in the sheets with questions numbers.