Kwindawo yespreadsheets, i-Excel ibe sisixhobo esiyimfuneko kwiingcali ezininzi kunye nabafundi ngokufanayo. Uluhlu lwayo olubanzi lwemisebenzi ephezulu kunye nezakhono zivumela ukubala okuntsokothileyo kwenziwe ngokufanelekileyo. Enye yezona zinto ziqhelekileyo kuhlalutyo lwamanani kukunyusa inani kumandla athile. Kule nqaku, siza kuhlolisisa indlela yokunyusa amandla kwi-Excel, usebenzisa imisebenzi efanelekileyo kunye namafomula ukufezekisa iziphumo ezichanekileyo nezithembekileyo. Siza kufunda amanyathelo ayimfuneko ukwenza lo msebenzi, ukwandisa ukusetyenziswa kwawo kwaye uphephe iimpazamo ezinokwenzeka. Zilungiselele ukonyusa izakhono zakho zeExcel!
1. Intshayelelo kwimisebenzi yamandla kwi-Excel
Imisebenzi yamandla kwi-Excel sisixhobo esiluncedo kakhulu sokubala kunye nohlalutyo lwedatha. Le misebenzi ikuvumela ukuba unyuse inani kumandla anikiweyo, ubale iingcambu, kwaye wenze eminye imisebenzi yemathematika. Kweli nqaku, ndiya kukukhokela Inyathelo nenyathelo indlela yokusebenzisa ezi mpawu indlela esebenzayo.
Ukuqala, kukho imisebenzi emininzi yamandla ekhoyo kwi-Excel, njengeMANDLA, POWER.MATRIY, ROOT, CUBICROOT, PHAKATHI, PRODUCT, kunye nokunye. Le misebenzi isetyenziswa ngokuxhomekeke kuhlobo lokubala ekufuneka ulwenzile. Umzekelo, ukuba ufuna ukunyusa inani kumandla athile, ungasebenzisa umsebenzi WAMANDLA. Ukuba ufuna ukubala ingcambu yenani, ungasebenzisa i ROOT umsebenzi.
Ukusebenzisa ezi mpawu, kuqala kufuneka ukhethe iseli apho ufuna isiphumo sivele khona. Emva koko, bhala igama lomsebenzi olandelwa zizibiyeli. Ngaphakathi kwezibiyeli, khankanya amaxabiso okanye iiseli ofuna ukuzisebenzisa ekubaleni. Qinisekisa ukuba uyawahlula amaxabiso ngeekoma. Umzekelo, ukuba ufuna ukuphakamisa inombolo yesi-2 kumandla we-3, ungabhala = AMANDLA(2,3). Nje ukuba ufake umsebenzi, cofa u-Enter kwaye i-Excel iya kubala isiphumo ngokuzenzekelayo.
2. Indlela yokusebenzisa umqhubi wamandla kwi-Excel
Umsebenzisi wamandla kwi-Excel sisixhobo esiluncedo sokwenza izibalo ze-exponential. Ukusebenzisa lo mqhubi, kufuneka ulandele la manyathelo alandelayo:
1. Khetha iseli ofuna ukwenza ubalo lwe-exponential. Qinisekisa ukuba iseli ayinanto kwaye ilungele ukufumana isiphumo.
2. Chwetheza inombolo yesiseko, ilandelwa sisimboli yeenkwenkwezi ezimbini (), kunye nenombolo ye-exponent. Umzekelo, ukuba ufuna ukunyusa u-2 kumandla ka-3, ungabhala "23″ kwiseli.
3. Cofa iqhosha elithi Faka kwaye i-Excel iya kuzibala iziphumo. Kule meko, uyakufumana u-8 njengesiphumo, kuba u-2 uphakanyiswe kumandla ka-3 ulingana no-8.
Kubalulekile ukukhumbula ukuba umqhubi wamandla uthatha kuqala kunabanye abaqhubi kwi-Excel. Ukuba unefomula entsokothileyo ebandakanya ezinye izibalo, kuyacetyiswa ukuba usebenzise izibiyeli ukubonisa ulandelelwano lwendlela yokusebenza.
Khumbula ukuba umqhubi wamandla kwi-Excel unokuphinda asetyenziswe kunye neereferensi kwezinye iiseli. Umzekelo, ukuba ufuna ukunyusa inani eligcinwe kwiseli A1 ukuya kumandla elinye inani kwiseli B1, ungachwetheza "=A1**B1" kwiseli apho ufuna isiphumo. I-Excel iya kubala isiphumo ngokusekwe kumaxabiso eeseli ezikhankanyiweyo.
3. Amanyathelo okunyusa inani libe namandla kwi-Excel
Ukuphakamisa inani kumandla kwi-Excel, ungasebenzisa umsebenzi I-POW. Lo msebenzi ufuna iimpikiswano ezimbini: inani lesiseko kunye ne-exponent ofuna ukunyusa kuyo. Nanku umzekelo wokusebenzisa umsebenzi wePOW:
=POW(A1, B1)
Phi A1 yiseli equlathe inani lesiseko kunye B1 yiseli equlathe i-exponent.
Ukongeza ekusebenziseni umsebenzi we-POW, ungasebenzisa kwakhona umqhubi wamandla (^) ukuphakamisa inani kumandla kwi-Excel. Umsebenzisi wombane usetyenziswa ngolu hlobo lulandelayo:
=A1^B1
Phi A1 yiseli equlathe inani lesiseko kunye B1 yiseli equlathe i-exponent.
Ukuba ufuna ukuphakamisa inani kumandla angatshintshiyo angekho kwiseli, ungasebenzisa ngokuthe ngqo umsebenzi we-POW okanye umqhubi wamandla. Umzekelo:
=POW(3, 2)
Lo mzekelo uzakuphinda-phinda inani u-3, eliyakulingana no-9.
4. Imizekelo esebenzayo yendlela yokunyusa amandla kwi-Excel
Enye yeekhonsepthi ezisetyenziswa kakhulu kwi-Excel kukunyusa amandla. Ukukwazi ukwenza olu balo kubalulekile ukwenza imisebenzi eyahlukeneyo yemathematika kwaye ubale iziphumo ezichanekileyo. Kweli nqaku, siza kwazisa ezinye, ngokulandela indlela inyathelo ngenyathelo.
Ngaphambi kokuqala ngemizekelo, kubalulekile ukukhumbula ukuba kwi-Excel isimboli ^ isetyenziselwa ukubonisa ukusebenza kokunyuselwa kwamandla. Ngokomzekelo, ukuphakamisa inani lesi-2 kumandla we-3, ifomula isetyenziswa =2^3. Xa oku kuqondwa, sinokuqala ngemizekelo esebenzayo.
Umzekelo 1: Masithi sifuna ukubala umphumo wokuphakamisa inani le-5 kumandla amanani 1 ukuya ku-5. Ukwenza oku, sinokusebenzisa umsebenzi we-POWER kwi-Excel. Kwiseli engenanto, sinokubeka ifomula = AMANDLA(5, A1), apho i-A1 yiseli equlethe inani esifuna ukulinyusa kumandla. Ngokutsala le fomula phantsi kweeseli ezikufutshane, siya kufumana iziphumo zamandla alandelelanayo.
5. Imisebenzi yaMandla aPhezulu kwi-Excel
Zisisixhobo esiluncedo kakhulu sokuhlalutya kunye nokulawula idatha ngokufanelekileyo. Le misebenzi isivumela ukuba senze izibalo ezinzima kwaye sifumane iziphumo ezichanekileyo kumaxwebhu ethu e-Excel. Nantsi eminye yemisebenzi exhaphakileyo yamandla aphambili kunye nendlela onokuyisebenzisa ngayo kwi-spreadsheets zakho.
IMALI UKUBA ISETIWE: Lo msebenzi usivumela ukuba sishwankathele amaxabiso kuluhlu oludibana neseti ethile yemilinganiselo. Umzekelo, ukuba sinoluhlu lweentengiso ngemveliso kwaye sifuna ukongeza kuphela intengiso yemveliso ngokukodwa, sinokusebenzisa lo msebenzi. Ukuyisebenzisa, kufuneka sicacise uluhlu lwamaxabiso okongeza kunye neendlela zokucoca.
I-Avareji edityanisiweyo: Ngalo msebenzi sinokufumana umndilili wamaxabiso kuluhlu oluhlangabezana neendlela ezithile. Umzekelo, ukuba sinetafile enamabanga abafundi kwaye sifuna ukufumana umndilili wabafundi abaphumelele iimviwo kuphela, sinokusebenzisa lo msebenzi. Njengakumsebenzi wangaphambili, kufuneka sicacise kuphela uluhlu lwexabiso kunye neendlela zokucoca.
6. Ubalo lwamandla kunye neereferensi zeseli kwi-Excel
Ukwenza oku, kuyimfuneko ukulandela amanyathelo athile aya kuququzelela inkqubo. Okokuqala, kubalulekile ukuqonda indlela amandla abalwa ngayo kwi-Excel. Indlela esisiseko yokubala amandla ithi = AMANDLA(inombolo, i-exponent). Apha, "inani" limele isiseko kwaye "i-exponent" imele amandla apho isiseko siya kunyuselwa khona.
Nje ukuba umgaqo osisiseko uqondwe, kuluncedo ukwazi eminye imisebenzi enxulumeneyo enokwenza izibalo zibe lula. Umzekelo, umsebenzi = AMANDLA.EWE Isetyenziswa xa ufuna ukubala amandla kuphela kumaxabiso athile ahlangabezana nemigaqo ethile. Umsebenzi uyafumaneka =MATRIX AMANDLA, ekuvumela ukubala amandla amanani ahlukeneyo kunye ne-exponents zombini.
Ukongeza, i-Excel ibonelela ngezixhobo ezibonakalayo eziluncedo zokwenza izibalo zamandla. Umzekelo, ungasebenzisa ibha yefomula ukufaka ireferensi kwiseli equlethe inombolo yesiseko kunye nenye iseli equlethe i-exponent. Oku kwenza kube lula ukuhlaziya amaxabiso kwaye uthintele iimpazamo xa ufaka amanani ngesandla kwifomula. Iitafile zePivot nazo zingasetyenziselwa ukuhlalutya kunye nokubonisa iziphumo zezibalo zamandla ngendlela ekulula ukuyiqonda.
7. Iingcebiso kunye namaqhinga okunyusa kwi-powerhouse kwi-Excel
Kwi-Excel, ukunyusa inani kumandla ngumsebenzi osetyenziswa ngokuqhelekileyo kubalo lwemathematika kunye nohlalutyo lwedatha. Ngethamsanqa, inkqubo ibonelela ngeendlela ezininzi zokwenza lo msebenzi ngokukhawuleza nangokuchanekileyo. Ngezantsi kukho ezinye:
1. Umsebenzisi wamandla (^): Umsebenzisi wamandla yenye yeendlela ezilula zokunyusa inani kwi-Excel. Isimboli ye "caret" (^) isetyenziselwa ukubonisa amandla ofuna ukunyusa inani kuwo. Umzekelo, ukuphakamisa inani lesi-2 kumandla wesithathu, uchwetheza "=2^3" kwiseli kwaye ucinezele u-Enter. Isiphumo siya kuba sisi-8.
2. AMANDLA umsebenzi: I-Excel ikwabonelela ngomsebenzi othile wokwenza izibalo zamandla. Umsebenzi WAMANDLA ikuvumela ukuba unyuse inani kuwo onke amandla akhankanyiweyo. Ukusebenzisa lo msebenzi, chwetheza «=POWERNUM; AMANDLA)» kwiseli apho ufuna ukufumana iziphumo. Umzekelo, ukuphakamisa inani lesi-4 kumandla esihlanu, bhala "= AMANDLA(4,5)", kwaye umphumo uya kuba ngu-1024.
3. Izingqinisiso ezixutyiweyo: Ukongeza ekuphakamiseni inani kumandla amiselweyo, kunokwenzeka kwakhona ukwenza lo msebenzi usebenzisa izikhombisi ezixubileyo kwi-Excel. Oku kuvumela amandla ahlukeneyo ukuba asetyenziswe kwiseli nganye kuluhlu olunikiweyo. Ukwenza oku, umsebenzi WAMANDLA unokusetyenziswa ngokudityaniswa neereferensi kwezinye iiseli. Umzekelo, ukuba unamaxabiso oluhlu kwiiseli A1:A5 kwaye ufuna ukunyusa amanani ngalinye kula kumandla achazwe kwiseli B1, ubhala "= AMANDLA(A1,B$1)" kwiseli. C1 kwaye tsala ifomula phantsi kwiseli C5. Ngale ndlela, inani ngalinye liya kuphakanyiswa kumandla ahlukeneyo ngokuxhomekeke kwixabiso kwiseli B1.
Ezi iingcebiso namaqhinga Baza kukunceda uphakamisele kwindlu yamandla kwi-Excel ngokufanelekileyo nangokuchanekileyo. Nokuba usebenzisa umsebenzisi wamandla, umsebenzi WAMANDLA, okanye iimbekiselo ezixubeneyo, unokwenza izibalo zamandla ngokukhawuleza nangokulula. Zama ngolu khetho kwaye ufumanise ukuba yeyiphi eyona ifanele iimfuno zakho kuhlalutyo lwakho kunye nokubala kwemathematika. Ungalibali ukuziqhelanisa nokusebenzisa olu lwazi kwiimeko ezahlukeneyo ukuphucula izakhono zakho zeExcel.
8. Uhlalutyo lweempazamo eziqhelekileyo xa uphakamisa amandla kwi-Excel
Xa uphakamisa amandla kwi-Excel, kuqhelekile ukwenza iimpazamo ukuba inkqubo echanekileyo ayilandelwa. Apha sibonisa ezona mpazamo zixhaphakileyo kunye nendlela yokuzisombulula:
1. Impazamo yeSintaksi: Kubalulekile ukuba uqaphele ukuba xa uphakamisa amandla kwi-Excel, "^" umqhubi usetyenziswa. Ukuba usebenzisa enye isimboli okanye ushiya iiparenthesi ngokuchanekileyo, i-Excel iya kuvelisa umyalezo wemposiso. Umzekelo, endaweni yokubhala "=A12A^2", ifomula echanekileyo iyakuba "=A1^2". Qinisekisa ukuba ulandela i-syntax efanelekileyo ukunqanda le mpazamo.
2. Impazamo embi yereferensi: Omnye umthombo oqhelekileyo wemposiso kukubhekisa kwiseli engalunganga. Umzekelo, ukuba ufuna ukwenza isikweri seseli B2, uya kuqinisekisa ukuba uchwetheza "=B2^2" endaweni ye "=B3^2." Jonga ngononophelo iireferensi zeeseli kwifomula yakho ukunqanda olu hlobo lwempazamo.
3. Impazamo xa kuxutywa izingqinisiso ezipheleleyo nezizalanayo: I-Excel ikuvumela ukuba usebenzise iireferensi ezipheleleyo kunye nezihambelanayo xa unyusa amandla. Ukuba ufuna ukugcina ireferensi yeseli ingaguquki xa ukopa ifomyula, qiniseka ukusebenzisa isimboli "$" phambi konobumba weseli kunye nenombolo. Umzekelo, ukuba ufuna ukwenza isikweri seseli B2 kwaye ukhuphele ifomula ezantsi, ungasebenzisa "=B$2^2" endaweni ye "=B2^2." Oku kuya kuqinisekisa ukuba ireferensi yeseli B2 ihlala ingatshintshi.
9. Izixhobo ezongezelelweyo zokuxhobisa kwi-Excel
Kwi-Excel, kukho izixhobo ezongezelelweyo ezongezelelweyo ezinokuba luncedo kakhulu ekuphuculeni izakhono zakho kunye nokwandisa ulawulo lwedatha. Ezi zixhobo zikuvumela ukuba wenze izenzo eziphambili kunye neziyinkimbinkimbi, eziza kukunceda uphucule imveliso yakho kunye nokusebenza kakuhle. Ngezantsi, siza kudwelisa ezinye zezona zixhobo ziphawuleka kakhulu zokuphucula amava akho e-Excel.
1. Isisombululi: Sisixhobo esiluncedo kakhulu ukufumana isisombululo esisiso kwingxaki enzima. Inokusetyenziswa ukusombulula iingxaki ulungiselelo okanye ukufumana elona xabiso liphezulu okanye lisezantsi lomsebenzi onikiweyo ngokusekelwe kuthotho lwezithintelo. NgeSolver, unokuchaza injongo ofuna ukuyiphumeza kunye nezithintelo ekufuneka zihlangatyezwe, emva koko ufumane esona sisombululo ngokuzenzekelayo.
2. Uhlalutyo lwedatha: I-Excel inoluhlu lwezixhobo zokuhlalutya idatha eziza kukuvumela ukuba ufumane ulwazi olubalulekileyo yedatha yakho. Ezi zixhobo zivela kwimisebenzi esisiseko yamanani ukuya kuhlalutyo lokubuyisela, uhlalutyo lokuhluka, kunye nohlalutyo lwentsingiselo. Ukongeza, unokwenza iigrafu eziguqukayo kunye neetafile eziguquguqukayo ukuze ubone idatha yakho ngokufanelekileyo.
3. Umbuzo wamandla: Esi sixhobo siya kukuvumela ukuba ungenise, uguqule kwaye ucoce idatha evela kwimithombo eyahlukeneyo ngokukhawuleza nangokufanelekileyo. Unokudibanisa idatha kwiifayile ezahlukeneyo okanye iidathabheyisi ngokuzenzekelayo, yenza ukuhluza, ukwahlula amakholomu, phakathi kwezinye izinto zokucoca kunye nokuguqulwa kwedatha. Umbuzo wamandla uluncedo ngakumbi xa usebenza ngemithamo emikhulu yedatha okanye xa ufuna ukuhlaziya rhoqo idatha yakho.
Ezi zizixhobo ezimbalwa ezongezelelweyo ezikhoyo kwi-Excel eziza kukuvumela ukuba uphucule amava akho kwaye ufumane okuninzi kwidatha yakho. Jonga ezi zixhobo kwaye ufumanise ukuba zinokwenza njani lula imisebenzi yakho kwaye wenze umsebenzi wakho nge-Excel ube lula!
10. Ukuthelekiswa kwemisebenzi yamandla kwi-Excel: AMANDLA vs. ^ umsebenzisi
Kwi-Excel, kukho iindlela ezahlukeneyo zokwenza imisebenzi yokunyusa. Kweli nqaku, siza kuthelekisa iindlela ezimbini ezidumileyo zokwenza oku: ukusebenzisa umsebenzi AMANDLA kunye nomsebenzisi ^. Zombini iinketho zisivumela ukuba siphakamise inani kumandla athile, kodwa nganye ineenzuzo zayo kunye nokuqwalaselwa kwayo.
Umsebenzi AMANDLA I-Excel ngumsebenzi wezibalo osivumela ukuba senze imisebenzi yokuphucula ngendlela elula. Ukusebenzisa lo msebenzi, kufuneka singenise inani lesiseko kunye namandla esifuna ukulinyusa. Umzekelo, ukuba sifuna ukunyusa inani lesi-2 kumandla u-3, sinokusebenzisa ifomula = AMANDLA(2,3). Lo msebenzi uluncedo ngakumbi xa sifuna ukunyusa amanani kumagunya angengawo amanani apheleleyo, kuba usivumela ukuba sisebenze ngee-exponents ze-fractional okanye zedesimali.
Kwelinye icala, umqhubi ^ Ikwasivumela ukuba senze imisebenzi yokuphucula kwi-Excel. Lo msebenzisi usetyenziswa ngendlela efanayo kwabanye abasebenzisi bezibalo, njengokudibanisa okanye ukuthabatha. Kufuneka nje sifake inombolo yesiseko, silandelwa ngumsebenzisi ^, kwaye ekugqibeleni amandla esifuna ukuyiphakamisa. Umzekelo, ukuphakamisa inani lesi-2 kumandla we-3, sinokusebenzisa ifomula =2^3. Kubalulekile ukukhumbula ukuba lo msebenzisi uvumela kuphela ukusebenza ngee-exponents ezipheleleyo, ngoko ke ukuba kufuneka sisebenze ngee-exponents ezinamaqhezu, kufuneka sisebenzise umsebenzi. AMANDLA.
11. Ubalwa njani iingcambu zesikwere kunye ne-cube kwi-Excel
Ukubala iingcambu zesikwere kunye ne-cube kwi-Excel ngumsebenzi olula onokuthi wenziwe ngokusebenzisa iifomyula kunye nemisebenzi ethile. Ngezantsi, ndiza kukubonisa amanyathelo ayimfuneko ukwenza ezi zibalo ngokuchanekileyo nangempumelelo.
Ukubala ingcambu isikwere kwi-Excel, ungasebenzisa umsebenzi SQRT(). Lo msebenzi uthatha impikiswano enye, eli inani ofuna ukubala ngalo ingcambu. Umzekelo, ukuba ufuna ukubala ingcambu ka9, ungasebenzisa ifomula =SQRT(9), kwaye isiphumo siyakuba ngu 3. Kubalulekile ukuqaphela ukuba SQRT () umsebenzi uhlala ubuyisela ixabiso elilungileyo lengcambu.
Ukubala ingcambu ye-cube kwi-Excel, ungasebenzisa umsebenzi CBRT(). Njengo SQRT () umsebenzi, CBRT () umsebenzi uthatha impikiswano enye, elinani ofuna ukubala ngalo ingcambu yetyhubhu. Umzekelo, ukuba ufuna ukubala ingcambu ye-cube ye-27, ungasebenzisa ifomula =CBRT(27), kwaye isiphumo siyakuba ngu 3. Kubalulekile ukukhankanya ukuba CBRT () umsebenzi ubuyisela zombini ixabiso elilungileyo nelibi lengcambu yetyhubhu. Ukufumana kuphela ixabiso elilungileyo, ungasebenzisa i ABS () umsebenzi ukufumana ixabiso elipheleleyo lesiphumo.
12. Ukusebenzisa i-Boost Functions yokuHlalutya kweDatha kwi-Excel
Imisebenzi yamandla kwi-Excel zizixhobo eziluncedo kakhulu zokuhlalutya idatha. Ngale misebenzi, sinokwenza imisebenzi yezibalo yokunyusa amandla ngokukhawuleza nangokufanelekileyo. Okulandelayo, ndiza kukubonisa indlela yokusebenzisa le misebenzi kwi-spreadsheets zakho.
Ukuqala, kufuneka sikhethe iseli apho sifuna ukubonisa isiphumo sesixhasi. Emva koko, sifaka le fomula ilandelayo: = AMANDLA(inombolo, i-exponent). Kwi-"number" kufuneka ufake ixabiso ofuna ukulinyusa kumandla kwaye kwi-"exponent" kufuneka ubhale ixabiso lamandla ofuna ukunyusa inani kuwo.
Ukongeza kumsebenzi WAMANDLA, i-Excel ineminye imisebenzi enxulumeneyo efana ne-POWER.IF, POWER.MATRIX, kunye ne-POWER.ERROR. Le misebenzi ikuvumela ukuba wenze ukunyusa okunemiqathango, ukunyusa uluhlu olupheleleyo, kwaye uphathe iimpazamo, ngokulandelanayo. Ungalibazisi ukuphonononga olu khetho ukwandisa amathuba ohlalutyo kwi-spreadsheets zakho.
13. Ukomelezwa kwi-Excel: izitshixo zokubala ngokuchanekileyo nangobuchule
Ukunika amandla ngumsebenzi wezibalo oxhaphake kakhulu kwizibalo ze-Excel kwaye kunokuba luncedo kakhulu ukwenza lula iifomula kunye nokukhawulezisa iinkqubo. Kweli candelo, siza kukubonisa izitshixo zokwenza ubalo oluchanekileyo nolusebenzayo usebenzisa ukuxhobisa kwi-Excel.
Ukunyusa inani kwi-Excel, ungasebenzisa umsebenzi I-POW okanye umqhubi ^. Umzekelo, ukuba ufuna ukubala u-2 kumandla we-3, ungafaka ifomula =POW(2,3) okanye ngokulula 2^3. Zombini iindlela ziya kukunika isiphumo sesi-8.
Ukuba ufuna ukwenza unyuso ngereferensi yeseli endaweni yenombolo ethile, bandakanya ngokulula ireferensi yeseli kwifomula. Umzekelo, ukuba unenombolo yesi-2 kwiseli A1 kwaye ufuna ukubala u-2 kumandla ka-3, ungasebenzisa ifomula = A1^3. Ngale ndlela, ukuba utshintsha ixabiso kwiseli A1, umphumo wokunyusa uya kuhlaziywa ngokuzenzekelayo.
14. Iindlela ezilungileyo xa unyusela amandla kwi-Excel
Xa uphakamisa amandla kwi-Excel, kubalulekile ukulandela iindlela ezithile ezifanelekileyo zokufumana iziphumo ezichanekileyo kwaye ugweme iimpazamo ezinokwenzeka. Ngezantsi kukho iingcebiso zokuqhuba le nkqubo ngokufanelekileyo.
1. Khetha iseli efanelekileyo: Phambi kokunyusela kumandla, qiniseka ukuba ukhetha iseli echanekileyo apho ufuna ukubonisa khona isiphumo. Oku kunokuba yiseli engenanto okanye enye equlathe inani ofuna ukufaka kulo umsebenzi wonyuso.
2. Sebenzisa umsebenzi WAMANDLA: I-Excel ibonelela ngomsebenzi othile wokunyusa amandla. Ungachwetheza ngokuthe ngqo ifomula kwiseli ekhethiweyo okanye usebenzise umsebenzi kwifomula entsokothileyo. Umzekelo, ukuphinda-phinda inani lesi-2, ungasebenzisa ifomula “= AMANDLA(2, 2)” okanye ngokulula uchwetheze “2^2” kwiseli ekhethiweyo.
3. Jonga iziphumo: Emva kokufaka i-boost, kuyacetyiswa ukuba uqinisekise iziphumo zokuqinisekisa ukuchaneka kwazo. Kuhlala kusenzeka ukwenza iimpazamo xa ufaka ifomula okanye iingxoxo kwi-Excel, ke jonga kabini! Kwakhona, qiniseka ukuba uyaziqonda iindlela i-Excel ebonisa ngayo iziphumo, ezifana nefomathi yamanani okanye ubhalo lwenzululwazi.
Ukuqukumbela, umsebenzi wamandla kwi-Excel umele isixhobo esixabisekileyo sokwenza izibalo zemathematika ngokufanelekileyo nangokuchanekileyo. Ngokudibanisa umsebenzi WAMANDLA kunye neminye imiyalelo ye-Excel kunye neefomula, kunokwenzeka ukuba usebenzise ngokukhawuleza imisebenzi yamandla kuluhlu olubanzi lwedatha.
Ngokulawula eli nqaku, abasebenzisi baya kukwazi ukonga ixesha kunye nomzamo xa bephinda izibalo, ngaloo ndlela beyenza lula imisebenzi yabo yemihla ngemihla. Ukongeza, ukuguquguquka kwe-Excel kuvumela iifomyula ukuba zenziwe ngokwezifiso ngokweemfuno ezithile zomsebenzisi ngamnye, ukufezekisa inqanaba lokuchaneka kunye nobugcisa kwiziphumo ezifunyenweyo.
Okubalulekileyo, njengawo nawuphi na umba we-Excel, ukuqonda okuqinileyo kwemigaqo esisiseko yespredishithi kunye nemisebenzi yesicelo ibalulekile. Ke ngoko, singacebisa ukuba abasebenzisi abanomdla ekuphononongeni ubunakho bokunyuselwa kumsebenzi wamandla kwi-Excel bachithe ixesha befunda kwaye baziqhelanise nezinto ezinokwenzeka ezahlukeneyo ezinikezelayo.
Ngale nto, baya kukwazi ukusebenzisa ngokupheleleyo oku kusebenza kwaye basebenzise njengesixhobo esithembekileyo sokusombulula iingxaki zemathematika ezintsonkothileyo, ukuphucula ukusebenza kakuhle. emsebenzini y ukwandisa imveliso ekuphatheni idatha yamanani. Ngamafutshane, umsebenzi wokunyusa amandla kwi-Excel umele isixhobo esixabisekileyo yabasebenzisi abafuna indlela yobugcisa nesebenzayo kwimisebenzi yabo yokubala yemathematika.
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.