Mukamagwira ntchito ndi Microsoft Excel, ogwiritsa ntchito amayenera kugwiritsidwa ntchito ndi maulumikilo a maselo ena omwe ali m'kabuku. Koma osati wosuta aliyense amadziwa kuti maulumikiziwa ali awiri a mitundu: mwamtheradi ndi wachibale. Tiyeni tione momwe amasiyana pakati pawo, ndi momwe angapangire chiyanjano cha mtundu wofunikila.
Tanthauzo la maulumikizano omvera ndi achibale
Kodi mndandanda wa mgwirizano ndi wachibale ndi Excel?
Zolumikizo zomveka ndi maulaliki omwe, pamene amakopera, makonzedwe a maselo samasintha, ali mu chikhazikitso. Mu maulumikizano ofanana, magwirizanitsidwe a maselo amasintha pamene amalembedwa, okhudzana ndi maselo ena a pepala.
Chitsanzo chofotokozera
Tiyeni tiwonetse momwe izi zimagwirira ntchito ndi chitsanzo. Tengani tebulo yomwe ili ndi kuchuluka ndi mtengo wa mitundu yosiyanasiyana ya mankhwala. Tiyenera kuwerengera mtengo.
Izi zimachitika pokhapokha kuchulukitsa kuchuluka (chigawo B) ndi mtengo (chigawo C). Mwachitsanzo, chifukwa cha dzina loyamba, mankhwalawo angawoneke ngati "= B2 * C2". Timalowa mu selo lofanana la tebulo.
Tsopano, kuti tisayendetse pamayendedwe a maselo omwe ali m'munsimu, timangoponyera ndondomekoyi ku khola lonselo. Timakhala pamunsi mwachindunji cha selo lachangidwe, dinani kumbuyo kwasakani pakasakani ndikukoka khola pansi pamene batani ili pansi. Choncho, njirayi imakopedwa ku maselo ena a tebulo.
Koma, monga momwe tikuonera, ndondomeko ya selo yapansi sizimawonekera "= B2 * C2"ndi = = B3 * C3 ". Choncho, mawonekedwe pansipa amasinthidwa. Malowa amasintha pamene akujambula komanso akugwirizana.
Cholakwika pa kugwirizana kofanana
Koma, osati nthawi zonse timafunikira ziyanjano zofanana. Mwachitsanzo, tikufunikira tebulo lomwelo kuti tiwerenge gawo la mtengo wa chinthu chilichonse cha katundu kuchokera pa ndalama zonse. Izi zimachitika pogawa ndalama ndi ndalama zonse. Mwachitsanzo, kuti tiwerenge kuchuluka kwa mbatata, timagawaniza mtengo wake (D2) ndi chiwerengero cha D7). Timapeza njira yotsatirayi: = = D2 / D7 ".
Ngati tiyesa kufotokozera fomuyi m'njira zina monga nthawi yoyamba, timapeza zotsatira zosatsutsika. Monga mukuonera, mzere wachiwiri wa tebulo, mawonekedwewo ali ndi mawonekedwe = = D3 / D8 ", ndiko kuti, osati kutchulidwa kwa selo ndi chiwerengero cha mzerewu, komanso kutchulidwa kwa selo wotsogoleredwa ndi chiwerengerochi chasintha.
D8 ndi selo yopanda kanthu, kotero chiganizo chimapereka cholakwika. Choncho, ndondomeko yomwe ili m'munsimu idzaimira selo D9, ndi zina zotero. Komabe, tikusowa kuti pamene mukujambula, kutchulidwa kwa selo D7 kumasungidwa nthawi zonse, kumene chiwerengero chonsecho chilipo, ndipo maumboni onse ali ndi katundu.
Pangani mgwirizano weniweni
Kotero, kwa chitsanzo chathu, wopereka malangizo ayenera kukhala wachidule, ndipo asinthe mzere uliwonse wa tebulo, ndipo gawoli liyenera kukhala liwu loti nthawi zonse likutanthauza selo limodzi.
Pogwiritsa ntchito maulumikizano othandizira, ogwiritsa ntchito sadzakhala ndi mavuto, chifukwa maulumikizi onse a Microsoft Excel ali okhudzana ndi osasintha. Koma ngati mukufuna kupanga mgwirizano, muyenera kugwiritsa ntchito njira imodzi.
Ndondomekoyi italowetsedwa, timangowika mu selo, kapena muzenera, kutsogolo kwa makonzedwe a chingwe ndi selolo, zomwe ziyenera kukhazikitsidwa, chizindikiro cha dola. Mukhozanso, mutangotha kulowa ku adilesiyi, yesani F7 ntchito yofunikira, ndipo zizindikiro za dola ziwonekera mosavuta kutsogolo kwa mzere ndi mndandanda wa zigawo. Mawonekedwe omwe ali pamwamba pa selo adzawoneka ngati awa: "= D2 / $ D $ 7".
Lembani ndondomekoyi pansi pa ndimeyo. Monga mukuonera, nthawi ino chirichonse chinachokera. Maselo ndi amtengo wapatali. Mwachitsanzo, mu mzere wachiwiri wa tebulo, mawonekedwe akuwoneka ngati "= D3 / $ D $ 7", ndiko kuti, wogawikana wasintha, ndipo phindu likusintha.
Zosakanikirana
Kuphatikiza pa mawonekedwe amtheradi ndi achibale, pali zotsatizana zowonjezera. Mwa iwo, chimodzi mwa zigawozo chimasiyanasiyana, ndipo chachiwiri chimakhazikitsidwa. Mwachitsanzo, mudongosolo losakanikirana ndi $ D7, mzere umasinthidwa, ndipo chigawocho chikhazikitsidwa. Kulumikizana D $ 7, mosiyana, kumasintha gawo, koma mzere uli ndi mtengo wapatali.
Monga mukuonera, pamene mukugwira ntchito ndi malemba mu Microsoft Excel, muyenera kugwira ntchito limodzi ndi maulumikizano onse kuti mugwire ntchito zosiyanasiyana. Nthawi zina, zowonjezereka zimagwiritsidwanso ntchito. Choncho, wogwiritsa ntchito ngakhale mlingo woyenera ayenera kumvetsetsa bwino kusiyana kwake, ndikutha kugwiritsa ntchito zipangizozi.
