Page 145 - Bangladesh_classwiz_BOOK2018_rev_Neat
P. 145

y
                                                      Abkxjbx-13

               1. wb‡Pi gvb¸‡jv GKwU bZzb Spreadsheet G cÖ‡ek KivI-









                 (K)   1 N‡i   1 I   2 †hvM Kivi Rb¨ GKwU wb‡`©kbv (Formula bq) cÖ‡ek KivI|

                 (L)   2 N‡i   2 +   2 +   2 wbY©q Kivi Rb¨ GKwU Formula cÖ‡ek KivI| Gic‡i   2 N‡i 7 cÖ‡ek
                     Kwi‡q cixÿv Ki|

                 (M)    I    Kjv‡gi QqwU N‡ii Mo †ei Kivi Rb¨   3 N‡i GKwU Formula wjL|   2 N‡i 3 cÖ‡ek Kwi‡q
                     cixÿv Ki|

                 (N)   ,    I    Kjv‡gi cÖ‡Z¨KwUi m‡e©v”P gvb †ei Kivi Rb¨   4 N‡i GKwU Formula wjL| Gici   1 N‡i

                     37 cÖ‡ek cixÿv Ki|

               2. GKwU bZzb Spreadsheet G Fill value wb‡`©kbv e¨envi K‡i    Kjv‡gi cÖ_g 15wU N‡i 3 †_‡K ïiæ K‡i
                  cÖwZevi 10 e„w×i Rb¨ evwK Ni¸‡jv c~Y© Ki| Gici   1 Gi gvb cwieZ©b K‡i †`L †h GwU Kjv‡gi evwK
                  As‡k ‡Kv‡bv cwieZ©b K‡i bv|

               3. (K) GKwU bZzb Spreadsheet G   1 N‡i 5 Ges   1 N‡i 7 cÖ‡ek KivI|


                  (L) Fill Formula e¨envi K‡i 7 K‡i e„w×i Rb¨   30 ch©šÍ Ni c~iY Ki|

                  (M)   1 †K cwieZ©b K‡i 5 K‡i e„w× Rb¨ 150 ch©šÍ MYbv Ki|

                                                  2
               4. Spreadsheet e¨envi K‡i   (  ) =    +    dvskbwUi GKwU gv‡bi ZvwjKv ˆZwi Ki| ïiæi Rb¨    Kjv‡g Gi
                  wewfbœ gvb bvI Ges Gici Fill Formula e¨envi K‡i    Kjv‡g wewfbœ gv‡bi Rb¨ dvsk‡bi gvb †ei Ki|

               5. wb‡Pi Spreadsheet Ges Fill Formula fv‡jvfv‡e jÿ¨ K‡iv-









                 (a)  Dc‡ii Fill Formula cÖ‡ek Kiv‡j Kx n‡e Zv e¨vL¨v Ki|
                 (b)  Fill Formula †K cwieZ©b K‡i Mean (A1 : A3) wjL‡j Kx n‡e? SETUP G wM‡q Show cell
                      ‡_‡K Formula †Z cwieZ©b K‡i cixÿv Ki|














                                                            140
   140   141   142   143   144   145   146   147   148   149   150