Tuesday 12 April 2011

microsoft excel


Step 1 = choose microsof office excel


Step 2 =open excel



Step 3 = insert title

 

Step 4 = change font size




STEP 5 = MERGE AND CENTER






STEP 6 = FINISH MERGE AND CENTER




STEP 7 = INSERT ALL ITEM





STEP 8= CHANGE THE COLUMN WIDTH









STEP 9 = CENTER THE ITEM (B5)

STEP 10 = INSERT HARGA BELIAN SEUNIT




STEP 11= CHANGE COLUMN WIDTH



STEP 12 = MERGE AND CENTER





STEP 13 = INSERT  HARGA JUALAN SEUNIT

STEP 14 = CHANGE COLUMN WIDTH





STEP 15 = MERGE AND CENTER

STEP 16 = INSERT PERATUS KEUNTUNGAN



STEP 17 =  CHANGE COLUMN WIDTH


STEP 18= MERGE AND CENTER



STEP 19 = INSERT KUANTITI

STEP 20 = MERGE AND CENTER



STEP 21 = INSERT JUMLAH BELIAN

STEP 22 =  CHANGE COLUMN WIDTH



STEP 23 = CLICK ALL BORDER

STEP 24 =  CLICK NO BORDER THAN CLICK OUTSIDE BORDER

STEP 25 = GET A PROFIT OF PERCENTAGE  


STEP 26 = PRESS ENTER






Step 27 = calculate jumlah belian



STEP 28 = FINISH CALCULATION








STEP 29 = MAKE A GRAPH FROM DATA ABOVE  = CLICK INSERT à CHOOSE  CHART




No comments:

Post a Comment