Zina mwa zizindikiro zambiri zomwe zimagwiritsidwa ntchito pa ziwerengero, muyenera kusankha mawerengedwe a kusiyana. Tiyenera kukumbukira kuti kuchita mwakuchita izi ndi ntchito yovuta. Mwamwayi, Excel imagwira ntchito kuti ikhale yowerengera. Pezani ndondomeko yogwiritsira ntchito ndi zipangizozi.
Kusiyanasiyana kuyerekezera
Kugawanitsidwa ndi kusiyana kwakukulu, komwe kumakhala maola ambiri a zopotoka kuchokera ku kuyembekezera. Choncho, limasonyeza kusiyana kwa chiwerengero chofanana ndi zomwe zimatanthauza. Chiwerengero cha kusiyana kwake chikhoza kuchitidwa kwa anthu ambiri, ndi chitsanzo.
Njira 1: Kuwerengetsera chiwerengero cha anthu
Kuwerengera kwa chizindikiro ichi ku Excel kwa anthu onse, ntchitoyi imagwiritsidwa ntchito DISP.G. Chidule cha mawu awa ndi awa:
= FUNSO G (Nambala 1; Nambala 2; ...)
Zonse zokwana 1 mpaka 255 zingagwiritsidwe ntchito. Zokambirana zikhoza kukhala zamtengo wapatali kapena mafotokozedwe a maselo omwe ali nawo.
Tiyeni tiwone momwe tingawerengere phindu ili pazomwe zili ndi deta.
- Sankhani selo pa pepala, momwe zotsatira za chiwerengero cha kusiyana zidzasonyezedwe. Dinani pa batani "Ikani ntchito"anaikidwa kumanzere kwa bar.
- Iyamba Mlaliki Wachipangizo. M'gululi "Zotsatira" kapena "Mndandanda wathunthu wa alfabeti" yambani kufufuza ndi dzina "DISP.G". Mukapezeka, sankhani ndipo dinani pa batani "Chabwino".
- Kuchita zowonjezera zokhudzana ndi ntchito DISP.G. Ikani cholozera mmunda "Number1". Sankhani maselo osiyanasiyana pa pepala, omwe ali ndi mndandanda wa nambala. Ngati pali mitundu yosiyanasiyanayi, ingagwiritsidwe ntchito polowera makonzedwe awo muwindo lamatsutso "Number2", "Number3" ndi zina zotero Deta yonse italowa, dinani pa batani "Chabwino".
- Monga mukuonera, zitatha izi, mawerengedwe amapangidwa. Chotsatira cha kuwerengera kusiyana kwa chiŵerengero cha anthu chikuwonetsedwa mu selo yoyambirira. Ichi ndi chimodzimodzi selo momwe chikhalidwecho chili DISP.G.
Phunziro: Excel ntchito wizara
Njira 2: chiwerengero cha chitsanzo
Mosiyana ndi chiwerengero cha mtengo wa anthu ambiri, mu chiwerengero cha zitsanzo, chipembedzo sichisonyeza chiwerengero cha nambala, koma osachepera. Izi zachitika kuti athetse vutolo. Excel imaganiziranso chiganizo ichi mu ntchito yapadera yomwe yapangidwa kuti izi ziwerengedwe - DISP.V. Msonkhano wake umayimilidwa ndi ndondomeko zotsatirazi:
= DISP.V (Number1; Number2; ...)
Chiwerengero cha zotsutsana, monga mu ntchito yapitayi, chingakhalenso zosiyana kuyambira 1 mpaka 255.
- Sankhani selo komanso mofanana ndi nthawi yoyamba, yendani Mlaliki Wachipangizo.
- M'gululi "Mndandanda wathunthu wa alfabeti" kapena "Zotsatira" fufuzani dzina "DISP.V". Pambuyo potsatira njirayi, yikani iyo ndipo dinani pa batani "Chabwino".
- Ntchito yowonekera zowonjezera. Kenaka, timayendanso chimodzimodzi monga momwe timagwiritsira ntchito mawu apitalo: ikani cholozera pamsasa wokambirana "Number1" ndipo sankhani malo omwe ali ndi mndandanda wa nambala pa pepala. Kenaka dinani pa batani. "Chabwino".
- Zotsatira za mawerengedwe zidzawonetsedwa mu selo losiyana.
Phunziro: Zowerengera zina zimagwira ntchito ku Excel
Monga mukuonera, pulogalamu ya Excel ingathandize kwambiri kuwerengera kusiyana. Chiwerengerochi chikhoza kuwerengedwa ndi kugwiritsa ntchito, kwa anthu onse komanso zitsanzo. Pachifukwa ichi, ntchito zonse zomwe amagwiritsa ntchito zimachepetsedwa pokhapokha kuti ziwonetsere kuchuluka kwa manambala osinthidwa, ndipo Excel imachita ntchito yaikulu. Inde, izi zidzasunga nthawi yambiri yogwiritsira ntchito.
