Incazelo yencazelo yeselula futhi isebenzise ku-Excel nama-Google AmaSpredishithi
Ukubhekisela kweseli ezinhlelweni zespredishithi njenge-Excel ne- Google AmaSpredishithi zikhomba indawo yeseli ekhasini lokusebenzela .
Iseli ingenye yezakhiwo ezinjengebhokisi ezigcwalisa ishidi lokusebenzela futhi iseli ngayinye ingatholakala ngezinkomba zayo zeseli - njenge-A1, F26 noma i-W345 - equkethe incwadi yekholomu nenombolo yomugqa ehamba endaweni yeseli. Uma ufaka uhlu lwebheli, incwadi yekholomu ihlale ibhalwe kuqala
Izikhombisi zeselula zisetshenziselwa amafomula , imisebenzi, amashadi , kanye neminye imiyalo ye-Excel.
Ukubuyekeza amafomula namashadi
Enye inzuzo yokusebenzisa izingqamuzana zamangqamuzana kumafomulashethi wespredishithi yilokho, ngokuvamile, uma idatha etholakala kumaseli athile aguqulwa, ifomula noma ishadi libuyekezwa ngokuzenzekelayo ukuze libonise ushintsho.
Uma ibhuku lokusebenzela selihlelwe ukuthi lingabuyekeze ngokuzenzekelayo uma izinguquko zenziwe kwiphepha lokusebenzela, ukubuyekezwa kokubhaliwe kungenziwa ngokucindezela ukhiye we-F9 ekhibhodi.
Ama-Worksheets ahlukene nezincwadi zokusebenza
Ukusetshenziswa kwezinkomba zeselula akukhawulelwanga kwiphepha elifanayo lomsebenzi lapho idatha ikhona khona. Amaseli angabhekiswa emafishini ahlukene asebenzayo.
Uma lokhu kwenzeka, igama lephepha lokusebenzela lifakiwe njengoba kuboniswe kwifomula emgqeni wesi-3 esithombeni ngenhla ehlanganisa ukubhekisela kweseli A2 kwiShidi 2 lencwadi efanayo.
Ngokufanayo, uma idatha esekelwe encwadini ehlukile ibhalwe, igama lencwadi kanye nephepha lokusebenzela lifakwe ekubhekiseni kanye nendawo yeseli. Ifomula emgqeni wesi-3 esithombeni ifaka ireferensi yeseli elingu-A1 eliseshidi 1 leBhuku2 - igama lencwadi yesibili.
Uhlobo lwamaseli A2: A4
Ngenkathi izinkomba zivame ukubhekisela kumaseli ngabanye - njenge-A1, angabhekisela eqenjini noma ububanzi bamaseli.
Amangqamuzana ahlonishwa yizikhombisi zeseli zamaseli ezingxenyeni ezingenhla ezingakwesokunxele nangaphansi kwesokudla.
Izingqikithi ezimbili zamaseli ezisetshenziselwa ububanzi zihlukaniswe nge-colon (:) ezitshela i-Excel noma i-Google Spreadsheets ukuthi ifake wonke amaseli phakathi kwala maphuzu okuqala nokuphela.
Isibonelo sobubanzi bamaseli aseduze siboniswa emgqeni wesi-3 wesithombe ngaphezulu lapho umsebenzi we-SUM usetshenziselwa ukuqedela izinombolo ku-A2: A4.
Ama-Relative, Absolute, nama-Mixed Cell References
Kunezinhlobo ezintathu zezikhombisi ezingasetshenziswa ku-Excel nama-Google AmaSpredishithi futhi zikhonjiswe kalula ngokuba khona noma ukungabikho kwezimpawu zama dollar ($) ngaphakathi kokubhekiselwe kweseli:
- Izikhombisi zezinhlobo ezihlobene aziqukethe izimpawu ze dollar - njengoba kuboniswe kwifomula emgqeni 2: = A2 + A4;
- izinkomba eziphelele zeseli zinempawu ze dollar ezifakwe encwadini ngayinye noma enombhalweni - njengoba kuboniswe kwifomula emgqeni 4: = $ A $ 2 + $ A $ 4;
- izinkomba ezixubile zezinhlamvu zinezibonakaliso zama dollar ezinamathele kunoma iyiphi incwadi noma inombolo encwadini kodwa hhayi kokubili - njengoba kuboniswe kwifomula emgqeni 5: = $ A2 + A $ 4.
Ukukopisha amafomula kanye nezinkomba ezihlukene zezinombolo
Inzuzo yesibili yokusebenzisa izingqikithi zamangqamuzana ngamafomula ukuthi yenza kube lula ukukopisha amafomula kusuka kwenye indawo kuya kwesinye kwiphepha lokusebenzela noma ibhuku lokusebenzela .
Izingqikithi zeseli ezihlobene zishintsha uma zikopishwa ukubonisa indawo entsha yefomula. Isibonelo, uma ifomula
= A2 + A4
ikopishwe kusuka esitokisini B2 kuya ku-B3, izinkomba zizoshintsha ukuze ifomula ibe:
= A3 + A5
Igama lesihlobo livela eqinisweni lokuthi liyashintsha ngokuphathelene nendawo yayo uma ikopishwe. Lokhu ngokuvamile kuyinto enhle futhi yingakho izinkomba eziphathelene nama cell are the type of reference reference okusetshenziselwa ngamafomula.
Ngesinye isikhathi, noma izikhombisi zezingcingo zidinga ukuhlala ziqinile lapho amafomula ekopishwa. Ukuze wenze lokhu, ukubhekisela okuphelele (= $ A $ 2 + $ A $ 4) isetshenziselwa ukuthi ayishintshi uma ikopishwe.
Noma kunjalo, ngezinye izikhathi, ungase ufune ingxenye yereferensi yeseli ukuze ushintshe - njengale ncwadi yekholomu - ngenkathi inombolo yomugqa ihlala static - noma ngokuphambene lapho ifomu likopishwa.
Yilapho ireferensi yeseli ehlanganisiwe isetshenziselwa (= $ A2 + A $ 4). Kungakhathaliseki ukuthi iyiphi ingxenye yereferensi ene-dollar isinamathiselwe kuyo ihlala igxilile, kanti enye ingxenye iyashintsha uma ikopishwa.
Ngakho-ke nge $ A2, uma ikopishwa, incwadi yekholomu izohlala ibe yi-A, kodwa izinombolo zomugqa zizoshintshela ku-$ A3, $ A4, $ A5, njalo njalo.
Isinqumo sokusebenzisa izingqikithi ezahlukene zesithenjwa uma udala ifomula isekelwe endaweni yedatha ezosetshenziswa ngamafomula akopishiwe.
Sebenzisa i-F4 ukuze ungeze izimpawu ze-Dollar
Indlela elula yokushintsha izingqikithi zeseli ezihlobene nokuphelele noma okuxubene ukucindezela ukhiye we-F4 ekhibhodi:
Ukuze ushintshe izingqikithi zeseli ezikhona, i-Excel kumele ibe kumodi yokuhlela, engenziwa ngokuchofoza kabili kuseli ngesinxele segundane noma ngokucindezela ukhiye we-F2 kwikhibhodi.
Ukuze uguqule izinkomba ezisezingeni elincane ezibhekiselwe kuzo:
- Cindezela u-F4 kanye ukuze ulungise ireferensi yeseli ngokuphelele njenge $ A $ 6
- Cindezela i-F4 okwesibili ukudala ireferensi elixubekile lapho inombolo yombhalo iphelele njenge-A $ 6
- Cindezela uF4 okwesithathu ukwakha ireferensi elixubekile lapho incwadi yekholomu iphelele njenge $ A6
- Cindezela u-F4 okwesine okwenzela ukuphindaphinda isixhumanisi se-cell njenge-A6.