Phakathi kokusebenza okuhlukahlukene kwe-Excel, umsebenzi I-OSTAT. Ikuvumela ukuba ubonise esitokisini esinqunyelwe izinsalela zokwehlukanisa inombolo eyodwa ngesinye. Masifunde kabanzi ukuthi lo msebenzi ungasetshenziswa kanjani ekusebenzeni, futhi sichaze nemisindo yokusebenza nayo.
Uhlelo lokusebenza
Igama lalesi senzo livela kwigama elifinyeziwe legama elithi "okusele ukwahlukanisa". Lo opharetha, ongowesigaba sezibalo, ukuvumela ukuthi ukhombise ingxenye esele yomphumela wokuhlukaniswa kwezinombolo esitokisini esibekiwe. Ngaso leso sikhathi, yonke ingxenye yomphumela ayikhonjiswanga. Uma isigaba sisebenzise amanani ezinombolo ngesibonakaliso esingesihle, umphumela wokucubungula uzokhonjiswa nophawu lowo ohlukanisile ayenalo. I-syntax yalesi sitatimende imi kanje:
= OSTAT (inombolo; divisor)
Njengoba ubona, le nkulumo inezimpikiswano ezimbili kuphela. "Inombolo" Isahlukaniso esibhalwe ngamanani ezinombolo. Ingxabano yesibili ukwahlukanisa, njengoba kufakazelwa yigama layo. Ungowokugcina kubo onquma isibonakaliso esizobuyiselwa ngalo umphumela wokucubungula. Izimpikiswano kungaba ngamanani ezinombolo ngokwawo noma izinkomba kumaseli eziqukethwe kuwo.
Cabanga ngezinketho eziningi zezinkulumo zokwazisa kanye nemiphumela yokuhlukanisa:
- Isingeniso
= OSTAT (5; 3)Umphumela: 2.
- Isingeniso:
= OSTAT (-5; 3)Umphumela: 2 (ngoba isahlukanisi liyinombolo enhle yezinombolo).
- Isingeniso:
= OSTAT (5; -3)Umphumela: -2 (ngoba isahlukanisi liyinombolo yezinombolo ezingezinhle).
- Isingeniso:
= OSTAT (6; 3)Umphumela: 0 (kusukela 6 kuvuliwe 3 ihlukaniswe ngaphandle kwensalela).
Isibonelo se-opharetha
Manje, ngesibonelo esithile, sibheka ama-nuances okusebenzisa lo opharetha.
- Vula incwadi yokusebenza ye-Excel, khetha iseli okuzovezwa kulo umphumela wokucwaninga kwedatha, bese uchofoza isithonjana "Faka umsebenzi"ibekwe eduze kwebha yefomula.
- Ukuqalisa kuyaqhubeka Umsebenzi Wizards. Hambisa esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi". Khetha igama I-OSTAT. Khetha bese uchofoza inkinobho. "Kulungile"etholakala engxenyeni engezansi yewindi.
- Iwindi lokuphikisana liyaqala. Siqukethe izinkambu ezimbili ezihambelana nezimpikiswano ezichazwe yithina ngenhla. Ensimini "Inombolo" faka inani lezinombolo elizobonakala. Ensimini "Isihlukanisi" faka inani lezinombolo okuzoba lisahlukanisi. Njengokuphikisana, ungafaka nezixhumanisi kumaseli lapho amanani acacisiwe akhiwe khona. Ngemuva kokuthi yonke imininingwane ikhonjisiwe, chofoza inkinobho "Kulungile".
- Ngemuva kokuthi isenzo sokugcina sesiphothuliwe, umphumela wokucutshungulwa kwedatha ngu-opharetha, okungukuthi, okusele kokwahlukaniswa kwezinombolo ezimbili, kukhonjiswa kuseli esiliqaphele esigabeni sokuqala sale ncwadi.
Isifundo: I-Excel Feature Wizard
Njengoba ukwazi ukubona, opharetha ofundwayo bakwenza kube lula ngokwanele ukubonisa izinsalela zokuhlukaniswa kwezinombolo kuseli elichazwe ngaphambi kwesikhathi. Ngasikhathi sinye, inqubo yenziwa ngokuya ngemithetho ejwayelekile efanayo neminye imisebenzi yesicelo se-Excel.
