Pogwira ntchito ndi mitundu mu Microsoft Excel, ogwiritsa ntchito amayenera kugwira ntchito yolumikizana ndi ma cell ena omwe ali mu chikalatacho. Koma, sikuti wogwiritsa ntchito aliyense amadziwa kuti maulalo awa ndi amitundu iwiri: Mtheradi komanso wachibale. Tiyeni tiwone momwe amasiyana pakati pawo, komanso momwe angapangire kulumikizana kwa mtundu womwe angafune.
Tanthauzo la zolumikizana zokhazokha komanso za abale
Kodi zolumikizana mwamtheradi komanso za abale ndi ziti ku Excel?
Zolumikizira zenizeni ndi maulalo mukamakopera zomwe zogwirizanitsa zama cell sizisintha, zimakhala pamalo okhazikika. Mwamalumikizidwe, magwirizano a maselo amasintha mukamakopera, maselo ena maselo.
Zitsanzo Zogwirizana
Tikuwonetsa momwe izi zimathandizira ndi chitsanzo. Tengani tebulo lomwe lili ndi kuchuluka ndi mtengo wa mayina osiyanasiyana azogulitsa. Tiyenera kuwerengera mtengo wake.
Izi zimachitika pongochulukitsa kuchuluka (mzati B) ndi mtengo (mzati C). Mwachitsanzo, pazina loyamba lazopanga, mawonekedwe ake amawoneka motere "= B2 * C2". Timalowetsa mu khungu lolingana la tebulo.
Tsopano, kuti musayende mwazomwe mukugwiritsa ntchito maselo omwe ali pansipa, ingolembetsani fomulamu yonse. Tikuimirira m'mphepete lamanja lam'mphepete mwa foniyo ndi chilinganizo, dinani batani lakumanzere, ndipo batani likakanikizidwa, kokerani mbewa pansi. Chifukwa chake, fomuloli imakopeka maselo ena a tebulo.
Koma, monga momwe tikuwonera, kachitidwe mu cell yapansi kale sikuwoneka "= B2 * C2", ndi "= B3 * C3". Chifukwa chake, mawonekedwe omwe ali pansipa nawonso amasinthidwa. Katunduyu amasintha mukamakopera komanso kukhala ndi zolumikizana.
Vuto lolumikizana ndi ulalo
Koma, kutali ndi onsewa timafunikira maulalo ocheperako. Mwachitsanzo, tikufunika pagome lomweli kuwerengera gawo la mtengo wazinthu zilizonse kuchokera pazokwanira. Izi zimachitika pogawa mtengo ndi kuchuluka. Mwachitsanzo, kuti tidziwe kukula kwa mbatata, timagawa mtengo wake (D2) ndi kuchuluka kwake (D7). Tikupeza njira zotsatirazi: "= D2 / D7".
Ngati tiyesera kutsata formula ku mizere inanso monga momwe idalili kale, tidzapeza zotsatira zosakhutira kwathunthu. Monga mukuwonera, kale mzere wachiwiri wa tebulo, kachitidwe kamene kali ndi mawonekedwe "= D3 / D8", sikuti kungolumikizana ndi foni ndi kuchuluka komwe kumayendetsedwa ndi mzere, komanso kulumikizana ndi foni yomwe imayang'anira zonse.
D8 ndi khungu lopanda kanthu, choncho mawonekedwe ake amapereka cholakwika. Chifukwa chake, kachitidwe pamizere pansipa padzatchulira foni D9, ndi zina zambiri. Koma tikuyenera kusunga ulalo wa foni D7 pomwe chiwerengero chonsecho chimapezeka tikakopera, ndipo maulalo onse ali ndi malowa.
Pangani cholumikizira chonse
Chifukwa chake, mwachitsanzo chathu, wogawanikayo akhale cholumikizana, ndikusintha mumizere iliyonse ya tebulo, ndipo gawoli liyenera kukhala cholumikizira chonse chomwe chimafotokoza za selo limodzi.
Ogwiritsa ntchito sangakhale ndi mavuto pakupanga maulalo, popeza maulalo onse mu Microsoft Excel ndi okhazikika. Koma, ngati mukufuna kupanga cholumikizira chonse, muyenera kugwiritsa ntchito njira imodzi.
Fomula italowetsedwa, timangoyika mu cell, kapena mu barula yokhazikitsidwa, kutsogolo kwa maulalo a mzere ndi mzere wa foni yomwe mukufuna kuphatikiza kwathunthu, chizindikiro cha dollar. Mukhozanso, mutangolowa adilesi, ndikanikizeni kiyi ya F7, ndi zizindikiro za dollar patsogolo pa mzere ndikuwonetsedwa pazolowera. Machitidwe omwe ali mu cell yapamwamba amatenga mawonekedwe otsatirawa: "= D2 / $ D $ 7".
Patani chilinganizo pansi. Monga mukuwonera, nthawi ino zonse zidatha. Maselo ali ndi mfundo zoyenera. Mwachitsanzo, mzere wachiwiri wa tebulo, kachitidwe kamawoneka "= D3 / $ D $ 7", ndiye kuti wogawanitsa wasintha, ndipo gawoli lakhalabe losasinthika.
Maulalo osakanikirana
Kuphatikiza pazolumikizana zofanana ndi zilizonse, palinso maulalo osakanikirana. Mwa iwo, chimodzi mwazinthu zimasintha, ndipo chachiwiri chimakonzedwa. Mwachitsanzo, ulalo wosakanikirana $ D7 umasintha mzere ndipo mzatiyo ndi wokhazikika. Maulalo D $ 7, m'malo mwake, amasintha mzati, koma mzerewu uli ndi mtengo wokwanira.
Monga mukuwonera, mukamagwira ntchito ndimagulu mu Microsoft Excel, muyenera kugwira ntchito ndi maulalo onse apabanja komanso mwamtheradi kuti mugwire ntchito zosiyanasiyana. Nthawi zina, maulalo osakanikirana amagwiritsidwanso ntchito. Chifukwa chake, wogwiritsa ntchito wapakatikati ayenera kuzindikira bwino kusiyana pakati pawo, ndikutha kugwiritsa ntchito zida izi.
