Mutane da yawa suna so su warware maganganu, akwai kuma mutanen da suke so su sa su. Wani lokaci, yin buƙatar motsa jiki yana buƙatar ba don fun ba, amma, alal misali, don jarraba ilimin dalibai a hanya marar hanya. Amma ƙananan mutane sun gane cewa Microsoft Excel yana da kyakkyawan kayan aiki don ƙirƙirar fassarar kalmomi. Kuma, hakika, sel a kan takardar wannan aikace-aikacen, kamar dai an tsara musamman don shigar da haruffan kalmomin da aka ƙayyade. Bari mu gano yadda za a kirkira ƙirar motsi a cikin Microsoft Excel da sauri.
Ƙirƙiri ƙwaƙwalwar motsa jiki
Da farko, kuna buƙatar samun ƙwaƙwalwar ƙwaƙwalwar ƙaddamarwa, wadda za ku yi kwafin a Excel, ko kuma ku yi tunani a kan tsarin giciye, idan kun ƙirƙira shi gaba ɗaya.
Don ƙwaƙwalwar ƙwaƙwalwa yana buƙatar sassan jiki, maimakon rectangular, azaman tsoho a cikin Microsoft Excel. Muna buƙatar canza siffar su. Don yin wannan, danna maɓallin gajeren hanya Ctrl + A a kan keyboard. Wannan za mu zabi dukan takardar. Sa'an nan, danna maɓallin linzamin linzamin dama, wanda ya sa mahallin menu. A cikinsa mun danna kan abu "Layin tsawo".
Ƙananan taga yana buɗewa inda kake buƙatar saita tsayin layin. Saita darajar zuwa 18. Danna maballin "Ok".
Don canja nisa, danna kan panel tare da sunan ginshiƙai, kuma a cikin menu wanda ya bayyana, zaɓa abu "Gurbin allon ...".
Kamar yadda a cikin akwati na baya, wata taga ta bayyana inda kake buƙatar shigar da bayanai. Wannan lokaci zai zama lambar 3. Danna maballin "Ok".
Na gaba, ya kamata ku ƙidaya yawan adadin sel don haruffa a cikin ƙwaƙwalwar ƙusa a cikin kwance a tsaye da kuma tsaye. Zaži yawan adadin sel a cikin takardar Excel. Duk da yake a cikin shafin "Home", danna kan maɓallin "Ƙungiyar", wadda take a kan rubutun a cikin akwatin kayan "Font". A cikin menu da ya bayyana, zaɓi abu "Duk iyaka".
Kamar yadda kake gani, ana sanya iyakoki da ke tattare da ƙwaƙwalwar motsin mu.
Yanzu, ya kamata mu cire waɗannan iyakoki a wasu wurare, don haka zangon motsa jiki yana daukan yanayin da muke bukata. Za a iya yin wannan ta amfani da kayan aiki kamar "Sunny", wanda ƙaddamarwar sa yana da siffar mai sharewa, kuma yana cikin cikin "Shirya" kayan aiki na wannan shafin "Home". Zaɓi iyakokin sassan da muke so mu shafe kuma danna kan wannan maɓallin.
Ta haka ne, zamu zana kwalliyar mu ta hanyar motsa jiki, ta hanyar cire wasu iyakoki, kuma muna samun sakamakon ƙarshe.
Don tsabta, a cikin yanayinmu, za ka iya zaɓar layi na kwance na ƙwaƙwalwar magana tare da launi daban-daban, alal misali, rawaya, ta yin amfani da maɓallin Ƙaƙwalwar Launi a kan rubutun.
Na gaba, sanya takardun tambayoyi a kan giciye. Mafi mahimmanci, aikata shi a cikin manyan fayiloli ba yawa ba. A cikin yanayinmu, ana amfani da lakabi na 8.
Don yin tambayoyin da kansu, za ka iya danna kowane yanki daga cikin kwayoyin daga zane-zane, sannan ka danna maɓallin "Haɗa Kwayoyin", wanda yake a kan rubutun, duk a kan wannan shafin a cikin kayan "Alignment".
Bugu da ƙari, a cikin babban ɗarurwar tarho, zaka iya bugawa, ko kwafe tambayoyin tambayoyi a can.
A gaskiya, ma'anar kalma ta shirya kanta. Ana iya bugawa ko warware shi tsaye a Excel.
Create AutoCheck
Amma, Excel ba ka damar yin ƙwaƙwalwar ƙuƙwalwar ƙira ba, amma kuma ma'anar kalma tare da bincike, wanda mai amfani zai nanata kalmar ta atomatik ko a'a.
Domin wannan, a cikin wannan littafi a kan sabon takarda mun yi tebur. Za a kira maballin farko "Answers", kuma za mu shigar da amsoshin tambayoyin zance a can. Shafin na biyu za a kira "Shigar". Wannan yana nuna bayanan da mai amfani ya shigar, wanda za a ja daga giciye kanta. Shafin na uku za a kira "Matches". A ciki, idan tantanin halitta na shafi na farko ya dace da tantanin halitta na biyu na shafi na biyu, ana nuna lambar "1", kuma in ba haka ba - "0". A cikin wannan shafi da ke ƙasa zaka iya yin tantanin tantanin halitta don yawan adadin amsoshi.
Yanzu, dole ne mu yi amfani da maƙalai don danganta tebur a kan takarda tare da tebur a kan takardar na biyu.
Zai zama sauƙi idan mai amfani ya shiga kowace kalma na ƙwaƙwalwar ƙuƙwalwar ƙuƙwalwa a cikin tantanin halitta ɗaya. Sa'an nan kuma zamu iya danganta kwayoyin halitta cikin "Shigarwa" tare da sassan da ke tattare da ƙwaƙwalwar ƙira. Amma, kamar yadda muka sani, ba kalma ɗaya ba, sai dai wata wasika ta shiga cikin kowane tantanin kwayar maƙalasar. Za mu yi amfani da aikin "CLUTCH" don hada waɗannan haruffa zuwa kalma ɗaya.
Saboda haka, danna maɓallin farko a cikin shafi "Izinin", kuma danna maballin don kiran Wizard na Wurin.
A cikin aikin wizard wanda ya bude, zamu sami aikin "CLICK", zaɓi shi, kuma danna maballin "Ok".
Ƙungiyar shawara ta buɗewa ta buɗe. Danna kan maɓallin da ke tsaye zuwa dama na filin shigar da bayanai.
An rage girman gwargwadon aikin aiki, kuma mun je cikin takarda tare da ƙwaƙwalwar motsa jiki, kuma zaɓin tantanin halitta inda wasikar farko ta kalma ta samo, wanda ya dace da layin akan takardar na biyu na takardun. Bayan zaɓin zabi, sake danna maballin zuwa hannun hagu na takardar shigarwa don komawa cikin taga na muhawara.
Muna yin irin wannan aiki tare da kowace wasika na kalma. Lokacin da aka shigar da bayanan, danna kan maballin "OK" a cikin maɓallin muhawarar aikin.
Amma, a lokacin da za a warware maganganu, mai amfani zai iya amfani da ƙananan ƙananan ƙananan haruffa, kuma shirin zai ɗauka su a matsayin daban-daban haruffa. Don hana wannan daga faruwa, za mu danna kan tantanin da muke bukata, kuma a cikin aikin da muka rubuta darajar "LINE". Sauran duk abinda ke ciki na tantanin halitta ana ɗauka a madogarar, kamar yadda a cikin hoton da ke ƙasa.
Yanzu, duk abin da masu amfani da haruffa za su rubuta a cikin kalmomin giciye, a cikin ɓangaren "Shigarwa" za a juya su zuwa ƙasa.
Hanyar irin wannan aiki tare da "CLUTCH" da "LINE" ayyuka dole ne a yi tare da kowane tantanin halitta a cikin "Shigar da" shafi, kuma tare da jimlalin dacewa na sel a cikin giciye kanta.
Yanzu, don kwatanta sakamakon "Answers" da kuma "Shigar" ginshiƙai, muna buƙatar amfani da "IF" aikin a cikin "Matches" shafi. Mun kasance a kan tantanin halitta na "Matches" shafi kuma shigar da aikin wannan abun ciki "= IF (daidaituwa na shafi na" Answers "= daidaitattun shafi na" Shiga "; 1; 0) Don misali na musamman, aikin zai kasance B3 = A3; 1; 0). "Muna yin irin wannan aikin don dukkan sassan" Matches ", sai dai" Labaran ".
Sa'an nan kuma zaɓar duk sel a cikin "Matches" shafi, ciki har da "Total" cell, kuma danna gunkin madauki a kan rubutun.
A yanzu a kan wannan takarda za a bincika ma'anar tsaka-tsaki daidai, kuma za a nuna sakamakon amsoshi daidai a cikin nau'i na duka. A cikin yanayinmu, idan aka warware warwareccen zangon kalma gaba ɗaya, to, lamba ta 9 ya kamata ta bayyana a tantanin sallar, tun da yawan adadin tambayoyin suna daidai da wannan lambar.
Don haka sakamakon ganin zato ba wai kawai a kan takardar ɓoye ba, har ma ga mutumin da yake yin ƙwaƙwalwar motsa jiki, zaka sake amfani da aikin "IF". Je zuwa takardar da ke dauke da ƙwaƙwalwar motsa jiki. Za mu zaɓi tantanin salula kuma mu shigar da darajar ta amfani da abin da ke biyo baya: "= IF (Sheet2! Shirye-shiryen tantanin halitta tare da jimlar score = 9;" An sake warware kalmar Kalmar ";" Yi tunani sake ")". A cikin shari'armu, wannan tsari yana da nau'i mai biyowa: "= IF (Sheet2! C12 = 9;" An sake warware kalmar Crossword ";" Yi tunani sake ")". "
Saboda haka, ƙwaƙwalwar motsa jiki a cikin Microsoft Excel ta kasance cikakke. Kamar yadda kake gani, a cikin wannan aikace-aikacen, ba za ka iya yin hanzari kawai ba, amma har ma ka ƙirƙiri madogara a ciki.
