Pakati pa ogwiritsira ntchito osiyanasiyana a Excel, ntchitoyo imayimira kuthekera kwake OSTAT. Chimakupatsani mwayi kuti muwone mu selo lomwe mwatsalira kugawa nambala nambala. Tiphunzire zambiri za momwe ntchito iyi ingagwiritsidwire ntchito, komanso kufotokoza tanthauzo la kugwira ntchito nayo.
Ntchito yogwiritsira ntchito
Dzina la ntchitoyi limachokera ku dzina lalifupi la mawu akuti "gawo lotsala". Wogwiritsa ntchito uyu, yemwe ali m'gulu la masamu, amakupatsani mwayi wowonetsa zotsalira zomwe zimachitika chifukwa cha magawanidwe manambala m'chipindacho. Nthawi yomweyo, gawo lonse la zotsatira silinawoneredwe. Ngati gawoli ligwiritsa ntchito manambala ndi chizindikiro chosalimbikitsa, zotsatira zake zidzawonetsedwa ndi chizindikiro chomwe wogawanacho anali nacho. Kapangidwe ka mawu awa ndi motere:
= OSTAT (nambala; divisor)
Monga mukuwonera, mawuwo ali ndi mfundo ziwiri zokha. "Chiwerengero" ndi gawo lomwe linalembedwera manambala. Mtsutso wachiwiri ndi wogawanitsa, monga zikuwonetsedwera ndi dzina lake. Ndi omaliza mwa iwo omwe amasankha chizindikiro chomwe zotsatira zake zidzabwezeretsedwera. Zotsutsazo zitha kukhala zenizeni pazokha kapena zonena za ma cell omwe zilimo.
Onani mitundu ingapo yamalingaliro oyambira ndi zotsatira zogawa:
- Mawu oyambira
= OSTAT (5; 3)Zotsatira zake: 2.
- Mawu oyambira:
= OSTAT (-5; 3)Zotsatira zake: 2 (popeza divisor iyi ndi nambala yabwino).
- Mawu oyambira:
= OSTAT (5; -3)Zotsatira zake: -2 (popeza divisor ndi nambala yolakwika).
- Mawu oyambira:
= OSTAT (6; 3)Zotsatira zake: 0 (popeza 6 pa 3 wogawidwa popanda wotsalira).
Chitsanzo chaogwiritsa ntchito
Tsopano, mwachitsanzo, timaganizira zamagetsi ogwiritsira ntchito opareshoni.
- Tsegulani buku lantchito la Excel, sankhani selo momwe zotsatirazi zikuwonetsedwera, ndikudina chizindikiro "Ikani ntchito"itayikidwa pafupi ndi baramu yodula
- Kachitidwe kakuchitika Ogwira Ntchito. Pitani ku gulu "Masamu" kapena "Mndandanda wathunthu wa zilembo". Sankhani dzina OSTAT. Sankhani ndikudina batani. "Zabwino"ili m'munsi mwa zenera.
- Windo la mkangano liyamba. Ili ndi magawo awiri omwe amagwirizana ndi zomwe tafotokozazi. M'munda "Chiwerengero" lowetsani mtengo wamanambala womwe udzawonekere. M'munda "Wogawa" lowetsani kuchuluka kwa manambala komwe kumakhala kwa divisor. Monga zotsutsana, mutha kulumikizanso maulalo omwe ma cell omwe amapezeka amapezeka. Pambuyo pazidziwitso zonse zomwe zasonyezedwa, dinani batani "Zabwino".
- Ntchito yomaliza ikamalizidwa, zotsatira za kukonza kwa wopanga ma data, ndiye kuti, zotsala za magawidwe awiri, zimawonetsedwa mu khungu lomwe tidazindikira mu gawo loyamba la bukuli.
Phunziro: Excel Feature Wizard
Monga mukuwonera, wothandizirayo akuwerengedwa zimapangitsa kuti zikhale zosavuta kuti ziwonetsere kugawa kwa manambala omwe ali m'chipindacho. Nthawi yomweyo, njirayi imachitidwa molingana ndi malamulo omwewo malinga ndi ntchito zina za ntchito ya Excel.
