Ntchito zinayi

Chimodzi mwazinthu zomwe zimaphatikizidwa ndi pulogalamu ya Excel Purceps ndikuchepa. Ntchito yake ndikubwerera ku tsamba la tsamba, komwe limapezeka, maselo a selo omwe ulalo womwe ulumikizidwe umafotokozedwa kuti ndi mtundu wa mkangano.

Zikuwoneka kuti palibe china chapadera chokhudza izi, chifukwa ndizotheka kuwonetsa zomwe zili mu khungu limodzi mwanjira inanso m'njira zina. Koma, monga momwe zimakhalira, zovuta zina zomwe zimapangitsa kuti zikhale zapadera zomwe zimagwirizanitsidwa ndi kugwiritsa ntchito wothandizira uyu. Nthawi zina, njirayi imatha kuthana ndi ntchito zotere zomwe mungachepetse kapena zingakhale zovuta kwambiri. Tiyeni tiphunzire zambiri, zomwe zikuyimira ntchito yapamwamba komanso momwe zingagwiritsidwire ntchito.

Kugwiritsa ntchito formula dvsl

Dzinalo lomwe wothandizira uyu DVSL limakhala ngati "ulalo wachiwiri". Kwenikweni, izi zikuwonetsa cholinga chake - kuwonetsa deta kudzera mu gawo lotchulidwa kuchokera ku khungu limodzi kupita lina. Komanso, mosiyana ndi ntchito zina zambiri zomwe zikugwira ntchito, ziyenera kufotokozedwa m'malemba, omwe ndi, owonetsedwa mbali zonse ziwiri ndi mawu.

Ogwiritsa ntchitowa amatanthauza gulu la "maulalo ndi arrays" ntchito ndipo ali ndi syntax:

= Dwarf (lolumikizira_chimodzi; [A1])

Chifukwa chake, mawonekedwe ali ndi mikangano iwiri yokha.

Kukangana "kulumikizana kwa cell" kumawonetsedwa ngati cholumikizira kwa tsamba, zomwe zili zomwe mukufuna kuwonetsa. Pankhaniyi, ulalo wotchulidwa uyenera kukhala ndi mawonekedwe, ndiye kuti "wokutidwa" ndi mawu.

Mfundo "A1" sikofunikira ndipo mwankhanza kwambiri siziyenera kuwonetsedwa konse. Itha kukhala ndi mfundo ziwiri za "chowonadi" ndi "bodza". Poyamba, wothandizirayo amafotokoza zolumikizana ndi "A1", mawonekedwe awa amathandizidwanso mosavomerezeka. Ngati mtengo wa mkanganowu sukunena zonse, zimaganiziridwa ndendende monga "chowonadi". Mlandu wachiwiri, zotchulidwa zimatsimikiziridwa mu kalembedwe ka R1C1. Mtundu uwu uyenera kuphatikizidwa mwachindunji m'magulu a Exel.

Ngati mukunena kuti, kung'ung'udza ndi mtundu wofanana ndi zingwe za selo imodzi kupita ku chikwangwani "chofanana." Mwachitsanzo, nthawi zambiri mawu

= Zokongola ("A1")

idzakhala yofanana ndi mawu

= A1.

Koma mosiyana ndi mawu akuti "= A1"

Onani tanthauzo la chitsanzo chosavuta kwambiri. Mu cell a B8 ndi B9, motsatana, adayikidwa kudzera mu "=" njira ndi ntchito ya zowala. Makhalidwe onsewa amatanthauza chinthu cha B4 ndikutulutsa zomwe zili patsamba. Mwachilengedwe izi ndizofanana.

Onjezani chinthu china chopanda kanthu patebulo. Monga mukuwonera, mizere inkasuntha. Mu njira yogwiritsa ntchito "yofanana", mtengo wake umakhala womwewo, monganso amatchulira cell yomaliza, ngakhale makatoni ake asintha, koma zambiri kuchokera kwa wothandizirayo wasintha. Izi ndichifukwa choti simangotanthauza kuti tsamba siliment, koma pamagwiritsidwe. Pambuyo kuwonjezera chingwe, adilesi ya B4 ili ndi cholembera china. Zolemba zake tsopano ndi fomula ndikuwonetsa papepala.

Wogwiritsa ntchito uyu sangathe kungowonetsa nambala yokhayo, komanso lembalo, zotsatira za kuwerengera njira ndi zina zilizonse zomwe zili mu thumba losankhidwa. Koma muzochita, ntchitoyi simagwiritsidwa ntchito modziyimira pawokha, ndipo nthawi zambiri ndi gawo lofunikira pazinthu zovuta.

Tiyenera kudziwa kuti wothandizirayo amagwiritsidwa ntchito polemba ma sheet ena ngakhale m'mabuku ena a Excel, koma pankhaniyi ayenera kukhazikitsidwa.

Tsopano tiyeni tikambirane zitsanzo za zitsanzo za kugwiritsa ntchito kwa wothandizirayo.

Chitsanzo 1: Kugwiritsa ntchito kamodzi kwa wothandizira

Poyamba, lingalirani za chitsanzo chosavuta kwambiri momwe kagwiritsi ntchito ka filemapp imapangidwira pawokha kuti mumvetsetse tanthauzo la ntchito yake.

Tili ndi tebulo lotsutsana. Pali ntchito yowonetsera deta yoyamba ya chipinda choyamba mu chinthu choyamba cha mtundu wa munthu wogwiritsa ntchito njira yophunzirira.

1. Tikuwonetsa chinthu choyambirira cha mzatiyo, komwe tikukonzekera kuyika formula. Dinani pa "Inter Apple".



2. Zenera la Wizard limayamba kuthamanga. Timasunthira ku gulu la "maulalo ndi aris". Kuchokera pamndandanda, sankhani mtengo "DVSS". Dinani pa batani la "OK".



3. Zenera lotsutsa la wopatsirana lidayambitsidwa. Mu "cholumikizira ku gawo la" gawo la "Munda, muyenera kutchula adilesi ya chinthucho papepala, zomwe tidzaonetsa. Zachidziwikire, zitha kukhazikitsidwa pamanja, koma zothandiza kwambiri ndipo zimakhala zosavuta kuchita izi. Ikani chotembere m'munda, kenako dinani batani lakumanzere pa chivundikiro choyenera papepala. Monga mukuwonera, zitachitika izi, adilesi yake idawonekera m'munda. Kenako timagawa ulalo ndi zolemba kuchokera kumbali zonse ziwiri. Pamene tikukumbukira, iyi ndi gawo logwira ntchito ndi mkangano wa fomulawu.

   Mu "gawo la", popeza timagwira ntchito mwachizolowezi chogwirizanitsa, mutha kuyika mtengo wa "chowonadi", ndipo mutha kuzisiya konse chopanda kanthu chomwe tichite. Izi zikhala zofanana.

   Pambuyo pake, dinani batani la "OK".



4. Monga tikuwona, tsopano zomwe zili mu chipinda choyamba chagome choyambirira chatebulo chikuwonetsedwa mu gawo lomwe foloko ili.



5. Ngati tikufuna kutsatira izi m'maselo, omwe ali pansipa, ndiye kuti mufunika kuperekedwa kwa njira iliyonse yapadera. Ngati tiyesera kuti tipewe kugwiritsa ntchito cholembera kapena njira ina yokopera, dzina lomweli liwonetsedwa m'mbali zonse za mzati. Chowonadi ndi chakuti, pamene tikukumbukira, matchulidwewo amachita ngati mkangano m'mawu (wokutidwa ndi mawu), zomwe zikutanthauza kuti sizingakhale zachibale.

Phunziro: Mzere wa Wizard mu pulogalamu yapamwamba

Chitsanzo 2: Kugwiritsa ntchito wothandizira munjira yonse

Ndipo tsopano tiyeni tiwone chitsanzo cha kugwiritsa ntchito mankhwalawa pafupipafupi, pomwe ndi gawo lofunikira la njira yovuta.

Tili ndi ndalama za pamwezi. Tiyenera kuwerengera kuchuluka kwa ndalama kwa nthawi yayitali, kwa mart - Meyi kapena June - Novembala. Zachidziwikire, chifukwa ichi, ndizotheka kugwiritsa ntchito njira yosavuta kuitana, koma pankhaniyi, ngati kuli kotheka, kuwerengera Generals Product nthawi iliyonse, tiyenera kusintha njira iyi nthawi zonse. Koma mukamagwiritsa ntchito ntchitoyo, kuwoneka kowoneka bwino kumatha kusinthidwa ndi mawonekedwe obisika, kungotchula mwezi womwewo m'maselo amodzi. Tiyeni tiyesetse kugwiritsa ntchito njirayi poyamba kuwerengera ndalamazo kwa nthawi kuyambira Meyi mpaka Meyi. Izi zikugwiritsa ntchito njirayi yophatikiza ogwiritsa ntchito boma ndi dontho.

1. Choyamba, pazinthu payekha payekha papepala la miyezi ya chiyambi ndi kumapeto kwa nthawi, komwe kuwerengera kumawerengeredwa, motsatana, "March" ndi "Meyi".



2. Tsopano timapereka dzina kwa maselo onse mu gawo la "ndalama", zomwe zidzakhale zofanana ndi mweziwo. Ndiye kuti, chinthu choyamba mu "Chuma", chomwe chili ndi kukula kwa ndalamazo, kuyenera kutchedwa "Januware", wachiwiri - "February", ndi zina zambiri.

   Chifukwa chake, kupatsa dzina loti gawo loyamba la mzatiyo, sankhani ndikusindikiza batani lamanja mbewa. Mndandanda wa nkhaniyo umatseguka. Sankhani chinthucho "Patsani dzina ...".



3. NJIRA YA DZINA LAPANSI LADZIKO LAPANSI. Mu "Dzinalo" limagwirizana ndi dzina "Januware". Palibenso kusinthanso pazenera sikuyenera kuchitidwa, ngakhale mutangoyang'ana kuti ogwirizanitsa mu adilesi ya foni ali ndi kukula kwa ndalama mu Januware. Pambuyo pake, dinani batani la "OK".



4. Monga mukuwonera, tsopano, mukamagawa izi pazenera la dzina, siliwonetsedwa ndi adilesi yake, kenako yomwe tidampatsa. Ogwira ntchito ngati omwewo amachitidwa ndi zigawo zina zonse za "ndalama", kuwapatsa ulemu mosamala "february", "Epulo", "Epulo", ext. mpaka Disembala wophatikizidwa.



5. Sankhani khungu lomwe kuchuluka kwa zomwe zatchulidwazi ziwonekere ndikugawa. Kenako dinani pa "Intern Apple". Imayikidwa kumanzere kwa mzere wa njira ndi kumanja kwa munda pomwe dzina la maselo limawonetsedwa.



6. Pazenera loyambitsidwa, ambuye a ntchito amapita ku gulu la "masamu". Panasankhe dzina "Sum". Dinani pa batani la "OK".



7. Pambuyo pa kuphedwa kumeneku, zenera lotsutsana lapadera limayambitsidwa, ntchito yokhayo yomwe ili kuikizira mfundo zake. Syntax ya ntchitoyi ndi yosavuta:

   = Sum (nambala1; nambala2; ...)

   Mwambiri, kuchuluka kwa mikangano kumatha kukwaniritsa zomwe 255. Koma mikati yonseyi ndi yopanda ulemu. Ndiwo nambala kapena mgwirizano wa khungu pomwe nambala iyi yapezeka. Amatha kuchitanso mtundu wa njira yolumikizidwa yomwe imawerengetsa nambala yomwe mukufuna kapena ikuwonetsa adilesi ya tsamba pomwe imayikidwa. Muli mu ntchito iyi yolumikizidwa ndi opaleshoni yathu idzagwiritsidwa ntchito pamenepa.

   Ikani cholozera mu "nambala ya" nambala1 ". Kenako dinani chithunzicho mu mawonekedwe a makona atatu olowera kumanja kwa mitsinje. Mndandanda wa ntchito zaposachedwa zomwe zagwiritsidwa ntchito ndizowululidwa. Ngati pali dzina la "Dvsl" pakati pawo, kenako dinani kuti mupite pawindo la ntchitoyi. Koma zitha kukhala kuti mndandandandawu simudzazipeza. Pankhaniyi, muyenera kudina dzinalo "ntchito zina ..." Pansi pa mndandanda.



8. Adayamba kale kukhala bwino pawindo la Wizy. Timasunthira ku gawo la "maulalo ndi arrays" ndikusankha dzina la DVSL. Pambuyo pake, mumadina batani la "OK" pansi pazenera.



9. Zenera la zotsutsana za wothandizirayo za wogwiritsa ntchito zimayambitsidwa. Mu "cholumikizira ku gawo la Cell", fotokozerani adilesi ya tsamba la tsamba, lomwe lili ndi dzina la mwezi woyamba wa produmulation kuti iwerengere. Chonde dziwani kuti pankhaniyi simufunikira kulumikizana m'mawu, popeza pankhaniyi sipadzakhala mgwirizano wa cell, koma zomwe zilipo, zomwe zili kale ndi mawu (mawu oti "March"). Gawo la "A1" lasiyidwa lopanda kanthu, popeza timagwiritsa ntchito mtundu wogwirizana.

   Adilesi atawonetsedwa m'munda, musathamangire batani la "Ok", chifukwa uku ndikugwira ntchito yoyesedwa, ndipo zochita zake zimakhala ndi chizolowezi chosiyana ndi algorithm. Dinani pa dzina "Sums" mu mzere wa mapangidwe.



10. Pambuyo pake, timabwereranso kukangana za SAMS. Monga mukuwonera, "nambala ya" nambala1 "yasowa kale ogulitsa atapindika ndi zomwe zili mkati mwake. Ikani chotemberedwe mu gawo lomwelo mutatha chizindikiro chomaliza mu mbiri. Ikani chizindikiro cha kolo (:). Chizindikiro ichi chimatanthawuza chizindikiro cha adilesi ya cell. Kenako, osachotsa chotemberero m'munda, dinani kachiwiri pacon ngati makona atatu osankha ntchito. Nthawi ino mndandanda wa ogwiritsira ntchito posachedwapa, dzina "DVSS" liyenera kuonedwa ngati lolondola, monga momwe tagwiritsira ntchito izi. Dinani dzina.



11. Zotsutsana za zotsutsana za wothandizira wa wothandizirayo amatsegulanso. Timalowa "ulalo wa foni" adilesi yazomwe zachokera papepala pomwe dzina la mwezi limapezeka, lomwe limaliza nthawi yoyerekeza. Apanso magwiridwe ake ayenera kulembedwa popanda mawu. Munda "A1" Siyaninso kanthu. Pambuyo pake, dinani batani la "OK".



12. Monga mukuwonera, zitatha izi, pulogalamuyi imapanga kuwerengera ndipo imapereka zotsatira za zomwe zimachitika nthawi yodziwika (March - Meyi) kulowa m'gululo lomwe form yomwe yapangayo imapezeka .



13. Ngati tisintha m'maselo, pomwe mayina a zoyambira ndi kumapeto kwa nthawi yotsalayo adalembedwa, chifukwa ena, pa Juni ndi Novembala, ndipo zotsatira zake zingasinthe moyenera. Kuchuluka kwa ndalama kwa nthawi yomwe yasinthidwa kudzakulungidwa.

Phunziro: Momwe mungawerengere ndalamazo

Monga tikuonera, ngakhale kuti ntchito za FVS sizingatchedwa imodzi mwa ogwiritsa ntchito otchuka, komabe, imathandizira kuthetsa ntchito zamavuto osiyanasiyana mosavuta kuposa momwe zingachitike. Zambiri mwa zosewerera izi ndizothandiza monga gawo la njira zovuta momwe ndi gawo lofunikira m'mawu. Komabe ziyenera kudziwidwa kuti kuthekera konse kwa doko wogwiritsa ntchito kumakhala kofunikira kwambiri kuti amvetsetse. Izi ndikungofotokozera kutchuka kotsika kwambiri kwa ntchito yothandizayi kuchokera kwa ogwiritsa ntchito.