Open a blank workbook$2.3.4.5.6.7.8.9.$ Write the following entries into the specified cells:C$2$ : Annual Fruit SalesB$3$ : $1999$ A$4$ : Apple F$3$ : TotalC$3$ : $2000$ A$5$ : Orange G$3$ : AverageD$3$ : $2001$ A$6$ : BananaE$3$ : $2002$B$4$ : $1000$ B$5$ : $2300$ B$6$ : $500$C$4$ : $1250$ C$5$ : $2500$ C$6$ : $300$D$4$ : $800$ D$5$ : $1200$ D$6$ : $600$E$4$ : $1300$ E$5$ : $1450$ E$6$ : $250$Merge the cells from A$2$ to G$2.$ Apply the following changes to the title line: Change the horizontal and vertical text alignments as center. Change the row height of row $2$ as $25.$ Change the font, font size, font style and font color as Tahoma, $18,$ bold,blue.Using range selection, select the cells from B$3$ to G$3.$ Then press Ctrl key on thekeyboard and select the cells from A$4$ to A$6.($this way you can select multiple cells ondifferent parts of the worksheet$)$ Now change the font, font size and font style of theselected cells as Times New Roman, $12,$ bold$-$italic.Using the AutoSum feature, find and write the sum of cells from B$4$ to E$4$ into cell F$4.$Then copy this cell to F$5$ and F$6.($Hold the right bottom of F$4$ and drag it to F$5$ andF$6)$ Observe that the formulas are updated when copied.Using the Average function find and write the average sales of apple over years intocell G$4.($Excel will suggest a range automatically to you, however this range will bewrong. So you will have to select the range yourself$)$ Using the same method in theprevious question, copy this cell to G$5$ and G$6.$Add a comment to G$4.$ Write the text Average sales over years into the commentbox.Select the cells from B$4$ to G$6.$ Change format of the selected cells to Currency withSymbol TL and $3$ decimal places.Change the column width of Column A such that all the texts on this column can fitinto the cells$\mathrm{.}10.$ Select the columns from B to G and apply AutoFit Selection for these columns$\mathrm{.}11.$ Add a new row above the $3$rd row $($that is between rows $2$ and $3)\mathrm{.}12.$ Add outside and inside borders to your table. For the ouside border choose athicker line. $($To add borders, select the range where you want to add borders $($that isfrom A$2$ to G$7),$ then choose Format Cells from the shortcut menu and click theBorder tab$)13.$ Select the title $($select the merged cell in row $2)$ and change the cell color to yellow.$($To change cell color, from the shortcut menu select Format Cells, then click Patterntab$)14.$ Select the cells B$4$ to G$4$ and A$5$ to A$7($Use Ctrl key$).$ Change the cell color as pink$\mathrm{.}15.$ Select the cells from B$5$ to G$7.$ Change the cell color as light blue$\mathrm{.}16.$ Using Print Preview feature, observe how your document would appear on a printedsheet. Add one of the automatic headers to the header. Add the page number to thefooter of the document. Change the page orientation as Landscape. $($Use thesetup menu in the Print Preview mode to add header&footer and change pageorientation$)17.$ Select the cells from B$5$ to G$7.$ Click on the Chart Wizard button. Select Columnchart type and the first chart sub$-$types. Write Annual Fruit Sales as the Charttitle, Year as the Category $($X$)$ axis, Value as the Category $($Y$)$ axis$\mathrm{.}18.$ Move the legend to the bottom of the chart. $($Right$-$click on the legend area andchoose Format Legend, then select Placement$)19.$ Change the pattern of the Chart Area. Select any of the patterns you like from theTexture patterns. $($Right$-$click on the Chart area, choose Format Chart Area, then