Phakathi kwezinkomba eziningi ezisetshenziswa kwizibalo, kuyadingeka ukugqamisa ukubalwa kokwehluka. Kumele kuqashelwe ukuthi ukwenza lokhu kubalwa kuwumsebenzi oshubile. Ngenhlanhla, i-Excel inezici zokushintsha inqubo yokubala. Thola i-algorithm yokusebenza ngalezi mathuluzi.
Ukubalwa kokwehluka
Ukuhlakazeka kuyisilinganiso sokwehluka, okuyisikwele esijwayelekile sokuphambuka kulindelo lwezibalo. Ngakho-ke, kuveza ukusakazwa kwezinombolo okuhlobene nenani eliphakathi. Ukubalwa kokuhlukahluka kungenziwa zombili ngenani labantu kanye nesampula.
Indlela yoku-1: ukubalwa kwabantu jikelele
Ukubala le nkomba ku-Excel ngesisekelo sabantu, umsebenzi I-Disp.G. I-syntax yale nkulumo imi kanje:
= DISP.G (Inombolo1; inombolo2; ...)
Sekukonke, izimpikiswano ezi-1 kuye kwezingu-255 zingasetshenziswa. Izimpikiswano kungaba ngamanani ezinombolo noma izinkomba kumaseli okulo.
Ake sibheke ukuthi lingabalwa kanjani leli nani lebanga ledatha yezinombolo.
- Sikhetha iseli eshidini lapho kuzoboniswa khona imiphumela yokubala ukwehluka. Chofoza inkinobho "Faka umsebenzi"ibekwe kwesokunxele sebha lefomula.
- Kuqala Isici Wizard. Esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi" sifuna impikiswano enegama I-Disp.G. Lapho isitholile, ikhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. I-Disp.G. Setha isikhombisi esigangeni "Inombolo1". Khetha uhla lwamaseli eshidi eliqukethe uchungechunge lwezinombolo. Uma ngabe kukhona amabanga anjalo amaningi, ungawasebenzisa futhi ukufaka izixhumanisi zawo kuwindi lokuphikisana lwensimu "Inombolo2", "Inombolo 3" njll. Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalezi zenzo sibalo senziwa. Umphumela wokubala umehluko kusuka kubantu uboniswa kuseli elicacisiwe ngaphambili. Yiso kanye iseli lapho ifomula ebekwe khona ngqo I-Disp.G.
Isifundo: I-Excel Feature Wizard
Indlela 2: ukubalwa kwesampula
Ngokuphikisana nokubalwa kwenani elivela kubantu jikelele, ekubalweni kwesampula, i-denominator ayikhombisi inani eliphelele lezinombolo, kodwa elilodwa elincane. Lokhu kwenziwa ukuze kulungiswe iphutha. U-Excel unaka le nuance emsebenzini okhethekile owenzelwe lolu hlobo lokubala - DISP.V. I-syntax yayo imelelwa yifomula elandelayo:
= IDP.V (Inombolo1; inombolo2; ...)
Inani lokuphikisana, njengakusebenza kwangaphambilini, lingahluka futhi ukusuka ku-1 kuye ku-255.
- Khetha iseli ngendlela efanayo nesikhathi esedlule, gijima Isici Wizard.
- Esigabeni "Uhlu oluphelele lwe-alfabhethi" noma "Izibalo" ngifuna igama "IDP.V". Ngemuva kokuthi ifomula itholakele, khetha bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana ngomsebenzi l yethulwa. Ngemuva kwalokho siqhubeka ngendlela efanayo ngokuphelele, njengalapho usebenzisa opharetha wangaphambilini: setha ikhesa enkundleni yezimpikiswano "Inombolo1" bese ukhetha indawo equkethe uchungechunge lwezinombolo kushidi. Bese uchofoza inkinobho "Kulungile".
- Umphumela wesibalo uzokhonjiswa kuseli elihlukile.
Isifundo: Eminye imisebenzi yezibalo ku-Excel
Njengoba ukwazi ukubona, uhlelo lwe-Excel luyakwazi ukwenza lula ukubalwa kokuhluka. Lesi sibalo singabalwa ngohlelo lokusebenza, kokubili kubantu jikelele nakwisampula. Ngasikhathi sinye, zonke izindlela zomsebenzisi empeleni zehla kuphela ukukhombisa uhla lwezinombolo ezizocutshungulwa, futhi i-Excel yenza umsebenzi omkhulu uqobo. Vele, lokhu kuzonga isikhathi esikhulu somsebenzisi.
