01 na 01
Shafin Farko / Shafi na Excel
Yawancin lokaci, ana amfani da tsarin tsarawa don canza cell ko launuka masu launi don amsa bayanai da aka shigar a cikin tantanin halitta kamar kwanakin da aka ƙayyade ko kashe kuɗin kuɗin da ya fi girma, kuma al'ada ana yin wannan ta hanyar amfani da tsarin na Excel.
Bugu da ƙari, zaɓuɓɓukan da aka riga aka saita, duk da haka, yana yiwuwa a ƙirƙira ka'idodin tsarin ka'ida ta al'ada ta hanyar amfani da takardun Excel don gwada don yanayin da aka ƙayyade-mai amfani.
Ɗaya daga cikin irin wannan tsari wanda ya haɗu da ayyukan MOD da ROW , ana iya amfani dasu don yin amfani da bayanan shafukan yanar gizo masu yawa wanda zai iya yin bayanai akan manyan ayyuka , sauƙin.
Dynamic Shading
Wani amfani da amfani da ita don ƙara shading shady shine cewa shading yana da ƙarfin wanda yana nufin yana canje-canje idan yawan lambobin sun canza.
Idan an saka sabbin layuka ko share madadin shading daidaita kanta don kula da alamar.
Lura: Sauran layuka ba shine kawai zaɓi tare da wannan tsari ba. Ta canza shi dan kadan, kamar yadda aka tattauna a kasa, wannan tsari zai iya inuwa kowane nau'in layuka. Za a iya amfani da su ta asali ta shade maimakon layuka idan kun zabi.
Misali: Shafi Lays Formula
Mataki na farko shi ne ya haskaka da kewayon kwayoyin da za a shaded tun lokacin da aka samo shi kawai yana rinjayar waɗannan sassan da aka zaɓa.
- Bude takardar aiki na Excel-wani aikin rubutu na blank zaiyi aiki don wannan koyawa
- Nuna samfurin sel a cikin takardun aiki
- Danna kan shafin shafin shafin rubutun
- Danna kan maɓallin Yanayin Yanayi don buɗe mahimman menu
- Zaɓi Sabuwar Dokar wani zaɓi don buɗe sabon maganganun Siffar Saiti
- Danna kan Amfani da Formula don ƙayyade wane ƙirar zaɓuɓɓukan tsari daga jerin a saman akwatin maganganu
- Shigar da wannan maƙala cikin akwatin da ke ƙasa da Tsarin dabi'u inda wannan darajar zaɓin gaskiya ne a cikin rabin ƙasa na akwatin maganganu = MOD (ROW (), 2) = 0
- Danna maɓallin Tsarin don buɗe akwatin maganganun Siffofin Siffar
- Danna Fill shafin don ganin samfurin launi na baya
- Zaɓi launi don amfani don shading sauran layuka na zaɓin da aka zaba
- Danna Ya yi sau biyu don rufe akwatin maganganu kuma komawa cikin takardun aiki
- Ya kamata a sanya shafuka dabam dabam a cikin zaɓin da aka zaɓa a shaded tare da launi da aka zaɓa
Harshen Formula
Yadda Excel yake karantawa wannan shi ne:
- lambar 2 a cikin maƙirarin ya tabbatar da cewa hoton shading yana maimaita kowace jere a cikin zaɓin da aka zaba
- yanayin = = 0 a cikin wannan tsari ya tabbatar da cewa jeri na farko a cikin kewayon ba a shaded - wanda aka aikata saboda wannan jeri yana ƙunshe da rubutun da suke tsara kansu.
Abin da MOD da ROW Do
Abinda ya dogara da aikin MOD a cikin tsari. Mene ne MOD ke raba raɗin jere (ƙaddara ta aikin ROW) ta lamba ta biyu a cikin shafuka kuma ya dawo da saura ko ƙaddara kamar yadda aka kira shi a wani lokaci.
A wannan lokaci, tsarawar yanayin yana ɗauka kuma yana kwatanta ma'auni tare da lambar bayan alamar daidai. Idan akwai wasa (ko mafi daidai idan yanayin yana TRUE), jere na shaded, idan lambobi a gefe ɗaya na daidai alamar ba su daidaita ba, yanayin shine FALSE kuma babu shading yana faruwa a wannan jere.
Alal misali, a cikin hoton da ke sama, lokacin da jere na ƙarshe a cikin zaɓin da aka zaba 18 ya raba ta 2 ta aikin MOD, sauran saura 0, don haka yanayin 0 = 0 shine TRUE, kuma jere an shaded.
Hada na 17, a gefe guda, lokacin da kashi 2 ya ragu na 1, wanda ba daidai ba 0, don haka jere an bar shi.
Shafukan Shading A maimakon Makuka
Kamar yadda aka ambata, ana iya canza tsarin da aka yi amfani da su don inuwa madaidaici don bada izinin shading ginshiƙai. Canjin da ake buƙata shine amfani da aikin COLUMN maimakon aikin ROW a cikin tsari. A yin haka, wannan tsari zai yi kama da wannan:
= MOD (COLUMN (), 2) = 0Lura: Canje-canje ga layukan shading da aka tsara domin canza yanayin da aka tsara a ƙasa kuma ya shafi shafukan shading.
Canja Formula, Sauya Tsarin Shading
Canza yanayin shading yana iya sauƙaƙe ta sauya ko dai daga cikin lambobi biyu a cikin tsari.
- Don samun shading jere tare da jere na farko maimakon na biyu, a karshen wannan tsari, canza = 0 zuwa = 1 ;
- Don samun kowane shafuka na uku ko na hudu a madadin wasu layuka, canza 2 a cikin tsari zuwa 3 ko 4.
Ƙwararren bazai iya zama Zero ko Ɗaya ba
Lambar da ke cikin kwakwalwan ana kiranta mai raba tun yana da lambar da ke rarraba a cikin aikin MOD. Idan ka tuna da baya a cikin nau'in lissafin rarraba ta sifilin ba a yarda ba kuma ba'a yarda a Excel ko dai. Idan kuna ƙoƙarin yin amfani da wani abu a cikin baka a wurin na 2, kamar:
= MOD (ROW (), 0) = 2ba za ku sami shading ba a cikin kewayon.
A madadin, idan kuna kokarin yin amfani da lambar don rarraba don haka tsarin shine kamar:
= MOD (ROW (), 1) = 0Kowane jere a cikin kewayon za a shaded. Wannan yana faruwa ne saboda kowane lambar da aka raba ta mutum ya bar saura ta sifilin, kuma ya tuna, lokacin da yanayin 0 = 0 shine TRUE, jere yana shaded.
Canja Mai sarrafa, Sauya Shadow Shading
Don gaske canza yanayin, canza yanayin haɓaka ko mai kwatanta (alamar daidai) da aka yi amfani da shi a cikin tsari ɗin zuwa alamar ƙasa (<).
Ta hanyar canza = 0 zuwa <2 (kasa da 2) misali, layuka biyu zasu iya shaded. Yi cewa <3, da shading za a yi a kungiyoyi uku.
Kaduna kawai don amfani da ƙasa da mai aiki shine tabbatar da cewa lambar a cikin ƙamus ɗin ya fi girma fiye da lamba a ƙarshen dabarar. Idan ba haka ba, kowace jere a cikin kewayon za a shaded.