Yadda ake yin wasan cacar kalmomi a cikin Excel mataki-mataki

Kusan kowa yana jin daɗin yin wasan cacar baki. Don haka, suna iya zama masu amfani a fagage daban-daban na rayuwa. Misali, a cikin kasuwancin kan layi. Ana iya kawo mai amfani zuwa rukunin yanar gizon ta hanyar sha'awar irin wannan ƙaramin wasan. Har ila yau ƙwaƙƙwaran kalmomi suna da amfani wajen koyarwa, domin ana iya amfani da su don ƙarfafawa ko gwada ilimin da aka samu.

Alal misali, ana amfani da su a cikin darussan Turanci na zamani, inda aka ba da ma'anar, kuma kana buƙatar rubuta kalmar da ta dace a cikin wani layi.

Kuma tare da taimakon Excel, zaku iya sarrafa ta atomatik kammala wasan wasan caca. A matsayin zaɓi, nuna daidaitattun amsoshi kuma duba ɗalibin ta hanyar ba shi maki.

Yadda ake zana wuyar warwarewa a cikin Excel

Don zana wuyar warwarewa a cikin Excel, kuna buƙatar danna Ctrl + A hade (zaku iya zaɓar komai da shi), sannan buɗe menu na mahallin ta danna-dama. Sa'an nan kuma ya kamata ka danna hagu a kan layin "Line tsawo" kuma saita shi a matakin 18.

Don ayyana faɗin shafi, danna hagu a gefen dama na tantanin halitta kuma ja shi zuwa dama.

Me yasa haka? Dalilin ya ta'allaka ne a cikin gaskiyar cewa sel a cikin Excel sun fara zama rectangular, ba murabba'i ba, yayin da aikinmu muna buƙatar sanya tsayi da faɗi iri ɗaya. Don haka, wajibi ne a sanya sel waɗanda aka keɓe don wannan wasan sigar da ta dace.

Sannan kuna buƙatar zaɓar waɗancan sel waɗanda za a keɓe don layuka. Bayan haka, muna neman ƙungiyar "Font", inda muka saita duk iyakoki. Hakanan zaka iya canza launin tantanin halitta ta wata hanya, idan kuna so.

A gefen dama na takardar, kuna buƙatar yin dogayen layi inda za a rubuta masa tambayoyi. Kar a manta sanya lambobi kusa da layukan da suka dace da lambobin tambaya.

Tsare-tsare shirye-shirye

Don koyar da wuyar warwarewa don sanin wane amsoshi ne daidai kuma don kimanta mai amfani, kuna buƙatar ƙirƙirar ƙarin takardar da ke jera ingantattun amsoshi. 

Wannan hoton hoton yana nuna cewa akwai manyan ginshiƙai guda uku:

1. Amsa. An jera ingantattun amsoshi anan.
2. Gabatarwa. Amsoshin da mai amfani ya shigar ana yin rikodin su ta atomatik a nan.
3. Alamar tambaya. Wannan yana nuna maki 1 idan mutumin ya amsa daidai da 0 idan ba daidai ba.

Hakanan a cikin cell V8 zai zama maki na ƙarshe. 

Na gaba, yi amfani da aikinStsepit” don manna haruffa guda ɗaya a cikin wasan cacar baki. Wannan ya zama dole don bayyanar gabaɗayan kalma a cikin wannan layin. Kuna buƙatar shigar da dabarar a cikin tantanin halitta na shafi na "Gabatarwa".

Babbar matsalar ita ce mutum na iya rubuta manyan haruffa da kanana. Saboda haka, shirin zai iya tunanin cewa amsar ba daidai ba ce, ko da yake daidai ne. Don magance wannan matsala, kuna buƙatar amfani da aikin KARANTA, wanda aka gabatar da aikin STsEPIT, kamar yadda aka nuna a cikin wannan layin code.

=СТРОЧН(СЦЕПИТЬ(Лист1!I6;Лист1!J6;Лист1!K6;Лист1!L6;Лист1!M6;Лист1!N6;Лист1!O6;Лист1!P6))

Wannan aikin yana canza duk haruffa zuwa nau'i iri ɗaya (wato, yana juya su zuwa ƙananan haruffa).

Na gaba, kuna buƙatar tsara yanayin. Idan amsar ta kasance daidai, sakamakon ya kamata ya zama ɗaya, kuma idan ba daidai ba, ya kamata ya zama 0. Don wannan, ana amfani da aikin da aka gina a cikin Excel. IF, shigar a cikin cell na shafi "?".

Don nuna darajar ƙarshe a cikin tantanin halitta V8, kuna buƙatar amfani da aikin SUM.

A cikin misalinmu, akwai mafi girman amsoshi 5 daidai. Manufar ita ce: idan wannan dabarar ta dawo da lamba 5, to, rubutun "An yi kyau" zai bayyana. Tare da ƙananan maki - "Ka sake tunani."

Don yin wannan, kuna buƙatar sake amfani da aikin IFshigar a cikin "Total" cell.

=IF(Sheet2!V8=5;"Madalla!";"Ka yi tunani game da shi...")

Hakanan zaka iya ƙara ikon nuna adadin batutuwan da ake buƙatar warwarewa zuwa aikin. Tunda matsakaicin adadin tambayoyi a misalinmu shine 5, kuna buƙatar rubuta wannan dabara a cikin wani layi daban:

= 5-'List1 (2)'!V8, inda 'List1 (2)'!V8

Don tabbatar da cewa babu kurakurai a cikin dabarun, kuna buƙatar shigar da amsar a cikin wasu layi na wasan cacar baki. Muna nuna amsar "drive" a layi na 1. A sakamakon haka, muna samun wadannan.

Wajibi ne a tabbatar da cewa mai kunnawa bai san wace amsa ce daidai ba. Suna buƙatar cire su daga grid ɗin giciye akan takardar taimako, amma a bar su a cikin fayil ɗin. Don yin wannan, buɗe shafin "Data" kuma nemo rukunin "Tsarin". Za a sami kayan aiki na "Group", wanda ya kamata a yi amfani da shi.

Za a buɗe zance, inda aka sanya akwati kusa da shigarwar "Kitsa". Gumakan fayyace tare da alamar ragi za su tashi a hagu.

Idan ka danna shi, za a ɓoye bayanan. Amma babban mai amfani da Excel yana iya buɗe amsoshin daidai cikin sauƙi. Don yin wannan, suna buƙatar kiyaye kalmar sirri.

Kuna buƙatar nemo shafin "Review", inda za'a sami rukunin "Change". Za a sami maɓallin "Takarda Kare". Yana buƙatar dannawa. Bayan haka, akwatin maganganu zai bayyana inda kake buƙatar rubuta kalmar wucewa. Komai, yanzu wani ɓangare na uku wanda bai san shi ba ba zai iya samun amsar daidai ba. Idan ya yi ƙoƙarin yin wannan, Excel zai gargaɗe shi cewa an kare takardar aikin kuma ba a yarda da umarnin ba.

Shi ke nan, an shirya ƙetare kalma. Sannan ana iya yin salo ta amfani da daidaitattun hanyoyin Excel.

Yadda za a yi ingantacciyar fahimta ta ƙetare kalma ta ilimi?

Ƙwaƙwalwar kalma mai wuyar warwarewa hanya ce mai tasiri wacce ke ba ku damar haɓaka ƙimar 'yancin kai na ɗalibai a cikin tsarin ilmantarwa, da kuma ƙara kuzari ga wannan tsari. Bugu da ƙari, yana ba da damar fahimtar sharuddan batun da ake nazari.

Don ƙirƙirar ƙaƙƙarfan wuyar warwarewa don koyo, dole ne ku bi waɗannan shawarwari:

1. Kada ku ƙyale kasancewar sel mara komai a cikin wuyar warwarewa.
2. Dole ne a yi la'akari da duk hanyoyin sadarwa a gaba.
3. Ba za a iya amfani da kalmomin da ba suna ba a cikin shari'ar zaɓen a matsayin amsoshi.
4. Dole ne a tsara amsoshin a cikin guda ɗaya.
5. Idan kalmomin sun ƙunshi haruffa biyu, to ana buƙatar tsaka-tsaki biyu. Gabaɗaya, yana da kyau a rage yawan kalmomin haruffa biyu. 
6. Kar a yi amfani da gajerun kalmomi (gidan marayu) ko gajarta (ZiL).

Yaya za ku yi amfani da kalmar wucewa a cikin Excel yayin koyo?

Yin amfani da fasahohin zamani a lokacin horo ba zai iya taimaka wa ɗalibai su ƙara himma a cikin tsarin ba, nazarin batun, amma kuma inganta ilimin kwamfuta. Kwanan nan, sanannen jagorar ilimi shine STEM, wanda ke ba da haɗin gwiwar kimiyya, fasaha, injiniyanci da lissafi a cikin kwas ɗaya.

Yaya wannan zai iya kasancewa a aikace? Misali, ana nazarin wasu batutuwa, misali, ilmin taurari (kimiyya). Dalibai suna koyon sabbin kalmomi, wanda sai su maimaita ta hanyar amfani da wasan keɓancewar kalmomi na Excel (fasaha). Anan zaka iya gaya wa ɗalibai yadda ake ƙirƙira irin wannan wasa mai wuyar warwarewa. Sannan yi ƙoƙarin ƙirƙirar na'urar hangen nesa ta amfani da dabarun lissafi.

Gabaɗaya, ƙamus na ɗaya daga cikin abubuwan da suka fi wahala wajen nazarin kowane fanni. Wasu daga cikinsu suna da wahalar koyo, kuma ɓangaren wasan yana haifar da ƙarin kuzari, wanda ke ba da gudummawa ga bullowar sabbin hanyoyin haɗin gwiwa a cikin kwakwalwa. Wannan tsari a cikin ilimin halin dan Adam ana kiransa ƙarfafawa mai kyau. Idan yaron yana sha'awar, zai fi son saka hannu a cikin abubuwan da ake nazarin.

Girman yaro, yawancin ayyukan ya kamata su kasance, na'urorin na'urorin na iya jujjuyawa zuwa ra'ayoyi masu ban sha'awa, kuma bambance-bambancen ayyuka dangane da rikitarwa na iya zama da bayyananne.

Amma wannan daya ne kawai daga cikin hanyoyi masu yawa na yin amfani da kalmomin shiga cikin koyarwa. Musamman, ana iya amfani dashi don:

1. Aikin gida ga dalibai. Dalibai suna haɓaka ikon fahimtar abubuwan ilimi da kansu, tsara tambayoyi, da haɓaka ƙwarewar ɗalibai.
2. Aiki a lokacin aji. Wasan wasan cacar baki hanya ce mai dacewa don maimaita abin darasi na ƙarshe. Yana ba ku damar hanzarta tsara bayanan da aka karɓa, a kan tushen abin da za a gina sabon abu.

Ƙirƙirar wasan cacar kalmomi a cikin Excel a cikin darasi ko a matsayin aikin gida yana da wani fa'ida mai mahimmanci - yana sa ya fi sauƙi don koyan wasu abubuwa. Lokacin da ɗalibi da kansa ya zo da tambayoyi na takamaiman lokaci, ana gina haɗin jijiyoyi a cikin kwakwalwarsa waɗanda ke taimaka masa fahimtar batun da kuma amfani da ilimin da aka samu a gaba.

Matakan harhada ƙwaƙƙwaran kalmomi na ilimi a cikin Excel

1. Da farko kuna buƙatar yanke shawara akan nau'in wasan cacar baki. Ana ba da shawarar yin amfani da sifofin da ba daidai ba. Abin farin ciki, Excel yana da isassun kayan aiki don haɓaka kowane ƙira. Mahimmanci, kalmomin ya kamata su kasance cikin 'yanci daga juna.
2. Sannan kuna buƙatar rubuta jerin sharuɗɗan da ma'anarsu. Yana da kyau a yi amfani da kalmomi masu sauƙi da masu haɗaka.
3. Matsayin ƙirar filin, ƙididdigewa.
4. Tsare-tsare (idan ya cancanta).

Hanyoyi don tsarawa da kimanta sakamakon

Baya ga hanyar da aka bayyana a sama ( jimlar adadin amsoshi daidai), kuma ana iya amfani da ma'auni masu nauyi. A wannan yanayin, kana buƙatar zana wani ginshiƙi, inda aka rubuta ƙididdigar ma'auni kusa da kowace tambaya, kazalika. Hakanan kuna buƙatar ƙara shafi tare da sakamakon gaba ɗaya. A wannan yanayin, jimillar tantanin halitta ya kamata ya zama jimlar ma'auni masu nauyi.

Wannan hanyar ƙididdige maki ta fi dacewa idan akwai fagage da yawa na rikitarwa daban-daban. A zahiri, adadin ingantattun amsoshi anan ba zai zama alama ta haƙiƙa ba.

Kowane batu da aka bayar a cikin ginshiƙi "?" wajibi ne a ninka ta hanyar ma'aunin nauyi, wanda yake a cikin shafi na gaba, sa'an nan kuma nuna ƙimar ma'auni.

Kuna iya yin kima a cikin nau'i na ƙimar mutum ɗaya. Sannan ana amfani da kaso na kalmomin da aka zaci a matsayin kimantawa.

Ribobi da Fursunoni na Haɗa Kalmomi a cikin Excel

Babban fa'ida shine cewa ba kwa buƙatar sarrafa ƙarin shirye-shirye. Duk da haka, wannan hanya yana da adadi mai mahimmanci. An halicci Excel don wasu ayyuka. Don haka, don tattara wasanin gwada ilimi a cikin maƙunsar bayanai, dole ne ku aiwatar da ayyukan da ba dole ba fiye da idan kuna amfani da shirye-shirye na musamman. Wasu suna ba ku damar yin hakan akan layi, sannan raba sakamakon tare da wasu mutane.

Ƙirƙirar wasan cacar baki a cikin Excel aiki ne mai wahala kuma mai tsayi. Yin amfani da wasu shirye-shirye na iya hanzarta wannan tsari sosai. Duk da haka, ƙwarewar maƙunƙun rubutu kawai ya ishe shi.

Yin amfani da wuyar warwarewa a cikin Excel a cikin kasuwanci

Ayyukan kasuwanci na buƙatar wasu basira. Misali, zaku iya gayyatar abokin ciniki don kammala wasan cacar baki, kuma idan ya yi nasarar yin hakan, ku ba shi kyauta. Bi da bi, wannan kyauta na iya zama babban kashi na tallan tallace-tallace. Lokacin da ya karɓa, za ku iya ba shi ƙarin ko ingantaccen sigar wani samfuri, amma riga don kuɗi.

Koyaya, a cikin kasuwanci, yin amfani da wasanin gwada ilimi na Excel ba ya yaɗu sosai. Babban hasarar wannan hanyar ita ce za a iya aiwatar da wasan caca iri ɗaya ta amfani da daidaitattun kayan aikin HTML da Javascript. Kuma ta amfani da aikace-aikace na musamman, zaku iya ƙirƙirar irin wannan kayan aiki cikin sauƙi a cikin editan gani kuma ba kwa buƙatar saukar da wani takarda daban zuwa kwamfutarka.

karshe

Don haka, ƙirƙirar wasan cacar kalmomi a cikin Excel baya buƙatar ƙwarewa da ƙwarewa na musamman. Kuna buƙatar kawai ku sanya shi ta hanya ta musamman, sannan kuma shigar da wasu ƴan dabaru domin tebur ɗin ta atomatik ya bincika sahihancin amsoshin.

Ana iya amfani da shi duka a cikin kasuwanci da kuma lokacin tsarin ilimi. A cikin yanayi na ƙarshe, sararin yin amfani da wasanin gwada ilimi ya fi girma. Ana iya amfani da su don gwada ilimin ɗalibai, da koyar da ilimin na'ura mai kwakwalwa, da kuma nazarin na'urorin ƙididdiga na wani nau'i na musamman.