Lokacin aiki tare da dabaru a Microsoft Excel, masu amfani dole suyi aiki tare da hanyoyin haɗin yanar gizo zuwa wasu sel da ke cikin takaddar. Amma, ba kowane mai amfani da ya san cewa waɗannan hanyoyin haɗin yanar gizon sun kasance nau'i biyu: cikakke kuma dangi. Bari mu bincika yadda suka bambanta tsakanin kansu, da kuma yadda za a ƙirƙiri hanyar haɗi da nau'in da ake so.
Ma'anar cikakkiyar hanyoyin haɗin kai
Menene hanyoyin haɗin kai da haɗin gwiwa a cikin Excel?
Cikakken hanyoyin haɗin yanar gizo shine lokacin da aka kwafa wanda abubuwan haɗin gwiwar ba su canzawa, suna cikin ingantaccen yanayi. A cikin hanyoyin haɗin gwiwa, daidaitawar sel suna canzawa yayin kwafa, dangane da sauran sel a cikin takardar.
Misalin Hadin Kai da Gwiwa
Mun nuna yadda wannan ke aiki tare da misali. Aauki tebur wanda ya ƙunshi adadin da farashin samfuran samfura daban-daban. Muna buƙatar lissafta farashin.
Ana yin wannan ta hanyar sauƙaƙa adadin (shafi B) ta farashin (shafi C). Misali, ga sunan samfurin farko, dabara zai yi kama da wannan "= B2 * C2". Mun shigar da shi a cikin sashin daidai tebur.
Yanzu, don kar ku tuƙa hannu da hannu cikin dabarun kwayayen da ke ƙasa, kawai kwafa wannan dabara zuwa ga gaba ɗaya shafi. Mun tsaya akan ƙananan dama na sel tare da dabara, danna maɓallin linzamin kwamfuta na hagu, kuma lokacin da aka matsi maɓallin, ja linzamin kwamfuta ƙasa. Don haka, an kwafa dabarar zuwa wasu ƙwayoyin tebur.
Amma, kamar yadda muke gani, dabara a cikin ƙananan ƙwayoyin riga bai yi kama ba "= B2 * C2", da "= B3 * C3". Saboda haka, dabarun da ke ƙasa ma an canza su. Wannan kayan yana canzawa yayin kwafa kuma suna da alaƙa da dangi.
Kuskuren haɗin dangi
Amma, nesa daga kowane yanayi muna buƙatar ainihin haɗin dangi. Misali, muna buƙatar su a tebur iri ɗaya don ƙididdige ragin farashin kowane kaya daga kaya. Ana yin wannan ta hanyar rarraba kudin ta jimlar. Misali, don kirga takamaiman nauyi na dankalin turawa, muna raba kimar sa (D2) ta jimlar (D7). Mun sami wannan dabarar: "= D2 / D7".
Idan muka yi kokarin kwafa fola zuwa wasu layi daidai da lokacin da ya gabata, za mu sami sakamako mai gamsarwa. Kamar yadda kake gani, tuni a cikin layi na biyu na tebur, dabara yana da tsari "= D3 / D8", wannan shine, ba hanyar haɗin yanar gizo ba kawai tare da jimlar ta hanyar layi, amma kuma hanyar haɗin yanar gizo wacce ke da alhakin jimillar.
D8 kwayar halitta ce gabaɗaya, don haka dabara yana ba da kuskure. Dangane da haka, tsari a cikin layin da ke ƙasa zai koma zuwa sel D9, da sauransu. Amma muna buƙatar ci gaba da hanyar haɗi zuwa tantanin D7 inda jimlar ta kasance a yayin da ake kwafa, kuma cikakkun hanyoyin haɗin suna da irin wannan mallaka.
Createirƙiri haɗin haɗi
Don haka, ga misalinmu, mai rarrabe ya kamata ya zama hanyar haɗi na dangi, da kuma canji a kowane layi na tebur, kuma rabon ya zama babban madaidaiciyar hanyar haɗin da ke magana akan tantanin halitta koyaushe.
Masu amfani ba za su sami matsala ƙirƙirar hanyar haɗin kai ba, tunda duk hanyoyin haɗin cikin Microsoft Excel suna da dangi da tsohuwa. Amma, idan kuna buƙatar yin hanyar haɗin kai, dole ne ku nemi dabara ɗaya.
Bayan an shigar da dabara, kawai a sanya shi a cikin tantanin halitta, ko a cikin mashin dabara, a gaban masu daidaitawa da shafi da layi na tantanin da kuke son kulla hanyar haɗin kai, alamar dala. Hakanan zaka iya, nan da nan bayan shigar da adireshin, danna maɓallin ayyuka na F7, kuma alamun dala a gaban jere kuma masu daidaita shafi za a nuna su ta atomatik. Dabarar da ke cikin sel gaba daya zata dauki wadannan matakai: "= D2 / $ D $ 7".
Kwafa dabarar ƙasa ƙasa. Kamar yadda kake gani, a wannan karon komai ya lalace. Kwayoyin suna ɗauke da madaidaitan dabi'u. Misali, a layi na biyu na tebur, tsarin yayi kama da "= D3 / $ D $ 7", wannan shine, mai rarrabuwa ya canza, kuma rabon gado ya kasance ba canzawa.
Hadin hade
Baya ga cikakkiyar hanyoyin haɗin kai da na dangi, akwai wadatattun hanyoyin haɗin kai. A cikin su, ɗayan kayan sun canza, na biyu kuma an gyara. Misali, gaurayar hade $ D7 tana canza layi kuma an saita shafi. Hanyar haɗin D $ 7, akasin haka, yana canza shafi, amma layi yana da ƙima.
Kamar yadda kake gani, lokacin aiki tare da dabaru a Microsoft Excel, dole ne kayi aiki tare da kusanci da madaidaiciya hanyoyin yin ayyuka daban-daban. A wasu halaye, ana kuma amfani da hanyoyin haɗin gauraye. Sabili da haka, koda mai amfani da tsakiyar matakin dole ne ya fahimci bambanci tsakanin su, kuma ya sami damar yin amfani da waɗannan kayan aikin.
