Xa usebenza neefomula kwiNkqubo ye-Microsoft Excel, abasebenzisi kufuneka basebenze ngokubhekisele kwezinye iiseli ezikwixwebhu. Kodwa, ayinguye wonke umsebenzisi esazi ukuba ezi ngxelo zizinto ezimbini: ezigqibeleleyo nezihlobo. Masifumanise ukuba bahluke njani komnye nomnye kunye nendlela yokwenza ikhonkco lohlobo olufunayo.
Ukuzimisela kwekhonkco elipheleleyo nelinganayo
Yintoni i-computer nelinganayo kwi-Excele?Iindlela ezigqibeleleyo zinxibelelana, xa ukukopa ukuba yeyiphi i-sel yokulungelelanisa ukuba ingatshintshi, zikwimeko eqingqiweyo. Ngokubhekisele kwizalathiso, ukulungelelaniswa kweeseli kutshintshwa xa kuqalwa, kuhambelana nezinye iiseli zephepha.
Umzekelo wesalathiso sesalamane
Makhe sibonise ukuba isebenza njani kumzekelo. Thatha itafile enenombolo kunye nexabiso lezinto ezahlukeneyo zemveliso. Kufuneka sibala iindleko.
Oku kwenziwa ngokuphindaphindwa ngokulula kwenani (ikholamu B) kwixabiso (ikholamu c). Umzekelo, kwigama lokuqala lemveliso, ifomula iya kujonga njalo "= B2 * c2". Ngenisa kwitafile efanelekileyo yetafile.
Ngoku, ukwenzela ngesandla, musa ukuqhuba iifomula zeselfowuni ezikwezantsi, ikopi ngokulula kwikholamu yonke. Sibe semphethweni osemazantsi weseli eziseleni kunye nefomula, cofa iqhosha lemouse lasekhohlo, kwaye xa iqhosha likhutshelwe, ukutsala imouse phantsi. Ke, ifomula iya kutyunjelwa kwezinye iiseli zetafile.
Kodwa, njengoko sibona, ifomula kwiseli esezantsi ayijongi "= B2 * C2", kodwa "= = B3 * C3". Ngokuhambelana, ezo fomula zilapha ngezantsi zitshintshile. Le yipropathi yotshintsho xa kutsala kwaye unakho amakhonkco.
Impazamo kwikhonkco
Kodwa, hayi kuzo zonke iimeko, sifuna amakhonkco onxibelelwano. Umzekelo, kufuneka ukubala ixabiso elithile lexabiso legama ngalinye lemveliso ukusuka kwinani lilonke. Oku kwenziwa ngokwahlula indleko zexabiso lilonke. Umzekelo, ukubala isabelo seetapile, siyindleko zaso (D2) sahlulela inani lilonke (D7). Sifumana le fomula ilandelayo: "= d2 / d7".
Kwimeko apho sizama ukukopa ifomula kwiminye imigca ngendlela efanayo nexesha elidlulileyo, emva koko sifumana isiphumo sokungakhathali ngokupheleleyo. Njengoko sibona, kumgca wesibini wetafile yefomula, inemilo "= d3 / d8", oko kukuthi, ayisiyo ikhonkco kwilayini ngomgca, kodwa nekhonkco kwiseli enoxanduva Isiphumo esiqhelekileyo.
I-D8 sisisele esingenanto ngokupheleleyo, ke ngoko ifomula kwaye inike impazamo. Ngokuhambelana, ifomula kumtya ongezantsi iya kubhekisa kwiseli ye-D9, njl. Kuyimfuneko ukuba ukukopa ikhonkco kwiseli ye-D7 kuhlala kugcinwa rhoqo, apho imali iyonke ibekwe, kwaye le propati inonxibelelwano olupheleleyo.
Ukwenza ikhonkco olupheleleyo
Ngenxa yoko, umzekelo, umzi-sahluli kufuneka ube lisalathiso, kwaye utshintsha kumgca ngamnye wetafile, kwaye isahlulo kufuneka sibe yireferensi epheleleyo, ehlala ikhutshelwe kwiseli enye.
Ngokudalwa kweekhonkco ezinxulumene, abasebenzisi abayi kuba neengxaki, kuba zonke iimbekiselo zeMicrosoft Excel zihambelana nokungagqibekanga. Kodwa ukuba ufuna ukwenza ikhonkco eligqibeleleyo, kuya kufuneka ufake isicelo sokwamkela enye.
Emva kokuba kufakwe ifomula, inxibe nje iseli, okanye kwifolokhwe, phambi kokulungelelaniswa kwekholamu kunye nemigca ye-plar. Unokufumana, ngokukhawuleza emva kokungena kwidilesi, cinezela iqhosha le-F7 ngokomsebenzi, kunye neempawu zedola ngaphambi kokuba kudityaniswe intambo yomtya kunye nekholamu iya kubonakaliswa ngokuzenzekelayo. Ifomula kwiseli ephezulu kakhulu iya kuthatha olu hlobo: "= d2 / $ d $ 7".
Khuphela ifomula phantsi kwikholamu. Njengoko ubona, ngeli xesha yonke into iphelelwe. Kwiiseli zixabiso elifanelekileyo. Umzekelo, kumgca wesibini wetafile yefomula ibonakala ngathi "= D3 / $ D $ 7", oko kukuthi, lo mdyarho utshintshile, kwaye i-Disdaided iguqukile.
Amakhonkco axubeneyo
Ukongeza kwizalathiso eziqhelekileyo kunye nezalathiso eziqhelekileyo, kukho amakhonkco abizwa ngokuba zidityaniswe. Kuyo, elinye lamacandelo liyahluka, kwaye okwesibini ilungisiwe. Umzekelo, kwisalathiso esixubeneyo $ D7, uguquko lwelayini, kwaye ikholamu ilungisiwe. Isalathiso D $ 7, ngokuchaseneyo, ikholamu itshintsha, kodwa umgca unexabiso elipheleleyo.
Njengoko sibona, xa sisebenza neefomula kwiNkqubo ye-Microsoft Excel, kuya kufuneka usebenze kunye nolawulo kunye nonxibelelwano olupheleleyo ukwenza imisebenzi eyahlukeneyo. Ngamanye amaxesha, amakhonkco axubeneyo asetyenziswa. Ke ngoko, umsebenzisi nenqanaba lomndilili kufuneka aqonde ngokucacileyo umahluko phakathi kwabo, kwaye akwazi ukusebenzisa ezi zixhobo.