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

a. Submited In sales_data work sheet as (Question a)

b. Submitted in sales_data(1) as (question b)

1. Total sum of sales = 10032628.85

2.Average of SALES = 3553.889072

3. Standard deviation of sales = 1841.865106

4. Variance of sales = 3392467.068

5. Minimum sales = 482.13

6. Maximum sales = 14082.8

c. submited in sales_data work sheet as (Question c)

d. The pivot Query is not available in MS Excel 2007. So i cant able to perfom and custamize Ribbon.

Procedure, to custamize ribbon is go to options and click more.., there we can see custamize. Using that we can custamize the Ribbon.

e. Submited in work sheet as (Question e)

f. Submited in sales_data as (Question f)

g. submited in sales_data as (Question g)

h. submited in sales_data(1) as (Question h)

i. submitwd in sales_data as (Question i)

j. Submited in sales_data as (Question j)