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

a. Answer in the attached file (Project 1).

b. Answer in the attached file (Project 1).

1. Total Sum of Sales = 10032629
2. Average of Sales = 3553.8891
3. Standard Deviation of Sales = 1841.8651
4. Variance of Sales = 3392467.1
5. Maximum Sales -= 14082.8
6. Minimum Sales = 482.13

c. Answer in the attached file (Project 1).

d. Answer in the attached file (Project 1).

e. Answer in the attached file (Project 1).

I have Microsoft Office 2013 which do not support Quarterly Data.

f. Answer in the attached file (Project 1).

g. Answer in the attached file (Project 1).

h. Answer in the attached file (Project 1).

i. Answer in the attached file (Project 1).

j. Answer in the attached file (Project 1).