EXERCISE 6 Item ID Item Name Item Price (RM) Quantity Sub total N101 Nail clipper 2.50 5 D102 Dress 11.90 10 T103 T-shirt 13.90 3 S101 Skirt 14.00 15 H103 Headband 4.00 10 J 102 Jacket 20.90 C105 Сoat...

Using data as shown above, you need to :

1)Calculate and fill the column using data validation.

2)Print screen all the step above and save.

3)The amount of RM must be in 2 decimal point.

4)Insert (name, matric number, section) on top (left side) of every worksheet.

5)Please rename and save your work as (matricnumber_LabSheet 6).

Extracted text: EXERCISE 6 Item ID Item Name Item Price (RM) Quantity Sub total N101 Nail clipper 2.50 5 D102 Dress 11.90 10 T103 T-shirt 13.90 3 S101 Skirt 14.00 15 H103 Headband 4.00 10 J 102 Jacket 20.90 C105 Сoat 35.50 Order subtotal Tax rate 6% Тax Shipping Option Shipping Cost Standard Discount TOTAL ORDER COST