Mukamagwira ntchito mu Excel, nthawi zina ogwiritsa ntchito amakumana ndi ntchito yosankha kuchokera pa mndandanda wa chinthu china ndikupereka mtengo wotsimikiziridwa motsatira ndondomeko yake. Ntchitoyi imayendetsedwa bwino ndi ntchito yomwe imatchedwa "ONSE". Tiyeni tiphunzire mwatsatanetsatane momwe tingagwirire ntchito ndi wogwiritsira ntchito, ndipo ndi mavuto ati omwe angagwire.
Gwiritsani ntchito SELECT
Ntchito KUSANKHA ndi wa gulu la opaleshoni "Zolumikizana ndi zolemba". Cholinga chake ndicho kupeza phindu lenileni mu selo losankhidwa, lomwe likugwirizana ndi nambala ya ndondomeko mu chinthu china pa pepala. Chidule cha mawu awa ndi awa:
= SELECT (index_number; value1; value2; ...)
Kutsutsana "Nambala ya ndondomeko" lili ndi tanthauzo la selo kumene chiwerengero cha ordinal cha chinthucho chiri, komwe gulu lotsatira la opaleshoni limapatsidwa mtengo wapadera. Chiwerengero ichi chikhoza kusiyana 1 mpaka 254. Ngati mumatchula ndondomeko yaikulu kuposa nambalayi, woyendetsa ntchito akuwonetsa zolakwika mu selo. Ngati mtengo wamtengo wapatali umalowa ngati mkangano woperekedwa, ntchitoyo idzazindikira kuti ndi mtengo wapafupi kwambiri womwe uli pafupi kwambiri ndi nambala iyi. Ngati atayikidwa "Nambala ya ndondomeko"zomwe palibe zotsutsana zotsutsana "Phindu", wogwira ntchitoyo adzabwezera cholakwika ku selo.
Gulu lotsatira la mikangano "Phindu". Iye akhoza kufika kuchuluka 254 zinthu. Kutsutsana kumafunika. Chofunika1 ". Mu gulu lino lazitsutsano, tchulani mfundo zomwe zidzakhale zofanana ndi nambala ya ndondomeko ya mkangano wakale. Ndiko, ngati ngati mkangano "Nambala ya ndondomeko" nambala yokondera "3", ndiye zidzafanana ndi mtengo umene unalowa ngati mkangano "Value3".
Miyezo ingakhale mitundu yosiyanasiyana ya deta:
- Zotsatira;
- Numeri;
- Malemba;
- Mafomu;
- Ntchito, ndi zina zotero.
Tsopano tiyeni tiwone zitsanzo zenizeni za kugwiritsidwa ntchito kwa woyendetsa.
Chitsanzo 1: dongosolo lokhazikika la zinthu
Tiyeni tiwone momwe ntchitoyi ikugwirira ntchito pachitsanzo chosavuta. Tili ndi tebulo yowerengera 1 mpaka 12. Ndikofunikira malinga ndi nambala zachinsinsi pogwiritsa ntchito ntchitoyi KUSANKHA onetsani dzina la mwezi womwewo molingana ndi gawo lachiwiri la tebulo.
- Sankhani selo yoyamba yopanda kanthu. "Dzina la mwezi". Dinani pazithunzi "Ikani ntchito" pafupi ndi bar yokupangira.
- Yambani Oyang'anira ntchito. Pitani ku gawo "Zolumikizana ndi zolemba". Timasankha kuchokera pandandanda dzina "ONSE" ndipo dinani pa batani "Chabwino".
- Fesito yotsutsana ndi otsogolera imayambira. KUSANKHA. Kumunda "Nambala ya ndondomeko" Adilesi ya selo yoyamba m'mwezi wowerengera mtundu iyenera kusonyezedwa. Ndondomekoyi ingatheke mwa kulowetsa mwadongosolo makonzedwe. Koma tidzachita zambiri mosavuta. Ikani malonda mmunda ndipo dinani batani lamanzere pamtundu woyenera pa pepala. Monga mukuonera, makonzedwewo amawonetsedweratu m'munda wa zenera.
Pambuyo pake, tidzatha kuyendetsa galimoto kupita ku gulu la minda "Phindu" dzina la miyezi. Komanso, munda uliwonse uyenera kukhala wofanana ndi mwezi wosiyana, ndiko, kumunda Chofunika1 " lembani "January"kumunda "Value2" - "February" ndi zina zotero
Mukamaliza ntchitoyi, dinani pa batani. "Chabwino" pansi pazenera.
- Monga momwe mukuonera, nthawi yomweyo mu selo yomwe tadzindikira muchithunzi choyambirira, zotsatira zake zinawonetsedwa, dzina lake "January"zofanana ndi chiwerengero choyamba cha mwezi wa chaka.
- Tsopano, musati mulowetse mwapangidwe mawonekedwe a maselo onse otsalirawo "Dzina la mwezi", tiyenera kufotokoza. Kuti muchite izi, sungani chithunzithunzi m'ngodya ya kumunsi ya selo yomwe ili ndi ndondomekoyi. Chizindikiro chodzaza chikuwonekera. Gwiritsani batani lakumbuyo la mouse ndipo yesani kugwiritsira ntchito mpaka kumapeto kwa chigawocho.
- Monga mukuonera, ndondomekoyi inakopedwa kuyeso lofunidwa. Pachifukwa ichi, mayina onse a miyezi yomwe imawonekera m'maselo akugwirizana ndi nambala yawo ya ordinal kuyambira kumtundu kupita kumanzere.
Phunziro: Excel ntchito wizara
Chitsanzo chachiwiri: dongosolo lokhazikika la zinthu
M'nkhani yapitayo, tinagwiritsa ntchito njirayi KUSANKHApamene nambala zonse za ndondomeko zakonzedweratu. Koma kodi mawuwa amagwira ntchito bwanji ngati miyezo yeniyeni imasakanizidwa ndi kubwerezedwa? Tiyeni tiwone izi pa chitsanzo cha tebulo ndi ntchito ya ana a sukulu. Chigawo choyamba cha tebulo chikuwonetsa dzina lomaliza la wophunzira, yesiti yachiwiri (kuyambira 1 mpaka 5 mfundo), ndipo lachitatu tiyenera kugwiritsa ntchito ntchitoyi KUSANKHA perekani izi mchitidwe woyenera ("zoipa kwambiri", "zoipa", "zokondweretsa", "zabwino", "zabwino").
- Sankhani selo yoyamba m'mbali. "Kufotokozera" ndipo pitani ndi chithandizo cha njirayo, yomwe idakambidwa kale pamwamba, muzenera la zotsutsana KUSANKHA.
Kumunda "Nambala ya ndondomeko" tchulani chiyanjano ku selo yoyamba ya chigawocho "Kufufuza"zomwe zili ndi mapepala.
Munda wa gulu "Phindu" tchulani njira zotsatirazi:
- Chofunika1 " - "Zoipa Kwambiri";
- "Value2" - "Zoipa";
- "Value3" - "Zosakwanira";
- "Value4" - "Zabwino";
- "Value5" - "Ndibwino".
Pambuyo poyambanso deta ili pamwambayi, dinani pa batani "Chabwino".
- Zotsatira za chinthu choyamba chikuwonetsedwa mu selo.
- Kuti tichite ndondomeko yofanana ndi zigawo zina zotsalazo, timakopera deta m'maselo ake pogwiritsa ntchito chidutswa chodzaza, monga chinachitidwira Njira 1. Monga mukuonera, nthawi ino ntchitoyi inagwira ntchito molondola ndi kutulutsa zotsatira zonse malinga ndi ndondomekoyi.
Chitsanzo chachitatu: Gwiritsani ntchito pamodzi ndi ogwira ntchito ena
Koma opanga opindulitsa kwambiri KUSANKHA Angagwiritsidwe ntchito pamodzi ndi ntchito zina. Tiyeni tiwone momwe izi zikuchitidwira ndi chitsanzo cha kugwiritsa ntchito ogwira ntchito KUSANKHA ndi SUM.
Pali tebulo la malonda a malonda ndi malo ogulitsa. Igawidwa muzitsulo zinayi, zomwe zimagwirizana ndi malo enaake. Zotsatira zimasonyezedwa payekha pazitsulo yeniyeni ndi mzere. Ntchito yathu ndikutsimikiza kuti mutatha kulowa chiwerengero cha chikwama mu selo lina la pepala, ndalama zomwe zimagwiritsidwa ntchito masiku onse ogulitsika zikuwonetsedwa. Pachifukwachi tidzagwiritsira ntchito ophatikiza SUM ndi KUSANKHA.
- Sankhani selo limene zotsatira zake zidzawonetsedwa ngati ndalama. Pambuyo pake, dinani pazithunzi zomwe tidziwa kale. "Ikani ntchito".
- Yatsegula zenera Oyang'anira ntchito. Nthawi ino timasunthira ku gululo "Masamu". Pezani ndi kusankha dzina "SUMM". Pambuyo pake dinani pa batani "Chabwino".
- Ntchitoyi zenera zowonekera. SUM. Wogwiritsa ntchitoyi amagwiritsidwa ntchito kuti awerengere manambala omwe ali m'maselo a pepala. Mawu ake omasuliridwawo ndi ophweka kwambiri komanso omveka bwino:
= SUM (nambala1; nambala2; ...)Izi zikutanthauza kuti zifukwa za woyendetsa katunduyo nthawi zambiri zimakhala ziwerengero, kapena, nthawi zambiri, zokhudzana ndi maselo kumene chiwerengerocho chiyenera kufotokozedwa. Koma kwa ife, kukangana kokha sikudzakhala nambala kapena chiyanjano, koma zomwe zili m'ntchitoyi KUSANKHA.
Ikani cholozera mmunda "Number1". Kenaka dinani pa chithunzi, chomwe chikuwonetsedwera ngati triangle yosokonezedwa. Chithunzichi chili mu mzere wofanana ndi batani. "Ikani ntchito" ndi bar yokupangira, koma kumanzere kwa iwo. Mndandanda wa ntchito zomwe wagwiritsidwa ntchito posachedwa zimatsegulidwa. Kuchokera muyeso KUSANKHA Posachedwapa tagwiritsidwa ntchito ndi ife mu njira yapitayi, ili pandandanda uwu. Kotero, ndikwanira kuti dinani pa dzina ili kupita ku zenera. Koma nkutheka kuti simungakhale ndi dzina ili mndandanda. Pankhaniyi, muyenera kutsegula pa malo "Zina ...".
- Yambani Oyang'anira ntchitomu gawo lomwe "Zolumikizana ndi zolemba" tiyenera kupeza dzina "ONSE" ndi kuzikweza. Dinani pa batani "Chabwino".
- Wowonjezera zotsutsana zenera yatsegulidwa. KUSANKHA. Kumunda "Nambala ya ndondomeko" tchulani chiyanjano ku selo la pepala, momwe tidzalowetsamo chiwerengero cha chiwonetsero cha kuwonetsera kwa chiwerengero cha ndalama.
Kumunda Chofunika1 " akufunika kulowa muzolumikizana za ndimeyi "Malo ogulitsa". Pangani izo mosavuta. Ikani cholozera mmalo mwachindunji. Ndiye, mutagwiritsa ntchito batani lamanzere, sankani selo lonse lachonde "Malo ogulitsa". Adilesi imasonyezedwa nthawi yomweyo muzenera zotsutsana.
Mofananamo m'munda "Value2" onjezerani zigawo zolembapo "Malo awiri"kumunda "Value3" - "Malonda atatu"ndi kumunda "Value4" - "Malonda 4".
Mutatha kuchita izi, dinani pa batani "Chabwino".
- Koma, monga momwe tikuonera, ndondomekoyi ikuwonetsa mtengo wolakwika. Izi ndizo chifukwa chakuti sitinalowere chiwerengero cha malowa mu selo yoyenera.
- Lowetsani chiwerengero cha malowa mu selo yosankhidwa. Chiwerengero cha ndalama zowonjezerapo chigawocho chidzawonekera nthawi yomweyo muzitsulo zomwe zimapangidwira.
Ndikofunika kuzindikira kuti mungathe kulemba manambala kuyambira 1 mpaka 4, omwe angagwirizane ndi chiwerengerocho. Ngati mulowa nambala ina iliyonse, ndondomekoyi imaperekanso vuto.
Phunziro: Momwe mungawerengere ndalama mu Excel
Monga mukuonera, ntchitoyi KUSANKHA mukamagwiritsa ntchito bwino, ikhoza kukhala mthandizi wabwino kwambiri pa ntchitoyi. Pogwiritsidwa ntchito pamodzi ndi ogwira ntchito ena, mwayiwu ukuwonjezeka kwambiri.
