Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
Excel Sheet Attached with Answers.
| Questions | Answers |
| a. | Borders, Font Size and alignment is completed in Project 1 Data Worksheet. |
| b. | i. Total Sum of Sales: 10032628.85 |
| ii. Average of Sales: 3553.889072 | |
| iii. Standard Deviation of Sales: 1841.865106 | |
| iv. Variance of Sales: 3392467.068 | |
| v. Maximum Sales: 14082.8 | |
| vi. Minimum Sales: 482.13 | |
| Formulas of the above answers are written at the bottom of the Project 1 Data worksheet Table. | |
| c. | Answer in Pivot Table 1 Worksheet. |
| d. | New Tab "ABC Tab" is created near Home Tab, check Project 1 Data Worksheet. |
| e. | Answer in Pivot Table 2 Worksheet. |
| f. | Values in Status and Product Line are differentiated by different colors. Check Project 1 Data Worksheet. |
| g. | Values in Order Date column has been changed as mentioned in the question and changed to proper date format, check Project 1 Data Worksheet.. |
| h. | Answer in Pivot Table 3 Worksheet. |
| i. | Product Code Column is split into 2 columns as Product Code 2 and Product Code 3, check Project 1 Data Worksheet. |
| j. | Top 10% is Highlighted using Conditional Formatting, check Project 1 Data Worksheet. |