$1.$ Use appropriate formulas to calculate the following amounts in the column indicated: Gross profit $($Column D$),$ Cost of divided by Sales $($Column E$),$ Gross profit divided by Sales $($Column F$),$ and cost of goods sold divided by gross profit $($Colum G$).$

$2.$ Use Excel's conditional formatting ability to format each added column as follows: Column D$,$ Top $10\%,$ Column E$,$ Greater than $25\%,$ Column F$,$ Green solid fill data bar, Column G Below Average.

$3.$ Explain how conditional formatting could be useful in thr sales$/$collection process. Consider the data below and for DSC corporation's recent sales.

$\backslash$table$[[\backslash$table$[[$Transaction$],[$number$]],\backslash$table$[[$Sales$],[$revenue$]],\backslash$table$[[$Cost of goods$],[$sold$]]],[1,$$$,4,818,$$$,973],[2,,1,070,,411],[3,,3,783,,817],[4,,4,862,,979],[5,,1,510,,477],[6,,4,419,,913],[7,,3,269,,740],[8,,2,477,,622],[9,,2,409,,611],[10,,3,643,,796],[11,,4,163,,874],[12,,1,926,,539],[13,,4,659,,949],[14,,4,421,,913],[15,,1,120,,418],[16,,1,107,,416],[17,,3,320,,748],[18,,4,955,,993],[19,,3,568,,785],[20,,2315,,597]]$