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

A. The proper formating of the data is done in excel attached below.

B.

i) TOTAL SUM OF SALES	10032660.9
ii) AVG OF SALES	3553.90041
iii) STD.DEV OF SALES	1841.85562
iv) VARIANCE OF SALES	3392432.13
v) MAX OF SALES	14082.8
vi) MIN OF SALES	482.13

C. The answer could be find in the attached excel in the sheet naming ANS-C.

D. As iam using the excel-2007 version iam unable to make the customization of ribbon or tab, i could explain the steps and it is as follows. STEP-1: Go to FILE tab and choose the EXCEL OPTIONS from there. STEP-2: You can find CUSTOMIZE RIBBON on the left side of the pannel, choose it. STEP-3: Click on the NEW TAB and add your own commands usefull in formating the data.

E. The answer could be find in the attached excel in the sheet naming ANS-E.

F. The answer could be find in the attached excel in the sheet naming MAIN DATA.

G. The changes are made in the MAIN DATA sheet in date format.

H. The answer could be find in the attached excel in the sheet naming ANS-H.

I. The answer is seperated in another sheet named ANS-I in the attached excel.

J. The top 10% is highlighted in the MAIN DATA sheet usingconditional formating.