Excel Sample Test (Conti.)

II. Do calculations

1. Calculate the Original Payment of each item

   Original Payment = Sale Price per Unit * Quantity

2. Calculate the discount of each item.
   If quantity is 10 or more, the % of discount will be counted as

   Discount = % of discount * Original Payment

   Otherwise, there is no discount.
   You have to use absolute address concept to drag down your formula.
3. Calculate the final payment for each item.

   Final Payment = Original Payment - Discount

4. Calculate the total for each column.
5. Calculate the average for each column.

Rename the sheet as "calculations" and save the file.

Go to the next page.