Maulalo a cyclic mu Microsoft Excel

Ndizovomerezeka kuti kulumikizana kwa ma cyclic ku Excel ndi mawu olakwika. Inde, nthawi zambiri izi zimakhala zowona, koma osati nthawi zonse. Nthawi zina zimagwiritsidwa ntchito mwadala. Tiyeni tiwone zamomwe ma cyclic amalumikizira, momwe angapangire, momwe mungapezere zomwe zikupezeka mu chikalata, momwe angagwirire nawo, kapena momwe mungazichotsere ngati pakufunika.

Kugwiritsa ntchito zozungulira zozungulira

Choyamba, tiyeni tiwone momwe kulumikizana kulili. M'malo mwake, awa ndi mawu akuti, kudzera m'njira m'maselo ena, amadzidziwitsa. Ikhozanso kukhala ulalo womwe umaphatikizidwa mu pepala lomwe limalozerako.

Dziwani kuti mwa kusinthika, mitundu yamakono ya Excel imangodziletsa kuchita ntchito yoyendetsa njinga. Izi ndichifukwa choti malankhulidwe oterewa ndi olakwika kwambiri, ndipo kutsitsa kumatulutsa nthawi ndi nthawi kuwerengera komanso kuwerengera, zomwe zimapangitsa kuti chiwonjezerochi chiwonjezeke.

Pangani ulalo wozungulira

Tsopano tiwone momwe tingapangire mawu osavuta a cyclic. Ichi ndi cholumikizira chomwe chili mgawelo limodzilo.

1. Sankhani pepala A1 ndipo lembani mawu otsatirawa:

   = A1

   Kenako, dinani batani Lowani pa kiyibodi.



2. Pambuyo pake, bokosi lakuchenjeza la mawu akuti cyclic limawonekera. Dinani batani mmenemo. "Zabwino".



3. Chifukwa chake, adalandira opaleshoni yoyenda pa pepala lomwe selo limadziloza lokha.

Tiyeni tisokoneze ntchitoyi pang'ono ndikupanga mawonekedwe a ma cyclic ochokera kuma cell angapo.

1. Mulimonsemo, zilembeni manambala. Lolani kuti ikhale khungu A1, ndi nambala 5.



2. Ku foni ina (B1) lembani mawu oti:

   = C1



3. Gawo lotsatira (C1) Timalemba formula wotere:

   = A1



4. Pambuyo pake tibwerera ku cell A1momwe chiwerengerocho chidakhazikitsidwa 5. Timalankhula za chinthucho. B1:

   = B1

   Dinani batani Lowani.



5. Chifukwa chake, maloko adatseka, ndipo tidakhala ndi zolemba zoyambirira. Tsamba lotichenjeza litatsekedwa, tikuwona kuti pulogalamuyo idalembera ulalo wolumikizana ndi mivi yamtambo pa pepala, lomwe limatchedwa mivi yoyang'anira.

Tsopano tiyeni tisunthirepo popanga mawu ozungulira pogwiritsa ntchito gome la zitsanzo. Tili ndi tebulo lazogulitsa chakudya. Mulinso mizati inayi yomwe dzina la malonda, kuchuluka kwa zinthu zomwe zagulitsidwa, mtengo wake ndi kuchuluka kwa ndalama zomwe zatsitsidwa pogulitsa buku lathunthu zikuwonetsedwa. Gome patsamba lomaliza lili kale ndi njira. Amawerengera ndalama pochulukitsa kuchuluka kwa mtengo.

1. Kuti mumange mzere mu mzere woyamba, sankhani pepala ndi kuchuluka kwa zinthu zoyambirira muakaunti (B2) M'malo mwa mtengo wokhazikika (6) timalowa formula pamenepo, yomwe ingaganizire kuchuluka kwa katundu pogawa zonse (D2) pamtengo (C2):

   = D2 / C2

   Dinani batani Lowani.



2. Tili ndi ulalo woyamba wozungulira, ubale womwe nthawi zambiri umawonetsedwa ndi mivi yotsata. Koma monga mukuwonera, zotsatira zake ndizolakwika komanso zofanana ndi zero, monga tanena kale, Excel imaletsa kuchitidwa kwa ma cyclic.



3. Koperani mawuwo ku maselo ena onse omwe ali mgolalo ndi kuchuluka kwa zinthu. Kuti muchite izi, ikani cholozera mu ngodya ya kumunsi kwa chinthu chomwe chili kale ndi formula. Choperekera chithunzicho chimasinthidwa kukhala mtanda, womwe nthawi zambiri umatchedwa chizindikiro chodzaza. Gwirani pansi batani lakumanzere ndikukokera mtanda uwu kumapeto kwa tebulo pansi.



4. Monga mukuwonera, mawuwo adakopedwa kuzinthu zonse za mzati. Koma, ubale umodzi wokha ndi womwe uli ndi mivi yoyesa. Zindikirani izi zamtsogolo.

Sakani maulalo ozungulira

Monga momwe tawonera pamwambapa, sizowona zonse zomwe zimakhudzidwa ndi pulogalamuyi poyerekeza ndi zozungulira, ngakhale zitakhala pa pepala. Popeza kuti zochitika zambiri zamakina ozungulira zimakhala zovulaza, ziyenera kuchotsedwa. Koma chifukwa cha ichi ayenera kupeza. Kodi mungachite bwanji ngati mawuwo alibe chizindikiro ndi mzere? Tithane ndi vutoli.

1. Chifukwa chake, ngati mutayamba fayilo ya Excel, zenera lazidziwitso limatseguka ndikuti ili ndi ulalo wozungulira, ndiye kuti muyenera kulipeza. Kuti muchite izi, pitani ku tabu Mawonekedwe. Dinani pa riboni patatu, lomwe lili kumanja kwa batani "Onani zolakwa"ili mu chipangizo Kudodometsa Kwambiri. Menyu umatseguka pomwe muyenera kuyendayenda pamalowo "Maulalo ozungulira". Zitatha izi, mndandanda wamndandanda wazinthu zomwe pulogalamuyo idazindikira ma cyclic amatsegulidwa menyu yotsatira.



2. Mukadina pa adilesi inayake, khungu lolingana ndi pepalalo limasankhidwa.

Pali njira inanso yodziwira momwe ulalo wozungulira uliri. Mauthenga okhudzana ndi vutoli ndi adilesi ya chinthu chomwe chili ndi mawu awa ili kumanzere kwa bar ya mawonekedwe, yomwe ili pansi pazenera la Excel. Zowona, mosiyana ndi mtundu wam'mbuyo, batani la mawonekedwe silingawonetse ma adilesi a zinthu zonse zomwe zili ndi mawonekedwe ozungulira, ngati alipo ambiri, koma ndi amodzi okha omwe adawonekera pamaso pa enawo.

Kuphatikiza apo, ngati muli m'bukhu lomwe lili ndi mawu ofotokozera, osati pa pepala momwe lilili, koma pa linalo, ndiye kuti uthenga wokhawo wolakwitsa popanda adilesi udzaonetsedwa mu bar yapa.

Phunziro: Momwe mungapezere zolumikizira zozungulira mu Excel

Konzani zolumikizana

Monga tafotokozera pamwambapa, nthawi zambiri, zochitika zam'mizinda ndizoyipa zomwe zimayenera kutayidwa. Chifukwa chake, ndizomveka kuti ukalumikizana ndi ma cyclic, ndikofunikira kuti uwongolere kuti ubweretse njira yabwino.

Pofuna kukonza kudalirika kwa cyclic, ndikofunikira kufunafuna kulumikizana konse kwa maselo. Ngakhale cheke chikusonyeza nambala inayake, cholakwacho sichingakhale chokha, koma china.

1. M'malo mwathu, ngakhale kuti pulogalamuyo imaloza molondola imodzi mwa maselo ali m'chiuno (D6), cholakwika chenicheni chagona mu foni ina. Sankhani chinthu D6kudziwa kuti ndi maselo ati omwe amakoka mtengo kuchokera. Timayang'ana mawuwo mu kapamwamba koyamba. Monga mukuwonera, phindu lomwe lili patsamba lino limapangidwa ndikuchulukitsa zomwe zili m'maselo B6 ndi C6.



2. Pitani ku cell C6. Sankhani ndikuyang'ana mzere wa fomula. Monga mukuwonera, iyi ndi mtengo wanthawi zonse (1000), zomwe sizomwe zimapangidwa pakuwerengera kachitidwe. Chifukwa chake, titha kunena molimba mtima kuti chinthu chomwe chatchulidwachi chiribe cholakwika chomwe chimayambitsa kupanga kwa ma cyclic.



3. Pitani ku foni yotsatira (B6) Pambuyo powunikira mu bar yamu, tikuwona kuti ili ndi mawu owerengeredwa (= D6 / C6), yomwe imakoka deta kuchokera kuzinthu zina za tebulo, makamaka, kuchokera pafoni D6. Chifukwa chake khungu D6 amatanthauza zambiri zazinthu B6 ndi mosemphanitsa, zomwe zimayambitsa kuzungulira.

   

   Apa tinawerengera chibwenzicho mwachangu, koma zenizeni zimachitika kuti pali ma cell ena ambiri amomwe amawerengedwa, osati zinthu zitatu, monga momwe takhalira. Kenako kusaka kumatha kutenga nthawi yayitali, chifukwa muyenera kuphunzira chilichonse chazunguzikulu.

4. Tsopano tiyenera kumvetsetsa kuti mu khungu liti (B6 kapena D6) ili ndi cholakwika. Ngakhale, mwawonekedwe, izi sizolakwika ngakhale, koma kugwiritsa ntchito molumikizira maulalo, zomwe zimabweretsa chiuno. Panthawi yomwe mukuganiza kuti ndi gawo liti lomwe liyenera kusintha, mfundozo ziyenera kuyikidwa. Palibe njira yodziwika bwino yochitira zinthu. Munthawi zonsezi, izi ndizosiyana.

   Mwachitsanzo, ngati patebulo lathu ndalama zonse zikuyenera kuwerengedwa ndikuchulukitsa kuchuluka kwa zinthu zomwe zagulitsidwadi ndi mtengo wake, ndiye titha kunena kuti kulumikiza kuwerengetsa kuchuluka kwaogulitsa kwathunthu ndi kopanda tanthauzo. Chifukwa chake, timachichotsa ndikuichotsa ndi mtengo wokhazikika.



5. Timagwira ntchito yofananira pamawu ena onse, ngati ali papepala. Pambuyo poti zolemba zonse zozungulira zachotsedwa mbukumo, uthenga wonena za kukhalapo kwa vutoli uyenera kuzimiririka pa bala.

   Kuphatikiza apo, kaya mawu a cyclic adachotsedwa kwathunthu, mutha kudziwa kuti mukugwiritsa ntchito chida cholondola cholakwika. Pitani ku tabu Mawonekedwe ndikudina makona atatu omwe akutidziwa kale kumanja kwa batani "Onani zolakwa" pagulu lazida Kudodometsa Kwambiri. Ngati mumenyu omwe atsegula, "Maulalo ozungulira" sakhala wogwira ntchito, izi zikutanthauza kuti tachotsa zinthu zonse zolembedwa. Kupatula apo, zidzakhala zofunikira kugwiritsa ntchito njira yochotsera zinthu zomwe zili m'ndondomeko yomweyo monga momwe zidaganiziridwapo kale.

Chilolezo cha Loopback

Gawo lapitalo la phunziroli, tinkakambirana zambiri momwe tingachitire ndi maulalo ozungulira, kapena momwe mungazipezere. Koma, m'mbuyomu zokambiranazi zidakhudzanso kuti nthawi zina, m'malo mwake, zitha kukhala zothandiza komanso kugwiritsa ntchito mosamala wogwiritsa ntchito. Mwachitsanzo, nthawi zambiri njirayi imagwiritsidwa ntchito powerengera ndalama pomanga mitundu yazachuma. Koma vuto ndilakuti, ngakhale mutagwiritsa ntchito mawu ozungulira modzipereka kapena osadziwa, Excel mwanjira yokhayo idzaletsabe opaleshoniyo, kuti isachititse kuti machitidwe azikhala ochuluka. Poterepa, nkhani yoletsa kukankha kotereku ikuyenera. Tiyeni tiwone momwe angachitire.

1. Choyamba, pitani ku tabu Fayilo Zolemba za Excel.



2. Kenako, dinani chinthucho "Zosankha"ili kumanzere kwa zenera lomwe limatseguka.



3. Zenera la Excel options liyamba. Tiyenera kupita pa tabu Mawonekedwe.



4. Ndi pawindo lomwe limatsegulira kuti zitheke kuloleza kuchitidwa kwa ma cyclic. Timapita kumunsi kwa zenera ili, pomwe zoikamo za Excel zimapezeka. Tidzagwira ntchito ndi block block Mawerengi Magawoyomwe ili pamwamba pomwe.

   Kuti mupewe kugwiritsa ntchito ma cyclic, yang'anani bokosi pafupi ndi gawo Yambitsani Ntchito Yoyambitsa Zakale. Kuphatikiza apo, kuchuluka kwa mayendedwe ake komanso zolakwika zina zitha kukhazikitsidwa. Mwakusintha, malingaliro awo ndi zana ndi 0.001, motsatana. Mwambiri, magawo awa safunika kuti asinthidwe, ngakhale ngati kuli kofunikira kapena ngati mungafunike, mutha kusintha pamalondawa. Koma apa mukuyenera kudziwa kuti zochulukitsa zambiri zimatha kudzetsa pulogalamuyo ndi pulogalamu yonseyo, makamaka ngati mukugwiritsa ntchito fayilo yomwe ili ndi mawu ambiri ozungulira.

   Chifukwa chake, onani bokosi pafupi ndi paramayo Yambitsani Ntchito Yoyambitsa Zakale, kenako kuti mawonekedwe atsopano ayambe kugwira, dinani batani "Zabwino"ili m'munsi mwa zenera la Excel.



5. Pambuyo pake, timangopita pa pepala la bukuli. Monga mukuwonera, m'maselo omwe ma cell a cyclic amapezeka, tsopano mawonekedwe amawerengedwa molondola. Pulogalamuyi siyimaletsa kuwerengera.

Komabe, ndikofunikira kudziwa kuti kuphatikiza ma cyclic ntchito sikuyenera kuzunzidwa. Gwiritsani ntchito ntchitoyi pokhapokha wosuta akakhala ndi chitsimikizo chonse pakufunika kwake. Kuphatikiza kosagwirizana ndi ma cyclic sikuti kungangoyambitsa kuchuluka kwa dongosolo ndikuchepetsa kuwerengera pakugwira ntchito ndi chikalata, koma wogwiritsa ntchitoyo mosazindikira angayambitse mawu olakwika a cyclic, omwe mosakhalitsa akhoza kutsekedwa ndi pulogalamuyo.

Monga tikuonera, nthawi zambiri, mayendedwe ozungulira ndi chinthu chofunikira chofunikira kuwongoleredwa. Pachifukwa ichi, choyambirira, ndikofunikira kuzindikira ubale wa cyclic yokha, kenako kuwerengera cell komwe cholakwikacho, ndipo, kenako, kuchichotsa ndikupanga kusintha koyenera. Koma nthawi zina, ntchito za ma cyclic zimatha kukhala zothandiza kuwerengetsa komanso kuchitidwa ndi wogwiritsa ntchito mosamala. Koma ngakhale pamenepo, munthu ayenera kuyandikira kugwiritsa ntchito mosamala, kukhazikitsa Excel ndikudziwa muyezo wowonjezera maulalo, omwe, akagwiritsidwa ntchito kwambiri, amatha kuchepetsa dongosolo.