

                           EXCEL  5.0



      EXCEL 祭 ᮪.ࠡ⪠ ⥪,ࠢ  


-ணࠬ ⮫쪮 魠,    ॢ室 ᯥ-


栫஢ ணࠬ-।  ணࠬ  .  -


ࠧ 㭪権    砫 ,祬 ⠢ ਬ 


ࠪ⨪.    ஡⥭  稭  ⮨  業


, ࠭ ⥩ EXCEL 殮 .


      14-  ⠡ ⮢  ਬ  ᮭ-


 ஢  ॡ 짮⥫   ணࠬ -


 . 砫 ᭮ 業  ⠪ ணࠬ,,-


,VisiCalc,⠢   㭪樨.  㣮.-


  묨  壠᪨ ⠬ ࣠   ᪮


ࠦ   ਮ    饥  祭.஬ -

                                - 2 -



,ࠧ 㭪権,।  ⠪  ⭮    ᪮


ணࠬ,   ᫮ ࠡ 짮⥫.ணࠬ  Win-


dows ᮧ  ⮣  ।뫪.


       ᫥  ६    ࠧ 諨  ᯮ짮 Win-


dows  ⢥ ᢮ 짮⥫᪮ ।. ᫥⢨, -


,ᮧ騥 ணࠬ ᯥ祭,砫 । 讥 -


 ணࠬ  Windows.


                              EXCEL.


      Excel  ᮤন  ⢮  ࠧ ⮢. 


  ᥬ ணࠬ  । Windows,⠫    ⮫쪮  


 Excel.  ࠡ    Excel   ࠡ稬 -


⮬( ⠡楩),ࠧ  ⤥ 祩.⮫  



                                - 3 -

㪢,ப-ࠬ.


          㣨  ணࠬ    ।  Windows,  


।⠢ ࠡ稩      ⤥쭮   ᢮ ᮡ⢥


-  뢠  ࠡ祩 ,⠪   ⠪ -


  ࠡ뢠 ᪮쪮 ࠡ ⮢.


       ࠡ祩 ࠭  ᯮ  㤥  256  ⮫殢  


16384 ப.ப ஭㬥஢  1  16384,⮫  㪢-


  ﬨ 㪢.᫥ 26 㪢 䠢  ᫥ -


樨 㪢  , ..


      Excel,   㣨 ணࠬ  Windows,  


 室  ப  .    室  㬥⮢


⠭⭠  ଠ஢.    㬥⮢  


   뢠  㭪樨 Excel.


                                - 4 -




                      ଫ ࠡ ⮢.




                             롮 .



      ⨯,ࠧ      ᯮ ⥪  뤥


ᮮ⢥騥 祩    ଠ.ࠢ  祩  


 ଠ.᫥ ⮣  ࠭    ஬  㪠-


 ࠧ .      ᯨ᪠  ।-


. 롮     ᬠਢ  ⠭   -


. 롮 ⨯ , ࠧ  ⨫  ᯮ짮 


 ,ᯮ   㬥⮢.





                             ⮢.


                                - 5 -


       饥 ६  ଫ ⠡  㬥⮢ ᯮ


讥 ⢮ ⮢.   䠪஢, -


 ਭ  ,-  ࠧ稢  ⥪,ଫ  ⥬


  ⮬.



                                ⨫.


         롮஬  ⨯     ࠧ   ⨫


:ᨢ,㦨     ન.ᯮ    ⨫


⮫쪮  뤥  ଠ樨  ⥪ 㬥⮢  ⠡.




                              㧮.



      Excel  뤥  ⠡     梥 


㧮 䮭,⮡  ਢ    . 뤥  ᯮ짮-



                                - 6 -

 ஦,⮡  ॣ㧨 ⠡.롥    -


 ଠ  祥.  뤥 祥   梥 -


᪨   .


                        ଠ஢ ᥫ.




     ᫨ 㦭,⮡  ॢ⨫    㤮  㬥,᫥


ந ଠ஢  ᥫ    祩. ᥣ ଠ


祩, 㤠   㬬. ⮣ 㦭 뤥 ଠ-


㥬 祩.⥬    ଠ-祩,  襬


- ᫮.롥ࠥ  㯯 ᫥ ப .ࠢ


 ᪮쪮  ਠ⮢ ଠ⮢ ᥫ.ଠ ᫠ -


।  ஢ 蠡,    :⮡


     祭,ᬮਬ ਠ ଠ஢ ᫠



                                - 7 -

13. ࢮ   蠡 ଠ⮢,     ଠ.


ன   ,   㤥 룫廊 ᫮  १ -

஢.



          ଠ                    


          #.###,##                  13


          0.000,00                  0.013,00


          #.##0,00                  13,00



     ᫨   ⢥ ஢ 蠡 ᯮ ,  -


 ,     .箪 ( -


  ⪨)   ,     .


ᯮ짮 ஢ 蠡    ,   ᫥ -


筮 ⮩,   㣨  ᯮ짮 "".᫨  -


 ᫠,     ࠧ冷 ᫥ ⮩    

                                - 8 -



 ࠢ  ,   ந室 㣫     -


.筮 ⠪  Excel 㣫 ஡ ᫠,    ମ஢


 楫,.. ࠧ冷 ᫥ ⮩.㣫,  ,  ⮫쪮


᫠,  뢮  ࠭,   ᯮ  -


祭.   ଠ   ਠ  㬬,  


 " ":   ᮬ   뢮  ,


 ᯮ  ଫ 壠᪮ 㬥.


                         ஢ઠ 䮣䨨.


       Excel  ணࠬ ஢ન 䮣䨨  ⥪⮢,-


室   祩  ࠡ祣  ,  ࠬ    ⥪⮢ -


.⮡   㦭 뤥 祩  ⥪⮢ ,  -


 室   ஢   䮣.᫨  㦭  ஢  



                                - 9 -

⥪, ᯮ   ꥪ,  롥 祩 稭  


ன Excel  ᪠ 訡. 㦭      -


 - 䮣. ⮬ Excel  筥 ஢ 䮣    ⥪.


  ஢    F7.᫨  ணࠬ  㦨


訡      ஢塞 ᫮  ᫮, ࠭ 


 ஢ઠ 䮣䨨.



                              .


      ⥬᪨ 㭪稨 뢠    ணࠬ    


ᯥ樠 ᨬ,뢠  ࠬ.  ᯨ᮪ ஢


  ⠡.



                  㭪           ਬ


     䬥᪨ 



                                - 10 -

     +                    ᫮          =A1+1


     -                    ⠭         =4-4


     *                    㬭         =A3*X123


     /                               =D3/Q6


     %                    業           =10%



      裡


     :                              =(A1:C10)


     ;                    ꥤ       =(A1;A2;A6)


     ⮢  ᮥ


     &                    ᮥ ⥪⮢



     ⮢  ᮥ ।祭   ⮣,  ⮡  


ᮧ ࠧ  㬥  ,ਬ, ࠧ  -



                                - 11 -

-ணࠬ ᠬ 㤥   祩,  ன ⠢ .



                    ॢ᫥ ࠡ ⮢.


      㬮砭  ,  ।஢    


㫠 祥  ᫥   ࠡ祬  ந室 -


᪨.   ᫮ ⥣樮 ⮢   


த⥫쭮 ६,  ⮬  ⬥ ⮬᪮ ᫥-


. ⮣ 㦭    ࢨ-ࠬ,  -


襩  ᫥     ⠭  ४-


⥫ ॢ  । ࠭.᫥ ⮣  ᫥ 


ࠡ祬   ந室 ⮫쪮 ᫥   ᫨.




                            㭪樨 Excel.

     㭪樨 ਧ  ࠡ  ᮧ  ⢨ 



                                - 12 -

஭묨 ⠡栬.⥩訬 ਬ஬ 믮 ⮢ -


  ᫮.ᯮ㥬 ⮩ 樨  樨 -


 㭪権. ᯮ ⥬ 㭪権 㦭  㤥    


    祩  ⤥쭮,  ਡ    


 . १ 㫠 㤥 룫拉 ᫥騬 ࠧ:


     =B1+B2+B3+C4+C5+D2

     ⭮,   ᠭ ⠪  諮  ६,-


       뫮   .⮡


    㬬  Excel, 室 ᥣ  -


⢮ 㭪 㬬,     ࠦ  㬬  


 㭪権,     㭪樨 ᫥   -


⢠.᫥   㭪権   ᪮,  -


⥩  ன ᪮. १ 㫠 㤥  룫廊  ᫥騬



                                - 13 -

ࠧ:



     =(B1:B3;C4:C5;D2)



     ᫨ ࠢ  ,  ,  稥  -


砥  祥.⮩ ࠧ 㬥 㭪権.


     ᯮ짮  祥,   ⥩,   ⢥ 㬥⮢


 㭪権 楫ᮮࠧ,  ᪮쪮 ,   , 來,  


 ,  ⠪  ணࠬ  뢠   ࠡ-


祬 .ਬ 㦭  㬬 ᥫ    祩    1  


4.   ⠪:




     =(1;2;3;4)


        㣨 ᯮᮡ:




                                - 14 -

     =(1:4)


                           ࠬ.


       ஭묨 ⠡栬 ᠬ  ᥡ 讥 㤮-


,  ᫨  㤠 ॢ 娥 ⮫ ᥫ  來 -


ࠬ   䨪.    Excel. Excel   ࠧ-


 ᯮᮡ ࠭   ࠬ, ⠢  訬 -


 : , -,"" ࠬ , -, "-


ࠬ ࠭". ࠬ ।⠢ ᮡ 䨪,-


  ࠡ ࠭  ࠭塞  ⮬  䠩;  ࠬ-


 ࠭ ᮧ  ᪨ 䠩. ७ -


ࠬ  ᥣ    ࠬ, ⠢饣  -


 Excel.



                     㬥⮢ ࠬ.

                                - 15 -




     ࠬ  ᮧ    ⮫쪮        -


ࠬ.        㣨 ᯮᮡ -  - 


  㬥⮢ ࠬ. ࠦ ⮩ 


 ࠭     - 㬥⮢.



    ਬ:    ᭮   ந -


ࠬ.뤥塞      㬥⮢   -


ࠦ ५,  ࠢ , ⮡  ᯨ᮪ ⨯ -


ࠬ.ࠢ ⨯ ࠬ    ࠡ祬  אַ㣮쭨  -


室 ࠧ,  ᪠   ࠬ.


     ᫨ 㦭 ᮧ ࠬ  ⤥쭮 ,    


ப ࠬ   .᫥ ⪮   ஬ -


ࠬ 㤥 ᮧ ⤥ ࠡ稩 .

                                - 16 -



                           ࠬ-.


     筮 ⠪ 來 ।⠢    ,  


   ⠢騥     業  楫.  


࠭ ,  ⠪   ࠬ  㣮  ⨯,    


 ࠬ.



                      ᨮ쭮 䮬.


      ଫ 㬥⮢ Excel । ஬ 䨪  -


ࠬ  ᮧ 㣨 ᪨ ꥪ, ਬ -


稢  ࠭,  ⮬ ᯥ뢠 אַ㣮쭨, , 


 ਢ ,  㣨  . ⠪ 믮 㭪   -


 ᪨ ꥪ⮢,    㤥 ॢ,   


믮   Excel,   ᯥ樠쭮 ᪮ ।.


                                - 17 -


      ᮧ 㭪 ।祭 ,  ᯮ  -


 㬥⮢ ᮢ. ࠦ ⮩   ࠭


     室   㬥⮢  ⠭-


⭠.



                             묨.


       ணࠬ,  ᠭ  樮 ⥬ Windows,


짮⥫  짮  ஬ (Clipboard), ।-


⠢ ᮡ  ,  ।⮢塞 樮  ।  


ᯮ殮 ࠧ ணࠬ.ᯮ , , ࠡ -


  Excel, ࢠ  ࠪ᪨  ३   ண-


ࠬ,   Windows  ন    ⮢.祬 ᨬ 


⥪饩 ணࠬ 室 ⢫     ⮩   -



                                - 18 -

. ⮣ 㦭 뤥 ᮮ⢥騥 祩.  


, ᯮ  ⮣   ࠢ-஢,  -


  Ctrl+C.  ᠬ Excel,    ணࠬ  


        ࠢ-⠢  -


   権 : Shift+Insert  Ctrl+V.



                 ⮢ । Word  Windows.


          㯠  Word  Windows   ⠡-


. ணࠬ     ଠ  Excel.୨    ࠧ


 ⠪  ࠭     .ᯮ  ࠡ⪨


⠡ ⥪⮢ ।  ࠡ뢠   .



                               ᯮ.



     Excel  ࠭ ࠡ稥        ࠧ  ଠ-


                                - 19 -


.⮡   ᢮ ଠ,  㦭    --


 ,    䠩.  ᯨ᮪ ଠ⮢,   -


 Excel  ८ࠧ ᢮ 䠩.































                                - 20 -








































                                - 21 -













