1. Enter column headings in the first row and wrap them.
2. Change column width as required for columns B to G. (Use Autofit)
4. Enter items' names in column A and all other information in columns B to D.
5. Let TOTAL COST = COST PER UNIT * NUMBER OF UNITS SOLD in cell E2.
6. Let TOTAL SALE PRICE = SALE PRICE PER UNIT * NUMBER OF UNITS SOLD in cell F2.
7. Find PROFIT in cell G2.
8. Copy three formulas from E2, F2 and G2 to rest of rows simultaneously. (Use Fill Down)
9.. Add your name.  Show me.
10. Sort the file according to the descending order of PROFIT.
11. SHOW ME
 

	A	B	C	D	E	F	G
1	ITEM	NUMBER OF UNITS SOLD	COST PER UNIT	SALE PRICE PER UNIT	TOTAL COST	TOTAL SALE PRICE	PROFIT
2	BINDER	500	4	7
3	BOOKBAG	350	5	10
4	CALENDER	300	3	8
5	NOTEBOOK	400	1	2
6	SHIRT	800	4	6
7	SCHEDULE	876	1	2