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

ALL ANSWERS ARE DONE AND UPLOADED BELOW, KINDLY CHECK IT ONCE.

A. Do proper formatting of the data with using borders, font size and appropriate alignment of the content?

ANS: Assaigned the data properly in Sheet no-1

B. Make summary of Products Sales by providing?

ANS: Table created with all values in sheet-2

C. CREATED PIVOT TABLE WITH GIVEN DATA.

D. USING 2007 VERSION NOT POSSIBLE TO CREAT NEW RIBBON, BUT KNOW HOW TO CREAT.

E. Analyse the Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarters using Pivot Table.?

ANS:Created the table in sheet-2

F.Present the data in different colours for values in field Status and ProductLine using conditional formatting.?

ANS: CREATED IN TABLE SHEET-2

G. CLEANING AND CHANGING DATES DONE IN MAIN SHEET, SHEET-1

H. Calculate the total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products.?

ANS: CREATED TABLE IN SHEET NO-2

I. SPLITTED THE DATA IN SHEET-3

J. HIGHLIGHTED IN SHEET-1 MAIN DATA