Mukamagwira ntchito ndi njira mu pulogalamu ya Microsoft Excel, ogwiritsa ntchito amayenera kugwira ntchito molingana ndi maselo ena omwe ali mu chikalatacho. Koma, si wogwiritsa aliyense amadziwa kuti maumboni awa ndi mitundu iwiri: mtheradi ndi wachibale. Tiyeni tiwone zomwe zimasiyana wina ndi mnzake komanso momwe angapangire ulalo wa mtundu womwe mukufuna.
Kutsimikiza mtima ndi maulalo athengo
Kodi maulalo ndi ogwirizana ndi chiyani?Maulalo olumikizana ndi maulalo, pokopera omwe ma cell sasintha, ali m'malo okhazikika. Mu zonena za cur, ma cell a maselo amasinthidwa pokopera, wachibale ndi ma cell ena.
Chitsanzo cha Mphunzitsi Wachibale
Tiyeni tiwone momwe zimachitikira pa chitsanzo. Tengani tebulo lomwe lili ndi nambala ndi mtengo wa zinthu zosiyanasiyana zamalonda. Tiyenera kuwerengera mtengo wake.
Izi zimachitika ndi kuchulukitsa kosavuta kwa kuchuluka kwake (Column B) pamtengo (mzere c). Mwachitsanzo, kwa dzina loyamba la mankhwalawa, njirayo ionekere "= B2 * * C2". Lowani patebulo yoyenera patebulo.
Tsopano, moyenera pamanja, musayendetse ma cell omwe ali pansipa, kungokonzera njira iyi. Timakhala pansi mpaka kumapeto kwa maselo omwe ali ndi formula, dinani batani lakumanzere, ndipo batani litafinya, ndikukoka mbewa pansi. Chifukwa chake, njirayo idzalembedweranso kumaselo ena a tebulo.
Koma, monga tikuwona, formula cell sawoneka "= B2 * * C2", koma "= B3 * C3". Chifukwa chake, mabungwe amenewo omwe ali pansipa asintha. Ichi ndiye katundu wosintha mukamakopera ndikukhala ndi maulalo.
Cholakwika mu ulalo wachibale
Koma, osati nthawi zonse, timafunikira kulumikizana. Mwachitsanzo, tifunika kuwerengera mtengo wapadera wa mtengo uliwonse wa dzina lililonse kuchokera ku ndalama zonse. Izi zimachitika pogawa mtengo wa ndalama zonse. Mwachitsanzo, kuwerengera gawo la mbatata, ndife mtengo wake (d2) kugawa ndalama zonse (D7). Timapeza njira yotsatirayi: "= D2 / D7".
Pakachitika kuti timayesa kukopera mzerewo kumizere ina mofananamo monga kale, ndiye kuti timapeza zotsatira zosakhutira. Monga tikuwonera, mu mzere wachiwiri wa tebulo la fomula, ili ndi mawonekedwe "= D3 / D8" zotsatira.
D8 ndi khungu lopanda kanthu, motero fomba ndikupereka cholakwika. Momwemonso, formula yomwe ili pansipa ifotokoza za maselo a D9, etc. Ndikofunikiranso kuti potengera kulumikizana kwa khungu la D7 limasungidwa nthawi zonse, pomwe ndalama zonse zili, ndipo katunduyu ali ndi maulalo kwathunthu.
Kupanga Ulalo Wogwirizana
Chifukwa chake, chifukwa cha chitsanzo chathu, wogawayi uyenera kufotokozera pamzere uliwonse wa tebulo, ndipo gawo liyenera kufotokozedwa kwathunthu, zomwe zimatchulidwanso ndi khungu limodzi.
Ndi chilengedwe cha maulalo ang'onoang'ono, ogwiritsa ntchito sadzakhala ndi mavuto, popeza mafotokozedwe onse a Microsoft Excorn ndi wachibale. Koma ngati mukufuna kulumikizana kwathunthu, muyenera kuyika phwando limodzi.
Fomuyo ikalowetsedwa, ingoyikeni mu khungu, kapena mu mawonekedwe, kutsogolo kwa mgwirizano wa cell ndi kachipinda kamene kalankhulidwe kalankhulidwe ka dola. Muthanso kulowa adilesi, dinani batani la F7 nthawi yomweyo, ndipo zizindikiro za dola zisanachitike zingwe ndi mzati zidzawonetsedwa zokha. Fomu ya cell yapamwamba idzatenga mtunduwu: "= D2 / $ D $ 7".
Koperani formula pansi mzati. Monga mukuwonera, nthawi ino iliyonse itayamba. M'maselo ndi mfundo zolondola. Mwachitsanzo, mu mzere wachiwiri wa tebulo la formula temp limawoneka ngati "= D3 / $ D $ 7", ndiye kuti wogawayo wasintha, ndipo othetsa zinthu sizimasintha.
Maulalo osakanikirana
Kuphatikiza pa maumboni wamba komanso osagwirizana, pamakhala maulalo osakanikirana. Mwa iwo, chimodzi mwazinthu zosiyanasiyana zimasiyanasiyana, ndipo chachiwiri chokhazikitsidwa. Mwachitsanzo, kutanthauzira kosiyanasiyana $ D7, mzere umasintha, ndipo mzerewo umakhazikika. Reference d $ 7, m'malo mwake, mawonekedwe ake asintha, koma mzerewu uli ndi mtengo wokwanira.
Monga tikuwonera, mukamagwira ntchito ndi njira zomwe zili mu pulogalamu ya Microsoft Excortl, muyenera kugwira ntchito ndi zilumikizozo zonse ziwiri zogwirizana ndi zogwirizana kuti muchite ntchito zosiyanasiyana. Nthawi zina, maulalo osakanizika amagwiritsidwanso ntchito. Chifukwa chake, wogwiritsa ntchitoyo ngakhale avarejiyo ayenera kumvetsetsa bwino kusiyana pakati pawo, ndikutha kugwiritsa ntchito zida izi.