Siffar ƙididdigar salula kuma amfani a cikin Excel da Google Sheets
Tsararren salula a cikin shirye-shiryen shafuka kamar Excel da Google Sheets sun gano wurin da tantanin halitta ke cikin takardun aiki .
Kwayar yana daya daga cikin nau'in akwatin da ke cika nau'in takarda kuma kowane tantanin halitta zai iya samuwa ta hanyar tantancewar salula - irin su A1, F26 ko W345 - wanda ya ƙunshi harafin shafi da lambar jere da suka haɗa a cikin tantanin cell. Lokacin da aka lissafa tantancewar salula, an rubuta jerin harafin farko a farko
Ana amfani da zantuttukan salula a cikin matakai , ayyuka, sigogi , da wasu dokokin Excel.
Ana ɗaukaka Formulas da Charts
Ɗaya daga cikin amfani da amfani da maƙallan salula a cikin takardun mahimmanci shine cewa, akai-akai, idan bayanan da aka samo a cikin Kwayoyin da aka ambata ya canza, ƙayyadadden tsari ko ginshiƙi na ɗaukakawa ta atomatik don nunawa da canji.
Idan an saita littafi ba don sabuntawa ta atomatik ba lokacin da aka canza canje-canje, za a iya aiwatar da sabuntawa ta hanyar latsa maɓallin F9 a kan keyboard.
Ɗaukakawa dabam-dabam da kuma Ayyuka
Ana amfani da yin amfani da bayanan salula ba tare da taƙaitaccen harafin rubutu ba inda aka samo bayanai. Za a iya rubuta sutura daga takardun aiki daban-daban.
Lokacin da wannan ya auku, ana haɗa sunan sunan aikin aiki kamar yadda aka nuna a cikin tsari a jere na 3 a cikin hoton da ke sama wanda ya haɗa da ma'anar tantanin halitta A2 a shafi na 2 na wannan littafin.
Hakazalika, lokacin da aka samo bayanan da ke cikin wani littafi daban-daban, ana kiran sunan littafi da kuma aikin aiki a cikin ma'ana tare da wurin tantanin halitta. Maganin a jere 3 a cikin hoton ya hada da ma'anar tantanin halitta A1 wanda yake a kan takardar 1 na Book2 - sunan sunan littafi na biyu.
Ranar salula A2: A4
Duk da yake nassoshi sukan koma zuwa kwayoyin halitta - irin su A1, suna iya koma zuwa ƙungiya ko kewayon kwayoyin.
Ana gano alamun ta hanyar tantance kwayoyin halitta a cikin hagu na hagu da ƙananan hagu na kewayon.
Ana amfani da ma'anar tantanin halitta guda biyu da ake amfani da su a madadin wani sashi (:) wanda ke nuna Excel ko Googlereadsheets don haɗa dukkanin sel tsakanin waɗannan farawa da ƙarshen maki.
Misali na kewayon Kwayoyin da ke kusa suna nuna a jere na 3 na hoton da ke sama inda aka amfani da SUM aiki don ƙidaya lambobin a cikin kewayon A2: A4.
Abinda ke da alhaki, Ƙarshe, da Maɗalai na Gida
Akwai nau'o'i uku da za a iya amfani dashi a cikin Excel da Google Sheets kuma ana iya gane su ta hanyar gaban ko babu alamun dollar ($) a cikin tantanin halitta:
- Rahotanni na dangi sun ƙunshi alamun dolar dollar - kamar yadda aka nuna a cikin maƙallin a jere 2: = A2 + A4;
- cikakkun sassan yanar gizo suna da alamomin alamomi da aka haɗe a kowace wasiƙa ko lambar a cikin wani tunani - kamar yadda aka nuna a cikin ma'anar a jere 4: = $ A $ 2 + $ A $ 4;
- haɗin gwargwadon ƙwayoyin da aka haɗa da alamomi na dollar suna haɗe da ko dai wasika ko lambar a cikin ma'ana amma ba duka biyu - kamar yadda aka nuna a cikin ma'anar a jere 5: = $ A2 + A $ 4.
Ana kwashe Formulas da kuma Siffofin Bambancin daban
Amfani na biyu don yin amfani da maƙallan salula a cikin mahimmanci shi ne cewa suna sauƙaƙe don kwafin tsari daga wuri ɗaya zuwa wani a cikin wani takarda ko littafi .
Mahimman bayanan salula sun canza lokacin da aka kofe don yin la'akari da sabon wuri na wannan tsari. Alal misali, idan dabarun
= A2 + A4
an kofe daga tantanin halitta B2 zuwa B3, nassoshi zasu canza don haka tsarin shine:
= A3 + A5
Sunan dangi ya zo ne daga gaskiyar cewa sun canza game da wurin su lokacin da aka kwafe su. Wannan shi ne mafi kyau abu kuma yana da dalilin da yasa labaran ƙwayoyin salula sune irin hanyar da aka yi amfani da ita ta hanyar amfani da su.
A wasu lokuta, kodayake tantancewar salula ya buƙaci zama a tsaye lokacin da aka kofe takardun. Don yin wannan, ana amfani da cikakkiyar tunani (= $ A $ 2 + $ A $ 4) wanda bai canza ba idan aka kwafi.
Duk da haka, a wasu lokuta, kuna so ɓangare na tantancewar salula don canzawa - kamar harafin shafi - yayin da ciwon jeri yana tsayawa tsaye - ko madaidaici lokacin da aka kwafi takarda.
Wannan shi ne lokacin da aka yi amfani da ƙwayar tantanin halitta mai amfani (= $ A2 + A $ 4). Kowane ɓangare na tunani yana da alamar dollar da aka haɗe da shi yana tsayawa tsaye, yayin da sauran ɓangaren sun canza lokacin da aka kwafi.
Saboda haka don $ A2, lokacin da aka kofe, harafin shafi zai zama A, duk da haka lambobin jeri zasu canza zuwa $ A3, $ A4, $ A5, da sauransu.
Ƙaƙarin da za a yi amfani da ƙididdigar maɓamai daban-daban a yayin ƙirƙirar wannan tsari ya danganta ne akan wurin da aka samo bayanan da za a yi amfani da su ta hanyar takaddama.
Yi amfani da F4 don Ƙara Alamun Dollar
Hanyar da ta fi dacewa don canza tantanin salula daga dangi ga cikakken ko haɗuwa shi ne danna maballin F4 akan keyboard:
Don canza saitunan tantanin tarin da ke ciki, Excel dole ne a cikin yanayin gyare-gyaren, wanda za'a iya yi ta hanyar danna sau biyu a kan tantanin halitta tare da maɓallin linzamin kwamfuta ko ta latsa maɓalli F2 a kan keyboard.
Don maida zumuntar dan adam ya danganta ga cikakkun kalmomin salula:
- Latsa F4 sau ɗaya don ƙirƙirar ƙirar salula ta cikakken cikakkiyar kamar $ A $ 6
- Latsa F4 a karo na biyu don ƙirƙirar wurin da aka haɗaka a inda lambar jere ta cika kamar A $ 6
- Latsa F4 a karo na uku don ƙirƙirar wurin da aka haɗaka a inda harafin shafi yake cikakkar kamar $ A6
- Latsa F4 a karo na huɗu don sake tantance ma'anar tantanin halitta game da su kamar A6.