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

1.

b.

c.

d.

e. and f.

Ans is int the attachment, please refer to sheet name: ans_1_e,f

g.

Ans is int the attachment, please refer to sheet name: ans_1_b,g,i,j

h.

i.

Ans is the attachment file. Please refer to sheet name: ans_1_b,g,i,j and check for cloumn N,O,P

j.

Ans is the attachment file. Please refer to sheet name: ans_1_b,g,i,j and check for red coloured highlighted cell, done using conditional formatting for column B.