Ungawabeka kanjani amadesimali ku-Excel? Kulesi sifundo sikushiyela zonke izinyathelo neminye imininingwane.
Impela, okwamanje kufanele wazi ukuthi i-Excel ingelinye lamathuluzi aphumelela kakhulu emhlabeni wokuhlela, ukuhlukanisa ngezigaba nokudala amaspredishithi, hhayi nje ngoba inenani elimangalisayo lemisebenzi. Kodwa ngenxa yokuthi ngaphakathi kwayo, singakwazi ukwenza noma yiluphi uhlobo lomsebenzi namaphrojekthi, ngaphandle kwesidingo sokuba ochwepheshe ngaphakathi kwe-interface.
Futhi, kufanele wazi ukuthi ngaphakathi kohlelo olufanayo singakwazi ukwenza imisebenzi yamadesimali, ewusizo kakhulu emikhakheni yokubalwa kwezimali nokuphatha, kungaba okomsebenzi, ibhizinisi noma nje umsebenzi wasenyuvesi. Ngaphakathi kwe-Excel singabeka amadesimali, Ngaphandle komzamo omkhulu.
Manje, uma uzithola usuqala ukwazi nokufunda ngezinzuzo ezimangalisayo ze-Excel, ngaphezu kwayo yonke imisebenzi equkethwe, sizobe sesikwenzela umsebenzi ube lula. ngikufundisa Ungawabeka kanjani amadesimali ku-Excel, njengokungathi unguchwepheshe.
Izindlela zokubeka amadesimali ku-Excel
Kulokho kumele sikutshele, ukuthi kunezindlela ezahlukene, esingakwazi ngazo engeza izinombolo zedesimali eshidini le-excel, lezo zindlela ezifanayo, sizichaza ngesinyathelo ngesinyathelo sazo. Okulandelayo:
Faka ifomula kukholamu ehambisanayo
Lena indlela yokuqala, esizokufundisa yona ukuthi ukwazi ukuyenza faka amadesimali eshidini le-excel, ngenxa yalokhu kufanele ulandele iziqondiso esikushiyela zona manje. Lawa alandelayo:
- Njengesinyathelo sokuqala, uzodinga ukuvula ispredishithi se-Excel.
- Ngemuva kwalokho kufanele ufake amanani ezinombolo eziyindilinga, ngayinye ngaphakathi kweseli ngalinye. Njengesincomo, kungcono kakhulu ukufaka izinombolo, konke ngaphakathi kwekholomu efanayo, okuzokwenza indlela ibe lula ukuyenza.
- Ngaphakathi kwekholomu yesibili, kufanele wengeze ifomula elandelayo “= round (A1,N)”. Ngaleso sikhathi, kufanele ufake inombolo yedesimali esikhundleni sika-"N" ngaphakathi kwefomula ofuna ukuyengeza.
- Kumakholomu alandelayo, ngeke kudingeke ukuthi ubhale kabusha ifomula, njengoba ungakwazi ukuhudula bese uyiphonsa kumaseli alandelayo, kuze kufike kwelokugcina ohlose ukulisebenzisa. Ungasebenzisa futhi izinketho zokukopisha nokunamathisela, uma zikukholomu efanayo.
- Isibonelo: “=Umjikelezo (A1,8)”
Yilokho kuphela! Ngaleyo ndlela uzobe usufundile indlela yokuqala yokubeka amadesimali ku-Excel.
Faka amadesimali ku-Excel ngaphandle kwefomula
Yilokho Enye indlela eyaziwayo faka amadesimali ku-excel, ngakolunye uhlangothi, lokhu akudingi amafomula ukuze akwazi ukusebenza futhi ngenxa yalokhu, sikushiyela nohlu oluphelele lwezinyathelo, olumi kanje:
- Okokuqala faka amanani ezinombolo wedesimali owafunayo, kuseli ngalinye.
- Bese kufanele ukhethe eyodwa noma zonke.
- Okulandelayo uzodinga ukuzitholela ngaphakathi kwethebhu "yokuqala".
- Bese, kufanele usebenzise izinkinobho "ukunciphisa noma ukwandisa" inani lamaseli akhethiwe ngedijithi eyodwa. Ngaleyo ndlela izobe isilungile.
Ngokufanayo, ungase ube nakho faka amadesimali ku-excel ngaphandle kokusebenzisa ifomula.
Faka amadesimali ku-Excel usebenzisa umsebenzi we-Truncate, kumadesimali angenawo amarounds
Kumelwe sivume ukuthi izindlela zangaphambilini zisekelwe kuphela endleleni evamile, esivumela ukuba sikhulise noma sinciphise inombolo, kuye ngokuthi idesimali yayo ingaphezulu noma ingaphansi kuka-5.
Kule ndlela, izinombolo zedesimali ezisele zizosuswa ngokuzenzakalelayo, kungakhathaliseki ukuthi i-symmetrical rounding, ngoba lokhu sinezinyathelo ezilandelayo:
- Ngaphakathi kweseli elingenalutho, kufanele sibhale ifomula elandelayo: “=TRUNCAR(A1;N)» sicabange ukuthi ibhokisi A! yilapho inombolo yedesimali ikhona futhi u-"N" uyinombolo yamadijithi esifuna ukuwabona kuspredishithi.
- Khona-ke kufanele sicindezele inkinobho ethi "enter" futhi ngaleyo ndlela siqedele.
Yilokho, ngakho sinenye Ungawabeka kanjani amadesimali ku-Excel.
Amadesimali ayindilinga ku-Excel. (Amaphuzu abalulekile okufanele acatshangelwe)
Kufanele wazi ukuthi beka amadesimali ku-excel, akubi umsebenzi onzima noma onzima, manje ukuhlanganisa lawa madesimali, ungasebenzisa zonke izindlela esikushiye nazo ngaphambilini. Ezifanayo ongazisebenzisa, uma ukuntuleka kwamadesimali akuyona inkinga kuwe.
Futhi, kufanele wazi ukuthi imisebenzi yokuzungeza amadesimali ngaphakathi kwe-Excel ngokuvamile ibuswa umthetho othile, lapho sitshelwa khona ukuthi uma idijithi yokugcina yenombolo yedesimali inkulu kuno-5, inombolo iyanda. a 1. Ngakolunye uhlangothi. isandla, uma leyo nombolo efanayo igcina ngedesimali enenani elingaphansi kuka-5, inombolo yesisekelo isala, nenani layo lamanje.
Ezinye izinhlelo zokusebenza ezisivumela ukuthi senze imisebenzi ngamadesimali
Esimeni esimangalisayo lokho I-Excel kungenzeka kungabi wuhlelo obulufuna ngempela ukwenza imisebenzi yakho yokubala ngamadesimali, sikushiyela ezinye izindlela, ongazisebenzisa okwamanje, ukuze ukwazi ukubeka amadesimali. Lokhu okulandelayo:
1. Uphawu
Lesi isibali esiku-inthanethi, lapho singenza khona zonke izinhlobo zemisebenzi ye-algebra, kusukela kwelula kakhulu kuye kweyinkimbinkimbi kakhulu.
Lesi sibali singasetshenziswa uma ufinyelela inkundla yewebhu https://es.symbolab.com/solver/decimals-calculator, kumahhala ngokuphelele futhi ungathola izici eziningi ezimangalisayo.
Ngaphezu kokuba usizo olukhulu, lapho wenza noma yikuphi ukuhlanganisa, ukususa, ukuphindaphinda noma ukuhlukaniswa kwamadesimali, ngaphandle kwesidingo sokubhala phansi noma ukulondoloza idatha, okuthile okwamanje.
2. I-DivPad: Izibalo Isinyathelo ngesinyathelo
Lona, ngakolunye uhlangothi, uhlelo lokusebenza olutholakalayo lwesistimu yokusebenza ye-Android, lapho ungenza khona zonke izinhlobo zemisebenzi yezibalo, kuhlanganise nokusebenza kwedesimali, ngendaba yemizuzu.
Uma ufuna ukubala noma uthole i-akhawunti, ngokunembile futhi ngokushesha, lolu hlelo lokusebenza lweselula yilona okufanele ulusebenzise.
3. Isibali sokuhlukanisa (nezinsalela noma amadesimali)
Lona, ngakolunye uhlangothi, luwuhlelo lokusebenza lwesistimu yokusebenza ye-Android, emahhala ngokuphelele futhi esebenzisanayo, okuwukuphela kwayo okukhethekile ukuthi igxile ngokusobala ekuxazululeni imisebenzi ngamadesimali.
Ngakho-ke uma kufanele ubale usebenzisa amadesimali, lolu hlelo lokusebenza yilona okufanele ulukhethe.