মাইক্রোসফট এক্সেল টিউটোরিয়াল ১১

75.  Column jyKv‡bvi wbqg t

            Ø ‡h Column-Gi Hide Kiv‡ev cÖ_‡g Cursor H Column-‡Z ivL‡Z n‡e| Zvici Format-G Click Ki‡j Format Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Column-†Z Click Ki‡j c`©vq Column-Gi kvLv Menu †`Lv hv‡e GLb Hide-G Click Ki‡Z n‡e Zv‡ZB Column jyKv‡bv n‡e|

76.  jyKv‡bv Column ‡ei Kivi wbqg t

            Ø Format-G Click Ki‡j Format Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Column-G Click Ki‡j c`©vq Column Gi kvLv Menu †`Lv hv‡e GLb Unhide-G Click Ki‡Z n‡e Zv‡ZB jyKv‡bv Column ‡ei n‡e|

77. Sheet Gi bvg cwieZ©b Kivi wbqg t

            Ø Format-G Click Ki‡j Format Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Sheet-G Click Ki‡j c`©vq Sheet-Gi kvLv Menu †`Lv hv‡e GLb Rename-G Click K‡i Cursor wbwÏó (Sheet 1 / Sheet 2 / Sheet 3)-G Block Kiv Ae¯’vq †`Lv hv‡e Zvici †m¯’v‡b bZzb bvg wjLv hv‡e|

78.  Sheet jyKv‡bvi wbqg t

            Ø cÖ_‡g H Sheet Open Ki‡Z n‡e| Zvici Format-G Click Ki‡j Format Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Sheet-G Click Ki‡j c`©vq Sheet-Gi kvLv Menu †`Lv hv‡e, GLb Hide-G Click Ki‡jB Sheet jyKv‡bv n‡e|

                                         

79.  jyKv‡bv Sheet ‡ei Kivi wbqg t

            Ø Format-G Click Ki‡j Format Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Sheet-G Click Ki‡j c`©vq Sheet-Gi kvLv Menu †`Lv hv‡e, GLb Unhide-G Click Ki‡jB jyKv‡bv Sheet ‡ei n‡e|

8O. jywK‡q †djyb µzwUi gvb t

Ø Gg GK G‡·‡j wewfbœ my‡Îi djvd‡j A‡bK mgq µzwUc~Y© gvb (Gii f¨vjy) †`Kv †h‡Z cv‡i| GUv nq f~j DcvË w`‡j| we‡kl K‡i hLb GK N‡ii (Cell) gvb‡K Aci †Kvb Lvwj Ni w`‡q fvM Kiv nq| †hgb: D1 N‡ii B1-Gi gvb‡K A1 Lvwj Ni w`‡q fvM Kiv nq ZLb fvMdj # DIV/O! †`Lv hv‡e| GwU n‡”Q µzwUc~Y© gvb| G‡¶‡Î Avcwb B‡”Q Ki‡j myÎwU gy‡Q †dj‡Z cv‡ib| wKš‘ ai“b Avcwb Zv PvB‡Qb bv| †Kbbv c‡i A1 ‡m‡j †Kvb gvb emv‡j µzwUc~Y© djvd‡ji N‡i # DIV/O!-Gi e`‡j GKwU ¯^vfvweK gvb cvIqv hv‡e| ZvB µzwUc~Y© djvdj‡K jywK‡q ivLv hvq| GRb¨ cÖ_‡g †h meN‡i = B1/A1 m~ÎwU e¨envi K‡i‡Qb Ges †hLv‡b µywUc~Y© gvb i‡q‡Q, †mB Ni¸‡jv Seledt Ki“b|  ai“b f~j †kvaiv‡bv m¤¢ve¨ Ni n‡jv, D1: D20.

Format-G Click Ki‡j Format Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Conditinal Formatting-G Click Ki‡j c`©vq Conditinal Formatting Dialog Box Avm‡e, Gevi Condition-G Click Ki‡j Condition-Gi Chart ‡`Lv hv‡e Ges GLv‡b ‡_‡K Formula is Select Kivi ci Format-G Click Ki‡j c`©vq Avevi Format Cells Dialog Box Avm‡e, GLb Color Box-G Click Ki‡j Color Gi Chart †`Lv hv‡e, GLvb †_‡K mv`v Color Select K‡i `yBevi Ok-†Z Click Ki‡Z n‡e|

81.  evbvb ï× Kivi wbqg t

            Ø Tools-G Click Ki‡j Tools Menu-Gi Sub-Menu ‡`Lv hv‡e, Gevi Spelling & Grammar-G Click Ki‡j c`©vq Spelling & Grammar Dialog Box Avm‡e| NOT in Dictionary Box-G f~j kã ¸‡jv †`Lv‡e Avi Suggestions Box-G ï× evbvb †`Lv‡e Ges GLvb †_‡K †hUv 100% ï× g‡b n‡q †mUv‡K Select K‡i Change-G Click Ki‡j evbvb ï× n‡e|