$1\mathrm{.}9$ Discounted Sales per Fruit & Total Sales:

In another new column $($e$.$g$.,$ "Discounted Sales"$),$ enter the formula: $=$D$2-$F$2($Replace D$2$ and F$2$ with the cell references for "Sales" and "Discount"$).$

Copy the formula down to calculate discounted sales for each fruit.

In a separate cell $($e$.$g$.,$ G$14),$ use SUM to find the total discounted sales: $=$SUM$($G$2$:G$11)($Replace G$2$:G$11$ with the range of cells containing discounted sales$).$