Phakathi kwabatshayeli be-Excel abahlukene, lo msebenzi uvela ngamakhono ayo. I-OSTAT. Ikuvumela ukuba ubonise esitokisini esicacisiwe insalela yehlukanisa inombolo eyodwa ngomunye. Ake sifunde kabanzi mayelana nokuthi lo msebenzi ungasetshenziswa kanjani ekusebenzeni, kanye nokuchaza ama-nuances okusebenza nawo.
Uhlelo lokusebenza
Igama lalo msebenzi lisuselwa egameni elifingqiwe legama elithi "okusele kwesigaba." Lo opharetha, oyingxenye yesigaba semathematika, ikuvumela ukuba ubonise ingxenye ehleliwe yomphumela wokuhlukanisa izinombolo kumakhalekhukhwini ocacisiwe. Ngesikhathi esifanayo, yonke ingxenye yomphumela ayichaziwe. Uma lesi sigaba sisebenzisa izindinganiso zamanani ngesibonakaliso esingalungile, umphumela wokucubungula uzoboniswa ngesibonakaliso sokuthi umhlukanisi unalo. I-syntax yale statement is kanje:
= OST (inombolo; umshayeli)
Njengoba ungabona, le nkulumo inezingxabano ezimbili kuphela. "Inombolo" isabelo esilotshwe enkulumweni yenombolo. Ingxabano yesibili ingumshayeli, njengoba kuboniswe negama layo kanye. Yilokugcina kulabo abaqamba isibonakaliso lapho umphumela wokucubungula uzobuyiselwa khona. Iziphakamiso zingaba izinombolo zezinombolo noma izinkomba ezisezindlini lapho ziqukethwe khona.
Cabangela izinketho eziningana zezinkulumo zokuqala kanye nemiphumela yokuhlukanisa:
- Inkulumo yokuqala
= REMA (5; 3)Umphumela: 2.
- Inkulumo yokuqala:
= OSTAT (-5; 3)Umphumela: 2 (ngoba umshayeli wezinombolo uyinani lezinombolo ezilungile).
- Inkulumo yokuqala:
= OSTAT (5; -3)Umphumela: -2 (ngoba umeluleki uyinani lezinombolo ezingalungile).
- Inkulumo yokuqala:
= OSTAT (6; 3)Umphumela: 0 (kusukela 6 kuqhubeke 3 ihlukaniswe ngaphandle kokusala).
Isibonelo sokusebenzisa opharetha
Manje ngesibonelo sokhonkolo, sibheka ama-nuances okusetshenziswa kwalolu opharetha.
- Vula ibhuku le-Excel, khetha iseli lapho umphumela wokucubungula idatha kuzokhonjiswa khona, bese uchofoze kwisithonjana. "Faka umsebenzi"kufakwe eduze kwe-bar bar.
- Ukuqaliswa kwenziwa Amakhosi omsebenzi. Hambisa kusigaba "Isibalo" noma "Uhlu oluphelele lwe-alfabhethi". Khetha igama "OSTAT". Khetha bese uchofoza inkinobho. "Kulungile"efakwe engxenyeni engezansi yewindi.
- Iwindi lempikiswano iqala. Iqukethe izinsimu ezimbili ezihambisana nezimpikiswano ezichazwe ngathi ngenhla. Ensimini "Inombolo" faka inani lezinombolo elizobonakala. Ensimini "Isihlukanisi" faka inani lezinombolo elizobe lihlukanisa. Njengama-arguments, ungaphinda ungene izinkomba kumaseli lapho kutholakala khona izindinganiso ezicacisiwe. Ngemuva kokuthi lonke ulwazi luchaziwe, chofoza inkinobho "Kulungile".
- Ngemuva kokuthi isenzo sokugcina senziwe, umphumela wokucutshungulwa kwedatha ngu-opharetha, okungukuthi, okusele okusehlukanisweni kwezinombolo ezimbili, uboniswa esitokisini esasiqaphele esigabeni sokuqala sale ncwajana.
Isifundo: I-Excel umsebenzi wizard
Njengoba ubona, u-opharetha ocwaningwayo wenza kube lula ngokwanele ukuletha okusele kwesigaba sezinombolo zibe esitokisini esicacisiwe ngaphambili. Kulesi simo, inqubo yenziwa ngokwemithetho efanayo efanayo neminye imisebenzi ye-Excel.
