Ukubalwa kokusakazwa kwe-Excel

Phakathi kwezinkomba eziningi ezisetshenziswa kwizibalo, kuyadingeka ukukhetha ukubalwa kokuhlakazeka. Kumele kuqashelwe ukuthi ukwenziwa ngesandla kwalokhu kubalwa kungumsebenzi onzima. Ngenhlanhla, uhlelo lokusebenza lwe-Excel lunemisebenzi ekuvumela ukuthi ushintshe inqubo yokubala. Sithola i-algorithm yokusebenza nalawa amathuluzi.

Ukubalwa kokuhlakazeka

Ukuhlakazeka kuyinkomba yokuhlukahluka, okuyisikwele esijwayelekile sokuphambuka kusuka ekulinganeni kwezibalo. Ngakho-ke, kuveza isaphulelo sezimpawu ezihlobene nenani eliphakathi. Ukubala kokuhlakazeka kungenziwa zombili ngenani elijwayelekile nesampula.

Indlela 1: Ukubalwa kwezolimo okujwayelekile

Ukubala le nkomba ku-Excel, isethi ejwayelekile isebenza umsebenzi wesibonisi. I-syntax yale nkulumo inefomu elilandelayo:

= D.g (inombolo1; inombolo2; ...)

Ingqikithi yezimpikiswano ezi-1 kuye kwezingu-255 ezingasetshenziswa. Njengabaphikisi basebenza njengamanani wenombolo kanye nezinkomba kumaseli atholakala kuwo.

Ake sibheke ukuthi ungabala kanjani leli nani ngobubanzi ngedatha yezinombolo.

1. Siveza ukukhethwa kweseli eshidini lapho imiphumela yokuhlakazwa kokuhlakazeka izokhonjiswa. Chofoza inkinobho ethi "Incress function", ibekwe ngakwesobunxele ngentambo yefomula.



2. Imisebenzi iyaqala. Esigabeni se- "Statistical" noma "uhlu olugcwele lwezinhlamvu", senza ukusesha impikiswano negama elithi "umlenze". Ngemuva kokutholakele, sivusa bese uqhafaza inkinobho ethi "KULUNGILE".



3. Ukuboniswa kokuboniswa kokuboniswa komsebenzi kuyasebenza. Faka isikhombisi endle "Inombolo1". Sabela ububanzi bamaseli eshidini, eliqukethe umugqa wezinombolo. Uma kunamabanga amaningana anjalo, khona-ke ungasebenzisa izixhumanisi ku- "Number2", "Number3" i-Field Argeam Window, njll. Ngemuva kwayo yonke imininingwane yenziwe, chofoza inkinobho ethi "Kulungile".



4. Njengoba ubona, ngemuva kwalezi zenzo zibalwe. Umphumela wokubala usayizi wokwehluka ngokwesethi ejwayelekile kukhonjiswa kwiseli elishiwo ngaphambili. Lesi yiseli lapho ifomula yegatsha itholakala khona ngqo.

Isifundo: I-Master of Imisebenzi ku-Excel

Indlela 2: Ukubalwa kwesampula

Ngokungafani nokubalwa kwenani ngokuya ngesethi evamile, ekubalweni kwesampula ku-denominator, hhayi inani eliphelele lezinombolo, kepha elinye lincane. Lokhu kwenziwa ukuze kulungiswe iphutha. I-Excel ibheka le nnokwane emsebenzini okhethekile, ohloselwe lolu hlobo lokubala - dis.v. I-syntax yayo imelelwa yifomula elandelayo:

= D (inombolo1; inombolo2; ...)

Inani lezimpikiswano, njengakumsebenzi owedlule, lingashintsha lisuka ku-1 liye ku-255.

1. Sigqamisa iseli futhi ngendlela efanayo nesikhathi esidlule, sethula imisebenzi yemisebenzi.



2. Esigabeni "Uhlu Olugcwele lwe-alfabhethi" noma "izibalo" ngifuna igama elithi "Dis.V.". Ngemuva kokuthi ifomula itholakele, sivusa futhi senze chofoza inkinobho ethi "Kulungile".



3. Umsebenzi we-function arganing wethulwa. Okulandelayo, senza ngokugcwele ngendlela efanayo, njengalapho sisebenzisa opharetha wangaphambilini: Sibeka ikhesa enkundleni ye- "Number1" bese ukhetha indawo equkethe umugqa wezinombolo eshidini. Bese uchofoza inkinobho ethi "KULUNGILE".



4. Umphumela wokubala uzosuswa esitokisini esihlukile.

Isifundo: Eminye imisebenzi yezibalo e-Excel

Njengoba ukwazi ukubona, uhlelo lwe-Excel luyakwazi ukulekelela kakhulu ukubalwa kokuhlakazeka. Leli nani lezibalo lingabalwa uhlelo lokusebenza, zombili ngenani elijwayelekile nesampula. Kulokhu, zonke izinto zomsebenzisi zincishiswa kuphela kwinkomba yohlu lwezinombolo ezisetshenzisiwe, nomsebenzi omkhulu we-Excel ngokwawo uqobo. Vele, izokonga inani elibalulekile lesikhathi somsebenzisi.