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

all the answers are uploaded below.

A. ans:Assigned the data properly in sheet-1.

B. Ans:table created with all values in sheet-2.

C. Ans:created pivot table with the given data.

D. Ans:using 2007 version not possible to create new ribbion,but know how to creat.

E. Ans:created the table in sheet-2.

F. Ans:created in table sheet-2.

G. Ans:cleaning and changing dates done in main sheet ,sheet-1.

H. Ans:created table in sheet-3.

I. Ans:splitted the data in sheet-3.

J.Ans:highlighted in sheet-1 main data.