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

Following are the answers of the above questions:-

B.

1. Total Sum of Sales =SUM(A:A)
2. Average of Sales =AVERAGE(A:A)
3. Standard Deviation of Sales =STDEV(A:A)
4. Variance of Sales =VAR(A:A)
5. Maximum Sales =MAX(A:A)
6. Minimum Sales =MIN(A:A)

Others are mentioned in the MS excel