01 ngo-04
Shintsha Idatha Elingenisiwe Kusuka Kumbhalo kuya Kufomethi Yombhalo
Ngesinye isikhathi, uma izindinganiso zingeniswa noma zikopishwa kwiphepha lokusebenzela le-Excel amanani agcina njengombhalo kunokuba kube nedatha yenombolo.
Lesi simo singabangela izinkinga uma kwenziwa umzamo wokuhlunga idatha noma uma idatha isetshenziselwa ukubalwa okubandakanya ezinye ze-Excel ezakhelwe ngaphakathi.
Emfanekisweni ngenhla, isibonelo, umsebenzi we-SUM usethelwe ukwengeza amanani amathathu - 23, 45, no-78 - akhiwe kumaseli D1 kuya ku-D3.
Esikhundleni sokubuyisa 146 njengempendulo; Kodwa-ke, lo msebenzi ubuyisela i-zero ngoba lezi zindinganiso ezintathu zifakwe njengombhalo kunokuba kube nedatha yenombolo.
Izikhombisi Zokusebenzela
Ukufometha okuzenzakalelayo kwe-Excel ngezinhlobo ezahlukene zedatha kaningi kuyinkomba eyodwa ebonisa lapho idatha ingeniswe noma ingenwe ngendlela engalungile.
Ngokuzenzakalelayo, idatha yocingo, kanye nemiphumela yefomula nemisebenzi, ihambelana ngakwesokudla kweseli, kuyilapho amanani wombhalo ehambelana ngakwesobunxele.
Izinombolo ezintathu - 23, 45, no-78 - esithombeni ngenhla zihambelana ngakwesobunxele bamaseli abo ngoba ziyizindinganiso zombhalo ngenkathi umsebenzi we-SUM ungena esitokisini D4 uhambelana ngakwesokudla.
Ukwengeza, i-Excel izovame ukukhombisa izinkinga ezingase zibe khona ngokuqukethwe kweseli ngokubonisa unxantathu omncane ohlaza okwesibhakabhaka ekhoneni elingaphezulu kwesokunxele leseli.
Kulesi simo, unxantathu obuluhlaza ubonisa ukuthi amanani ema-cell D1 kuya ku-D3 afakiwe njengombhalo.
Ukulungisa idatha yezinkinga ngokunamathisela okhethekile
Izinketho zokushintsha le datha emuva kwifomethi yenombolo ukusebenzisa i- VALUE umsebenzi ku-Excel bese unamathisela okhethekile.
Namathisela okhethekile inguqulo ekhulisiwe yomyalo wokunamathisela okunika inamba yezinketho ngokuqondene nalokho okwenziwe ukudluliselwa phakathi kwamaseli ngesikhathi sokusebenza kwekhophi / ukunamathisela .
Lezi zinketho zihlanganisa imisebenzi eyisisekelo yezibalo ezifana nokungezelela nokuphindaphinda.
Hlanganisa ama-Values ngo-1 nge-Paste Special
Inketho yokuphindaphinda ngokunamathisela okhethekile ngeke nje yandeze zonke izinombolo ngesamba esithile futhi unamathisele impendulo kwisitokisini esendaweni, kodwa izophinde iguqulwe amanani ombhalo ukuze ubale idatha uma ukungena kwakho kwandezwa ngenani le-1.
Isibonelo ekhasini elilandelayo sisebenzisa lesi sici sokunamathisela esikhethekile ngemiphumela yokusebenza:
- impendulo yomsebenzi we- SUM ishintsha kusuka ku-zero kuya ku-146
- izimiso ezintathu eziguqula ukulungiswa ukusuka ngakwesobunxele besiteleni kuya kwesokudla
- izinkomba zephutha lezintambo eziluhlaza okwesibhakabhaka zisusiwe kumaseli aqukethe idatha
02 ka 04
Namathisela Isibonelo Esikhethekile: Ukuguqula Umbhalo Kumanani
Ukuze uguqule izindinganiso zamathekisthi ukuze ubale idatha, kufanele siqale ukufaka izinombolo ezithile njengombhalo.
Lokhu kwenziwa ngokuthayipha i-apostrophe ( ' ) phambi kwenombolo ngayinye njengoba ingene esitokisini.
- Vula ishidi lokusebenzela elisha ku-Excel elinawo wonke amaseli asethelwe kufomethi ejwayelekile
- Chofoza kuseli D1 ukuze wenze iseli esebenzayo
- Thayipha i-apostrophe elandelwe inombolo 23 engena esitokisini
- Cindezela ukhiye wokungena kwikhibhodi
- Njengoba kuboniswe esithombeni ngenhla, iseli D1 kufanele libe nexantathu eluhlaza ekhoneni eliphezulu lesokunxele leseli futhi inombolo 23 kufanele ihambisane ngakwesokudla. I-apostrophe ayibonakali esitokisini
- Chofoza kuseli D2, uma kunesidingo
- Thayipha i-apostrophe elandelwa inombolo engu-45 esitokisini
- Cindezela ukhiye wokungena kwikhibhodi
- Chofoza kuseli D3
- Thayipha i-apostrophe elandelwe inombolo 78 esitokisini
- Cindezela ukhiye wokungena kwikhibhodi
- Chofoza kuseli E1
- Thayipha inombolo 1 (akukho apostrophe) esitokisini bese ucindezela ukhiye we-Enter ekhibhodi
- Inombolo 1 kufanele ihambisane ngakwesokudla kweseli, njengoba kuboniswe esithombeni ngenhla
Qaphela: Ukubona i-apostrophe phambi kwezinombolo zingene ku-D1 kuya ku-D3, chofoza kwenye yalezi cell, njenge-D3. Ku- bar yefomula ngaphezulu kwephepha lokusebenzela, ukungena '78 kufanele kubonakale.
03 ka 04
Namathisela Isibonelo Esikhethekile: Ukuguqula Umbhalo Kumanani (Umq.)
Ukufaka umsebenzi we-SUM
- Chofoza kuseli D4
- Thayipha = SUM (D1: D3)
- Cindezela ukhiye wokungena kwikhibhodi
- Impendulo 0 kufanele ivele esitokisini D4, ngoba amanani kumaseli D1 kuya ku-D3 afakiwe njengombhalo
Qaphela: Ngaphezu kokuthayipha, izindlela zokufaka umsebenzi we-SUM esitokisini lokusebenzela zifaka:
Ukuguqula umbhalo kumanani ngokunamathisela okukhethekile
- Chofoza iseli E1 ukuze wenze iseli esebenzayo
- Ethempelini laseKhaya lebhebhoni , chofoza ku-Copy icon
- Izintuthwane ezihambayo kufanele zivele zizungeze iseli E1 ebonisa ukuthi okuqukethwe kwalesi seluli kukopishwa
- Gqamisa amaseli D1 kuya ku-D3
- Chofoza umcibisholo ophansi ngezansi kwesithonjana sokunamathisela kuthebhu yaseKhaya yebhebhoni ukuvula imenyu yehla
- Emenyu, chofoza Namathisela Okukhethekile ukuze uvule ibhokisi lokubhalela elikhethekile lokunamathisela
- Ngaphansi kwesigaba sokusebenza sebhokisi lebhokisi, chofoza inkinobho yomsakazo eduze Kwenyuka ukuze usebenze lo msebenzi
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
04 ka 04
Namathisela Isibonelo Esikhethekile: Ukuguqula Umbhalo Kumanani (Umq.)
Imiphumela Yeshidi Lokusebenza
Njengoba kuboniswe esithombeni ngenhla, imiphumela yalokhu kusebenza kuphepha lokusebenzela kufanele ibe:
- amanani amathathu kumaseli D1 kuya ku-D3 kufanele ahambelane ngakwesokudla emasethini abo
- ama- triangles aluhlaza kufanele asuke ekhoneni eliphezulu ngakwesokudla selinye ngalinye
- imiphumela yomsebenzi we-SUM esitokisini se-D4 kufanele ufunde manje 146 okungukuthi inani lezinombolo ezintathu kumaseli D1 kuya ku-D3