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

b.)Answer:

c.)Answer:

d.)Answer:

step1:go to file and select options.

step2:select customize Ribbon.

e.)Answer:

g.)Answer:

step 1:select column and select find and select option in the home tab.

step 2:type the word you want to find in the find what box.

step 3:select replace option at the upper left corner and type the word you want to replace with.

step 4:selectt replace all.

h.)Answer:

The Answers for (a.),(f.),(j.) are submitted as excel file below