# Excel Sample Test (Conti.)

## II. Do calculations

- Calculate the
**Original Payment** of each item__Original Payment__ = __Sale Price per Unit__ * __Quantity__

- 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.
- Calculate the final payment for each item.
__Final Payment__ = __Original Payment__ - __Discount__

- Calculate the
**total **for each column.
- Calculate the
**average** for each column.

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

Go to the next page.