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

Mini project answers:

= I have uploaded the answer for the above ten questions in Ms excel kindly please refer it.

=The answer for Q.) A,B,D are in one excel worsheet

Q.) C is in one sheet

Q.) E is in one sheet

Q.) F,G,H,I,J are in one excel sheet

All the sales calculation are done in sheet itself kindly please refer it apart from that images are attached below.

Q.b images for sales calculation only using shipped items.

std deviation of sales

varianceof sales

max of sales

min of sales