Mutane da yawa suna son warware kalmomin shiga, akwai kuma mutanen da suke son tsara su. Wasu lokuta, ana buƙatar wasan ƙwallon ƙafa ba kawai don nishaɗi ba, amma, alal misali, don gwada ilimin ɗalibai ta hanyar da ba ta dace ba. Amma, mutane ƙalilan ne suka fahimci cewa Microsoft Excel babbar kayan aiki ne don ƙirƙirar kalmomin shiga. Kuma, hakika, ƙwayoyin da ke kan takardar wannan aikace-aikacen, kamar dai an keɓe su ne musamman don shigar da haruffan kalmomin da aka zato a can. Bari mu gano yadda za a hanzarta ƙirƙirar wasan ƙwallon ƙafa a cikin Microsoft Excel.
Halittar Magana
Da farko dai, kuna buƙatar nemo wata yar tsana-tsalle-tsalle tsallake-tsallake wanda daga ciki zaku iya kwafin shi a cikin Excel, ko kuyi tunani kan tsarin wasan ƙwallon ƙwallon kalma idan kukazo da kanku.
Tsarin wuyan jigon kalma yana buƙatar sel mai murabba'i, ba maɓallin kusurwa ba, kamar yadda tsoho ne a Microsoft Excel. Muna buƙatar canza fasalin su. Don yin wannan, a kan keyboard, danna maɓallin kewayawa Ctrl + A. Wannan mun zaɓi ɗayan takardar. Bayan haka, muna danna-dama, wanda ke kawo menu na mahallin. A ciki, danna kan abu "Layin Height".
Wani karamin taga yana buɗewa wanda kuke buƙatar saita tsayin layin. Saita darajar zuwa 18. Danna maɓallin "Ok".
Don canza nisa, danna kan kwamiti tare da sunan ginshiƙai, kuma a cikin menu wanda ya bayyana, zaɓi abu "Fitar shafi ...".
Kamar yadda ya gabata, taga yana bayyana wacce kake buƙatar shigar da bayanai. Wannan lokacin zai zama lamba 3. Danna maballin "Ok".
Na gaba, ya kamata ku lissafa adadin sel don haruffa a cikin wasan ƙwallon ƙafa a cikin sararin kwance da tsaye. Zaɓi adadin ƙwayoyin da suka dace akan takardar aikin Excel. Kasancewa cikin maɓallin "Gida", danna maɓallin "Border", wanda ke kan kintinkiri a cikin akwatin kayan aiki "Font". A cikin menu wanda ya bayyana, zaɓi abu "All Borders".
Kamar yadda kake gani, an saita iyakokin da suke bayyana wasanin wasan kwaikwayon mu.
Yanzu, yakamata ku cire wadannan iyakokin a wasu wurare domin wasan kwaikwayo na cin amana game da abubuwan da muke buƙata. Ana iya yin wannan ta amfani da kayan aiki kamar "Share", gunkin ƙaddamar da wanda yana da siffar mai ɓarna, kuma yana cikin "Gyara" kayan toshe shafin "Babban". Zaɓi iyakokin sel waɗanda muke so mu goge kuma danna wannan maɓallin.
Don haka, sannu a hankali zamu zana jigon jumla, muna cire iyakokin ɗaya bayan ɗaya, kuma muna samun sakamakon da aka gama.
Don tsinkaye, a cikin yanayinmu, zaku iya zaɓar layin kwance a kalma cikin launi daban, misali rawaya, amfani da maballin "Cika launi" akan kintinkiri.
Abu na gaba, sanya lambobi na tambayoyi a wuyan jumla. Mafi kyawun duka, yi wannan a cikin babban font. A cikin lamarinmu, ana amfani da font 8.
Don sanya tambayoyin kansu, zaku iya danna kowane yanki daga cikin ƙarancin kalmomin, kuma danna maɓallin "Haɗa Kwayoyin", wanda ke kan haƙarƙarin teburin guda ɗaya a cikin kayan aiki na "Alignment".
Gaba kuma, a cikin babbar sel da aka hada, zaku iya bugawa, ko kwafa a can tambayoyin wuyar warwarewa.
A zahiri, wasan ƙwallon ƙafa tana shirye don wannan. Ana iya buga shi, ko warware shi kai tsaye a cikin Excel.
Autoirƙiri AutoCheck
Amma, Excel yana ba ku damar yin ƙwallan jumla, kawai, wulakantacce wuyar warwarewa tare da dubawa inda mai amfani zai nan da nan ainihin kalmar daidai ko a'a.
Don yin wannan, a cikin littafi guda akan sabon takarda yi tebur. Amfani na farko za a kira shi "Amsoshin", kuma za mu shigar da amsoshin wasan puzz a ciki. Na biyu shafi za a lakabi mai shiga. Yana nuna bayanan da mai amfani ya shigar, wanda za a ja daga ƙwallon ƙwallon kanta da kanta. Rukunin na uku za a kira shi "Matches." A ciki, idan tantanin farko na layi ya dace da tantanin da ya dace da sashin na biyu, lambar "1" zata nuna, in ba haka ba - "0". A cikin shafi ɗaya da ke ƙasa, zaka iya yin sel don jimlar adadin amsoshin da aka tsammani.
Yanzu, ta hanyar dabaru, dole ne mu danganta tebur akan takarda tare da tebur akan takardar na biyu.
Zai iya zama mai sauƙi idan mai amfani ya shigar da kowace kalma na wasan ƙwallon ƙafa a cikin sel guda. Bayan haka zamu iya danganta sel a cikin akwati da aka shiga tare da sel masu dacewa a cikin wasan kwaikwayo na ma'abutai bayani. Amma, kamar yadda muka sani, ba kalma ɗaya ba ce, amma wasika ɗaya ta dace cikin kowane sel ƙwallan jumla. Muna amfani da aikin "CONNECT" don haɗa waɗannan haruffa zuwa kalma ɗaya.
Don haka, danna kan tantanin farko a cikin shafin “Shiga”, saika latsa maballin kiran mai aiki.
A cikin taga Mai buɗe Maɓallin Aiki, mun sami aikin "CONNECT", zaɓi shi, sannan danna maɓallin "Ok".
Farashin muhawara na aiki zai bude. Danna maballin da yake gefen dama na filin shigarwa.
Wurin taga muhawara na aikin an rage girmansa, kuma mun je takardar tare da wuyar warwarewa, kuma zaɓi wayar inda harafin farko na kalmar da ta dace da layin kan takardar na biyu na takaddar tana. Bayan an yi zaɓi, sake danna maɓallin a hannun hagu na shigarwar tsari don komawa zuwa taga muhawara na ayyuka.
Muna yin irin wannan aiki tare da kowane harafin kalmar. Lokacin da aka shigar da dukkan bayanai, danna maɓallin "Ok" a cikin taga muhawara na ayyuka.
Amma, lokacin da ake warware wata wulakantacciyar magana, mai amfani zai iya amfani da ƙananan ƙananan haruffa da manyan haruffa, kuma shirin zai ɗauki su azaman haruffa daban-daban. Don hana wannan faruwa, muna tsaye akan tantanin da muke buƙata, kuma a cikin layin aikin mun saita darajar zuwa "LINE." Muna ɗaukar sauran abubuwan da ke cikin tantanin halitta a brackets, kamar yadda yake a hoton da ke ƙasa.
Yanzu, ko da menene haruffa masu amfani suka rubuta a cikin wuyar warwarewa, a cikin shafin “An Shiga” za a canza su zuwa .aramin baki.
Tsarin aiki iri ɗaya tare da ayyukan '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' LINE '' ya kamata a yi tare da kowane sel a cikin '' shiga '', kuma tare da kewayon ƙwayoyin sel a cikin alamar tsageranci kansu.
Yanzu, domin kwatanta sakamakon “martani” da “shiga” ginshikan, muna bukatar amfani da aikin “IF” a cikin “Matches”. Zamu je sashin da ya dace a cikin jerin "Matches" kuma shigar da aiki na wannan abun ciki "= IF (daidaitawa daga cikin shafi" martani "= = daidaitawa daga cikin shafin" Ya shiga "; 1; 0)." B3 = A3; 1; 0) ". Muna yin irin wannan aiki ga duk sel a cikin Matches column, sai dai jimlar sel.
Sannan zaɓi dukkan ƙwayoyin da ke cikin “Matches” shafi, gami da “Jimlar” tantin, sannan ka danna kan sumul ɗin auto-sum a kan kintinkiri.
Yanzu, a wannan takaddar, za a bincika daidaitaccen abu mai warware matsalar wuyar warware magana, kuma za a nuna sakamakon amsoshi daidai azaman duka ci. A cikin lamarinmu, idan an warware matsalar wuyar warware batun magana, to lambar 9 ya kamata ya fito a cikin jimlar tantancewar, tunda jimlar tambayoyin daidai take da wannan lambar.
Don haka ana iya ganin sakamakon mafita ba wai akan ɓoyayyen takarda ba, har ma ga mutumin da ke warware ƙullin ma'amala, zaku iya sake amfani da aikin "IF". Ka je wa takardar da ke kunshe da tangarda. Muna zaɓar tantanin halitta, kuma shigar da darajar a can bisa ga wannan tsarin: "= IF (Sheet2! Cell yana daidaitawa tare da jimillar maki = 9;" An warware matsalar kalma ";" Ka sake tunani "). A yanayinmu, tsarin yana kama da wannan: "= IF (Sheet2! C12 = 9;" An warware matsalar wuyar warwarewa ";" Ka sake tunani ")."
Saboda haka, wasan ƙwallon ƙafa a cikin Microsoft Excel an shirya gabaɗaya. Kamar yadda kake gani, a cikin wannan aikace-aikacen ba zaka iya sauri wuyar warware wata kalma kawai ba, amma kuma ƙirƙirar gwajin atomatik a ciki.
