Create an inventory list with the following columns: Item Name, Quantity, Price.
Do the following operations to the above
table
1.
Add
cell borders to inventory list.
2.
Colour
the column header cell with black colour and cell text with white colour.
3.
Create
a column name “Line total” and calculate the line total of each item.
4.
Get
the number of items in the inventory.
5.
Calculate
the total items in the inventory.
6.
Calculate
the inventory total.
7.
Find
the lowest priced item in the inventory.
8.
Find
the highest priced item in the inventory.
9.
Calculate
the average unit price.
10.
Add
another column name “Re-Order”. If the quantity is less than 30, print “YES”,
otherwise “NO”.