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
Use Excel's conditional formatting ability to format each added column as follows: Column D Top Column E Greater than Column F Green solid fill data bar, Column G Below Average.
Explain how conditional formatting could be useful in thr salescollection process. Consider the data below and for DSC corporation's recent sales.
tabletableTransactionnumbertableSalesrevenuetableCost of goodssold$$
