I-module iyigugu elihle kunoma iyiphi inombolo. Ngisho nenani elibi lizohlala linemodemu enhle. Ake sithole ukuthi singakanani ukubala inani le-module ku-Microsoft Excel.
Umsebenzi we-ABS
Ukubala ukubaluleka kwe-module ku-Excel, kunomsebenzi okhethekile okuthiwa i-ABS. I-syntax yalo msebenzi ilula: "ABS (inombolo)". Noma, ifomula lingathatha ifomu elithi "ABS (ikheli le-cell nenombolo)".
Ukuze ubale, isibonelo, imodemu kusukela enombolweni -8, udinga ukushayela ibha yefomula noma kunoma yisiphi iseli kushidi, ifomu elilandelayo: "= ABS (-8)".
Ukubala, cindezela inkinobho ENTER. Njengoba ubona, uhlelo luphendula ngenani elihle lenombolo 8.
Kukhona enye indlela yokubala imodemu. Kuyafaneleka kulabo abasebenzisi abangajwayele ukukhumbula izingqikithi ezihlukahlukene. Sichofoza esitokisini esifuna ukuthi umphumela ugcinwe. Chofoza inkinobho "Faka umsebenzi", esekwesokunxele kwebha yefomula.
I-Function Wizard iqala. Kulolu hlu, olukulo, udinga ukuthola umsebenzi we-ABS, bese ukhetha. Bese uchofoza inkinobho ethi "Kulungile".
Iwindi lempikiswano yokusebenza ivula. Umsebenzi we-ABS unengxabano eyodwa kuphela - inombolo. Siyifaka. Uma ufuna ukuthatha inombolo kusuka kudatha egcinwe esitokisini sedokhumenti, bese uchofoza inkinobho ekhona ngakwesokudla kwifomu lokufaka.
Emva kwalokho, iwindi linciphisa, futhi udinga ukuchofoza kuseli eliqukethe inombolo ofuna ukubala kuyo. Ngemuva kokuthi inombolo ingeziwe, chofoza futhi inkinobho ngakwesokudla kwenkambu yokufaka.
Ifasitela enezimpikiswano zomsebenzi ivuselelwe futhi. Njengoba ungabona, insimu ethi "Inombolo" igcwele inani. Chofoza inkinobho ethi "Kulungile".
Ukulandela lokhu, i-modulus yenombolo oyikhethile iboniswa kuseli owashiwo ekuqaleni.
Uma inani likhona etafuleni, ifomula yefomula ingakopishwa kwamanye amaseli. Ukuze wenze lokhu, udinga ukuma ekhoneni elingezansi elingakwesokunxele leseli, lapho sekuvele khona ifomula, ubambe inkinobho yegundane bese uyihudula phansi ekugcineni kwetafula. Ngakho, kule kholomu, inani le-modulo idatha yomthombo izovela kumaseli.
Kubalulekile ukuqaphela ukuthi abanye abasebenzisi bazama ukubhala imodemu, njengokujwayelekile kwamashematics, okungukuthi, | | (inombolo) |, isibonelo | -48 |. Kodwa, ngokuphendula, bathola iphutha, ngoba i-Excel ayiqondi le syntax.
Njengoba ubona, akukho lutho oluyinkimbinkimbi ekubaleni imodemu kusuka kwinombolo ku-Microsoft Excel, ngoba lesi senzo senziwa ngokusebenzisa umsebenzi olula. Isimo esiwukuphela kwukuthi uvele nje udinga ukwazi lo msebenzi.
