Pakati pazisonyezo zambiri zomwe zimagwiritsidwa ntchito mu mawerengero, ndikofunikira kuwunikira kuwerengera kwa kusiyana. Dziwani kuti kuchita kuwerengera uku ndi ntchito yovuta. Mwamwayi, Excel ili ndi mawonekedwe osinthira kuwerengera. Pezani algorithm yogwira ntchito ndi zida izi.
Kuwerengera kwamitundu
Kubalalitsika ndi kusiyanasiyana, komwe ndi gawo lalikulu la kupatuka kuchoka pachiyembekezo cha masamu. Chifukwa chake, chikuwonetsa kufalikira kwa ziwerengero molingana ndi mtengo wapakati. Kuwerengera kwa kusiyanasiyana kukhoza kuchitika ndi anthu onse komanso mwachitsanzo.
Njira 1: kuwerengera kwa anthu wamba
Kuwerengera chizindikiro ichi ku Excel pamtundu wa anthu, ntchitoyo DISP.G. Kapangidwe ka mawuwa ndi motere:
= DisP.G (Nambala1; Nambala2; ...)
Pazonse, mfundo 1 mpaka 255 zingagwiritsidwe ntchito. Zowunikirazi zitha kukhala zowerengetsera kapena zowerengera ku maselo momwe zilimo.
Tiyeni tiwone momwe angaerengere mtengo wamlingo womwe uli ndi data manambala.
- Timasankha khungu pa pepalalo momwe zotsatira za kuwerengera kuwonekera. Dinani batani "Ikani ntchito"atayikidwa kumanzere kwa barula yamu formula.
- Iyamba Fotokozerani Wizard. Gulu "Zowerengera" kapena "Mndandanda wathunthu wa zilembo" timafunafuna mkangano ndi dzinalo DISP.G. Mukapezeka, sankhani ndikudina batani "Zabwino".
- Ntchito yotsutsana ndi ntchito imayamba. DISP.G. Khazikitsani chotembezera m'munda "Nambala1". Sankhani maselo osiyanasiyana pa pepala lomwe lili ndi nambala angapo. Ngati pali magulu angapo otere, mutha kuwagwiritsanso ntchito kuti alowe m'malo awo pazolowera zotsutsana pamunda "Nambala2", "Nambala 3" etc. Pambuyo polemba data yonse, dinani batani "Zabwino".
- Monga mukuwonera, izi zitatha kuwerengera kumapangidwa. Zotsatira zakuwerengera zakusiyana ndi kuchuluka kwa anthu zikuwonetsedwa mu khungu lomwe adatchulapo kale. Ndilo selo momwe kakhalidwe komwe amapangidwira mwachindunji DISP.G.
Phunziro: Excel Feature Wizard
Njira 2: kuwerengera zitsanzo
Mosiyana ndi kuwerengera mtengo kuchokera kwa anthu wamba, powerengera zitsanzo, chipembedzo sichisonyeza kuchuluka kwa manambala, koma m'modzi akuchepera. Izi zimachitika pofuna kukonza cholakwikacho. Excel imaganizira za chida ichi mu ntchito yapadera yomwe idapangidwira kuwerengera kwamtunduwu - DisP.V. Kapangidwe kake kamayimiriridwa ndi kachitidwe kotsatira:
= DisP.V (Nambala1; Nambala2; ...)
Chiwerengero cha zotsutsana, monga momwe zimagwirira ntchito yapitayi, chimatha kusintha kuchokera 1 mpaka 255.
- Sankhani khungu komanso chimodzimodzi ngati nthawi yapita, thamanga Fotokozerani Wizard.
- Gulu "Mndandanda wathunthu wa zilembo" kapena "Zowerengera" kufunafuna dzina "DISP.V". Momwe mapangidwewo apezeka, sankhani ndikudina batani "Zabwino".
- Ntchito yotsutsana ndi ntchito imayambitsidwa. Kenako timapitilira mofananamo, monga tikugwiritsira ntchito woyambayo: ikani cholozera m'malo otsutsa "Nambala1" ndikusankha dera lomwe lili ndi zotsatsira manambala papepala. Kenako dinani batani "Zabwino".
- Zotsatira za kuwerengera zikuwonetsedwa mu khungu limodzi.
Phunziro: Ntchito zina zowerengera mu Excel
Monga mukuwonera, pulogalamu ya Excel imatha kuthandizira kuwerengera kwamitunduyo. Ziwerengerozi zitha kuwerengeka ndikugwiritsa ntchito, onse ponseponse komanso mwachitsanzo. Nthawi yomweyo, zochita zonse za ogwiritsira ntchito zimatsikira kungowonetsa kuchuluka kwamanambala omwe akukonzedwa, ndipo Excel imagwiranso ntchito yake yomwe. Zachidziwikire, izi zimapulumutsa nthawi yambiri yogwiritsa ntchito.
