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

