Uzibeka njani iidesimali kwi-Excel? Kule tutorial sikushiya onke amanyathelo kunye nezinye iinkcukacha.
Ngokuqinisekileyo, ngoku kufuneka uqaphele ukuba i-Excel sesinye sezona zixhobo ziphumeleleyo kwihlabathi zokucwangcisa, ukuhlula kunye nokudala i-spreadsheets, kungekhona nje ngokuba inenani elimangalisayo lemisebenzi. Kodwa ngenxa yokuba ngaphakathi kwayo, sinokuqhuba naluphi na uhlobo lomsebenzi kunye neeprojekthi, ngaphandle kwesidingo sokuba neengcali ngaphakathi kwe-interface.
Kananjalo, kuya kufuneka uyazi ukuba kwakule nkqubo inye sinokwenza imisebenzi yedesimali, eluncedo kakhulu kwimimandla ye-accounting kunye nolawulo, nokuba kungomsebenzi, ishishini okanye nje njengesabelo saseyunivesithi. Ngaphakathi kwe-Excel sinokubeka iidesimali, Ngaphandle komgudu omkhulu.
Ngoku, ukuba usazi kwaye ufunde malunga neenzuzo ezimangalisayo ze-Excel, ukongeza kuyo yonke imisebenzi equlethweyo, siya kukwenzela lula umsebenzi. ndiyakufundisa indlela yokubeka idecimals kwi-Excel, ngokungathi uyincutshe.
Iindlela zokubeka idecimals kwi-Excel
Kuloo nto kufuneka sikuxelele, ukuba kukho iindlela ezahlukeneyo, esinokuthi ngazo Yongeza amanani wokugqibela kwiphepha le-excel, ezo ndlela zifanayo, sizichaza kuwe inyathelo ngenyathelo. Zeziphi ezi zilandelayo:
Ngenisa ifomula kwikholamu ehambelanayo
Le yindlela yokuqala, esiya kukufundisa ngayo ukuba ukwazi ngenisa idesimali kwiphepha le-Excel, ukwenza oku kufuneka ulandele imiyalelo esikushiyela yona ngoku. Zezi zilandelayo:
- Njengenyathelo lokuqala, kuya kufuneka uvule i-Excel spreadsheet.
- Emva koko kufuneka ufake amaxabiso amanani ajikelezileyo, ngalinye lingaphakathi kwiseli nganye. Njengesindululo, kungcono ukuba ufake amanani, onke ngaphakathi kwikholamu enye, oko kuya kwenza ukuba kube lula ukwenza indlela.
- Kwikholamu yesibini, kufuneka udibanise le fomyula ilandelayo "= round (A1,N)". Ngelo xesha, kufuneka ubuyisele u-“N” kwifomula ngenani lokugqibela, ofuna ukulongeza.
- Kwimiqolo elandelayo, akuyi kuba yimfuneko ukuba uphinde ubhale ifomula, kuba unokutsala kwaye uyilahle kwiiseli ezilandelayo, kude kube yile yokugqibela uceba ukuyisebenzisa. Ungasebenzisa kwakhona ukhetho lokukhuphela kunye nokuncamathisela, xa zikwikholamu efanayo.
- Umzekelo: “=Umjikelo (A1,8)”
Kuko konke! Ngaloo ndlela uya kuba ufunde inqaku indlela yokuqala yokubeka idesimali kwi-Excel.
Beka idesimali kwi-Excel ngaphandle kwefomula
Nguwo enye indlela eyaziwayo, kuba ngenisa idesimali kwi-ExcelNgenxalenye yayo, oku akufuni iifomyula ukuba zisebenze kwaye oku, sikushiya noluhlu olupheleleyo lwamanyathelo, olu lulandelayo:
- Kuqala ngenisa amaxabiso amanani amanani owafunayo kwiseli nganye.
- Emva koko kufuneka ukhethe enye okanye zonke.
- Okulandelayo kuya kufuneka uye kwithebhu "ekhaya".
- Emva koko, kufuneka usebenzise amaqhosha "ukunciphisa okanye ukwandisa" inani leeseli ezikhethiweyo ngedijithi enye. Ngaloo ndlela iya kube ilungile.
Ngokunjalo uya kuba sele ukwazi beka idesimali kwi-Excel ngaphandle kokusebenzisa ifomula.
Beka idesimali kwi-Excel usebenzisa umsebenzi weTruncate, kwiidesimali ngaphandle kwemijikelo
Kufuneka sivume ukuba iindlela zangaphambili zisekelwe kuphela kwindlela eqhelekileyo, evumela ukuba sinyuse okanye sinciphise inani, kuxhomekeke ekubeni idesimali ingaphezulu okanye ingaphantsi kwesi-5.
Ngale ndlela, amanani edesimali ashiyekileyo aya kususwa ngokuzenzekelayo, kungajongwanga ukusondezwa kwe-symmetrical Ukwenza oku, sinala manyathelo alandelayo:
- Ngaphakathi kwiseli engenanto, kufuneka sibhale le fomula ilandelayo: “=TRUNCATE(A1;N)” sicingela ukuba ibhokisi A! Kulapho inani lokugqibela likhoyo kwaye u-“N” linani lamasuntswana esifuna ukuwabona kwi-spreadsheet.
- Okulandelayo kufuneka sicinezele iqhosha elithi "enter" kwaye yindlela esigqiba ngayo.
Yiyo loo nto, ngoko sifumana enye indlela yokubeka idecimals kwi-Excel.
Iidesimali ezijikelezayo kwi-Excel. (Amanqaku aphambili ekufuneka eqwalaselwe)
Kuya kufuneka uyazi ukuba beka idesimali kwi-Excel, ayingomsebenzi unzima okanye unzima, ngoku ukurhangqa ezi decimals, ungasebenzisa zonke iindlela esikushiye ngazo ngasentla. Kwaezo unokubhenela kuzo, ukuba ukunqongophala kweedesimali akuyongxaki kuwe.
Kwakhona, kufuneka wazi ukuba imisebenzi yokurhangqa idesimali ngaphakathi kwe-Excel ilawulwa ngumthetho othile, apho sixelelwa ukuba idijithi yokugqibela yenani ledesimali likhulu kuno-5, inani liyanyuswa a 1. Ngakolunye uhlangothi, ukuba elo nani liphela kwidesimali ngexabiso elingaphantsi ko-5, ngoko ke inani elisisiseko lihleli, linexabiso langoku.
Ezinye izicelo ezisivumela ukuba senze imisebenzi ngeedesimali
Kwimeko engakholelekiyo ukuba I-Excel ayisiyonkqubo ubuyijonga ngenene ukwenza izibalo zakho ngeedesimali, sikushiyela ezinye iindlela, onokuzisebenzisa ngoko nangoko, ukuze ukwazi ukubeka idesimali. Ezo zezi zilandelayo:
1. Uphawu
Esi sisixhobo sokubala esikwi-intanethi, apho sinokwenza zonke iintlobo zemisebenzi yealjibra, ukusuka kweyona ilula ukuya kweyona intsonkothileyo.
Ungasebenzisa le calculator xa ufikelela kwiqonga layo lewebhu https://es.symbolab.com/solver/decimals-calculator, isimahla kwaye unokufumana uninzi lwezinto ezimangalisayo.
Ukongeza, kuluncedo kakhulu xa usenza naluphi na ukudibanisa, ukuthabatha, ukuphinda-phinda okanye ukwahlula idesimali, ngaphandle kwesidingo sokubhala phantsi okanye ukugcina idatha, into nje ngalo mzuzu.
2. DivPad: Mathematika inyathelo ngenyathelo
Oku, ngokwenxalenye yayo, sisicelo esikhoyo senkqubo yokusebenza ye-Android, apho unokwenza zonke iintlobo zemisebenzi yemathematika, kubandakanywa nokusebenza kwedesimali, kwimizuzu embalwa.
Ukuba ufuna ukubala okanye ufumane iakhawunti, ngokuchanekileyo nangokukhawuleza, esi sicelo seselfowuni sesona kufuneka usisebenzise.
3. Ikhaltyhuleyitha yokwahlula (kunye nentsalela okanye idesimali)
Oku, ngokwenxalenye yayo, sisicelo senkqubo yokusebenza ye-Android, esimahla kwaye iyasebenzisana, ekuphela kwento engaqhelekanga egxile ekusombululeni imisebenzi ngeedesimali.
Ke ukuba uhlala ubala usebenzisa idecimals, esi sicelo sesona kufuneka usikhethe.