ogy, the

Please do the following $9$ questions:

Merge and Center the title ABC Company in row $3$ across columns A through J$.$

Use "autofill" to enter the correct quarter labels into cells F$11$ and G$11.$

Use "wrap text" to wrap any long labels in the column heading in row $11.$

Use conditional formatting for the QTR $1$ Sales in column D$,$ which will highlight the cells with a Light Red Fill with Dark Red Text, for amounts that are greater than $$20,000.$

Using the SUM function, enter formulas into every cell in column H that will calculate the $2020$ total sales for ABC Company's eight employees.

The cells in column I should contain formulas $($that use an absolute cell reference to cell $F6)$ that will represent the total sales each salesman is projected to sell in $2021.$

Employees with $2020$ total sales that are over the $2020$ sales quota should get an award. The cells in column J should say YES if a salesman's total seles is over the quota, or No if they are not. Use an IF function and an absolute cell reference that refers to the $2020$ Sales Quota amount.

Enter the correct functions necessary into cells $B6,B7$ and $B8$ that will display the Total, Minimum and Average values from the $2020$ Total Sales only $($column H$).$ Additionally, use the COUNT function to enter a correct formula into cell $B9$ that will display the total number of salespeople that the ABC Company employs.

Createa$3$D piechart that will show Peteesi's sales for quarters $1$ through $4$ Makesure that youenteratilie for the chart and data Iabelsthat display thesales amount.