Ukufunda indlela yokwenza isikwere kwi-Excel kubaluleke kakhulu, ngakumbi xa uhlala usebenza nale nto ukwenza izibalo okanye izibalo. I-Excel ibe sisixhobo esiluncedo kakhulu, akukhathaliseki nokuba uza kwenza izibalo ezisisiseko okanye ufuna ukuyisebenzisela izibalo ezinzima emsebenzini wakho.
Okwangoku le nkqubo yeMicrosoft ifumene uhlaziyo olukhulu oko kukuvumela ukuba wenze izibalo. Ungade uyisebenzise ukwenza izibalo zokubala kwiinkampani ezinkulu. Kodwa ukuze ufezekise oku, kufuneka wazi ukuba ngawaphi amanyathelo ekufuneka uwalandele.
Kweli nqaku sichaza indlela onokwenza ngayo isikwere kwi-Excel, ngokulandela iindlela ezimbini kunye namanyathelo ambalwa ukuze ukwazi ukwenza ngokukhawuleza izibalo zakho.
Umsebenzi wamandla kwi-Excel
Umsebenzi wamandla kwi-Excel Iluncedo kakhulu ekwenzeni izibalo zemathematika, xa uyisebenzisa ikunika isiphumo sokunyusa impikiswano yenani kumandla. Isivakalisi somsebenzi wamandla simi ngolu hlobo lulandelayo: AMANDLA (inombolo; amandla).
Ukuze usebenzise umsebenzi kufuneka uqonde indlela yokuwusebenzisa. Kwingxoxo "inani" kufuneke u bhala isiseko wamandla ofuna ukuwabala (eli kufuneka libe linani lokwenyani). Kwicandelo "amandla"yiyo i-exponent apho ufuna ukunyusa elo nani.
Umsebenzi wamandla we-Excel sisixhobo esiluncedo kwiingcali zezibalo ezihlala zisenza izibalo ezintsonkothileyo. Ngokukodwa kwabo bakhetha ukushiya ukubala ezandleni zeprogram. Ngale ndlela banokugxila kwizibalo ezintsonkothileyo kwimisebenzi yabo.
Amanyathelo okufunda indlela yokwenza isikwere kwi-Excel kunye nomsebenzi wamandla
Ukukwazi ukusebenzisa umsebenzi wamandla kwi-Excel kwaye ke ufunde indlela yokwenza isikwere kwi-excelUngalandela la manyathelo angezantsi:
- Into yokuqala ekufuneka uyenzile vula i-excel sheet, sincoma ukuba wenze itafile ecwangcisiweyo ukuba kukho amanani amaninzi ofuna ukuwasquare.
- Nje ukuba ulungelelanise idatha yakho kwitafile, kufuneka ujonge icandelo kwimenyu ephambili iifomula.
- Nje ukuba ukhethe ukhetho lweefomyula, kufuneka ufumane ukhetho kwindawo ephezulu ekhohlo Faka umsebenzi.
- Ukwenza njalo kuvula imenyu entsha, apho ungabhala khona igama lomsebenzi owukhangelayo, kulo mzekelo kufuneka ubhale. AMANDLA.
- Nje ukuba uyenzile, uya kuphawula ukuba unako khetha umsebenzi wamandla kwaye cinezela ukwamkela.
- Ngoku uqaphela indlela enye imenyu evula ngayo, apho bakuxelela ukuba kufuneka bhala inani okanye isiseko samandla. Kufuneka ugcine engqondweni ukuba kolu khetho unokongeza iseli apho inani ofuna ukusquaretha likhoyo.
- Bakwakunika icandelo ekufuneka ubhale kulo igunya oza kuliphakamisa (kule meko kufuneka u2).
- Nje ukuba ufake zombini idatha, uya kuqaphela isiphumo sokuphindaphinda inombolo oyibonisileyo.
Ngokulandela la manyathelo uya kukwazi ukwenza isikwere naliphi na inani olifunayo kwi-Excel ngaphandle kwengxaki.
Ungasebenzisa kwakhona ifomula yamandla kwi-Excel ngqo kwaye ugcine amanyathelo ambalwa. Ukuyiphumeza unako khetha iseli kwiphepha le-Excel ofuna ukwenza ubalo.
Kanye kwiseli kufuneka ubhale kuphela i-syntax yomsebenzi, kodwa njengefomula “= AMANDLA (inombolo; amandla)”; apho kufuneka uqale ubhale inani ofuna ukuphinda-phinda kwaye ngokunokuba nenani u-2, ukuze ukwazi ukuphinda-phinda.
Indlela yokwazi ukwenza isikwere kwi-Excel ngamanyathelo ambalwa
Umsebenzi wamandla ayisiyiyo kuphela indlela ngoko unako ukuphakamisa isikwere. Kukho indlela enokukhawuleza kunye nezibalo ezilula. Nanga amanyathelo onokuthi uwalandele:
- Into yokuqala ekufuneka uyenzile khetha iseli apho ufuna ukubonisa isikwere, inani.
- Ngoku kufuneka ufake okubhaliweyo kulandelayo ngaphakathi kwezicatshulwa “=(inombolo okanye iseli)^2".
- Ngaphakathi kwezibiyeli kufuneka faka inombolo Ufuna ukwenza ntoni okanye ngenisa iseli iphi inombolo ofuna ukuyisquare.
- Ngokusebenzisa le fomyula ngokuthe ngqo kwiseli, uya kufumana isiphumo senani ofuna ukuliphindaphinda ngokulula kunye namanyathelo ambalwa.
La manyathelo alula kakhulu kwaye anokuba luncedo kakhulu xa ufuna ukwenza izibalo zomzuzwana.
Yintoni endifanele ndiyigcine engqondweni xa ndiphindaphinda inombolo kwi-Excel?
Xa ufunda ukwenza isikwere inani kwi-Excel, kuya kufuneka ucinge imiba ebalulekileyo, nokuba yeyiphi kwezi ndlela zimbini ozisebenzisayo. Phakathi kweengongoma ekufuneka uzithathele ingqalelo zezi:
- Kwimeko yokusebenzisa umsebenzi AMANDLA, nokuba ubhala ifomula ngqo kwiseli okanye wenze inkqubo ngemenyu yefomula. Kufuneke u qonda ukuba yintoni isiseko samandla kwaye i-exponent yosoloko ingu-2, noko kulo mzekelo ofuna ukusoloko usikwere.
- Xa ubhala ifomula ngokuthe ngqo kwiiseli ze-Excel kufuneka usebenzise uphawu "+" okanye "="".. Ukuba awufuni, inkqubo ayiqapheli uqulunqo ozama ukulusebenzisa, umzekelo, kufuneka ibe: “=amandla (inombolo; i-exponent)"Okanye"+(inombolo okanye iseli)^2"
- Kubalulekile ukuba vavanya ukuba yeyiphi eyona ndlela ilungileyo xa ubala isikwere kwi-Excel. Kuba ukuba lubalo lomsebenzi wakho, kuyacetyiswa ukuba usebenzise ifomula enikezwe yi-Excel. Kuba oku kunokuba luncedo ukuba ufuna ukutshintsha i-exponent, ukuba unokucelwa ukuba uyinyuse ngaphezu kophindwe kabini.
- Ngokufanelekileyo, gcina idatha ilungelelanisiwe ngeetheyibhile kwaye uchonge ukuba ngawaphi amaxabiso owabalayo kwaye ke ukwazi ukusebenzisa iindlela zesquaring kwi-Excel ngokuchanekileyo.
Inkqubo yokwazi ukuba isikwere inani kwi-Excel ayikho into enzima, ukuba nje usebenzisa enye yeenkqubo ngokuchanekileyo, uya kukwazi ukwenza izibalo zakho ngaphandle kwengxaki.
Ngoku ekubeni ufunde indlela yokwenza isikwere inani kwi-Excel, unako yenza ezi ntlobo zokubala ngokukhawuleza, kungakhathaliseki ukuba uluphi na ukusetyenziswa oya kukunika idatha yakho.