Ukuhlukaniswa ku-Excel. Ukuhlukaniswa kusebenza kanjani ku-Excel

I-Excel wuhlelo olusebenza ngendlela emangalisayo. Ingasetshenziswa kokubili njengohlobo lwendawo yokuhlela futhi njengesibali esisebenza kakhulu esikuvumela ukubala noma yini. Namuhla sizobheka ukusetshenziswa kwesibili kwalolu hlelo lokusebenza, okuwukuthi ukuhlukaniswa kwezinombolo.

Lokhu okunye okuvamile ukusetshenziswa kwamaspredishithi, kanye neminye imisebenzi ye-arithmetic efana nokuhlanganisa, ukususa, nokuphindaphinda. Eqinisweni, ukuhlukaniswa kufanele kwenziwe cishe kunoma yikuphi ukusebenza kwezibalo. Ibuye isetshenziswe ekubalweni kwezibalo, futhi kulokhu le processor yesipredishithi isetshenziswa kakhulu.

Amakhono okuhlukanisa kusipredishithi se-Excel

Ku-Excel, ungaletha amathuluzi amaningana ayisisekelo ngesikhathi esisodwa ukwenza lo msebenzi, futhi namuhla sizonikeza lawo asetshenziswa kaningi. Lokhu ukusetshenziswa kwamafomula anenkomba eqondile yamanani (okuyizinombolo noma amakheli amaseli) noma ukusetshenziswa komsebenzi okhethekile ukwenza lo msebenzi wezibalo.

Ukwehlukanisa inombolo ngenombolo

Lena indlela eyisisekelo kakhulu yokwenza lokhu kusebenza kwezibalo ku-Excel. Kwenziwa ngendlela efanayo nanjengesibali esivamile esisekela okokufaka kwezinkulumo zezibalo. Umehluko kuphela ukuthi ngaphambi kokufaka izinombolo nezimpawu zabaqhubi be-arithmetic, kufanele ufake uphawu =, oluzobonisa uhlelo ukuthi umsebenzisi usezofaka ifomula. Ukuze wenze umsebenzi wokuhlukanisa, kufanele usebenzise uphawu / uphawu. Ake sibone ukuthi lokhu kusebenza kanjani ekusebenzeni. Ukuze wenze lokhu, landela izinyathelo ezichazwe kuleli bhukwana:

1. Sichofoza igundane kunoma iyiphi iseli engaqukethe idatha (okuhlanganisa namafomula anikeza umphumela ongenalutho noma izinhlamvu ezingaphrinteki).
2. Okokufaka kungenziwa ngezindlela eziningi. Ungaqala ngokuqondile ukuthayipha izinhlamvu ezidingekayo, uqale ngophawu olulinganayo, futhi kukhona ithuba lokufaka ifomula ngqo emugqeni wokufaka wefomula, otholakala ngenhla.
3. Kunoma yikuphi, kufanele uqale ubhale uphawu =, bese ubhala inombolo ezohlukaniswa. Ngemuva kwalokho, sibeka uphawu lwe-slash, emva kwalokho sibhala phansi inombolo okuzokwenziwa ngayo umsebenzi wokuhlukanisa.
4. Uma kukhona abahlukanisi abambalwa, bangangezwa komunye nomunye usebenzisa ama-slash eyengeziwe.
5. Ukurekhoda umphumela, kufanele ucindezele inkinobho Faka. Uhlelo luzokwenza ngokuzenzakalelayo zonke izibalo ezidingekayo.

Manje sihlola ukuthi uhlelo lubhale inani elilungile yini. Uma umphumela kuvela ukuthi awulungile, kunesizathu esisodwa kuphela - ukufakwa kwefomula okungalungile. Kulokhu, udinga ukukulungisa. Ukuze wenze lokhu, chofoza endaweni efanele kubha yefomula, yikhethe bese ubhala inani elilungile. Ngemuva kwalokho, cindezela ukhiye wokungena, futhi inani lizobalwa kabusha ngokuzenzakalelayo.

Eminye imisebenzi ingase isetshenziselwe ukwenza imisebenzi yezibalo. Zingahlanganiswa nokuhlukaniswa. Kulokhu, inqubo izoba njengoba kufanele ibe ngokwemithetho ejwayelekile ye-arithmetic:

1. Ukusebenza kokuhlukanisa nokuphindaphinda kwenziwa kuqala. Ukwengeza nokususa kuza okwesibili.
2. Izisho nazo zingafakwa kubakaki. Kulokhu, zizohamba phambili, ngisho noma ziqukethe imisebenzi yokuhlanganisa nokukhipha.

Sonke siyazi ukuthi, ngokwemithetho eyisisekelo yezibalo, ukuhlukaniswa ngoziro akunakwenzeka. Futhi kuzokwenzekani uma sizama ukwenza umsebenzi ofanayo ku-Excel? Kulokhu, iphutha elithi “#DIV/0!” izokhishwa.

Ukuhlukaniswa kwedatha yeseli

Kancane kancane senza izinto zibe nzima. Kuthiwani uma, ngokwesibonelo, kudingeka sihlukanise amaseli phakathi kwawo? Noma uma udinga ukuhlukanisa inani eliqukethwe kuseli ethile ngenombolo ethile? Kufanele ngisho ukuthi izici ezijwayelekile ze-Excel zinikeza ithuba elinjalo. Ake sihlolisise indlela yokwenza lokhu.

1. Sichofoza kunoma iyiphi iseli engenawo amanani. Njengasesibonelweni sangaphambilini, udinga ukwenza isiqiniseko sokuthi azikho izinhlamvu ezingaphrinteki.
2. Okulandelayo, faka uphawu lokufaka lwefomula =. Ngemva kwalokho, sichofoza kwesokunxele iseli eliqukethe inani elifanele.
3. Bese ufaka uphawu lokuhlukanisa (slash).
4. Bese ukhetha iseli ofuna ukulihlukanisa. Bese, uma kudingeka, faka isileshi futhi bese uphinda izinyathelo 3-4 kuze kufakwe inombolo efanele yezimpikiswano.
5. Ngemva kokuthi isisho sesifakwe ngokugcwele, cindezela u-Enter ukukhombisa umphumela kuthebula.

Uma udinga ukuhlukanisa inombolo ngokuqukethwe kweseli noma okuqukethwe kweseli ngenombolo, lokhu kungenziwa futhi. Kulesi simo, esikhundleni sokuchofoza inkinobho yegundane kwesokunxele kuseli elihambisanayo, kufanele ubhale phansi inombolo ezosetshenziswa njenge- divisor noma i-dividend. Ungakwazi futhi ukufaka amakheli eselula ukusuka kukhibhodi esikhundleni sezinombolo noma ukuchofoza kwegundane.

Ukwehlukanisa ikholomu ngekholomu

I-Excel ikuvumela ukuthi wenze umsebenzi wokuhlukanisa ikholomu eyodwa kwenye. Okusho ukuthi, inombolo yekholomu eyodwa izohlukaniswa idinominetha yekholomu eduze kwayo. Akuthathi isikhathi esiningi ukwenza lokhu, ngoba indlela lokhu kusebenza okwenziwa ngayo ihlukile, ishesha kakhulu kunokumane uhlukanise isisho ngasinye kwesinye. Yini okudingeka yenziwe?

1. Chofoza kuseli lapho kuzovezwa khona umphumela wokugcina wokugcina. Ngemva kwalokho, faka inombolo yokufaka yefomula =.
2. Ngemva kwalokho, chofoza kwesokunxele iseli lokuqala, bese uhlukanise phakathi kwesibili ngendlela echazwe ngenhla.
3. Bese ucindezela inkinobho yokufaka.

Ngemva kokwenza lo msebenzi, inani lizovela kuseli elihambisanayo. Kuze kube manje konke kunjengoba kuchazwe ngenhla.

Ngemva kwalokho, ungenza imisebenzi efanayo kumaseli alandelayo. Kodwa lokhu akuwona umqondo osebenza kahle kakhulu. Kungcono kakhulu ukusebenzisa ithuluzi elikhethekile elibizwa nge-autocomplete marker. Lesi isikwele esivela ekhoneni elingezansi kwesokudla seseli ekhethiwe. Ukuze uyisebenzise, ​​udinga ukuhambisa ikhesa yegundane phezu kwayo. Iqiniso lokuthi konke kwenziwa ngendlela efanele lingatholakala ngokushintsha umcibisholo ube isiphambano. Ngemva kwalokho, cindezela inkinobho yegundane kwesokunxele bese uyibambe phansi, hudula ifomula kuwo wonke amaseli asele.

Ngemva kokwenza lo msebenzi, sithola ikholomu egcwele idatha edingekayo.

Ukunakwa. Ungahambisa ifomula ohlangothini olulodwa kuphela ngesibambo SokuQedela Ngokuzenzakalelayo. Ungadlulisa amanani kokubili ukusuka phansi kuye phezulu futhi ukusuka phezulu kuye phansi. Kulesi simo, amakheli eseli azothathelwa indawo lawa alandelayo ngokuzenzakalelayo.

Lo mshini ikuvumela ukuthi wenze izibalo ezifanele kumaseli alandelayo. Nokho, uma udinga ukuhlukanisa ikholomu ngenani elifanayo, le ndlela izoziphatha ngendlela engafanele. Lokhu kungenxa yokuthi inani lenombolo yesibili lizoshintsha njalo. Ngakho-ke, udinga ukusebenzisa indlela yesine ukuze konke kube okulungile - ukuhlukanisa ikholomu ngokuqhubekayo (inombolo eqhubekayo). Kodwa ngokuvamile, leli thuluzi lisebenziseka kalula uma ikholomu iqukethe inombolo enkulu yemigqa.

Ukuhlukanisa ikholomu kuseli

Ngakho, yini okufanele yenziwe ukuze kuhlukaniswe ikholomu yonke ngenani elingaguquki? Ukuze wenze lokhu, udinga ukukhuluma ngezinhlobo ezimbili zamakheli: isihlobo futhi ngokuphelele. Ezokuqala yilezo ezichazwe ngenhla. Lapho nje ifomula isikopishwa noma iyiswa kwenye indawo, izixhumanisi ezihlobene zishintshwa ngokuzenzakalelayo zibe kwezifanele.

Izithenjwa eziphelele, ngakolunye uhlangothi, zinekheli eligxilile futhi azishintshi lapho udlulisela ifomula kusetshenziswa umsebenzi wokukopisha-namathisela noma umaka oziqedela ngokuzenzakalelayo. Yini okudingeka yenziwe ukuze kuhlukaniswe ikholomu yonke ibe iseli elilodwa (ngokwesibonelo, ingase iqukathe inani lesaphulelo noma inani lemali engenayo yomkhiqizo owodwa)?

1. Senza ukuchofoza kwegundane kwesokunxele kuseli yokuqala yekholomu lapho sizobonisa khona imiphumela yokusebenza kwezibalo. Ngemuva kwalokho, sibhala ifomula yesignali yokufaka, chofoza iseli lokuqala, uphawu lokuhlukanisa, owesibili, njalonjalo ngokusho kohlelo. Ngemva kwalokho, sifaka okungaguquki, okuzosebenza njengenani leseli ethile.
2. Manje udinga ukulungisa isixhumanisi ngokushintsha ikheli ukusuka kwesihlobana ukuya kokuphelele. Senza ukuchofoza kwegundane kokungaguquki kwethu. Ngemuva kwalokho, udinga ukucindezela ukhiye we-F4 kukhibhodi yekhompyutha. Futhi, kwamanye ama-laptops, udinga ukucindezela inkinobho ethi Fn + F4. Ukuze uqonde ukuthi udinga ukusebenzisa ukhiye othile noma inhlanganisela, ungazama noma ufunde imibhalo esemthethweni yomkhiqizi wekhompyutha ephathekayo. Ngemva kokucindezela lo khiye, sizobona ukuthi ikheli leseli selishintshile. Kwengezwe uphawu lwedola. Usitshela ukuthi kusetshenziswa ikheli eliphelele leseli. Udinga ukwenza isiqiniseko sokuthi uphawu lwedola lubekwe eduze kwakho kokubili uhlamvu lwekholomu kanye nenombolo yomugqa. Uma kunophawu olulodwa lwedola, khona-ke ukulungiswa kuzokwenziwa ngokuvundlile noma ngokuqondile.
3. Okulandelayo, ukuze uqinisekise umphumela, cindezela ukhiye wokufaka, bese usebenzisa umaka wokugcwalisa ngokuzenzakalelayo ukwenza lo msebenzi namanye amaseli akule kholomu.
4. Siyawubona umphumela.

Ungawusebenzisa kanjani umsebenzi OWAMFIHLO

Kukhona enye indlela yokwenza ukuhlukanisa - usebenzisa umsebenzi okhethekile. I-syntax yayo ithi: =INGXENYE(inombolo, idinominetha). Akunakwenzeka ukusho ukuthi kungcono kune-standard division operator kuzo zonke izimo. Iqiniso liwukuthi izungeza okusele enambeni encane. Okusho ukuthi, ukuhlukaniswa kwenziwa ngaphandle kokusala. Isibonelo, uma umphumela wezibalo kusetshenziswa u-opharetha ojwayelekile (/) kuyinombolo 9,9, emva kokusebenzisa umsebenzi I-PRIVATE inani 9 lizobhalwa kuseli. Ake sichaze ngokuningiliziwe ukuthi ungawusebenzisa kanjani lo msebenzi ekusebenzeni:

1. Chofoza iseli lapho umphumela wezibalo uzorekhodwa khona. Ngemuva kwalokho, vula ibhokisi lengxoxo yokufaka umsebenzi (ukwenza lokhu, chofoza inkinobho ethi "Faka umsebenzi", etholakala ngokushesha ngakwesobunxele eduze komugqa wokufaka wefomula). Le nkinobho ibukeka njengezinhlamvu ezimbili zesi-latin fx.
2. Ngemva kokuvela kwebhokisi lengxoxo, udinga ukuvula uhlu oluphelele lwe-alfabhethi lwemisebenzi, futhi ekugcineni kohlu kuzoba no-opharetha. I-PRIVATE. Siyayikhetha. Ngezansi nje kuzobhalwa ukuthi kusho ukuthini. Futhi, umsebenzisi angafunda incazelo enemininingwane yokuthi usetshenziswa kanjani lo msebenzi ngokuchofoza ilinki ethi “Usizo lwalo msebenzi”. Ngemva kokuqeda zonke lezi zinyathelo, qinisekisa ukukhetha kwakho ngokucindezela inkinobho ethi KULUNGILE.
3. Elinye iwindi lizovuleka phambi kwethu, lapho udinga ukufaka khona inombolo nedenominator. Awukwazi ukubhala phansi izinombolo kuphela, kodwa futhi izixhumanisi. Konke kuyafana nokuhlukaniswa kwezandla. Sihlola ukuthi idatha ikhonjiswe kahle kangakanani, bese siqinisekisa izenzo zethu.

Manje sibheka ukuthi wonke amapharamitha afakwe kahle yini. I-Life Hack, awukwazi ukubiza ibhokisi lengxoxo yokufaka yokufaka, kodwa mane usebenzise umugqa wokufaka wefomula, ubhale umsebenzi lapho njenge =OKUYIMFIHLO(81), njengoba kuboniswe esithombeni ngezansi. Inombolo yokuqala inamba futhi eyesibili idinominetha.

Ama-agumenti omsebenzi ahlukaniswa ngama-semicolon. Uma ifomula ifakwe ngokungalungile, ungayilungisa ngokwenza izinguquko emugqeni wokufaka wefomula. Ngakho-ke, namuhla sifunde ukwenza umsebenzi wokuhlukanisa ngezindlela ezahlukene ku-Excel. Akukho lutho oluyinkimbinkimbi kulokhu, njengoba sibona. Ukuze wenze lokhu, udinga ukusebenzisa i-division operator noma umsebenzi I-PRIVATE. Eyokuqala ibala inani ngendlela efanayo ncamashi nesibali. Owesibili angathola inombolo ngaphandle kwensalela, engase ibe usizo ekubaleni.

Qiniseka ukuthi uyazijwayeza ngaphambi kokusebenzisa le misebenzi ekusebenzeni kwangempela. Yiqiniso, akukho lutho oluyinkimbinkimbi kulezi zenzo, kodwa ukuthi umuntu ufunde okuthile kungashiwo kuphela lapho enza izenzo ezifanele ngokuzenzakalelayo, futhi enze izinqumo intuitively.