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

ANS.A select cell/column>right click>format cell>font ,aliment,boder,fill

ANS.B-Total sum of sales =sum(sale range)

Average of sale, =average(sales range)

StDev =StDev(sales range)

Variance of sales =VAR(sales range)

Maximum, =max(sales range)

Minimum, =Min(sales range)

ANS.C select whole data>insert>pivot table

ANS.D GO>File>option>customize ribbon>new tab

ANS.E select whole data>insert>pivot table>Quantitesorder and Qatar in the row>year in column

ANS.F- select column>conditional formatting>Highlight cell Rule>text the contain>select cell>fill colour

ANS.G select column>ctrl+f>replace the given condition

ANS.H select data >insert.pivot table>status in row>sum of sales in values

ANS.I select column>data>text to coumn>dilimite>set

ANS.J Select column>conditional formatting>Top/bottem rule>Top 10%