OkwangokuI-Excel ibe sisixhobo esisisiseko sayo nayiphi na ingcaphephe efuna ukunyusa imisebenzi yayo kunye nohlalutyo lwedatha. Phakathi kwemisebenzi emininzi eyinikezelayo le nkqubo, kukho ukhetho lokujikeleza amaxabiso, okubaluleke kakhulu xa usebenza ngamanani achanekileyo. Kweli nqaku, siza kuphonononga ngokweenkcukacha indlela yokujikeleza kwi-Excel kunye neendlela ezahlukeneyo ezikhoyo zokuqinisekisa ukujikeleza ngokweemfuno zethu zobugcisa.
1. Intshayelelo yokusondeza kwi-Excel: iziseko kunye nezicelo
Ukujikeleza linqaku elibalulekileyo kwi-Excel elisivumela ukuba sihlengahlengise amaxabiso amanani ukuya kwinani elifunekayo ledesimali. Kweli candelo, siza kuphonononga iziseko zokusondeza kwi-Excel kunye nezicelo zayo ezahlukeneyo kwizicwangciso zobungcali kunye nezifundo. Siza kufunda indlela yokusebenzisa lo msebenzi ngempumelelo ukuphucula izibalo zethu kunye nokunikezela ngolwazi oluchanekileyo.
Okokuqala, kubalulekile ukuqonda indlela ukusondeza kusebenza ngayo kwi-Excel. Umsebenzi wokurhangqa usetyenziselwa ukunyenyisa inani kwinani elichaziweyo lamasuntswana wokugqibela. Umzekelo, ukuba sifuna ukurhangqa inani elingu-3.1459 ukuya kwiindawo ezimbini zedesimali, i-Excel iya kusinika ixabiso elingqukuva elingu-3.15. Oku kunokuba luncedo ngakumbi xa sisebenza ngamanani amakhulu okanye xa sifuna ukwenza izibalo zethu zilawuleke ngakumbi.
Ukongeza kwisicelo sayo esisisiseko, ukujikeleza kwi-Excel kusenokusetyenziswa kwiimeko ezahlukeneyo. Umzekelo, ukujikelezisa ngokuqhelekileyo kusetyenziswa kwi-accounting ukulungelelanisa amaxabiso emali kwiindawo ezimbini zedesimali. Kwakhona kunokuba luncedo kuhlalutyo lwedatha, apho kudla ngokuyimfuneko ukubonisa iziphumo kunye nenani elithile lamadijithi abalulekileyo. Ukwazi usetyenziso olwahlukeneyo lokusondeza kuya kusivumela ukuba siwusebenzise kakhulu lo msebenzi kwimisebenzi yethu yemihla ngemihla.
2. Isivakalisi esisisiseko samaxabiso ajikelezayo kwi-Excel
Sisixhobo esiluncedo kakhulu sokufumana iziphumo ezichanekileyo nezithandekayo kwi-spreadsheets zethu. Excel isinika iindlela ezahlukeneyo zokujikeleza amaxabiso ngokuzenzekelayo, nangona kunjalo, kubalulekile ukwazi i-syntax esisiseko ukuze ukwazi ukulungelelanisa nokwenza ezi ziphumo ngokweemfuno zethu.
Eyona ndlela iqhelekileyo yokusondeza ixabiso kwi-excel ngumsebenzi we-Round. Lo msebenzi uthatha njengengxoxo yenani esifuna ukurhangqa kunye nenani leendawo zedesimali apho sifuna ukuqikelela isiphumo. Umzekelo, ukuba sinalo inani u-12.3456 kwaye sifuna ukulisondeza kwindawo ezimbini zedesimali, singasebenzisa ifomula. =UMJIKELO(12.3456,2). Esi siphumo sizakubuya ngo-12.35, kuba idesimali yesithathu inkulu kuno okanye ilingana no-5.
Ukongeza kumsebenzi we-ROUND, i-Excel ikwabonelela nangeminye imisebenzi ehambelanayo efana ne-ROUNDUP kunye ne-ROUNDDOWN. Le misebenzi isivumela ukuba sirhangqe inani phezulu okanye phantsi, ngokulandelelanayo. Umzekelo, ukuba sinalo inani u-12.3456 kwaye sifuna ukulisondeza lifike kwindawo ezimbini zedesimali, singasebenzisa ifomula. =ROUNDUP(12.3456,2). Esi siphumo sizakubuya ngo 12.35, kuba idesimali yesithathu inkulu kuno okanye ilingana no 5, kwaye sifuna ukusondeza.
3. Uwusebenzisa njani umsebenzi we-ROUND kwi-Excel
Umsebenzi we-ROUND kwi-Excel sisixhobo esiluncedo kakhulu sokuhlengahlengisa amaxabiso eseli kwinani elithile ledesimali. Inokuba luncedo ngakumbi kwiimeko apho sifuna iziphumo ezichanekileyo kwimisebenzi yethu yezibalo. Apha siza kukubonisa Inyathelo nenyathelo Uwusebenzisa njani lo msebenzi kwi-spreadsheets zakho:
1. Khetha iseli ofuna ukufaka kuyo umsebenzi we-ROUND.
2. Chwetheza okubhaliweyo kulandelayo kwibha yefomula: =REDONDEAR(
3. Okulandelayo, faka inombolo okanye iseli ofuna ukuyisonga. Umzekelo, ukuba ufuna ukurhangqa ixabiso kwiseli A1, ungachwetheza A1.
4. Chaza inani leendawo zedesimali ofuna ukurhangqa ixabiso kuzo. Umzekelo, ukuba ufuna ukurhangqa kwiindawo ezimbini zedesimali, ungachwetheza ,2) ekupheleni kwefomula.
5. Cinezela iqhosha elithi Faka kwaye iseli iya kubonisa ixabiso elirhangqwe ngokweeparamitha ezikhankanyiweyo.
Khumbula ukuba ungasebenzisa umsebenzi we-ROUND ngokudibanisa neminye imisebenzi ye-Excel, efana ne-ADD okanye i-SUBTRACT. Oku kukuvumela ukuba wenze izibalo ezintsonkothileyo ngamaxabiso angqukuva. Zama ngamaxabiso ahlukeneyo kunye nedecimals ukuze ufumane iziphumo ezinqwenelekayo kwi-spreadsheets zakho.
4. Ukusondeza kwi-Excel: imiyalelo yesinyathelo ngesinyathelo
Ukusondeza kwi-Excel, kukho iindlela ezininzi zokuyenza. Ngezantsi kukho imiyalelo yenyathelo nenyathelo lokwenza olu hlobo lokurhangqa kwi-spreadsheet sakho.
1. Sebenzisa i-ROUND.CEILING umsebenzi: Lo msebenzi ujikeleza inani kwinani elikufutshane lomzobo othile. Ukusondeza, kufuneka uchaze inani kunye nokuphindaphinda ofuna ukurhangqa kuzo. Umzekelo, ukuba ufuna ukusondeza kuphinda-phindo olukufutshane lwe-10, ungasebenzisa ifomula =ROUND.CEILING(A1,10).
2. Sebenzisa umsebenzi onguMJIKELO: Ukuba ufuna ukusondeza kwelona nani lilonke likufutshane, ungasebenzisa umsebenzi ongu- RUND. Lo msebenzi uza kurhangqa inani elikufutshane kwelona nani liphezulu liphelele, nokuba leliphi ixabiso lokugqibela. Ifomyula iya kuba = RUND(A1,0).
5. Ukusondeza kwi-Excel: imizekelo ebonakalayo
Ukusondeza kwi-Excel, kukho iindlela ezahlukeneyo ezinokusetyenziswa ngokuxhomekeke kwiimfuno zomsebenzisi. Ngezantsi, imizekelo ebonakalayo kunye necacileyo yendlela yokusebenzisa lo msebenzi kwi-spreadsheet iya kuboniswa.
Ukusebenzisa umsebenzi we FLOOR
Indlela elula yokunciphisa kukusebenzisa umsebenzi UMGAQO ye-Excel. Lo msebenzi ikuvumela ukuba urhangqe inani ukuya kwelona xabiso liphantsi lilandelayo. Ukuyisebenzisa, kufuneka ukhethe iseli apho ufuna ukufaka khona isiphumo kwaye ubhale le fomula ilandelayo:
=UMPHANDI(inani, [ukubaluleka])
Phi inombolo lixabiso ofuna ukulisangqa kwaye ukubaluleka linani lokugqibela ofuna ukurhangqa kulo. Umzekelo, ukuba sifuna ukurhangqa inani u-3.76 ukuhla ukuya kwelona nani lilonke likufutshane, singasebenzisa le fomula ilandelayo:
=UMGANGATHO(3.76, 1)
Ukusebenzisa umsebenzi weTRUNCATE
Enye indlela eluncedo yokusondeza kwi-Excel kukusebenzisa umsebenzi NQUMA. Lo msebenzi ususa indawo yokugqibela yenani ngaphandle kokuyirhangqa.
Ukusebenzisa lo msebenzi, kufuneka ukhethe iseli apho ufuna ukubonisa khona isiphumo kwaye ubhale ifomula:
=TRUNCATE(inani, [iidesimali])
Phi inombolo lixabiso ofuna ukulicutha kwaye iidesimali linani leedesimali ofuna ukuzisusa. Umzekelo, ukuba sifuna ukunciphisa inani u-4.72 ukubonisa kuphela iindawo ezimbini zokuqala zedesimali, le fomula ilandelayo iya kusetyenziswa:
= TRUNIKA(4.72, 2)
Ukusebenzisa ukufomatha okulungiselelweyo
Ukongeza kwimisebenzi ekhankanyiweyo, kuyenzeka kwakhona ukurhangqa kwi-Excel usebenzisa ukufomatha ngokwesiko. Ukwenza njalo, kufuneka ukhethe iseli apho ufuna ukubonisa khona umphumo, cofa iqhosha lemouse ekunene kwaye ukhethe u-"Fomatha iiseli" ukhetho.
Emva koko, kufuneka ucofe kwithebhu ethi "Inombolo" kwaye ukhethe ukhetho "lweSiko". Kwindawo ethi "Uhlobo", le fomati ilandelayo kufuneka ifakwe:
0
Le fomati iyakurhangqa inani ukuya kutsho kwelona nani lilonke likufutshane. Umzekelo, ukuba sifuna ukurhangqa inani elingu-6.9, liza kuboniswa njengo-6.
6. Ukusondeza kwinani elithile ledesimali kwi-Excel
Omnye wemisebenzi eqhelekileyo kwi-Excel kukurhangqa inani ukuya kwinani elithile ledesimali. Ngamanye amaxesha kuyimfuneko ukunciphisa ukuchaneka kwamaxabiso ukwenza lula ukubonwa okanye ukubala. Kweli nqaku, uya kufunda indlela yokujikeleza amanani kwi-Excel usebenzisa iindlela ezahlukeneyo kunye nemisebenzi.
1. Ukujikeleza nge-RAUND function: Umsebenzi we-ROUND ngomnye wemisebenzi esetyenziswa kakhulu ukujikeleza amanani kwi-Excel. Ngalo msebenzi, ungakhankanya inani leendawo zedesimali ofuna ukurhangqa kuzo. Umzekelo, ukuba unenombolo engu-12.3456 kwaye ufuna ukuyisondezela kwiindawo ezimbini zedesimali, usebenzisa le fomula ilandelayo: =ROUND(12.3456, 2). Isiphumo siya kuba yi-12.35.
2. Ukusondeza phezulu okanye ezantsi: Ngamanye amaxesha, kufuneka usondeze inani phezulu okanye ezantsi, nokuba indawo yesishumi inkulu okanye ingaphantsi ko-5. Ukwenza oku, ungasebenzisa i-ROUNDUP kunye ne-ROUNDDOWN imisebenzi ngokulandelelanayo. Umzekelo, ukuba unenombolo 8.3 kwaye ufuna ukuyisonga, usebenzisa ifomula: =ROUNDUP(8.3, 0). Isiphumo siya kuba ngu-9. Ngokufanayo, ukuba ufuna ukuyisonga phantsi, usebenzisa ifomula: =ROUNDDOWN(8.3, 0). Isiphumo siya kuba yi-8.
7. Indlela yokusondeza kwelona nani likufutshane kwi-Excel
Ukusondeza kwinani elikufutshane kwi-Excel yinto esetyenziswa ngokuqhelekileyo xa sisebenza ngedatha yamanani kwaye sifuna ukuwenza lula kwixabiso elilawulekayo. Ngethamsanqa, i-Excel isinika umsebenzi othile wale njongo. Okulandelayo, ndiza kuchaza indlela yokuyisebenzisa:
1. Okokuqala, khetha iseli apho ufuna ukufaka khona ukurhangqa kwaye ucofe kuyo ukuze uyiqaqambise.
2. Emva koko, yiya kwibha yefomula ye-Excel kwaye uthayiphe "=" kulandelwa igama lomsebenzi ojikelezayo, kulo mzekelo "ROUND". Umzekelo, ukuba ufuna ukurhangqa inani kwiseli A1, ifomula kufuneka iqale ngo “=ROUND(A1”).
3. Okulandelayo, chwetheza isiphumlisi “,” kwaye ukhethe inani ledesimali ofuna ukurhangqa kuyo. Umzekelo, ukuba ufuna ukurhangqa kwiindawo ezimbini zedesimali, chwetheza "2." Ifomula epheleleyo iya kujongeka ngolu hlobo: «=UMJIKELO(A1,2)».
8. Ukusondeza ngokwemiqathango kwi-Excel: indlela yokusebenzisa umsebenzi we-RANDIM
Kwi-Excel, umsebenzi we-RANDIM usetyenziselwa ukuvelisa amanani angaqhelekanga phakathi kwe-0 kunye no-1. Kodwa kuthekani ukuba ufuna ukuvelisa amanani angaqhelekanga aziphindaphinda ngo-5? Apha kulapho ujikelezo olunemiqathango kwi-Excel luqala khona. Ngobu buchule, ungarhangqa amanani aveliswe ngumsebenzi we-RANDIM ukuya kuphinda-phindo olukufutshane lwesi-5.
Okulandelayo, ndiza kukubonisa indlela yokusebenzisa umsebenzi we-RANDOM kunye nokujikeleza okunemiqathango kwi-Excel inyathelo ngenyathelo:
1. Kwiseli engenanto, chwetheza "=RANDOM()". Le fomyula iyakuvelisa inani elingaqhelekanga phakathi kwe-0 kunye ne-1.
2. Okulandelayo, khetha iseli apho ubhale khona ifomula kwaye ucofe ekunene. Kwimenyu eyehlayo, khetha u-"Fomatha iiseli."
3. Kwifestile yefomathi yeseli, khetha ithebhu "Inombolo". Kuluhlu lweendidi, khetha "Custom."
4. Kwindawo ethi “Type”, chwetheza “0;-0;;@” uze ucofe “Kulungile.”
Nje ukuba ulandele la manyathelo, iseli izakubonisa inani elingenamkhethe eliya kujikelezwa kuphinda-phindo olukufutshane lwesi-5. Ukuba ufuna ukuvelisa amanani amaninzi angaqhelekanga, khuphela nje ifomula kwezinye iiseli.
Khumbula ukuba ukujikeleza okunemiqathango kwi-Excel kunokuba luncedo kwiimeko apho kufuneka uvelise amanani angaqhelekanga ahambelana nezithuba ezithile okanye iipateni ezithile. Zama ngeefomula ezahlukeneyo kwaye ufumane esona sisombululo silungileyo kwimeko yakho!
9. Amaqhinga kunye neengcebiso zokusondeza amaxabiso kwi-Excel
Xa usebenza ngamaxabiso amanani kwi-Excel, kuqhelekile ukufumana imfuneko yokujikeleza la maxabiso ukuze ufumane iziphumo ezichanekileyo. Kweli candelo, siya kukubonelela iingcebiso namaqhinga oko kuya kukunceda ukusondeza amaxabiso kwi-Excel ngendlela elula nesebenzayo.
Ukuqala, enye yeendlela eziqhelekileyo zokurhangqa amaxabiso kwi-Excel ngumsebenzi we-ROUND. Lo msebenzi usivumela ukuba sirhangqe ixabiso ukuya kwinani elithile lamasuntswana. Umzekelo, ukuba sifuna ukurhangqa inani elingu-3.14159 ukuya kwezi-2 iindawo zesishumi, sinokusebenzisa ifomula. ROUND(3.14159, 2). Eli xabiso liya kujikelezwa ku-3.14.
Elinye iqhinga eliluncedo lokurhangqa amaxabiso kwi-Excel kukusetyenziswa koMPHANTSI kunye nemisebenzi yeCEILING. Umsebenzi onguMPHANTSI uyasivumela ukuba sirhangqe inani ezantsi kwinani elipheleleyo elikufutshane okanye ezantsi kuphinda-phindo olukufutshane lokubaluleka. Kwelinye icala, umsebenzi weCEILING urhangqa inani ukuya kutsho kweyona intembu ikufutshane okanye ukuya kutsho koyena phinda-phinda wokubaluleka. Le misebenzi iluncedo ngakumbi xa kufuneka sihlengahlengise amaxabiso ngokwemigaqo ethile yokurhangqa.
10. Ukubaluleka kokuseta ukufomatha okufanelekileyo emva kokusondeza kwi-Excel
Xa usebenza ngedatha yamanani kwi-Excel, ngokuqhelekileyo kufuneka ujikeleze iziphumo zeefomula okanye imisebenzi. Nangona kunjalo, kubalulekile ngokulinganayo ukuseka ukufomatha okufanelekileyo emva kokusondeza ukuze kuqinisekiswe ukuchaneka kunye nokunikezelwa kwedatha. Kweli candelo, siza kuphonononga ukubaluleka kweli nyathelo kunye nendlela yokufezekisa ngokuchanekileyo. ngempumelelo.
Nje ukuba usondeze eyakho idatha kwi-excelNokuba usebenzisa umsebenzi we-ROUND okanye nayiphi na enye ifomula, kubalulekile ukuba uhlengahlengise ukufomatha kweeseli ukubonisa ngokuchanekileyo inani elingqukuva. Ukwenza oku, khetha iiseli eziqulethe idatha ejikeleziweyo kwaye usebenzise ukufomatha inombolo efanelekileyo. Ngokomzekelo, ewe idatha yakho bonisa izixa zemali, ungakhetha uhlobo lwemali.
Okubalulekileyo, ngokuseka ukufomatha okufanelekileyo emva kokujikeleza, unokunqanda ukungaqondani kunye neempazamo xa ubonisa iziphumo zakho kwabanye. abanye abantu. Ukongeza, ukufomatha okufanelekileyo kukwaphucula ukufundeka kunye nokuqonda idatha ye wena. Umzekelo, ukuba usebenza ngezixa ezincinci zedesimali, ukuseta ifomathi yenani ledesimali kwinani elithile ledesimali kunokukunceda ubonise idatha ngokucacileyo nangokuchanekileyo ngakumbi.
11. Usetyenziso olukwinqanaba eliphezulu lokusondeza kwi-Excel: izibalo zemali kunye nezibalo
Ukujikeleza luphawu olubalulekileyo kwi-Excel, ngakumbi xa kufikwa kwizibalo zemali kunye nezibalo. Kweli candelo, siza kuphonononga ezinye izicelo eziphambili zokusondeza kwi-Excel kunye nendlela enokunceda ngayo ekuphatheni idatha echanekileyo yamanani.
Esinye sezona zicelo zixhaphakileyo zokusondeza kwi-Excel kukubalo lwemali. Xa usebenza ngamanani emali, kubalulekile ukuqinisekisa ukuba iziphumo zichanekile kwaye zijikelezwe ngokufanelekileyo. Umzekelo, ukuba sibala inzala okanye iintlawulo zenyanga kwimali-mboleko, ukusondeza okufanelekileyo kungenza umahluko. I-Excel inikezela ngemisebenzi emininzi yokujikeleza, njenge-ROUND, ROUND.PLUS, ROUND.MINUS, phakathi kwezinye, ezikuvumela ukuba ulungelelanise iziphumo ngokweemfuno ezithile.
Ukongeza, ukusondeza kukwabalulekile kuhlalutyo lwamanani. Kwiimeko ezininzi, idatha eqokelelweyo inokuqulatha i-decimals okanye amaxabiso achanekileyo angeyomfuneko kuhlalutyo. Ukusebenzisa ukusondeza okufanelekileyo kunokwenza lula idatha kwaye yenze kube lula ukuyitolika. Umzekelo, xa usenza iigrafu okanye imizobo, kuyacetyiswa ukuba ujikeleze amaxabiso ukunqanda ukugcwala okubonakalayo kunye nokuphucula ukuqonda kweziphumo. I-Excel ibonelela ngemisebenzi efana ne-ROUNDMULTIPLE kunye ne-ROUNDDEFAULT, enceda kwezi meko ngokulungelelanisa amaxabiso kwii-multiples ezithile okanye ngokusondeza okanye ukuhla, ngokulandelanayo.
12. Iimpazamo eziqhelekileyo xa usondeza kwi-Excel kunye nendlela yokuziphepha
Xa usebenza ngamanani kwi-Excel, kuyinto eqhelekileyo ukuba ujikeleze amaxabiso ukuze ufumane ucoceko kwaye kulula ukutolika iziphumo. Nangona kunjalo, ukusondeza kwi-Excel kunokubangela iimpazamo ukuba akwenziwanga ngokuchanekileyo. Ngezantsi kukho ezinye.
- Ukusondeza okungalunganga: Enye yeempazamo eziqhelekileyo xa ukusondeza kwi-Excel kwenzeka xa umsebenzi we-ROUND usetyenziswa ngokungalunganga. Kubalulekile ukuqonda ukuba lo msebenzi usebenza njani kunye nendlela yokukhetha idesimali ezifanelekileyo ukunqanda iimpazamo. Kuyacetyiswa ukuba usebenzise umsebenzi we-ROUND kunye nenani elifunekayo leendawo zedesimali ukuqinisekisa ukuba amaxabiso arhangqwe ngokuchanekileyo.
- Impazamo yokuchaneka: Enye impazamo eqhelekileyo kukuphulukana nokuchaneka xa usondezwa kwi-Excel. Oku kwenzeka xa amanani aneendawo ezininzi zedesimali esetyenziswa kwaye asondezwa kwinani elincinane leendawo zedesimali. I-Excel inokucutha amaxabiso kwaye ingawajikelezi ngokuchanekileyo. Ukunqanda le mpazamo, kuyacetyiswa ukuba usebenzise ifomathi efanelekileyo yamaxabiso kwaye usete ukuchaneka okufunayo phambi kokurhangqwa.
- Ukusondeza okungafanelekanga kwemisebenzi: Xa usebenzisa ukusondeza kwi-Excel ukwenza izibalo ngemisebenzi, kubalulekile ukuqonda ukuba le misebenzi iwaphatha njani amanani ajikelezileyo. Eminye imisebenzi inokuchatshazelwa kukusondeza kwaye inokunika iziphumo ezingachanekanga. Kwezi meko, kuyacetyiswa ukujikeleza amaxabiso kuphela ekupheleni kwazo zonke izibalo ukuthintela iingxaki zokuchaneka.
Ngamafutshane, kubalulekile ukuba uqaphele ezi mpazamo ziqhelekileyo xa usondeza kwi-Excel kwaye uthathe amanyathelo okuziphepha. Ukusebenzisa umsebenzi we-ROUND ngokuchanekileyo, ukuphepha ukulahleka kokuchaneka, kunye nokuqonda indlela ukujikeleza okuchaphazela ngayo imisebenzi ngamanyathelo abalulekileyo okufumana iziphumo ezichanekileyo nezithembekileyo kwi-Excel.
13. Uyenza njani i-automate ukujikeleza kwi-Excel kunye nee-macros zesiko kunye neefomyula
Ukujikeleza ngokuzenzekelayo kwi-Excel kunokuba ngumsebenzi oluncedo kakhulu kwaye osebenzayo, ngakumbi xa usebenza ngemithamo emikhulu yedatha. Ngethamsanqa, i-Excel ibonelela ngeendlela ezininzi zokusebenzisa le nkqubo, njengokusebenzisa ii-macros kunye neefomyula zesiko. Amanyathelo ayimfuneko ukwenza oku kuzenzekelayo kuya kuchazwa ngezantsi.
1. Ukusetyenziswa kweefomyula eziqhelekileyo: I-Excel ivumela ukudalwa kweefomyula eziqhelekileyo ukuya kumanani ajikelezayo ngokweemfuno zethu ezithile. Umzekelo, ukuba sifuna ukusondeza inani kwinani elipheleleyo elikufutshane, sinokusebenzisa ifomula =UKURUNGQONGA.PHANTSI(A1,0), apho u-A1 yiseli equlathe inani esifuna ukulisangqa. Ukuba sifuna ukusondeza kuphinda-phindo olukufutshane luka-0.5, singasebenzisa ifomula =UMJIKELO(A1*2,0)/2. Ezi fomyula zinokusetyenziswa kwiiseli eziyimfuneko ngesandla, kodwa zinokusetyenziswa ngokudibeneyo kunye ne-macros ukwenza inkqubo ngokuzenzekelayo.
2. Ukwenza iimakhro: Imakhro lulandelelwano lwemiyalelo okanye imiyalelo enokurekhoda ize idlalwe kamva kwi-Excel. Ukujikeleza ngokuzenzekelayo, sinokwenza i-macro eyenza imisebenzi efunekayo kwiiseli ezikhethiweyo. Umzekelo, sinokurekhoda i-macro esebenzisa ifomyula yesiko lokurhangqa ekhankanywe ngasentla kwi-a uluhlu lweeseli ethile. Sinokuthi ke sinikeze isinqumli se-keyboard okanye iqhosha kwi-macro ukuyiqhuba ngokukhawuleza nangaliphi na ixesha. Ngale ndlela, ukusondeza kuya kwenziwa ngokuzenzekelayo ngalo lonke ixesha siqhuba i-macro.
14. Umahluko ophambili phakathi kwe-ROUND, ROUND.MINUS kunye ne-TRUNCATE imisebenzi kwi-Excel
Kwi-Excel, kuqhelekile ukudibana nesidingo sokurhangqa amanani okanye ukunciphisa amaxabiso. Ukwenza le misebenzi, i-Excel ibonelela ngemisebenzi emithathu engundoqo: Round, RUND.MINUS kunye neTRUNCATE. Nangona zisebenza injongo efanayo, kukho umahluko ophambili phakathi kwazo obalulekileyo ukuphawulwa.
- Round OUT: Lo msebenzi ujikeleza inani kwinani elikufutshane elipheleleyo. Ukuba idesimali iyalingana okanye inkulu kuno-0.5, inani lifinyezwa kwinani elipheleleyo elilandelayo eliphezulu; Ukuba ingaphantsi kwe-0.5, isondezwa kwinani elipheleleyo elikufutshane.
- UMJIKELISO.MINUS: Ngokungafaniyo ne-ROUND, lo msebenzi usoloko ujikeleza inani kwinani elipheleleyo elikufutshane. Oko kukuthi, ukuba kukho idesimali engaphantsi kwe-0.5, iyakususwa nokuba ingaphezulu okanye ingaphantsi kwe-0.5.
- TINQA: I-TRUNCATE isusa ngokulula indawo yesishumi yenani, ngaphandle kokusondeza. Oku kuthetha ukuba inani elifinyeziweyo liyakuhlala lingaphantsi okanye lilingana nelokuqala.
Kubalulekile ukugcina ezi yantlukwano engqondweni xa usebenzisa ezi imisebenzi kwi-excel, njengoko zinokuchaphazela iziphumo zokubala. Umzekelo, ukuba ukusondezwa okuchanekileyo kuyafuneka, i-ROUND.MINUS ayisayi kuba ngumsebenzi ofanelekileyo. Kwelinye icala, ukuba ujonge ukususa ngokulula idesimali ngaphandle kwesidingo sokurhangqa, I-TRUNCATE iya kuba lolona khetho lulungileyo.
Ukuqukumbela, ukusondeza kwi-Excel sisixhobo esisisiseko sokuqinisekisa ukuchaneka nokuthembeka kwizibalo zamanani ezenziweyo. kwiphepha yokubala. Ngomsebenzi we-ROUND, i-ROUNDUP, kunye ne-ROUNDDOWN, abasebenzisi banokuhlengahlengisa amaxabiso kwinani elifunekayo leendawo zedesimali kwaye baqinisekise ukuba iziphumo ziyahambelana kwaye zichanekile.
Kubalulekile ukuba uqaphele imithetho yokusondeza kwaye uqonde ukuba ichaphazela njani amanani aphakathi kunye nama-negative amanani, kunye nokunyuka nokuhla kwamaxabiso. Oku kuya kusivumela ukuba senze izigqibo ezinolwazi malunga nendlela yokujikeleza ngokufanelekileyo idatha.
Ukongeza, i-Excel isinika ithuba lokusebenzisa ukujikeleza okunemiqathango, okusivumela ukuba siseke iindlela ezithile zokujikeleza amanani ngokweemfuno zethu. Olu phawu luluncedo ngakumbi xa usebenza ngeeseti ezinkulu zedatha kwaye ufuna ubhetyebhetye olukhulu kwinkqubo yokurhangqa.
Ngamafutshane, ukufunda ukujikeleza kwi-Excel kusinika inzuzo enkulu xa sisebenza ngamanani kwaye sisenza izibalo ezichanekileyo. Ukwazi kakuhle le misebenzi kuya kusinceda siphephe iimpazamo kwaye sibonise ulwazi ngendlela ecacileyo neqondakalayo.
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.