Social Icons

Pages

Friday 5 April 2013

HOW TO DESIGN A DECIMAL CONVERTER USING MICROSOFT OFFICE EXCEL





HELLO FRIENDS I STILL REMAIN YOUR HOST "ELKAMCY IVY OKOH"....TODAY I WANT TO TEACH YOU GUYS HOW TO DESIGN A DECIMAL CONVERTER USING MICROSOFT OFFICE EXCELL..... JUST FOLLOW THE STEPS BELOW
FIRST OF ALL YOUR TOOLS SHOULD BE READY FIRST WHICH ARE:

Computer, White board, Marker, Eraser, paper and pen.
the next step now
1)you boot the system you gonna use
2)launch your Microsoft office excell
3)create three columns and insert "decimal input,output and error checking routine"
4)you then create a blank workbook or worksheet under the decimal input column

5) Click on review (home tools), click on New Comment. A textbox will appear, you then type “the name of the work you are doing, binary number”, click on cell style on the home page and the input column was coloured.
6)Click on the first output column, clicked on formulas, insert functions (engineering), and click on “dec2bin” (a dialogue box will appear and you input A2).

7)Click on error check routine, click on formulas, click logical (iferror), dialogue box  will appear, type B2, tab, type Invalid binary number.

 
8)you must repeate same steps for dec2oct and dec2Hex and inserte their respective values in the function box........ 





ENJOY YOUR 

No comments:

Post a Comment