Imodyuli yokuSebenza kwi-Excel

Imodyuli yexabiso elifanelekileyo ngalo naliphi na inani. Nokuba kwinani elingelilo, imodyuli iya kuhlala ilungile. Makhe sifumanise ukuba silubala njani ubukhulu bemodyuli kwiMicrosoft Excel.

Inqaku le-ABS

Ukubala ubukhulu bemodyuli e-Excel, kukho into ekhethekileyo ebizwa ngokuba yi "Abs". I-syntax yalo msebenzi ilula kakhulu: ABS (inombolo). Nokuba ifomula inokuthatha olu hlobo: i-abs (idilesi_chhilden_s_ch). Ukubala, umzekelo, imodyuli evela kwinombolo -8, kufuneka uqhube kwifomula yomtya okanye nakweyiphi na iseli kuluhlu lweefomula zilandelayo: "= ABS (-8)".

Ukwenza ubalo, cinezela kwi-ENTER-Inkqubo inika ixabiso elifanelekileyo lokuphendula.

Ikho enye indlela yokubala imodyuli. Ilungele abo basebenzisi abangaqhelanga ukugcina iifomula ezahlukeneyo entloko.

1. Cofa kwiseli apho sifuna ukuyigcina isiphumo. Cofa kwiqhosha elithi "fasa umsebenzi", ubekwe ngasekhohlo kwi-formula yoluhlu.



2. "I-Wizard imisebenzi iqala. Kuluhlu, okufumaneka kuyo, fumana inqaku le-ABS kwaye ukhethe. Ndiyaqinisekisa Kulungile.



3. Impikiswano yomsebenzi ivula. I-ABS ineengxabano enye kuphela-inani, ke siyazisa. Ukuba ufuna ukuthatha inombolo kwidatha egcinwe kuyo nayiphi na iseli yoxwebhu, cofa iqhosha elibekwe ngasekunene kwefom yokufaka.



4. Ifestile iya kuza, kwaye kufuneka ucofe kwiseli, apho umntu anayo inani apho ufuna ukubala imodyuli. Emva kokudibanisa kwakhona, cofa kwiqhosha ngasekunene kwecandelo lokufaka.



5. I-Apess iwindow eneempikiswano zomsebenzi, apho intsimi "yenombolo" izakugcwaliswa ngexabiso. Cofa Kulungile.



6. Ukulandela oku, ukubaluleka kwemodyuli yenombolo oyikhethileyo iboniswe kwiseli oyikhethileyo.



7. Ukuba ixabiso likwitheyibhile, ifomula yemodyuli inokukhutshelwa kwezinye iiseli. Ukwenza oku, kuya kufuneka uzisa isikhombisi sekona esezantsi esezantsi yeseli, apho sele kukho ifomula, ikhupha iqhosha iqhosha le mouse kwaye liyichithe ezantsi kwetafile. Ke, kwiiseli zale khowudi kuya kubakho ixabiso lemodyuli yedatha ye-Idatha.

Kubalulekile ukuba uqaphele ukuba abanye abasebenzisi bazama ukurekhoda imodyuli, njengoko injalo ngokwesiko kwimathematics, oko kukuthi | (inombolo) | , umzekelo | -48 | | . Kodwa kwimeko enjalo, kuphela imposiso iya kuvela endaweni yokuphendula, kuba i-Excel ayiyiqondi i-syntax enjalo.

Ukubala imodyuli kwinani ngeMicrosoft Excel, akukho nto inzima, kuba le nyathelo yenziwe usebenzisa umsebenzi olula. Imeko kuphela kukuba eli nqaku kufuneka lazi.