Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
1) sum of sales
=sum(number1:number2)
2)Average
=Average(number1:number2)
3) Standard deviation of sales
=STDEV(number1:number2)
4) Variance of sales
= VAR(number1:number2)
5) maximum sales
= MAX(number1:number2)
6) Mimimum sales
= MIN(number1:number2)