Page 39 - Play v1.0 gujarati class 7
P. 39

ðfoþex{kt ©uýe …‚tË fhðe (Selecting a Range in a Worksheet)

                 yk…ýu {kW‚™ku W…Þku„ fhe™u y™u Shift fe™ku W…Þku„ fhe™u ©uýe …‚tË fhe þfeyu Aeyu.
                 {kW‚™ku W…Þku„ fhe™u (By using the Mouse)

                 {kW‚™ku W…Þku„ fhe™u ©uýe …‚tË fhðk {kxu ™e[u™k …„÷ktyku y™w‚hku :
                 …„÷wt 1   «Úk{ ‚u÷ …h Âõ÷f fhku fu ßÞktÚke Œ{u ©uýe þY fhðk {kt„ku Aku.

                 …„÷wt 2   {kW‚™wt zkƒwt ƒx™ ˃kðku y™u …fze hk¾ku y™u RÂåAŒ ©uýe …‚tË
                           fhðk {kxu {kW‚™u ºkkt‚w zÙuøk fhku.
                 …„÷wt 3   RÂåAík Mku÷ ÃkMktË ÚkkÞ íÞkhu çkxLk Akuzku. yk heíku ©uýe …‚tË fhðk{kt   {kWMk îkhk ÃkMktË fhkÞu÷ Mku÷ ©uýe
                           ykðu Au.                                                       (Cell range selected by mouse)

                 rþ^x fe™ku W…Þku„ fhe™u (By using the Shift Key)
                 Shift fe™ku W…Þku„ fhe™u ©uýe …‚tË fhðk {kxu ™e[u™k …„÷ktyku y™w‚hku :

                 …„÷wt 1   «Úk{ ‚u÷ …h Âõ÷f fhku fu su{ktÚke Œ{u ©uýe þY fhðk {kt„ku Aku.
                 …„÷wt 2   feƒkuzo ÃkhÚke rþ^x fe ˃kðku y™u …fze hk¾ku y™u AuÕ÷k ‚u÷ …h Âõ÷f fhku su Œ{u …‚tË„e fhðk {kt„ku Aku,
                 …„÷wt 3   rþ^x fe Akuzku. ©uýe …‚tË fhðk{kt ykðu Au.

                 ‚u÷ huLs™wt ™k{ (Naming a Cell Range)

                 yu{yu‚ yuõ‚u÷ ‚u÷ huLsLku ™k{ ykÃkðk™e …hðk™„e yk…u Au. yk
                 ™k{ ‚u÷ huLs™e søÞkyu ðk…he þfkÞ Au ‚u÷ huLs{kt ™k{ ‚kut…ðk {kxu
                 ™e[u™k …„÷kt ¼hku:
                 …„÷wt 1   ‚u÷ ™e ©uýe …‚tË fhku fu su{kt Œ{u ™k{ ÷¾ðk {kt„ku Aku.

                 …„÷wt 2   rhƒ™{ktÚke VkuBÞow÷k xuƒ …h Âõ÷f fhku.
                 …„÷wt 3   DEFINE NAMES „úw…  nuX¤ DEFINE NAME f{kLz
                           …h Âõ÷f fhku. NEW NAME  zkÞ÷ku„  ƒkuõ‚ Ëu¾kÞ Au.

                 …„÷wt 4   ™k{ ÷¾ku y™u OK ƒx™ …h Âõ÷f fhku. ™k{™k ¾k™k{kt          Mku÷ huLs rMk÷uõxuz (Cell range selected)
                           ™k{ Ëu¾kÞ Au












                            LÞq Lku{ zkÞ÷kuøk çkkuõMk (New Name dialog box)   Lku®{øk Mku÷ huLs (Naming cell range)

                 nðu, yk…ýu ‚qºkku{kt ‚u÷ ‚h™k{kt™e søÞkyu yk ™k{™ku W…Þku„ fhe þfeyu Aeyu.


                     VkuBÞow÷k y™u Œu™k «fkhku{kt ‚u÷ ‚t˼o (Cell Referencing in Formulas and Its Types)
                 ‚u÷  huVhuL‚ yu ‚u÷™wt ‚h™k{wt Au su™ku W…Þku„ [ku¬‚ ‚u÷ ™u Ëþkoððk {kxu ‚qºk{kt ÚkE þfu Au.  íku yuf ‚qºk nkuE þfu Au, su
                 yLÞ ‚u÷™ku huVhuL‚ ‚{kðu Au. ykðk rfM‚k{kt, ‚qºk™wt …rhýk{ {qÕÞku …h ykÄkrhŒ Au. òu Œ{u huVhuL‚ ‚u÷{kt fkuE VuhVkh

                 fhku Aku, íkku VkuBÞwo÷kLkwt  …rhýk{ yk…{u¤u ƒË÷kÞu÷ ykðþu.


                                                                                             VkuBÞwo÷k yLku VtõþLk  37
   34   35   36   37   38   39   40   41   42   43   44