Lokacin aiki tare da tsari a cikin shirin Microsoft Excel, masu amfani dole suyi aiki tare da sauran ƙwayoyin da ke cikin takaddar. Amma, ba kowane mai amfani ya san cewa waɗannan nassoshi suna da jinsin biyu ba: cikakkar da dangi. Bari mu gano abin da suka bambanta da juna da kuma yadda ake ƙirƙirar hanyar haɗi na nau'in da ake so.
Tabbatar da cikakken haɗin dangantakar
Menene cikakken dangantakar dangantakar da dangi a cikin excele?Cikakkulware ingantattu sune hanyoyin haɗi, lokacin da kwafin wane irin salon sel ba sa canzawa, suna cikin tsayayyen jihar. A cikin dangi nassoshi, ana canza daidaitawar sel lokacin kwafa, dangi zuwa wasu sel.
Misalin kwatankwacin dangi
Bari mu nuna yadda yake aiki akan misali. Aauki tebur da ya ƙunshi lamba da farashin abubuwa daban-daban. Muna buƙatar lissafta farashin.
Wannan ana yin wannan ta hanyar adadin adadin adadin (shafi na B) akan farashin (Shafi c). Misali, ga sunan farko na samfurin, dabara zata duba don haka "= B2 * C2". Shigar da shi zuwa teburin da ya dace na tebur.
Yanzu, cikin tsari da hannu, kada ku fitar da dabarun tantanin halitta waɗanda suke ƙasa a ƙasa, kawai kwafa wannan tsari ne ga dukkanin shafi. Mun zama a kan gefen dama na sel tare da dabara, danna maɓallin linzamin kwamfuta na hagu, kuma lokacin da maballin yake narkar da maɓallin, cire linzamin kwamfuta ƙasa. Don haka, za a kwafa dabara ga sauran sel na tebur.
Amma, kamar yadda muke gani, dabara a cikin ƙananan sel ba ta kalli "= B2 * C2", amma "= B3 * C3". Dangane da haka, waɗannan dabarun da suke ƙasa sun canza. Wannan shine kayan canji lokacin da kwafa kuma suna da hanyoyin haɗi.
Kuskure a cikin dangantakar dangi
Amma, ba a kowane yanayi ba, muna buƙatar haɗi na dangi. Misali, muna buƙatar yin lissafin takamaiman darajar darajar kowane sunan samfurin daga jimlar. Ana yin wannan ta hanyar rarraba farashin kuɗi don adadin. Misali, don kirga rabon dankali, muna farashin sa (D2) raba duka adadin (D7). Muna samun tsari mai zuwa: "= D2 / D7".
A cikin taron cewa muna ƙoƙarin kwafa dabara zuwa sauran layin guda a daidai wannan hanyar, to, muna samun sakamako gaba daya. Kamar yadda muke gani, a layin na biyu na tebur na dabara, yana da tsari "= D3 /8", wannan shine hanyar haɗi zuwa sel tare da layi, amma kuma hanyar haɗi zuwa sel mai mahimmanci ga Janar.
D8 shine babban kwayoyin halitta, don haka dabara ta bayar da kuskure. Dangane da tsari a cikin kirtani da ke ƙasa zai koma ga Selel, da sauransu. Hakanan ya wajaba a kan cewa lokacin da aka tattara mahadar zuwa tantanin D7 kullum, inda adadin yake, kuma wannan kayan yana da cikakkun hanyoyin haɗin yanar gizo.
Ingirƙirar Haɗin Haɗi
Don haka, ga misalinmu, wanda ya rabu ya zama mai ma'ana, kuma canza a cikin kowane layin tebur, kuma rarrabuwar kawuna dole ne ya kasance cikakken tunani, tantanin halitta ɗaya da aka ambata koyaushe.
Tare da ƙirƙirar haɗin kusancin dangi, masu amfani ba za su sami matsaloli ba, tunda duk nassoshi ga Microsoft Microsoft suna da alaƙa da tsoho. Amma idan kuna buƙatar yin ingantacciyar hanyar haɗi, dole ne ka yi amfani da liyafar guda ɗaya.
Bayan an shigar da dabara, a sauƙaƙe saka a cikin sel, ko a cikin tsari na dabara, a gaban daidaitawar kwayar da layin tantanin halitta ya kamata a yi, alamar dala. Hakanan zaka iya, nan da nan bayan shigar da adireshin, danna maɓallin F7 na F7 nan da nan, da dala ta nuna alamun kyan gani ta atomatik. Tsarin a cikin manyan sel na sama zai dauki wannan nau'in: "= D2 / $ D $ 7".
Kwafi da tsari a shafi. Kamar yadda kake gani, wannan lokacin komai ya juya. A cikin sel daidai ƙimar ƙimar. Misali, a layin na biyu na tebur tebur yayi kama "= D3 / $ d $ 7", wato, wanda ya fi shi canzawa, kuma ba ya canzawa.
Haɗin haɗi
Baya ga misalin cikakken da dangi nassoshi, akwai-da ake kira gauraye hade. A cikinsu, ɗayan abubuwan da suka shafi bambance-bambancen, da kuma gyara na biyu. Misali, a wurin hade kan hanyar $ D7, layin layin yana canzawa, kuma an gyara shafi. Tunani D $ 7, akasin haka, tsarin canje-canje, amma layin yana da cikakken darajar.
Kamar yadda muke gani, lokacin aiki tare da tsari a cikin shirin Microsoft Excel, dole ne ka yi aiki tare da dangi da cikakkun hanyoyin yin ayyuka daban-daban. A wasu halaye, ana amfani da hanyoyin haɗi. Sabili da haka, mai amfani har ma da matsakaita ya kamata a bayyane bambanci tsakanin su, kuma sami damar amfani da waɗannan kayan kida.