Lapho usebenza amafomula eMicrosoft Excel, abasebenzisi kufanele basebenze nezixhumanisi kwamanye amaseli akulo mbhalo. Kepha, akuwona wonke umsebenzisi owazi ukuthi lezi zixhumanisi zingezinhlobo ezimbili: ngokuphelele nesihlobo. Ake sibheke ukuthi bahluke kanjani phakathi kwabo, nokuthi bangasakha kanjani isixhumanisi sohlobo olufunayo.
Incazelo yezixhumanisi eziphelele nezihlobene
Yini izixhumanisi eziphelele nezihlobene ku-Excel?
Izixhumanisi ezingaphelele ziyizixhumanisi lapho kukopishwa ukuthi izixhumanisi zamaseli aziguquki, zikusimo esimisiwe. Ekuxhumaniseni okuhlobene, izixhumanisi zamaseli ziyashintsha lapho zikopisha, zihlobene namanye amaseli eshidini.
Isibonelo sesixhumanisi esihlobene
Sibonisa ukuthi kusebenza kanjani lokhu ngesibonelo. Thatha itafula eliqukethe inani nentengo yamagama wemikhiqizo ahlukahlukene. Sidinga ukubala izindleko.
Lokhu kwenziwa ngokumane kuphindaphindwe inani (ikholamu B) ngentengo (ikholamu C). Isibonelo, egameni lomkhiqizo wokuqala, ifomula izobukeka kanjena "= B2 * C2". Siyifaka esitokisini esihambisanayo setafula.
Manje, ukuze ungashayeli ngesandla ngokufomatha kwamaseli angezansi, vele ukopishe leli fomula kulo lonke ikholamu. Simi onqenqemeni olungezansi kweseli ngefomula, chofoza inkinobho yegundane kwesobunxele, futhi uma inkinobho icindezelwe, donsela igundane phansi. Ngakho-ke, ifomula ikopishelwa kwamanye amaseli etafula.
Kepha, njengoba sibona, ifomula esitokisini esingezansi isivele ingabukeki "= B2 * C2", futhi "= B3 * C3". Ngokuhambisana, amafomula angezansi nawo ayaguqulwa. Le mpahla iyashintsha uma ukopisha futhi unezixhumanisi ezihlobene.
Iphutha lesixhumanisi
Kepha, kude kuzo zonke izimo sidinga izixhumanisi ezihlobene ngqo. Isibonelo, sidinga ethebuleni elifanayo ukubala isabelo sezindleko zento ngayinye yezimpahla ezivela ku-isiyonke. Lokhu kwenziwa ngokuhlukanisa izindleko ngenani eliphelele. Isibonelo, ukubala amandla athize amazambane, sihlukanisa inani laso (D2) ngenani eliphelele (D7). Sithola ifomula elandelayo: "= D2 / D7".
Uma sizama ukukopisha ifomula kweminye imigqa ngendlela efanayo nesikhathi esedlule, sizothola umphumela ongagculisi ngokuphelele. Njengoba ubona, kumugqa wesibili wethebula, ifomula inefomu "= D3 / D8", okungukuthi, hhayi ukuxhumana kuphela kweseli enesamba esithuthwe ngumugqa, kodwa futhi nesixhumanisi seseli elibhekele inani lelo.
I-D8 yiseli engenalutho ngokuphelele, ngakho-ke ifomula inika iphutha. Ngokuvumelana nalokho, ifomula esemugqeni ongezansi izobhekisa kuseli D9, njll. Kepha sidinga ukugcina ukuxhumana kusi-cell D7 lapho kutholakala khona ingqikithi lapho kukopishwa, futhi izixhumanisi eziphelele zinempahla enjalo.
Dala isixhumanisi esiphelele
Ngakho-ke, ngokwesibonelo sethu, isahlukanisi kufanele sibe isixhumanisi esilinganiselweyo, futhi ushintsho kumugqa ngamunye wethebula, futhi ukwahlukaniswa kufanele kube isixhumanisi esiphelele esisho njalo kuseli elilodwa.
Abasebenzisi ngeke babe nezinkinga zokwenza izixhumanisi ezihlobene, ngoba zonke izixhumanisi ezikwiMicrosoft Excel zihlobene ngokuzenzakalelayo. Kepha, uma udinga ukwenza isixhumanisi esiphelele, kuzofanela usebenzise inqubo eyodwa.
Ngemuva kokuthi ifomula ifakiwe, simane nje sifake esitokisini, noma kubha yefomula, phambi kwezixhumanisi zekholomu kanye nomugqa weseli ofuna ukwenza ukuxhumana ngokuphelele, uphawu lwedola. Futhi unga, ngokushesha ngemuva kokufaka ikheli, cindezela ukhiye wokusebenza we-F7, nezimpawu zamadola phambi komugqa nezixhumanisi zekholomu kuzovezwa ngokuzenzakalelayo. Ifomula esesitokisini esiphezulu izothatha le ndlela elandelayo: "= D2 / $ D $ 7".
Kopisha ifomula phansi ikholomu. Njengoba ukwazi ukubona, kulokhu yonke into yaphumelela. Amaseli aqukethe amanani afanele. Isibonelo, emgqeni wesibili wethebula, ifomula libukeka "= D3 / $ D $ 7", okungukuthi, isahlukanisi sesiguqukile, kanti ukwahlukaniswa kuhleli kungashintshiwe.
Izixhumanisi ezixubekile
Ngaphezu kwezixhumanisi ezijwayelekile zangempela nezihlobene, kukhona ukuxhumana okubizwa ngokuthi ukuxubile. Kuzo, enye yezakhi iyashintsha, bese eyesibili ilungiswe. Isibonelo, isixhumanisi esihlanganisiwe $ D7 sishintsha umugqa bese ikholomu ihleliwe. Isixhumanisi D $ 7, Ngokuphambene nalokho, sishintsha ikholomu, kepha umugqa unenani eliphelele.
Njengoba ukwazi ukubona, lapho usebenza namafomula eMicrosoft Excel, kufanele usebenze nezixhumanisi zombili nezihlobene ngokuphelele ukwenza imisebenzi ehlukahlukene. Kwezinye izimo, izixhumanisi ezixubile nazo ziyasetshenziswa. Ngakho-ke, noma umsebenzisi osezingeni eliphakathi nendawo kufanele aqonde kahle umehluko phakathi kwabo, futhi akwazi ukusebenzisa la mathuluzi.
