Ungazungeza kanjani inombolo ku-Excel. Ifomethi yenombolo ngemenyu yokuqukethwe, ukusetha ukunemba okudingekayo, izilungiselelo zokubonisa

I-spreadsheet i-Excel inomsebenzi obanzi okuvumela ukuthi wenze ukukhohlisa okuhlukahlukene ngolwazi lwezinombolo. Ngokuvamile kwenzeka ukuthi lapho kwenziwa izenzo ezihlukahlukene, amanani angama-fractional ayaqedwa. Lesi isici esiwusizo kakhulu, njengoba umsebenzi omningi ohlelweni awudingi imiphumela enembile. Kodwa-ke, kunezibalo ezinjalo lapho kudingekile ukulondoloza ukunemba komphumela, ngaphandle kokusebenzisa ukuzungeza. Ziningi izindlela zokusebenza ngezinombolo ezifinyezwayo. Ake sibheke yonke into ngokuningiliziwe.

Izinombolo zigcinwa kanjani ku-Excel futhi ziboniswe esikrinini

Inqubo yesipredishithi isebenza ezinhlotsheni ezimbili zolwazi lwezinombolo: isilinganiso kanye nenembile. Umuntu osebenza kumhleli wespredishithi angakhetha indlela yokubonisa inani lenombolo, kodwa ku-Excel ngokwayo, idatha isesimweni esinembile - kufika ezinhlamvini eziyishumi nanhlanu ngemva kwephoyinti ledesimali. Ngamanye amazwi, uma isibonisi sibonisa idatha kuze kufike ezindaweni ezimbili zamadesimali, isipredishithi sizosho irekhodi elinembe kakhudlwana enkumbulweni phakathi nezibalo.

Ungenza ngendlela oyifisayo ukuboniswa kolwazi lwezinombolo esibonisini. Inqubo yokuqoqa yenziwa ngokwemithetho elandelayo: izinkomba ukusuka ku-zero kuya kwezine ezihlanganisiwe zifinyezwa phansi, futhi kusukela kwezinhlanu kuye kweziyisishiyagalolunye - kuya kwenkulu.

Izici zokusondeza izinombolo ze-Excel

Ake sihlole ngokuningiliziwe izindlela ezimbalwa zokuhlanganisa imininingwane yezinombolo.

Ukuzungeza ngezinkinobho zeRibhoni

Cabangela indlela yokuhlela yokuqoqa kalula. Imiyalelo enemininingwane ibukeka kanje:

1. Sikhetha iseli noma ububanzi bamaseli.
2. Sidlulela esigabeni esithi “Ekhaya” futhi kubhulokhi yomyalo ethi “Inombolo,” chofoza i-LMB kokuthi “Yehlisa ukujula kancane” noma “Khuphula ukujula kancane”. Kuyaphawuleka ukuthi idatha yezinombolo ekhethiwe kuphela izozungezwa, kodwa kuze kufike kumadijithi ayishumi nanhlanu enani asetshenziselwa izibalo.
3. Ukwanda kwezinhlamvu ngeyodwa ngemva kokhefana kwenzeka ngemva kokuchofoza into ethi “Khulisa ukujula kancane”.

4. Ukunciphisa izinhlamvu ngazinye kwenziwa ngemva kokuchofoza into ethi “Yehlisa ukujula kancane”.

Ukuzungezisa Ngefomethi Yeseli

Ngokusebenzisa ibhokisi elibizwa ngokuthi “Ifomethi Yeseli”, kuyenzeka futhi ukusebenzisa ukuhlela ukuzungeza. Imiyalelo enemininingwane ibukeka kanje:

1. Sikhetha iseli noma ububanzi.
2. Chofoza i-RMB endaweni ekhethiwe. Imenyu yokuqukethwe ekhethekile ivuliwe. Lapha sithola into ebizwa ngokuthi “Fometha Amaseli …” bese uchofoza i-LMB.

3. Iwindi lamaseli efomethi liyavela. Yiya esigatshaneni esithi "Inombolo". Sinaka ikholomu "Amafomethi wezinombolo:" bese usetha inkomba ethi "Numeric". Uma ukhetha ifomethi ehlukile, uhlelo ngeke lukwazi ukusebenzisa izinombolo zokusondeza.. Maphakathi newindi eduze "Nenani lezindawo zamadesimali:" sibeka inombolo yezinhlamvu esihlela ukuzibona phakathi nenqubo.

4. Ekugcineni, chofoza into ethi "KULUNGILE" ukuze uqinisekise zonke izinguquko ezenziwe.

Setha ukunemba kwesibalo

Ezindleleni ezichazwe ngenhla, amapharamitha asethiwe abe nomthelela kuphela ekuphumeni kwangaphandle kolwazi lwezinombolo, futhi lapho kwenziwa izibalo, kwasetshenziswa amanani anembe kakhudlwana (kuze kufike kuhlamvu lweshumi nanhlanu). Ake sikhulume ngokuningiliziwe mayelana nendlela yokuhlela ukunemba kwezibalo. Imiyalelo enemininingwane ibukeka kanje:

1. Iya engxenyeni ethi "Ifayela", bese ngakwesobunxele sefasitela elisha sithola into ebizwa ngokuthi "Amapharamitha" bese uchofoza kuyo nge-LMB.

2. Ibhokisi elibizwa ngokuthi “Izinketho ze-Excel” liyavela esibukweni. Sithuthela ku- "Okuthuthukisiwe". Sithola ibhulokhi yemiyalo "Lapho ubala kabusha le ncwadi." Kuyaphawuleka ukuthi izinguquko ezenziwe zizosebenza kuyo yonke incwadi. Faka uphawu lokuhlola eduze nombhalo othi “Setha ukunemba njengasesikrinini.” Ekugcineni, chofoza into ethi "KULUNGILE" ukuze uqinisekise zonke izinguquko ezenziwe.

3. Ilungile! Manje, lapho kubalwa ulwazi, inani lokukhiphayo ledatha yezinombolo esibonisini lizocatshangelwa, hhayi leli eligcinwe kumemori ye-spreadsheet processor. Ukusetha amanani ezinombolo abonisiwe kwenziwa nganoma iyiphi yezindlela ezi-2 ezichazwe ngenhla.

Ukusetshenziswa kwemisebenzi

Qaphela! Uma umsebenzisi efuna ukuhlela ukuzungezisa lapho ebala ngokuhlobene neseli eyodwa noma amaningana, kodwa engahleli ukwehlisa ukunemba kwezibalo kuyo yonke incwadi yokusebenzela, kufanele asebenzise amakhono o-opharetha we-ROUND.

Lo msebenzi unokusebenzisa okuningana, okuhlanganisa ukuhlanganiswa nabanye opharetha. Ku-opharetha abayinhloko, ukusondeza kuyenziwa:

• “ROUNDDOWN” – enombolweni eseduze ezansi kumoduli;
• “ROUNDUP” – kufika kunani eliseduze kakhulu phezulu kumodulo;
• "OKRVUP" - ngokunemba okucacisiwe kumodulo;
• "OTBR" - kuze kube yisikhathi lapho inombolo iba uhlobo oluphelele;
• “ISIQEPHU” – kufika enanini elishiwo lezinhlamvu zedesimali ngokuhambisana namazinga amukelekile okufinyeza;
• "OKRVNIZ" - ngokunemba okucacisiwe phansi kwe-modulo;
• “NGISHONA” – kuya enanini elilinganayo eliseduze;
• "OKRUGLT" - ngokunemba okucacisiwe;
• “ODD” – ukuya enanini eliyinqaba eliseduze.

I-ROUNDDOWN, ROUND, kanye ne-ROUNUP opharetha banaleli fomu elijwayelekile elilandelayo: =Igama lomsebenzisi (inombolo;inombolo_amadijithi). Ake sithi umsebenzisi ufuna ukwenza inqubo yokuzungezisa yenani elingu-2,56896 kuya kwezingu-3 zedesimali, lapho-ke udinga ukufaka “=UMJIKELO(2,56896;3)”. Ekugcineni, uzothola:

Ama-opharetha athi “ROUNDDOWN”, “ROUND”, kanye ne-“ROUNDUP” anefomu elijwayelekile elilandelayo: =Igama lomsebenzisi(inombolo,ukunemba). Uma umsebenzisi efuna ukufinyeza inani elingu-11 libe ukuphindaphinda okubili okuseduze, kuzomele angene “=UMJIKELO(11;2)”. Ekugcineni, uzothola:

Ama-opharetha athi “ODD”, “SELECT”, kanye nokuthi “EVEN” anefomu elijwayelekile elilandelayo:  =Igama lomsebenzisi (inombolo). Isibonelo, lapho esondeza inani 17 kunani eliseduze elilinganayo, udinga ukungena «= LWESINE(17)». Ekugcineni, uzothola:

Kuyafaneleka ukuqashelwa! Umsebenzisi angafakwa emugqeni wemisebenzi noma kuseli ngokwayo. Ngaphambi kokubhala umsebenzi kuseli, kufanele kukhethwe kusengaphambili ngosizo lwe-LMB.

Ispredishithi siphinde sibe nenye indlela yokufaka yesisebenzisi esikuvumela ukuthi wenze inqubo yokuqoqa imininingwane yezinombolo. Kuhle uma unetafula lezinombolo ezidinga ukuguqulwa zibe amanani ayindilinga kwenye ikholomu. Imiyalelo enemininingwane ibukeka kanje:

1. Sithuthela esigabeni "Amafomula". Lapha sithola isici esithi “Math” bese uchofoza kuso nge-LMB. Uhlu olude luvuliwe, lapho sikhetha khona u-opharetha obizwa ngokuthi “ROUND”.

2. Ibhokisi lengxoxo elibizwa ngokuthi “Izimpikiswano Zomsebenzi” livele esibukweni. Umugqa "Inombolo" ungagcwaliswa ngolwazi ngokwakho ngokufaka ngesandla. Enye inketho ekuvumela ukuthi uhlanganise lonke ulwazi ngokuzenzakalelayo iwukuba uchofoze i-LMB kusithonjana esitholakala kwesokudla senkambu ukuze ubhale ukuphikisana.

3. Ngemva kokuchofoza lesi sithonjana, iwindi elithi “Izimpikiswano Zomsebenzi” ligoqekile. Sichofoza i-LMB endaweni ephezulu kakhulu yekholomu, ulwazi esihlela ukuzungeza kuyo. Inkomba ivele ebhokisini lezimpikiswano. Sichofoza i-LMB kusithonjana esitholakala kwesokudla senani elivelayo.

4. Isikrini siphinde saveza iwindi elibizwa ngokuthi “Izimpikiswano Zomsebenzi”. Emgqeni othi "Inani lamadijithi" sishayela ngokujula kancane lapho kudingeka khona ukunciphisa izingxenyana. Ekugcineni, chofoza into ethi "KULUNGILE" ukuze uqinisekise zonke izinguquko ezenziwe.

5. Inani lenombolo lifinyeziwe. Manje sidinga ukwenza inqubo yokusondeza kuwo wonke amanye amaseli akule kholomu. Ukuze wenze lokhu, hambisa i-pointer yegundane ekhoneni elingezansi kwesokudla senkambu ngomphumela obonisiwe, bese, ngokubamba i-LMB, welula ifomula ekupheleni kwetafula.

6. Ilungile! Senze inqubo yokusondeza kuwo wonke amaseli kule kholomu.

Ungawasondeza kanjani phezulu naphansi ku-Excel

Ake sibhekisise u-opharetha we-ROUNUP. I-agumenti yokuqala igcwaliswa ngale ndlela elandelayo: ikheli leseli lifakwe nolwazi lwezinombolo. Ukugcwalisa i-agumenti yesibili kunemithetho elandelayo: ukufaka inani elithi “1” kusho ukuzungeza ingxenyenamba yedesimali engxenyeni ephelele, ukufaka inani elithi “2” kusho ukuthi ngemva kokuqaliswa kwenqubo yokusondeza kuzoba nohlamvu olulodwa ngemva kwephoyinti ledesimali. , njll. Faka inani elilandelayo emugqeni wokufaka amafomula: = UMQEPHU (A1). Ekugcineni sithola:

Manje ake sibheke isibonelo sokusebenzisa i-opharetha engu-ROUNDDOWN. Faka inani elilandelayo emugqeni wokufaka amafomula: =I-ROUNDSAR(A1).Ekugcineni sithola:

Kuyaqapheleka ukuthi ama-opharetha athi “ROUNDDOWN” kanye ne-“ROUNDUP” asetshenziselwa futhi ukusebenzisa inqubo yokuzungezisa umehluko, ukuphindaphinda, njll.

Isibonelo sokusetshenziswa:

Ungafinyeza kanjani inombolo ephelele ku-Excel?

I-opharetha ethi "KHETHA" ikuvumela ukuthi usebenzise ukusondeza kunamba ephelele futhi ulahle izinhlamvu ngemva kwephoyinti ledesimali. Ngokwesibonelo, cabangela lesi sithombe:

Umsebenzi okhethekile wespredishithi obizwa ngokuthi “INT” ukuvumela ukuthi ubuyisele inani eliyingqikithi. Kukhona impikiswano eyodwa kuphela - "Inombolo". Ungafaka idatha yezinombolo noma izixhumanisi zamaseli. Isibonelo:

Ububi obukhulu besisebenzisi ukuthi ukuzungezisa kwenziwa phansi kuphela.

Ukuze uhlanganise ulwazi lwezinombolo kumanani aphelele, kuyadingeka ukusebenzisa ama-opharetha acatshangelwe ngaphambilini “ROUNDDOWN”, “EVEN”, “ROUNDUP” kanye “ODD”. Izibonelo ezimbili zokusebenzisa lawa ma-opharetha ukuze kusetshenziswe ukusondeza ohlotsheni oluphelele:

Kungani i-Excel ihlanganisa izinombolo ezinkulu?

Uma isici sohlelo siqukethe inani elikhulu, isibonelo 73753956389257687, kuzothatha ifomu elilandelayo: 7,37539E+16. Lokhu kungenxa yokuthi inkambu inokubuka "Okuvamile". Ukuze ukhiphe lolu hlobo lokukhishwa kwamanani amade, udinga ukuhlela ifomethi yenkambu futhi ushintshe uhlobo lube Lwezinombolo. Inhlanganisela yokhiye "CTRL + SHIFT + 1" izokuvumela ukuthi wenze inqubo yokuhlela. Ngemva kokwenza izilungiselelo, inombolo izothatha indlela efanele yokubonisa.

Isiphetho

Kusuka esihlokweni, sithole ukuthi ku-Excel kunezindlela ezi-2 eziyinhloko zokuzungeza isibonisi esibonakalayo solwazi lwezinombolo: usebenzisa inkinobho kubha yamathuluzi, kanye nokuhlela izilungiselelo zefomethi yeseli. Ukwengeza, ungasebenzisa ukuhlela ukufinyezwa kolwazi olubaliwe. Kukhona futhi izinketho eziningana zalokhu: ukuhlela imingcele yedokhumenti, kanye nokusebenzisa opharetha bezibalo. Umsebenzisi ngamunye uzokwazi ukuzikhethela indlela efaneleke kakhulu efanele izinhloso nezinjongo zakhe ezithile.