II. Do Calculations

  1. (15%) Calculate the total cost, total sale price, and profit for each item.
             total cost = units * unit cost
             total sale price = units * unit sale price
             profit = total sale price - total cost
    
  2. (10%) Calculate the donation according to the following principle.
               If the profit is greater than the 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.

  3. (10%) Calculate the total, average, lowest and highest values for each column in rows 9 to 12.
Go to Next Page