Zogulitsa zapamwamba

Kuchuluka kwa ntchito ku Microsoft Excel

Mukamagwiritsa ntchito kuwerenga kwina, kumafunika kupeza kuchuluka kwa ntchito. Nyuzipepala yamtunduwu nthawi zambiri imachitika ndi owerengera ndalama, mainjiniya, okonza mapulani, ophunzira a mabungwe ophunzitsira. Mwachitsanzo, njira iyi yowerengera ikufunika kuti mupeze malipiro onse omwe amapezeka masiku ambiri. Kukhazikitsa kwa izi kungafunike m'makampani ena, ngakhale zosowa zapakhomo. Tiyeni tiwone momwe mu pulogalamu yapamwamba yomwe mungawerengere kuchuluka kwa ntchito.

Kuwerengera kuchuluka kwa ntchitoyo

Kuchokera pa zomwe zachitikazo zikuwonekeratu kuti kuchuluka kwa ntchito ndi kuwonjezera kwa zotsatira zochulukitsa manambala. Kupambana, izi zitha kuchitidwa pogwiritsa ntchito njira yosavuta ya masamu kapena kugwiritsa ntchito gawo lapadera la diip. Tiyeni tilingalire mwatsatanetsatane njirazi payokha.

Njira 1: Kugwiritsa ntchito njira ya masamu

Ogwiritsa ntchito ambiri amadziwa kuti kuposa zomwe mungachite zambiri pamathanzi. Njira iyi ingagwiritsidwe ntchito kupeza kuchuluka kwa ntchito. Pulogalamuyi, malinga ndi malamulo a masamu, nthawi yomweyo imawerengera ntchitozo, ndipo kenako ndikungowonjezera iwo.

Ikani chikwangwani cha "chofanana" (=) mu khungu lomwe zotsatira za kuwerengetsa zidzakhala zotulutsa. Timalemba mawu owerengera pa template yotsatirayi:
= A1 * B1 * ... + A2 A2 * B2 * ... + A3 * B3 * ... + ... +
Mwachitsanzo, motere, mawuwo amatha kuwerengedwa:
= 54 * 45 + 15 * 265 + 47 * 12 + 69 * 78 * 78

Njira ya kuchuluka kwa ntchito mu Microsoft Excel

Kuti muwerengere ndikutulutsa zotsatira zake pazenera, dinani batani la Lowetsani pa kiyibodi.

Zotsatira za kuwerengetsa njira ya kuchuluka kwa ntchito mu Microsoft Excel

Njira 2: Gwirani ntchito ndi maumboni

M'malo mwa manambala apadera mu njirayi, mutha kutchula maulalo ku maselo omwe ali. Maulalo amatha kulowa pa Panchi, koma ndizosavuta kuchita izi powunikira pambuyo pa "= =", "kapena" chizindikiro, chomwe chili ndi nambala.

Chifukwa chake, lembani mawuwo, komwe m'malo mwa manambala omwe akuwonetsa ma cell.

Kuchuluka kwa ntchito ndi maulalo a Microsoft Excel

Kenako, kuwerengetsa, dinani batani la Lowetsani. Zotsatira za kuwerengetsa kuwonetsedwa.

Zotsatira za kuwerengetsa njira ya kuchuluka kwa ntchito ndi mafotokozedwe a Microsoft Excel

Zachidziwikire, kuwerengera kwamtunduwu ndikosavuta komanso kosavuta, koma ngati pali mfundo zambiri mugome zomwe muyenera kuchulukitsa, kenako ndikudula, njira iyi imatha nthawi yambiri.

Phunziro: Gwirani ntchito ndi njira zambiri

Njira 3: Kugwiritsa Ntchito Chidule

Kuti muwerenge kuchuluka kwa ntchitoyi, ogwiritsa ntchito ena amakonda ntchito yapadera yopangidwira izi - mwachidule.

Dzina la wothandizira uyu akunena za cholinga chake chokha. Ubwino wa njirayi isanakwane ndi yomwe ili nayo mutha kuthana ndi ma arraby athunthu nthawi yomweyo, m'malo mochitapo kanthu ndi nambala iliyonse kapena khungu lililonse.

Syntax ya ntchitoyi ili ndi mtundu uwu:

= Sungunulani (ARY1; Array2; ...)

Zotsutsana za wothandizirayu ndi zida zanthawi. Nthawi yomweyo, amakhala m'magulu a kuchulukitsa. Ndiye kuti, ngati mungachotse pa template, tinakambirana za pamwambapa (A1 * B1 * ... + A2 A2 B2 * ....) ALIYENSE AMENE ALIYENSE Izi zimayenera kukhala mtundu womwewo ndipo wofanana m'litali. Zitha kukhala, zonse molunjika komanso molunjika. Onse, wogwiritsa ntchitoyu amatha kugwira ntchito ndi chiwerengero cha mikangano kuyambira 2 mpaka 255.

Njira ya temple itatha kulembedwa nthawi yomweyo m'selo kuti ibweretse zotsatira zake, koma ogwiritsa ntchito ambiri amakhala osavuta komanso mosavuta kuwerengera kudzera mu ntchito zomwe mukufuna.

Sankhani khungu pa pepala lomwe zotsatirapo zomaliza zidzawonetsedwa. Dinani pa batani la "phala ntchito". Imakongoletsedwa mu mawonekedwe a chithunzi cha chithunzi ndipo ili kumanzere kwa gawo la formula.

Sinthani ku mbuye wa ntchito mu Microsoft Excel

Pambuyo pa ogwiritsa ntchito adapanga deta, ntchito zomwe Mbuye amayamba. Imapereka mndandanda wa onse, mochepera pang'ono, ogwiritsa ntchito omwe mungagwiritse ntchito bwino. Kuti mupeze ntchito yomwe mukufuna, pitani ku gulu la "masamu" kapena "mndandanda wathunthu wa zilembo". Pambuyo papeza dzinalo "DUPRY", tikuutsimikizira ndikudina batani la "OK".

Kusintha Kukangana kwa Balmarinzi Kugwiritsa Ntchito Microsoft Excel

Windo la kukangana limayambitsidwa. Ndi kuchuluka kwa zotsutsana zomwe zitha kukhala ndi minda ya 2 mpaka 255. Ma adilesi a mizere amathamangitsidwa ndi dzanja. Koma zimatenga nthawi yambiri. Mutha kuchita mwanjira ina. Ikani cholozera m'munda woyamba ndikuwonetsa mtundu wa mkangano woyamba papepala ndi batani lakumanzere. Momwemonso, timachita ndi yachiwiri komanso ndi mitundu yonse yamigwirizano yomwe maofesi omwe amagwirizana nawo nthawi yomweyo. Pambuyo pazomwe zidalembedwera, dinani batani la "OK" pansi pazenera.

Kukangana Kukonzekera Chidule mu Microsoft Excel

Pambuyo pa zochita izi, pulogalamuyo imapanga kuwerengera kotsiriza ndikuwonetsa zotsatira zomaliza m'chipinda chomwe zidanenedwera m'ndime yoyamba.

Zotsatira za kuwerengera ntchito yachidule mu Microsoft Excel

Phunziro: Mzere wa Wizard mu Excel

Njira 4: Ntchito ntchito ndi vuto

Ntchitoyo ndiyabwino komanso yoti itha kugwiritsidwa ntchito ndi mkhalidwe. Tidzakambirana momwe izi zimachitikira mwachitsanzo.

Tili ndi tebulo la malipiro ndipo tili ndi masiku a antchito abizinesi m'miyezi itatu pamwezi. Tiyenera kudziwa kuchuluka kwa wogwira ntchito parfenov d.f. wapeza nthawi yonseyi.

Momwemonso, monga nthawi yapita, itanani zotsutsana za ntchito ya Chidule. M'magawo awiri oyamba, tikuwonetsa ngati kuchitika malinga ndi magulu omwe antchito ndi kuchuluka kwa masiku omwe amawagwiritsa ntchito. Ndiye kuti, timachita zonse monga momwe zidayambira kale. Koma mu gawo lachitatu, timakhazikitsa magwiridwe antchito a mndandandawo, womwe uli ndi mayina a ogwira ntchito. Pambuyo pa adilesiyo, onjezani mbiri:
= "Parfenov d.f."

Pambuyo pazonse zomwe zidapangidwa, dinani batani la "OK".

Kukangana ntchito mwachidule ndi microsoft Excel

Pulogalamuyi imapanga kuwerengera. Mizere yokhayo imagwiritsidwa ntchito, pomwe pali dzina "Parfenov D.f", ndiye kuti, zomwe tikufuna. Zotsatira za kuwerengera zikuwonetsedwa mu chipinda chosankhidwa. Koma zotsatira zake ndi zero. Izi ndichifukwa choti mawonekedwe ali mu mawonekedwe omwe Iwo ulipo tsopano, amagwira molakwika. Tiyenera kuzisintha pang'ono.

Zotsatira za kuwerengedwa ndi vuto ku Microsoft Excel

Pofuna kutembenuza formula, sankhani khungu lomwe lili ndi mtengo womaliza. Chitani zochita mu chingwe. Kutsutsana ndi mkhalidwewo kumatenga mabatani, ndipo pakati pa iyo ndi zotsutsana zina zomwe zili ndi kusintha kwa comma ku kuchulukitsa chizindikiro (*). Dinani batani lolemba. Pulogalamuyi imayamba kuwerengetsa ndipo nthawi ino imapereka mtengo woyenera. Tinalandira malipiro onse kwa miyezi itatu, yomwe ndi chifukwa cha wogwira ntchito kwa kampani ya Parthenov D. F.

Zotsatira zomaliza zowerengera pansi pa mkhalidwe mu Microsoft Excel

Momwemonso, mikhalidwe ingagwiritsidwe ntchito osati kwa lembalo, komanso manambala omwe ali ndi madeti, kuwonjezera zizindikiro za mikhalidwe "", = ".

Monga mukuwonera, pali njira ziwiri zazikulu zowerengera kuchuluka kwa ntchito. Ngati deta si yochulukirapo, ndikosavuta kugwiritsa ntchito njira yosavuta ya masamu. Ziwerengero zambiri zikaphatikizidwa kuwerengera, wosutayo amasunga nthawi yake ndi kuyesetsa kwake ngati pakufunika kuthekera kwa ntchito yapadera ya dip. Kuphatikiza apo, mothandizidwa ndi wothandizira yemweyo, mutha kuwerengera pansi pa mkhalidwe womwe foremula nthawi zonse sakudziwa momwe angachitire.