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

a. its is done using proper function. first add a new row above use the function =proper("a2") where a2 is the text that has to be updated drag it to other rows and copy the resvlt and paste the values in the original row and fdelete the newly inserted row and add borders and cell color or text color to highlight and click on center alignment. Answer is updated in excel file sales_data sales_data sheet

b.Answer is updated in excel file sales_data sales_data sheet on cells from B2827 to E2832

c. Answer is updated in excel file sales_data sheet 1 from a1 cell.

d. this is done by clicking file and going to options and selecting customized ribbon and clicking new tab and renaming it as ABC. add a new group and rename it and select the data formatting options and add them to the group respectively.

e.Answer is updated in excel file sales_data sheet 1 from a14 cell.

f. there are two ways to do it. first is by selecting the feild and clicking the conditional formatting and another way is to add filter and select filter by text. Answer is updated in excel file sales_data sales_data sheet.

g. Answer is updated in excel file sales_data sales_data sheet, this is done by selecting find and replace

h.Answer is updated in excel file sales_data sheet 1 from a39 cell.

i. first click the feild and goto data tab and select text to column proceed with the delimeter _ and click finish when done. Answer is updated in excel file sales_data sales_data sheet M and N columns

j. this is done using conditional formatting by selecting top/buttom rules and selecting a color to the to 10% the 5 value can change depending on the user. Answer is updated in excel file sales_data sales_data sheet B columns