Kugwira ntchito ndi gulu lotchulidwa mu Microsoft Excel

Chimodzi mwazida zomwe zimapangitsa kuti ntchitoyi ikhale yosavuta ndi njira zomwe zimakupatsani mwayi wokwaniritsa ntchito ndi njira zosunga deta ndikutcha ma array. Chifukwa chake, ngati mukufuna kutanthauzira mitundu yosiyanasiyana ya data, simuyenera kulemba ulalo wovuta, koma sonyezani dzina losavuta lomwe inu kale mudasankha gulu linalake. Tiyeni tiwone zovuta zopindulitsa zomwe zimagwiritsidwa ntchito ndi mayina otchulidwa.

Kutchedwa Area Manipulation

Mtundu wa mayina ndi gawo la maselo omwe wogwiritsa ntchito adapereka dzina lake. Nthawi yomweyo, dzinali limawonedwa ndi Excel ngati adilesi ya dera lotchulidwa. Itha kugwiritsidwa ntchito ngati gawo la njira zogwirira ntchito ndi zotsutsana, komanso zida zapadera za Excel, mwachitsanzo, Onani Makhalidwe.

Pali zofunika kuti dzina la gulu la maselo likhale:

• Pasakhale malo okhalamo;
• Iyenera kuyamba ndi kalata;
• Kutalika kwake kusakhale kuposa zilembo 255;
• Siyenera kuyimiriridwa ndi ogwirizanira a fomu A1 kapena R1C1;
• Bukulo silikhala ndi dzina lomweli.

Dera la foni litha kuwoneka likasankhidwa m'gawo la dzina, lomwe lili kumanzere kwa baramu yodula.

Ngati dzina la masanjidwewo silinapatsidwe, ndiye pamunda womwe uli pamwambapa, mukasankhidwa, adilesi ya foni yakumanzere yakusanja ikuwonetsedwa.

Pangani magulu a mayina

Choyamba, tidzaphunzira momwe tingapangire mtundu wotchuka ku Excel.

1. Njira yofulumira komanso yosavuta yoperekera dzinalo ndikulembera m'gulu la mayina mutasankha dera lolingana. Chifukwa chake, sankhani masanjidwewo ndikulowetsa mundawo dzina lomwe tikuwona kuti ndilofunikira. Ndikofunikira kuti ndizosavuta kukumbukira komanso kufanana ndi zomwe zili m'maselo. Ndipo, ndikofunikira, ndizofunikira kuti zikwaniritse zofunikira zomwe zidanenedwa pamwambapa.



2. Pulogalamuyi kuti ilowetse dzinali m'kaundula wake ndikulikumbukira, dinani batani Lowani. Dzinalo lidzaperekedwa kumalo osankhidwa a khungu.

Pamwambapa adatchedwa njira yofulumira kwambiri yopangira dzina la omwe adalipo, koma siyitali ndiokhawo. Njirayi itha kuchitika kudzera menyu.

1. Sankhani mndandanda womwe mukufuna kuchita opareshoni. Dinani pa kusankha ndi batani la mbewa yoyenera. Pamndandanda womwe umatsegulira, sankhani njira "Patsani dzina ...".



2. Zenera lopanga dzina limatseguka. Kupita kuderalo "Dzinalo" yendetsani dzinalo mogwirizana ndi zomwe tafotokozazi. M'deralo "Zosintha" Adilesi yamagulu osankhidwa akuwonetsedwa. Ngati mwasankha moyenera, ndiye kuti simukuyenera kusintha m'derali. Dinani batani "Zabwino".



3. Monga mukuwonera m'munda wa dzina, dzina la m'deralo limagawidwa bwino.

Njira inanso pakugwirira ntchito iyi ndi monga kugwiritsa ntchito zida pa tepi.

1. Sankhani malo omwe mukufuna kusintha kuti akhale dzina lake. Pitani ku tabu Mawonekedwe. Mu gululi "Mayina Otchulidwa" dinani pachizindikiro "Dzinalo".



2. Zenera lomasulira lomweli limatseguka ngati mugwiritsa ntchito njira yapita. Ntchito zina zonse zimachitidwa chimodzimodzi.

Njira yotsiriza yopatsa dzina la foni, yomwe tiona, ndikugwiritsa ntchito Woyang'anira mayina.

1. Sankhani gulu. Tab Mawonekedwedinani pachizindikiro chachikulu Woyang'anira Mayinaonse mu gulu limodzi "Mayina Otchulidwa". Kapena mutha kugwiritsa ntchito ma keystrokes Ctrl + F3.



2. Zenera limayatsidwa Woyang'anira mayina. Mmenemo, dinani batani "Pangani ..." pakona yakumanzere.



3. Kenako zenera lodziwika bwino lomwe limapanga mafayilo limayambitsidwa, pomwe muyenera kuchita zojambula zomwe takambirana pamwambapa. Dzinalo lomwe lidzagawidwe pagulidwe liwoneke Dispatcher. Ikhoza kutseka ndikudina batani lozungulira pafupi ndikona kumanja.

Phunziro: Momwe mungatchulire dzina la foni ku Excel

Ntchito Zosiyanasiyana

Monga tafotokozera pamwambapa, ma array omwe atchulidwa amatha kugwiritsidwa ntchito pazinthu zosiyanasiyana ku Excel: njira, ntchito, zida zapadera. Tiyeni tiwone chitsanzo china cha momwe izi zimachitikira.

Patsamba limodzi tili ndi mndandanda wazamitundu yamaukompyuta. Tili ndi ntchito patsamba lachiwiri patebulopo kuti tipeze mndandanda wotsika pamndandanda.

1. Choyamba, pa mindandanda, timapereka mayina amtunduwu mwanjira zilizonse zomwe takambirana pamwambapa. Zotsatira zake, pakuwonetsa mndandandawo mundandanda wa dzina, dzina la adayilo liyenera kuwonetsedwa. Likhale dzina "Models".



2. Pambuyo pake, timasunthira ku pepala lomwe gome limakhalapo, pomwe timayenera kupanga mndandanda wotsika. Sankhani dera lomwe lili patebulopo lomwe tikukonza kuti mndandanda uzikhala pansi. Pitani ku tabu "Zambiri" ndipo dinani batani Chitsimikiziro cha data mu bokosi la zida "Gwirani ntchito ndi deta" pa tepi.



3. Pa zenera loyambitsa kutsimikizika kwa data, pitani ku tabu "Zosankha". M'munda "Mtundu wa deta" sankhani mtengo Mndandanda. M'munda "Gwero" mwachizolowezi, muyenera kugwiritsa ntchito pamanja zinthu zonse zamndandanda wotsatsa, kapena perekani ulalo mndandanda, ngati zili m'ndondomekoyo. Izi sizabwino kwambiri, makamaka ngati mndandandandawo uli papepala lina. Koma kwa ife, zonse ndizosavuta, popeza tidatipatsa dzinalo ku gulu lolingana nalo. Ndiye ingoikani chikwangwani zofanana ndipo lembani dzinali m'munda. Mawu otsatira akuti:

   = Zitsanzo

   Dinani "Zabwino".



4. Tsopano, mukasuntha pamwamba pa selo iliyonse pamtundu womwe tinagwiritsira ntchito kutsimikizika kwa data, pembetatu limawoneka kumanja kwake. Mukadina pazing'onoting'onozi mumatsegula mndandanda wazidziwitso, zomwe zimachotsedwa pamndandanda patsamba lina.



5. Tiyenera kusankha njira yomwe mukufuna kuti phindu kuchokera pamndandandandawu liwoneke.

Mtundu wotchulidwa umagwiritsidwanso ntchito mosavuta monga mfundo kuzinthu zosiyanasiyana. Tiyeni tiwone momwe izi zimagwiritsidwira ntchito pochita ndi chitsanzo china.

Chifukwa chake, tili ndi tebulo momwe ndalama za nthambi zisanu zamalonda zimafotokozedwera pamwezi. Tiyenera kudziwa ndalama zonse za Nthambi 1, Nthambi 3 ndi Nthambi 5 munthawi yonse yomwe tafotokozayi.

1. Choyamba, timapereka dzina pamzere uliwonse wa nthambi yolingana pagome. Pa nthambi 1, timasankha malo omwe ali ndi maselo omwe ali ndi deta pazachuma chake kwa miyezi itatu. Pambuyo powunikira mundawo ya dzina, lembani dzinalo "Nthambi_1" (musaiwale kuti dzinalo silingakhale ndi danga) ndikudina batani Lowani. Dzinalo lipangidwe. Ngati mungafune, mutha kugwiritsa ntchito njira ina iliyonse kupatsa dzina, lomwe takambirana pamwambapa.



2. Momwemonso, powunikira madera omwe tikugwirizana, timapereka mayina a mizere ndi nthambi zina: "Nthambi_2", "Nthambi_3", "Nthambi_4", "Nthambi_5".



3. Sankhani gawo la pepalalo momwe maulosi adzawonetsedwa. Dinani pachizindikiro "Ikani ntchito".



4. Kuyambitsa Ogwira Ntchito. Timasamukira kumalo "Masamu". Timayimitsa kusankhaku mndandanda wa opanga omwe akupezeka pa dzinalo SUM.



5. Windo la otsutsana ndi ogwiritsira ntchito limagwira SUM. Ntchitoyi, yomwe ndi gawo la gulu la ogwiritsa ntchito masamu, idapangidwa mwachidule kuti ifotokoze bwino za manambala. Mtundu wa syntax umaimiridwa ndi njira iyi:

   = SUM (nambala1; nambala2; ...)

   Monga zosavuta kumvetsetsa, wothandizira akufotokozera mwachidule zotsutsana zonse za gululo "Chiwerengero". Mwanjira yotsutsana, ziwerengero zonse zomwe zimagwiritsidwa ntchito palokha komanso zomwe maselo kapena magawo omwe amapezeka angagwiritsidwe ntchito. Ngati mipata yagwiritsidwa ntchito, kuchuluka kwa zinthu zomwe zili muzinthu zawo, kuwerengera kumbuyo, kumagwiritsidwa ntchito ngati zokangana. Titha kunena kuti "tikulumpha" pamachitidwe. Ndi yankho la vuto lathu kuti mabulangete azigawo azigwiritsidwa ntchito.

   Opaleshoni yonse SUM atha kukhala ndi mfundo imodzi mpaka 255. Koma kwa ife, kukangana katatu kokha kungafunike, chifukwa tiwonjezera magulu atatu: "Nthambi_1", "Nthambi_3" ndi "Nthambi_5".

   Chifukwa chake, ikani cholozera m'munda "Nambala1". Popeza tidapereka mayina ku magulu omwe akufunika kuwonjezeredwa, sitifunikira kulowa zolumikizira kumunda kapena kusankha malo ofananira pa pepalalo. Nenani mwachidule dzina lafotokozelayo kuti muwonjezere: "Nthambi_1". Kulowa m'minda "Nambala2" ndi "Nambala 3" lembani moyenerera "Nthambi_3" ndi "Nthambi_5". Mukamaliza kugwiritsa ntchito manambala pamwambapa, dinani "Zabwino".



6. Zotsatira zake amawerengedwa mu cell yomwe idasankhidwa asanapite Fotokozerani Wizard.

Monga mukuwonera, kupatsa dzina m'magulu a maselo munkhaniyi kunapangitsa kuti zikhale zosavuta kuwonjezera manambala omwe amapezeka, poyerekeza ndi ngati tikugwira ntchito ndi maadiresi, osati mayina.

Zowonadi, zitsanzo ziwirizi zomwe tanena pamwambapa zikuwonetsa kutali ndi zabwino zonse ndi mwayi wogwiritsa ntchito maina omwe ali ndi mayina akagwiritsidwa ntchito ngati gawo la ntchito, mafomula, ndi zida zina za Excel. Njira zomwe mungagwiritse ntchito zidutswa zomwe dzinalo lidatchulidwa sizili zosawerengeka. Komabe, zitsanzozi zimapangitsanso kuti athe kumvetsetsa zabwino zomwe zimatchulidwa papa pepala poyerekeza ndi kugwiritsa ntchito ma adilesi awo.

Phunziro: Momwe mungawerengere kuchuluka kwake pa Microsoft Excel

Otchedwa Range Management

Njira yosavuta yosamalira magawo omwe adatchulidwa ndi Woyang'anira mayina. Pogwiritsa ntchito chida ichi, mutha kupatsa mayina kumasamba ndi maselo, kusintha magawo omwe adatchulidwa kale ndikuwachotsa. Za momwe mungagwiritsire ntchito Dispatcher Tanena kale pamwambapa, ndipo tsopano taphunzira momwe tingagwiritsire ntchito zina mmenemo.

1. Kupita ku Dispatcherpitani ku tabu Mawonekedwe. Pamenepo muyenera dinani chizindikiro, chomwe chimatchedwa Woyang'anira Mayina. Chithunzi chomwe chatchulidwa chili mgululi "Mayina Otchulidwa".



2. Pambuyo kupita Dispatcher kuti muchite kunyamula kofunikira ndi mndandanda, muyenera kupeza dzina lake m'ndandanda. Ngati mndandanda wazinthu sizambiri, ndiye kuti izi ndizosavuta. Koma ngati m'buku lakalipoli pali makumi angapo aomwe ali ndi dzina kapena kuposerapo, ndiye kuti kuthandizira ntchitoyo ndikomveka kugwiritsa ntchito zosefera. Dinani batani "Zosefera"ili pakona yakumanja ya zenera. Kujambula kumatha kuchitika panjira zotsatirazi posankha zomwe zikugwirizana mumenyu womwe umatsegulira:
   • Mayina papepala;
   • mu buku;
   • ndi zolakwika;
   • palibe zolakwika;
   • Mayina apadera;
   • Mayina a tebulo.

   Kuti mubwererenso mndandanda wathunthu wa zinthu, ingosankha njira "Fafanizani".



3. Kusintha malire, dzina kapena zinthu zina zamtundu wotchulidwa, sankhani chinthu chomwe mukufuna Dispatcher ndipo dinani batani "Sinthani ...".



4. Zenera kusintha kwa dzina limatsegulidwa. Ili ndi magawo omwewo monga zenera lopangira mtundu womwe tidatchulawu kale. Pakadali pano minda idzadzaza ndi chidziwitso.

   M'munda "Dzinalo" Mutha kusintha dzina la malowo. M'munda "Zindikirani" Mutha kuwonjezera kapena kusintha cholembapo. M'munda "Zosintha" Mutha kusintha adilesi ya gulu lodziwika. Pali mwayi woti muchite izi mwa kugwiritsa ntchito maulalo ofunikira, kapena poika chikwangwani m'munda ndikusankha mndandanda wamitundu yolingana ndi pepala. Adilesi yake idzaonekere kumunda. Gawo lokha lomwe silingasinthidwe ndi "Chigawo".

   Mukasintha idathayo ndikumaliza, dinani batani "Zabwino".

Komanso Dispatcher ngati ndi kotheka, mutha kupanga njira yochotsa mtundu womwe watchulidwa. Poterepa, sichili chigawo chokha chomwe chimasungidwa papepala chimachotsedwa, koma dzina lomwe adapatsidwa. Chifukwa chake, njirayi ikamalizidwa, zida zomwe zikuwonetsedwa zitha kupezeka kudzera m'magwirizano awo.

Izi ndizofunikira kwambiri, chifukwa ngati mwayika kale dzina lochotsedwamo mwanjira ina, ndiye kuti mukachotsa dzinalo mufomalo likhala lolakwika.

1. Kuti muchite njira yochotsera, sankhani chinthu chomwe mukufuna kuchokera pamndandanda ndikudina batani Chotsani.



2. Pambuyo pake, bokosi la zokambirana limayambitsidwa, lomwe limafunsa kuti zitsimikizire kutsimikiza kwake kuchotsa zomwe zasankhidwa. Izi zimachitika kuti ogwiritsa ntchito asatsate njirayi molakwika. Chifukwa chake, ngati mukutsimikiza kuti muyenera kuchotsa, ndiye kuti muyenera dinani batani "Zabwino" pawindo lotsimikizira. Apo ayi, dinani batani. Patulani.



3. Monga mukuwonera, zinthu zomwe zasankhidwa zachotsedwa pamndandanda. Dispatcher. Izi zikutanthauza kuti mndandanda womwe adalumikiza udatayika dzina. Tsopano zizindikiridwa ndi ogwirizanitsa okha. Pambuyo pamanyumba onse mu Dispatcher malizitsani, dinani batani Tsekanikutsiriza zenera.

Kugwiritsa ntchito mayina omwe atchulidwa kungapangitse kuti zisamagwire ntchito ndi Excel formula, ntchito, ndi zida zina. Zinthu zomwe zidatchulidwazo zimatha kuwongoleredwa (kusinthidwa ndikuchotsedwa) pogwiritsa ntchito zapadera Dispatcher.