Gwirani ntchito ndi matchulidwe a cyclic mu Excel

Kulumikizana kwa cyclic ku Microsoft Excel

Amakhulupirira kuti mafotokozedwe a cyclic omwe ali pazambiri ndi mawu olakwika. Zowonadi, nthawi zambiri izi ndizotero, komabe osati nthawi zonse. Nthawi zina amagwiritsa ntchito mosamala. Tiyeni tiwone maulalo a cyclic ndi momwe mungawapangire momwe angapezere kale mu chikalatacho momwe mungagwiritsire ntchito nawo kapena momwe mungachichotsere.

Kugwiritsa Ntchito Maumboni a Cyclic

Choyamba, pezani batani la cyclic. Mwakutero, mawuwa, omwe, kudzera munjira zina m'maselo ena, amangotanthauza. Komanso, ikhoza kukhala chilungulo chomwe chimapezeka mu gawo la tsamba lomwe limangotanthauza.

Tiyenera kudziwa kuti posasintha, mabatani amakono a Excel okha amangochotsa njira yogwiritsira ntchito chizolowezi. Izi ndichifukwa choti mawu oterewa ambiri ndi olakwika, ndipo chimbudzi chimakhala chobwerezabwereza komanso kuwerengera, chomwe chimapanga katundu wowonjezera pa kachitidwe.

Kupanga ulalo wa cyclic

Tsopano tiwone momwe mungapangire mawonekedwe osavuta a cyclical. Ili likhala chilungulo chomwe chili m'chipinda chimodzi chomwe chimatanthauza.

Tikuwonetsa chinthu cha pepala la A1 ndikulemba mawu otsatirawa:
= A1.
Kenako, dinani batani la Lowetsani pa kiyibodi.

Kupanga ulalo wosavuta wa cyclic ku Microsoft Excel

Pambuyo pake, mawu ochenjeza a cell a cell a cell akuwoneka. Dinani batani la "OK".

Kuchenjeza za mabokosi onena za ulalo wa cyclic mu Microsoft Excel

Chifukwa chake, tinachita opaleshoni yozungulira pa pepala lomwe khungu limangotanthauza zokha.

Ntchito yovuta kwambiri ndikupanga mawonekedwe a cyclic kuchokera maselo angapo.

Mu gawo lililonse la pepalalo, lembani nambala. Lolani kuti ikhale cell A1, ndi nambala 5.

Mu cell ina (B1) Lembani mawuwo:
= C1.

Mu gawo lotsatira (C1) Tilembatu mtundu wotere:
= A1.

Selo imodzi imatanthawuza wina ku Microsoft Excel

Pambuyo pake, timabwereranso ku cell A1, pomwe nambala yaikidwa 5. Kutchulanso ku gawo la B1:
= B1.
Dinani batani lolemba.

Maulalo okhazikitsa mu Slex mu Microsoft Excel

Chifukwa chake, kuzungulira kotsekedwa, ndipo tidalandira ulalo wapadera wapadera. Windo la Chenjezo litatsekedwa, tikuwona kuti pulogalamuyi idawonetsa mgwirizano wa padera lokhala ndi mivi, yomwe imatchedwa mivi.

Kuyankhulana kwa cyclic kulumikizana mu Microsoft Excel

Tsopano tikupeza mawu ozungulira pa tebulo. Tili ndi tebulo lotsatira. Imakhala ndi mizati inayi, yomwe imawonetsa dzina la zinthuzo, kuchuluka kwa zinthu zogulitsidwa, mtengo ndi kuchuluka kwa ndalama zogulitsa voliyumu yonse. Gome mu mzere womaliza ali ndi ma fomu. Amawerengera ndalama pochulukitsa kuchuluka kwa mtengo.

Revenue kuwerengetsa patebulo mu Microsoft Excel

Kuti musunge formula mu mzere woyamba, tikutsindika za pepalalo ndi chiwerengero cha chinthu choyamba (B2). M'malo mwa mtengo wazokhazikika (6), lowetsani njirayo, yomwe ilongosola kuchuluka kwa katundu pogawa ndalama zonse (c2):
= D2 / C2

Dinani batani lolemba.

Ikani ulalo wa cyclica mu tebulo mu Microsoft Excel

Tazindikira ulalo woyamba wa cyclic, ubale womwe umadziwika ndi muvi woyenda. Koma monga tikuwona, zotsatira zake ndizolakwika ndipo zofanana ndi zero, monga zanenedwa kale, Exarll amaletsa kuphedwa kwa cyclic.

Ulalo wa cyclic mu tebulo ku Microsoft Excel

Koperani mawuwo m'magawo ena onse a mzere ndi kuchuluka kwa zinthu. Kuti muchite izi, khazikitsani cholozera ku mbali yakumanzere ya chinthu chomwe chili kale ndi njira. Cursor imasinthidwa kukhala mtanda, womwe umayitanidwa kuti uzitcha cholembera. Lambulani batani lakumanzere ndikukoka mtanda mpaka kumapeto kwa tebulo pansi.

Monga mukuwonera, mawuwo adakopedwa ku zinthu zonse za mzati. Koma, ubale umodzi wokha ndi womwe umadziwika ndi muvi woyenda. Zindikirani zamtsogolo.

Maulalo a Cyclic amakopedwa mu tebulo ku Microsoft Excel

Sakani maulalo a cyclic

Monga momwe taonera kale, osati nthawi zonse pulogalamuyi imasokoneza ubale wa cyclic ntchentche ndi zinthu, ngakhale zitakhala papepala. Popeza kuti mwamphamvu kwambiri za anthu ambiri pa nthawi yayitali zimakhala zovulaza, ziyenera kuchotsedwa. Koma chifukwa cha izi ayenera kupeza. Kodi mungachite izi bwanji ngati mawu ake sanalembedwe ndi mzere wa mivi? Tiyeni tichite ndi ntchitoyi.

Chifukwa chake, ngati mutayamba fayilo yopambana, muli ndi zenera la chidziwitso kuti ili ndi ulalo wapadera, ndikofunikira kuti mupeze. Kuti muchite izi, sinthani ku "njira". Dinani pa nthiti pa makona atatu, omwe ali kumanja kwa batani la "Kuyang'ana Zolakwika", komwe kuli "kudalira chida. Menyu imatseguka pomwe cholembera chiyenera kuchitidwa ndi "maulalo a cyclic". Pambuyo pake, mndandanda wotsatirawu umatsegula mndandanda wa ma adilesi omwe pulogalamuyi yapeza pulogalamu ya cyclic.

Sakani maulalo a cyclic mu Microsoft Excel

Mukadina pa adilesi inayake, khungu lolingana limasankhidwa papepala.

Sinthani ku khungu lomwe lili ndi ulalo wa cyclic mu Microsoft Excel

Pali njira ina yodziwira komwe kulumikizana kwa cycli kuli. Uthenga wokhudza vutoli ndi adilesi ya chinthu chomwe chili ndi mawonekedwe ofananawo mbali ya chingwe, yomwe ili pansi pazenera. Zowona, mosiyana ndi mtundu wakale, ma adilesi a sikuti zinthu zonse zomwe zili ndi cro maumboni adzawonetsedwa pa bar, ngati pali ambiri a iwo, koma imodzi yokhayo, yomwe idawonekera kwa ena.

Mauthenga a Cyclic Colouse pagawo la Aness Pannel mu Microsoft Excel

Kuphatikiza apo, ngati muli m'bukhu lokhala ndi mawu okhala ndi pakhosi, osati pa pepala lomwe lilipo, ndipo pa linalo, ndiye kuti pali uthenga wonena kuti kupezeka kwa cholakwika chidzawonetsedwa mu bar.

Ulalo wa cyclica pa pepala lina ku Microsoft Excel

Phunziro: Momwe Mungapezere Malumikizidwe a Cyclic Kupambana

Kukonzanso Maumboni a Cyclic

Monga tafotokozera pamwambapa, mwankhanza kwambiri, ntchito zapakhomo ndizoyipa, zomwe zimayenera kuthetsedwa mosavuta. Chifukwa chake, ndizachilengedwe kuti gawo la cyclic litapezeka, ndikofunikira kukonza kuti zibweretse njira yabwinobwino.

Pofuna kukonza kudalira kwa chilengedwe, muyenera kuonanso maselo onse. Ngakhale chekizani foniyo mwachidule, ndiye kuti cholakwika sichingakuphiridwe paokha, koma m'malo ena a udzu.

Kwa ife, ngakhale kuti pulogalamuyi imalozane molondola maselo amodzi (D6), olakwitsa kwenikweni agona mu chipinda china. Sankhani D6 chinthu kuti mupeze maselo omwe amatulutsa mtengo wake. Timayang'ana mawuwo mu Chingwe cha Formula. Monga tikuwona, mtengo womwe uli m'bokosili umapangidwa ndi kuchulukitsa zomwe zili mu maselo a B6 ndi C6.

Pitani ku CES CES. Tikuunikira ndikuyang'ana chingwe cha formula. Monga tikuwona, ndi mtengo wamba (1000), womwe si malonda kuwerengera. Chifukwa chake, nkwabwino kunena kuti chinthu chotsimikizika sichikhala ndi zolakwika zomwe zimayambitsa ntchito za cyclic.

Kufunikira kofunikira mu Microsoft Excel

Pitani ku cell yotsatira (B6). Pambuyo posankha mu formula mzere, tikuwona kuti ili ndi mawu owerengedwa (= D6 / C6), yomwe imatulutsa deta kuchokera kumeza ina, makamaka, kuchokera ku cell ya d6. Chifukwa chake, cell ya D6 imatanthawuza chidziwitso cha chinthu cha B6 ndi mosemphanitsa, chomwe chimayambitsa kuyambiranso.

Apa ubale womwe timawerengedwa mwachangu, koma m'malo mwake pali milandu yomwe maselo ambiri amatenga nawo gawo pazowerengera, osati zigawo zitatu monga tili nazo. Kenako kusaka kungatenge nthawi yayitali, chifukwa uyenera kuphunzira chilichonse.
Tsopano tiyenera kumvetsetsa maselo (B6 kapena D6) ili ndi cholakwika. Ngakhale, mwamwayi, sichomveka ngakhale cholakwika, koma kungogwiritsa ntchito mafotokozedwe ochulukirapo omwe amatsogolera kulowera. Mukamathetsa zomwe zimathetsa khungu ziyenera kusinthidwa, muyenera kugwiritsa ntchito mfundo. Palibe algorithm yodziwikiratu. M'njira zonsezi, malingaliro awa adzakhala ake.
Mwachitsanzo, ngati tebulo lathu litagawana ndalama zonse ziyenera kuwerengetsa kuchuluka kwa ogulitsa katundu pamtengo wake, ndiye kuti titha kunena kuti ulalo womwe umawerengera ndalama zonse ndizowonekeratu. Chifukwa chake, timachichotsa ndikusintha ndi zofunikira.

Ulalo umasinthidwa ndi zomwe zili mu Microsoft Excel

Kuchita koteroko kumachitika chifukwa cha mawu ena onse a cyclic ngati ali papepala. Pambuyo kwambiri maulalo onse a pasic achotsedwa m'buku, uthenga wonena za vutoli uyenera kuthamangitsidwa ndi chingwe.
Kuphatikiza apo, mawu achi cyclic adachotsedwa kwathunthu, mutha kudziwa pogwiritsa ntchito chida chojambulira. Pitani ku "njira" ndi dinani makona anu akutiazidziwitsa kumanja kwa batani la "Kuyang'ana" "Kutengera njira" . Ngati "ma cyclic maulalo" omwe ali mu menyu omwe akuyenda sakugwira ntchito, ndiye, zikutanthauza kuti tidachotsa zinthu zonsezi m'lembali. Mosakayikira, muyenera kugwiritsa ntchito njira zochotsa zinthu zomwe zalembedwa, zomwezo chimodzimodzi.

Malumikizidwe a Cyclic mu Bukuli Palibe Microsoft Excel

Chilolezo cha kuphedwa kwa maofesi a cyclic

M'gawo lakale la phunziroli, tidauza, makamaka momwe angachitire ndi mafotokozedwe a cyclic, kapena momwe angazipeze. Koma, m'mbuyomu, kucheza nawonso kwa nthawi ina kwa nthawi zina iwo, m'malo mwake, akhoza kukhala othandiza ndikugwiritsa ntchito mosamala ndi wogwiritsa ntchito. Mwachitsanzo, nthawi zambiri njirayi imagwiritsidwa ntchito ngati mawerengero owerengera mukamamanga mitundu yachuma. Koma vuto ndilakuti, ngakhale mutakhala ndi chikumbumtima kapena mosadziwa kuti mumagwiritsa ntchito ma cyclic, kuti muchepetse kugwirira ntchito pazinthuzo. Pankhaniyi, funso lokakamiza kutsekereza limakhala lofunikira. Tiyeni tiwone momwe mungachitire.

Kutseka maulalo a cyclic mu Microsoft Excel

Choyamba, timasamukira ku "fayilo" tabu ya Excel.

Pitani ku fayilo ya fayilo ku Microsoft Excel

Chotsatira, dinani pa "magawo" omwe ali kumanzere kwa zenera lomwe limatseguka.

Pitani ku zenera la parameter ku Microsoft Excel

Zenera la utatu wa ukapolo limayamba kuthamanga. Tiyenera kupita ku tabu ".

Kusintha kwa Formula Tab mu Microsoft Excel

Ili pazenera lomwe limatsegulidwa lidzaloledwa kuchita zoopsa za pantclic. Pitani kumanja kwa zenera ili, pomwe makonda a Excel ndi achindunji. Tidzagwira ntchito ndi "magawo a mafinya" omwe ali pamwamba.
Kuti mulole kugwiritsa ntchito mawu a cyclic, muyenera kukhazikitsa zojambula za "kuthandizira kuwerengera". Kuphatikiza apo, mu chipika chomwecho, mutha kukhazikitsa kuchuluka kwa malire ndi kulakwitsa kwina. Mwachisawawa, malingaliro awo ndi 100 ndi 0,001, motero. Nthawi zambiri, magawo awa safunikira kusinthidwa, ngakhale ngati kuli kotheka, ndizotheka kusintha ku minda yomwe yatchulidwayi. Koma apa ndikofunikira kulingalira izi zowonjezera izi zimatha kuyambitsa katundu wambiri pa pulogalamuyi ndi kachitidwe kalikonse, makamaka ngati mumagwira ntchito ndi fayilo yomwe mawu ambiri cyclic amayikidwa.
Chifukwa chake, timakhazikitsa zojambulajambula za "gawo lowerengera", kenako kuti makonda atsopano omwe adalowa nawo, dinani batani la "Ok"

Yambitsani kuwerengetsa kwamphamvu mu Microsoft Excel

Pambuyo pake, timangopita ku pepalalo la buku lapano. Monga tikuwonera, m'maselo omwe ma cyclic omwe ali pachimake amapezeka, tsopano zomwe zimawerengedwa molondola. Pulogalamuyi siyitseka kuwerengera mwa iwo.

Mitundu ya cyclic imawonetsa mfundo zolondola mu Microsoft Excel

Komabe ndikofunikira kudziwa kuti kuphatikizidwa kwa ntchito zapa Cyclic sikuyenera kuzunzidwa. Gwiritsani ntchito izi pokhapokha ngati wogwiritsa ntchito ali ndi chidaliro chonse pakufunikira kwake. Kuphatikizika kosaganizira kwa ntchito za cyclic sikungangoyambitsa katundu kwambiri pamtunduwu ndikuchepetsa kuwerengera mukamagwira ntchito ndi chikalata, koma wogwiritsa ntchito sangakhale wosinthika ndi pulogalamuyi.

Monga tikuwona, mwamphamvu kwambiri za milandu, maumboni a cyclic ndi chodabwitsa chomwe muyenera kumenya nawo. Pachifukwa ichi, choyambirira, muyenera kuzindikira ubale wozizira pawokha, ndiye kuti muwerengere khungu lomwe cholakwika chalembedwa, ndipo pamapeto pake muchotseke ndikupanga kusintha koyenera. Koma nthawi zina, kugwira ntchito payclic kumatha kukhala kothandiza powerengera ndikugwiritsa ntchito ogwiritsa ntchito mosamala. Koma ngakhale pamenepo, ndikofunikira kugwiritsa ntchito mosamala, kukonza bwino komanso kudziwa momwe zinthu zinafotokozerako, zomwe, zikagwiritsidwa ntchito pazinthu zambiri, zimatha kuchepetsa ntchito ya kachitidwe.