(15%) Calculate the total cost, total sale price, and profit for each item.
total cost = units * unit costtotal sale price = units * unit sale priceprofit = total sale price - total cost
(10%) Calculate the donation according to the following principle. If the profitis greater thanthe number at the cell G15 (i.e., Minimum Profit for Donation),
the information about the amount of donation is at the cell G16,
otherwise, there is no donation.
Note that apply the absolute address concept(i.e. fix a cell address) to drag down formula.
(10%) Calculate the total, average, lowest and highest values for each column in rows 9 to 12.