Ntchito ya IND 38 ku Microsoft Excel

Chimodzi mwazomwe zimapangidwa mu Excel ndi INDIA. Ntchito yake ndikubwerera ku chidutswa cha pepalacho komwe kuli, zomwe zili muchipinda chomwe chikugwirizanachi chikuwonetsedwa ngati mkangano pamawu.

Zikuwoneka kuti palibe chachilendo pamenepa, chifukwa ndizotheka kuwonetsa zomwe zili mu foni imodzi m'njira ina. Koma, monga momwe zimakhalira, kugwiritsa ntchito opaleshoni iyi kumaphatikizapo ma nuances ena omwe amawapangitsa kukhala osiyana. Nthawi zina, fomuloli imatha kuthana ndi mavuto omwe sangathe kuthana nawo m'njira zina, kapenanso zimakhala zovuta kwambiri. Tiyeni tiwone mwatsatanetsatane momwe opangirayo alili. INDIA ndi momwe angagwiritsidwire ntchito pochita.

Kugwiritsa ntchito kachitidwe kolembedwa ka INDIRECT

Dzinalo la operekedwayo INDIA imayimira bwanji Lumikizanani Kawiri. Kwenikweni, izi zikuwonetsa cholinga chake - kutulutsa zomwe zikupezeka kudzera pa ulalo wodziwika kuchokera pa foni imodzi kupita kwina. Kuphatikiza apo, mosiyana ndi ntchito zina zambiri zomwe zimagwira ndi maulalo, ziyenera kuwonetsedwa pamawonekedwe, ndiye kuti, ili ndi zilembo zolemba mbali zonse ziwiri.

Wogwiritsa ntchitoyu ali m'gulu la ntchito. Malingaliro ndi Kufika ndipo ili ndi syntax yotsatira:

= INDIRECT (cell_link; [a1])

Chifukwa chake, fomuloli ili ndi mfundo ziwiri zokha.

Kukangana Cell Link yowonetsedwa ngati cholumikizana ndi chidutswa cha pepala, zomwe zili momwe mukufuna kuwonetsera. Nthawi yomweyo, cholumikizacho chimayenera kukhala ndi mawonekedwe a mawu, ndiko kuti, "wokutidwa" ndi mawu osakira.

Kukangana "A1" ndichosankha ndipo nthawi zambiri sizifunikira kuonetsedwa konse. Itha kukhala ndi matanthawuzo awiri "ZOONA" ndi FALSE. Poyambirira, wothandizira amagwiritsa ntchito maulalo "A1", ndiye, kalembedwe kameneka kamaphatikizidwa ndi Excel mwanjira yokhayo. Ngati phindu la mkangano silinatchulidwe, ndiye kuti lidzalingaliridwa chimodzimodzi "ZOONA". Pachiwiri, maulalo amafotokozedwa kalembedwe "R1C1". Mitundu iyi yolumikizirana iyenera kuphatikizidwa makamaka pazokonda za Excel.

Mwachidule, ndiye INDIA Ndi mtundu wolumikizana chimodzimodzi kuchokera ku khungu limodzi kupita ku linzake chikumbumtima chofanana. Mwachitsanzo, nthawi zambiri, mawu

= INDIRECT ("A1")

izikhala yofanana ndi mawuwo

= A1

Koma mosiyana ndi mawuwo "= A1" wothandizira INDIA sanakhwinyire ku selo inayake, koma zogwirizanitsa ndi chinthucho.

Ganizirani zomwe izi zikutanthauza ndi chitsanzo chosavuta. M'maselo B8 ndi B9 motero adalemba wolemba "=" kachitidwe ndi ntchito INDIA. Mawonekedwe onsewa amatanthauza chinthu. B4 ndikuwonetsa zomwe zili papepala. Mwachilengedwe, izi ndizofanana.

Onjezani chinthu china chopanda patebulopo. Monga mukuwonera, mizere yasuntha. Mu kachitidwe kugwiritsa ntchito zofanana mtengo wake umakhala wofanana, popeza umayang'ana mu foni yomaliza, ngakhale magwirizano ake asinthidwa, koma zambiri zomwe zikuwonetsedwa ndi woyendetsa INDIA asintha. Izi zikuchitika chifukwa chakuti sizikunena za pepala, koma zogwirizira. Pambuyo kuwonjezera pamzere wawo B4 ili ndi chinthu china cha pepala. Zomwe zili mkati mwake mwapangidwa tsopano ndikuwonetsera papepala lothandizira.

Wogwiritsa ntchitoyu amatha kuwonetsa mu nambala ina osati manambala okha, komanso zolemba, zotsatira za kuwerengera ma formula ndi mfundo zina zilizonse zomwe zimapezeka pazosankhidwa patsamba. Koma pochita, ntchitoyi sichigwiritsidwa ntchito palokha, ndipo nthawi zambiri imakhala mbali yofunika kwambiri pamapangidwe ovuta.

Tiyenera kudziwa kuti wothandizira amagwira ntchito yolumikizira ma worksheets ena komanso ngakhale zomwe zili m'mabuku ena a Excel, koma pamenepa ziyenera kukhazikitsidwa.

Tsopano tiyeni tiwone zitsanzo za kagwiritsidwe ntchito ka opareshoni.

Chitsanzo 1: kugwiritsa ntchito wosuta

Poyambira, lingalirani za chosavuta kwambiri momwe ntchito imagwirira ntchito INDIA amachita payekha kuti mumvetse tanthauzo la ntchito yake.

Tili ndi tebulo lokakamira. Ntchitoyi ndikuwunika mapangidwe a foni yoyamba ya gawo loyambayo mpaka gawo loyambirira la gawo lina pogwiritsa ntchito njira yomwe yaphunziridwayo.

1. Sankhani gawo loyambirira lopanda kanthu komwe tikonzekere kuyikira chilinganizo. Dinani pachizindikiro "Ikani ntchito".



2. Zenera limayamba. Ogwira Ntchito. Timasunthira ku gululi Malingaliro ndi Kufika. Kuchokera pamndandanda, sankhani mtengo wake "INDIA". Dinani batani "Zabwino".



3. Zenera laopangidwenso la opaleshoni likuyamba. M'munda Cell Link ikufunika kuwonetsa adilesi ya chinthucho papepala chomwe tiziwonetsa. Zachidziwikire, zitha kuikidwa pamanja, koma zotsatirazi ndizothandiza komanso zosavuta. Khazikitsani chotengera m'munda, kenako dinani kumanzere pazinthu zofananira papepala. Monga mukuwonera, nthawi yomweyo atero adawonetsedwa mundawo. Kenako, mbali zonse ziwiri, sankhani ulalo ndi mawu ogwidwa. Monga momwe timakumbukira, ichi ndi gawo la kugwira ntchito ndi kutsutsana kwa njira iyi.

   M'munda "A1", popeza timagwira ntchito zamagulu ogwirizanitsa, titha kuyika mtengo "ZOONA", koma mutha kungochisiyira chopanda chilichonse, chomwe tichita. Izi zikhala zochita zofanana.

   Pambuyo pake, dinani batani "Zabwino".



4. Monga mukuwonera, zomwe zili mu cholembera choyamba cha gome loyambirira zikuwonetsedwa mu pepala momwe mawonekedwe INDIA.



5. Ngati tikufuna kuyika ntchitoyi m'maselo omwe ali pansipa, ndiye kuti tikuyenera kuyika chida chilichonse pachokha. Ngati tiyesera kutengera izi pogwiritsa ntchito chikhomo kapena njira ina, ndiye kuti dzina lomwelo litawonetsedwa pazinthu zonse. Chowonadi ndi chakuti, monga momwe timakumbukira, ulalo umakhala ngati mkangano mu mawonekedwe amawu (wokutidwa ndi zolemba), zomwe zikutanthauza kuti sizingafanane.

Phunziro: Excel Feature Wizard

Chitsanzo 2: Kugwiritsa ntchito kachipangizo kogwiritsa ntchito modula

Tsopano tiyeni tiwone chitsanzo cha wogwiritsa ntchito pafupipafupi INDIApomwe ili gawo la zovuta kupanga.

Tili ndi tebulo lamalonda la pamwezi. Tiyenera kuwerengetsa kuchuluka kwa ndalama kwakanthawi, mwachitsanzo, pa Marichi - Meyi kapena Juni - Novembala. Inde, chifukwa cha ichi mutha kugwiritsa ntchito njira yosavuta yopangira, koma pankhaniyi, ngati mungafunikire kuwerengera zonse zotsatira, nthawi zonse tiyenera kusintha njira iyi. Koma mukamagwiritsa ntchito INDIA zitha kusintha gawo lofupikitsidwa pomangotchulira mwezi wolingana m'maselo osiyana. Tiyeni tiyesetse kugwiritsa ntchito njirayi poyesa kuwerengera kuchuluka kwa nthawi kuyambira pa Marichi mpaka Meyi. Izi zikugwiritsa ntchito chilinganizo chophatikiza ogwira ntchito SUM ndi INDIA.

1. Choyamba, pazinthu zomwe zili papepala timalemba mayina a miyezi yoyambira ndi kutha kwa nthawi yowerengera. Marichi ndi Meyi.



2. Tsopano perekani dzina ku maselo onse omwe ali mgululo Ndalama, zomwe zidzakhale zofanana ndi dzina la mwezi womwewo. Ndiye kuti, chinthu choyamba mzere Ndalamaomwe ali ndi kukula kwa ndalama ayenera kutchedwa Januwalechachiwiri - February etc.

   Chifukwa chake, kupatsa dzina gawo loyambirira la chipilalacho, lisankhe ndikudina batani la mbewa yoyenera. Zosankha zam'mawu zimatsegulidwa. Sankhani zomwe zili mmenemo "Patsani dzina ...".



3. Zenera lakulenga dzina limayamba. M'munda "Dzinalo" lembani dzina Januware. Palibe kusintha kwina komwe kumafunikira pazenera, ngakhale mutatero, mutha kuyang'ana kuti magawo azigwirizana pamtunda "Zosintha" zofanana ndi adilesi ya foni yomwe ili ndi ndalama za Januware. Pambuyo pake, dinani batani "Zabwino".



4. Monga mukuwonera, tsopano pamene chinthuchi chisankhidwa muzenera la mayiyo, si adilesi yake yomwe iwonetsedwa, koma dzina lomwe tidalipatsa. Timagwiranso ntchito yofanana ndi zinthu zina zonse za mzatiwu. NdalamaTchulani iwo mndandanda February, Marichi, Epulo etc. mpaka December kuphatikiza.



5. Sankhani selo yomwe nambala yonse yazomwe idasindikizidwayi ikuwonetsedwa, ndikusankha. Kenako dinani chizindikiro "Ikani ntchito". Ili kumanzere kwa baramu ya formula ndi kumanja kwa munda komwe dzina la maselo likuwonetsedwa.



6. Pazenera loyambitsa Ogwira Ntchito pitani ku gululi "Masamu". Pamenepo timasankha dzinalo SUM. Dinani batani "Zabwino".



7. Kutsatira izi ,windo la wotsutsana likuyamba SUMntchito yokhayo ndikukhazikitsa mfundo zowonetsedwa. Syntax yantchito imeneyi ndi yosavuta:

   = SUM (nambala1; nambala2; ...)

   Mwambiri, kuchuluka kwa kukangana kumatha kufika pamtengo 255. Koma mikangano yonseyi ndi yofanana. Zikuyimira chiwerengero kapena magwirizano a foni yomwe nambala imakhalamo. Atha kuthandizanso ngati pulogalamu yomangidwa yomwe imawerengera nambala yomwe mukufuna kapena kuwonetsa adilesi ya pepala lomwe ili. Muli mtundu uwu wa ntchito yomwe omangirayo azigwiritsa ntchito ndi ife INDIA pankhaniyi.

   Khazikitsani chotembezera m'munda "Nambala1". Kenako dinani chizindikirocho ngati pembetatu wobowoleza kumanja kwa gawo lamagama osiyanasiyana. Mndandanda wazomwe udagwiritsidwa ntchito posachedwa ukuwonetsedwa. Ngati pakati pawo pali dzina "INDIA", kenako dinani pomwepo kuti mupite pazenera zotsutsa za ntchitoyi. Koma zitha kuchitika kuti simupeza pamndandandandawu. Poterepa, dinani dzinalo "Zina ..." m'munsi kwambiri mndandanda.



8. Zenera lodziwika bwino limayamba. Ogwira Ntchito. Timasunthira ku gawo Malingaliro ndi Kufika ndikusankha dzina la wothandizira pamenepo INDIA. Pambuyo pa izi, dinani batani "Zabwino" pansi pazenera.



9. Woyendetsa Window Window Woyambitsa INDIA. M'munda Cell Link sonyezani adilesi ya pepala lomwe lili ndi dzina la mwezi woyambira mtunduwo. Chonde dziwani kuti pokhapokha pakufunika kuti musayankhe malangizowo, popeza pamalopo sipofunika kukhala adilesi, koma zomwe zili, zomwe zili kale ndi mawonekedwe (mawu Marichi) Mundawo "A1" siyani yopanda kanthu, chifukwa timagwiritsa ntchito mtundu wanthawi zonse wogwirizanitsa mayina.

   Adilesi ikawonetsedwa m'munda, musathamangire kukanikiza batani "Zabwino", popeza iyi ndi ntchito yokhazikika, ndipo zomwe amachita nayo ndizosiyana ndi algorithm wamba. Dinani pa dzinalo SUM bala.



10. Pambuyo pake, tibwereranso pazenera la mkangano SUM. Monga mukuwonera, m'munda "Nambala1" wogulitsa wawonetsedwa kale INDIA ndi zomwe zilimo. Timayika cholozera m'munda womwewo titangolemba munthu wotsiriza kujambula. Ikani chikwangwani (:) Chizindikirochi chimatanthawuza chizindikiro cha adilesi yamagulu angapo amaselo. Kupitilira apo, osachotsa chidziwitso kumunda, onaninso chizindikiro chamtundu wamakona atatu kuti musankhe ntchito. Pano pa mndandanda wa ogwiritsa ntchito omwe agwiritsidwa ntchito posachedwapa "INDIA" iyenera kukhalapo, popeza tidagwiritsa ntchito posachedwa. Timadina dzinalo.



11. Windo la otsutsana likutsegulanso INDIA. Timayika m'munda Cell Link adilesi ya chinthucho papepala pomwe pali dzina la mwezi womwe umamaliza nthawi yolipiritsa. Apanso, ma mgwirizano amayenera kuyikidwa popanda mawu olemba. Mundawo "A1" Siyani opanda kanthu. Pambuyo pake, dinani batani "Zabwino".



12. Monga mukuwonera, atatha kuchita izi, pulogalamuyo imawerengera ndikuwonetsa zotsatira zowonjezera ndalama zomwe kampaniyo ili nayo panthawi yomwe idanenedwe (Marichi - Meyi) pachinthu chomwe chidasankhidwa kale momwe machitidwewo amapezekera.



13. Ngati tisintha mu maselo pomwe mayina amiyezi yakuyambira ndi kutha kwa nyengo yolipira adayikidwira, kwa ena, mwachitsanzo, ku Juni ndi Novembala, ndiye kuti zotsatira zake zidzasintha. Kuchuluka kwa ndalama za nthawi yomwe ikunenedwayi kudzawonjezedwa.

Phunziro: Momwe mungawerengere kuchuluka kwa Excel

Monga mukuwonera, ngakhale kuti ntchitoyo INDIA sitha kutchedwa imodzi mwodziwika kwambiri pakati pa ogwiritsa ntchito, komabe, zimathandiza kuthana ndi zovuta za zovuta ku Excel ndizosavuta kuposa momwe zingapangidwire pogwiritsa ntchito zida zina. Chachikulu kwambiri, opaleshoni iyi imakhala yothandiza pazinthu zovuta momwe zimagwiranso ntchito. Komabe, ziyenera kudziwidwa kuti mphamvu zonse za wothandizira INDIA kovuta kumvetsetsa. Izi zimangofotokozera kutchuka kotsika kwa ntchito yofunikayi pakati pa ogwiritsa ntchito.