Okuqukethwe
Imvamisa, abasebenzisi abenza izibalo ku-Excel ababoni ukuthi amanani ezinombolo abonisiwe kumaseli awahlali evumelana nedatha esetshenziswa uhlelo ukwenza izibalo. Imayelana namanani angama-fractional. Iqiniso liwukuthi uhlelo lwe-Excel lugcina kumemori amanani ezinombolo aqukethe amadijithi angama-15 ngemuva kwephoyinti ledesimali. Futhi naphezu kweqiniso lokuthi, yithi, izinombolo ezi-1, 2 noma 3 kuphela ezizovezwa esikrinini (njengomphumela wezilungiselelo zefomethi yeseli), i-Excel izosebenzisa inombolo egcwele evela enkumbulweni ukuze ibale. Ngezinye izikhathi lokhu kuholela emiphumeleni nemiphumela engalindelekile. Ukuvimbela lokhu ukuthi kungenzeki, udinga ukulungisa ukunemba kokuzungeza, okungukuthi, ukusethe ngendlela efanayo naleyo esesikrinini.
Okuqukethwe
Isebenza kanjani ukuzungeza ku-Excel
Okokuqala, udinga ukucabangela iqiniso lokuthi kungcono ukungasebenzisi lesi silungiselelo ngokungadingekile. Kuyafaneleka ukuthi ucabange ngokucophelela futhi uzinqumele ukuthi kunengqondo yini ukusetha ukunemba njengasesikrinini noma cha, ngoba kaningi lapho wenza izibalo ngenani elikhulu lezinombolo eziyingxenye, lokho okubizwa ngokuthi umphumela wokuqongelela kwenzeka, okunciphisa ukunemba kwezibalo ezenziwe.
Kuyafaneleka ukusetha ukunemba njengasesikrinini ezimweni ezilandelayo. Isibonelo, ake sithi sifuna ukwengeza izinombolo 6,42 kanye no 6,33, kodwa sifuna ukubonisa indawo eyodwa yedesimali, hhayi ezimbili.
Ukuze wenze lokhu, khetha amaseli owafunayo, chofoza kwesokudla kuwo, khetha into ethi “Fometha Amaseli ..”.
Ukuthi “Inombolo”, chofoza ifomethi ethi “Izinombolo” ohlwini olungakwesokunxele, bese usetha inani libe ku-“1” ngenani lezindawo zamadesimali bese uchofoza okuthi KULUNGILE ukuze uphume ewindini lokufometha futhi ulondoloze izilungiselelo.
Ngemuva kwezenzo ezithathiwe, ibhuku lizobonisa amanani 6,4 kanye no-6,3. Futhi uma lezi zinombolo eziyingxenye yengezwa, uhlelo luzonikeza isamba esingu-12,8.
Kungase kubonakale sengathi uhlelo alusebenzi kahle futhi lenze iphutha ekubaleni, ngoba 6,4 + 6,3 = 12,7. Kodwa ake sithole ukuthi ngabe kunjalo ngempela, nokuthi kungani umphumela onjalo uvele.
Njengoba sishilo ngenhla, i-Excel ithatha izinombolo zangempela ukuze ibale, okungukuthi 6,42 kanye no-6,33. Enqubweni yokuwafingqa, umphumela uba ngu-6,75. Kodwa ngenxa yokuthi ngaphambi kokuthi leyo ndawo yedesimali icaciswe kuzilungiselelo zokufometha, iseli eliwumphumela lifinyezwa ngendlela efanele, futhi umphumela wokugcina uboniswa olingana no-6,8.
Ukuze ugweme ukudideka okunjalo, ikhambi elilungile ukusetha ukunemba kokuzungeza njengasesikrinini.
Qaphela: Ukuze uthole inani langempela elisetshenziswa uhlelo lokubala, chofoza iseli eliqukethe inani lezinombolo, bese unaka ibha yefomula, ezobonisa inombolo egcwele egcinwe kumemori yohlelo.
Ukulungisa kanjani ukunemba njengasesikrinini
Okokuqala, ake sithole ukuthi ukunemba kokusondeza kumiswa kanjani njengakusikrini enguqulweni I-Excel 2019.
- Siya kumenyu ethi "Ifayela".
- Chofoza entweni ethi “Izilungiselelo” ohlwini olungakwesokunxele phansi impela.
- Iwindi elengeziwe elinamapharamitha wohlelo lizovuleka, ngakwesokunxele lapho sichofoza ingxenye ethi "Okuthuthukisiwe".
- Manje, ngakwesokudla sezilungiselelo, bheka ibhulokhi ebizwa ngokuthi “Lapho ubala kabusha le ncwadi:” bese uthikha ibhokisi eduze kwenketho ethi “Setha ukunemba okucacisiwe”. Uhlelo luzosixwayisa ngokuthi ukunemba kuzoncishiswa ngalesi silungiselelo. Siyavumelana nalokhu ngokuchofoza inkinobho ethi KULUNGILE bese u-OK futhi ukuze uqinisekise izinguquko futhi uphume ewindini lezinketho.
Qaphela: Uma kudingekile ukukhubaza le modi, hamba kumingcele efanayo futhi umane ukhiphe ibhokisi lokuhlola elihambisanayo.
Ukulungisa Ukunemba Okuzungezayo Ezinguqulweni Zangaphambili
Ngaphandle kwezibuyekezo eziqhubekayo zohlelo lwe-Excel, imisebenzi eminingi eyisisekelo kanye ne-algorithm yokuyisebenzisa ishintsha kancane noma ihlale ifana ukuze abasebenzisi, ngemuva kokushintshela enguqulweni entsha, bangabi nobunzima bokujwayela isixhumi esibonakalayo esisha, njll.
Esimweni sethu, i-algorithm yokusetha ukunemba njengasesikrinini ezinguqulweni zangaphambili zohlelo icishe ifane naleyo ebesiyicabangele ngenhla ngenguqulo ka-2019.
I-Microsoft Excel 2010
- Yiya kumenyu ethi "Ifayela".
- Chofoza entweni enegama elithi “Izilungiselelo”.
- Ewindini lezilungiselelo elivulayo, chofoza into ethi "Okuthuthukisiwe".
- Faka uphawu ngaphambi kwenketho ethi “Setha ukunemba njengasesikrinini” kubhulokhi yezilungiselelo “Lapho ubala kabusha le ncwadi”. Futhi, siqinisekisa ukulungiswa okwenziwe ngokuchofoza inkinobho ethi OK, sicabangela iqiniso lokuthi ukunemba kwezibalo kuzoncishiswa.
I-Microsoft Excel 2007 kanye ne-2003
Izinguqulo zale minyaka, ngokusho kwabanye abasebenzisi, seziphelelwe yisikhathi. Abanye babheka njengento elula kakhulu futhi bayaqhubeka nokusebenza kuzo kuze kube yilolu suku, naphezu kokuvela kwezinguqulo ezintsha.
Ake siqale ngenguqulo ka-2007.
- Chofoza kusithonjana se- "Microsoft Office", esitholakala ekhoneni eliphezulu kwesokunxele sewindi. Uhlu kufanele luvele lapho udinga ukukhetha khona ingxenye ebizwa ngokuthi "Izinketho ze-Excel".
- Elinye iwindi lizovuleka lapho udinga khona into ethi "Okuthuthukisiwe". Okulandelayo, kwesokudla, khetha iqembu lezilungiselelo elithi “Lapho ubala kabusha le ncwadi” bese uqoka ibhokisi eliseduze nomsebenzi othi “Setha ukunemba njengakusikrini”.
Ngenguqulo yangaphambilini (2013), izinto zihlukile.
- Kubha yemenyu ephezulu udinga ukuthola isigaba "Isevisi". Ngemva kokuba isikhethiwe, uhlu luzoboniswa lapho udinga uchofoze into ethi "Izinketho".
- Efasiteleni elivula namapharamitha, khetha okuthi “Isibalo” bese uthikha ibhokisi eliseduze kwenketho ethi “Ukunemba njengasesikrinini”.
Isiphetho
Ukusetha ukunemba njengasesikrinini ku-Excel kuyasiza kakhulu, futhi ezimeni ezithile, umsebenzi obalulekile okungeyena wonke umsebenzisi owaziyo ngawo. Ngeke kube nzima ukwenza izilungiselelo ezifanele kunoma yiziphi izinguqulo zohlelo, njengoba kungekho mehluko oyisisekelo ohlelweni lwesenzo, futhi umehluko usezindaweni eziguquliwe kuphela, lapho, nokho, ukuqhubeka kugcinwa khona.