Imodyuli yokusebenza ku-Excel

Imodyuli yinani eliphelele eliphelele lanoma iyiphi inombolo. Noma ngenombolo engemihle, imodyuli izohlala inethemba. Ake sibheke ukuthi ungabala kanjani ubukhulu bemodyuli e-Microsoft Excel.

Isici se-ABS

Ukubala ubukhulu bemodyuli e-Excel, kunesici esikhethekile esibizwa nge- "Abs". I-syntax yalo msebenzi ilula kakhulu: I-ABS (inombolo). Kuphakathi ifomula ingathatha lolu hlobo: I-AB (ikheli_Izingane_s_ch). Ukubala, isibonelo, imodyuli kusuka kunombolo -8, udinga ukushayela ifomula yentambo noma kunoma yisiphi iseli ohlwini lwefomula elandelayo: "= I-ABS (8)".

Ukwenza ukubalwa, cindezela ku-Enter - Uhlelo lukhipha inani elihle ekuphenduleni.

Kunenye indlela yokubala imodyuli. Ilungele labo basebenzisi abangajwayele ukugcina amafomula ahlukahlukene ekhanda.

1. Chofoza esitokisini lapho sifuna ukugcina khona umphumela. Chofoza inkinobho ethi "Incress function", ibekwe ngakwesobunxele ngentambo yefomula.



2. Iwindi le- "Wizard Recetions" liqala. Kuluhlu, olutholakala kulo, thola isici se-ABS bese ulikhetha. Ngiyaqinisekisa ukuthi kulungile.



3. Ukuphikisana nomsebenzi kuyavuleka. I-ABS inengxabano eyodwa kuphela - inombolo, ngakho-ke sethula. Uma ufuna ukuthatha inombolo kusuka kwidatha egcinwe kunoma yisiphi iseli sedokhumenti, cindezela inkinobho ebekwe ngakwesokudla kwefomu lokufaka.



4. Iwindi lizofika, futhi udinga uchofoze esitokisini, lapho umuntu equkethe inombolo ofuna ukubala ngayo imodyuli. Ngemuva kokungeza futhi, chofoza inkinobho ngakwesokudla kwensimu yokufaka.



5. Faka iwindi ngezimpikiswano zomsebenzi, lapho inkambu "yenombolo" izogcwaliswa ngenani. Chofoza KULUNGILE.



6. Ukulandela lokhu, inani lemodyuli yenombolo oyikhethile iboniswa esitokisini osikhethile.



7. Uma inani litholakala etafuleni, ifomula yemodyuli ingakopishwa kwamanye amaseli. Ukuze wenze lokhu, udinga ukuletha isikhombisi ekhoneni elingezansi kwesokunxele seseli, lapho sekuvele khona ifomula, vala inkinobho yegundane bese uyisebenzisa phansi kuze kube sekupheleni kwetafula. Ngakho-ke, kumaseli wale kholamu kuzoba nenani lemodyuli yedatha yomthombo.

Kubalulekile ukuqaphela ukuthi abanye abasebenzisi bazama ukuqopha imodyuli, njengoba kungokwesiko kuzibalo, okungukuthi | (inombolo) | , Ngokwesibonelo | -48 | . Kepha esimweni esinjalo, kuzovela iphutha kuphela esikhundleni sokuphendula, ngoba i-Excel ayiqondi i-syntax enjalo.

Ekubalweni kwemodyuli kusuka kunombolo nge-Microsoft Excel, akukho lutho olunzima, ngoba lokhu kwenziwa kusetshenziswa umsebenzi olula. Isimo kuphela ukuthi lesi sici udinga nje ukwazi.