Abantu abaninzi bayathanda ukusombulula amagama anqamlezo, kukho nabantu abathanda ukuba benze. Ngamanye amaxesha, igama elinomsinga liyadingeka kungekuko nje ukuzonwabisa, kodwa, umzekelo, ukukhangela ulwazi lwabafundi ngendlela engaqhelekanga. Kodwa, bambalwa abantu abaqikelela ukuba isixhobo esihle sokwenza amagama esinxilisayo yinkqubo ye-Microsoft Excel. Kwaye, inene, iiseli kwiphepha lesicelo, ngokungathi zenzelwe ngokukodwa ukuze zilungele oonobumba bamagama aneqhenqa apho. Masifumanise ukuba ungayenza njani ngokukhawuleza ipuzzle yamagama kwiNkqubo ye-Microsoft Excel.
Ukudala igama
Okokuqala, kufuneka ufumane igama elipheleleyo elipheleleyo, apho uya kwenza ikopi kwinkqubo ye-Excel, okanye uqwalasele ubume begama lomnqamlezo, ukuba uza nayo ngokupheleleyo.
Kwigama elingumnqamlezo, ufuna iiseli zesikwere, hayi uxande, njengemigangatho yeMicrosoft Excel. Kufuneka sitshintshe imilo yabo. Ukwenza oku, ucinezela i-CTRL + ikhibhodi kwikhibhodi. Oku sibalaselisa iphepha lonke. Emva koko, ngokucofa iqhosha lemouse lasekunene, elibiza imenyu yemeko. Kuyo, cofa kumgca "ukuphakama komgca".
Iwindow encinci ivula apho kufuneka useke khona ukuphakama komtya. Faka ixabiso 18. Sicofa kwiqhosha "Kulungile".
Ukutshintsha ububanzi, cofa kwipaneli ngegama leekholamu, nakwimenyu ebonakala, khetha "ububanzi bekholamu ...".
Njengakwimeko yangaphambili, iwindow ivele apho idatha kufuneka yongezwe. Ngeli xesha iya kuba linani 3. Cofa kwiqhosha "Kulungile".
Okulandelayo, kuya kufuneka ubale inani leeseli ngoonobumba kwigama elingumnqamlezo kwindawo ethe tyaba kwaye nkqo. Khetha inani elihambelanayo leeseli kwiphepha le-Excel. Ukuba kwithebhu yasekhaya, cofa kwiqhosha "lomda", obekwe kwitheyiphu yesixhobo sefonti. Kwimenyu ebonakalayo, khetha into "yonke imida".
Njengoko sibona, imida echaza amagama esimnqamlezo senziwe.
Ngoku, kufuneka uyisuse le mida kwezinye iindawo ukuze i-ross wil fake i-US. Oku kunokwenziwa kusetyenziswa isixhobo esinjalo, 'ukucaca' 'ukucamala ", oqalayo i icon enendlela ye-eraser, kwaye ukuhlela" i-Toolbar "ithebhu" ikhaya elifanayo "ithebhu" ikhaya "ikhaya elifanayo" Ikhaya elifanayo "ithebhu" ikhaya "ikhaya elifanayo" ithebhu "ikhaya" ikhaya elifanayo "ithebhu" ikhaya "ikhaya" ikhaya elifanayo. Sibonisa imida yeeseli esifuna ukuyicima kwaye icofe eli qhosha.
Ke, ngokuthe ngcembe sitsala igama lethu, ngokususa imida, kwaye sifumana iziphumo ezilandelweyo.
Ukucaciswa, kwimeko yethu, unokuqaqambisa umtya othe tyaba ngomgaqo, umzekelo, tyheli, usebenzisa iqhosha "Landisa" kwi-tepi.
Emva koko, sibeka inani lemibuzo kwigama lomnqamlezo. Kungcono ukwenza le meko ininzi. Kwimeko yethu, ifonti isetyenziswa 8.
Ukwenzela ukubeka imibuzo ngokwayo, ungacofa nayiphi na indawo ye-cell ecaleni kwiphepha elinqamlezileyo. Kwaye cofa kwiqhosha "lokudibanisa" kwibhokisi yebhokisi efanayo kwibhokisi yesixhobo efanayo.
Ngapha koko, kwiseli enkulu edibeneyo, ungashicilelwa, okanye ukukopa imibuzo kwigama lomnqamlezo.
Ngokwenyani, igama layo lilungele oku. Ingaprintwa, okanye isonjululwe ngqo kwi-Excel.
Ukudalwa kweKhowudi ye-Auto
Kodwa, i-Excel ikuvumela ukuba wenze nje i-rossword nje yegama, kodwa negama elinqamlekileyo ngesheke apho iya kubonisa ngokuzenzekelayo i-Sout Service isombulule igama okanye hayi.
Kule, kwincwadi enye kwiphepha elitsha senza itafile. Ikholamu yakhe yokuqala iya kubizwa ngokuba "ziimpendulo", kwaye siza kungena kwiimpendulo kwigama lomnqamlezo. Umqolo wesibini uya kubizwa ngokuba "ufake". Kukho idatha ebonisiweyo efakwe ngumsebenzisi oza kutsalwa kwigama lomnqamlezo. Ikholamu yesithathu iya kubizwa ngokuba "kukuhlangana". Kuyo, ukuba iseli yekholamu yokuqala iya kudibana neseli ehambelanayo yekholamu yesibini, umzobo "1" uyaboniswa, kwaye ngenye indlela - "0". Kwikholamu efanayo apha ngezantsi, unokwenza iseli kwinani lilonke leempendulo ezivunyiweyo.
Ngoku, siphantsi kwetafile kwiphepha elinye elinetafile kwiphepha lesibini.
Iya kuba ngathi yigama ngalinye lifihlekile kwiseli elinye. Emva koko sazibophelela iiseli kwikholamu "efakiweyo" kunye neeseli gama ezinxulumene ne-comment. Kodwa, njengoko sisazi, akukho lizwi elinye lilingane kwiseli nganye yomnqamlezo, kodwa ileta enye. Sisebenzisa umsebenzi "wokuthinjwa" ukudibanisa ezi leta kwigama elinye.
Ke, cofa kwiseli yokuqala kwikholam ethi "Engenisiweyo", kwaye ucofe kwiqhosha lokubiza i-wizard yemisebenzi.
Kwimisebenzi yeWizard Wizard evula, sifumana umsebenzi "wokubamba", yikhethe, kwaye ucofe iqhosha "Kulungile".
Impikiswano yomsebenzi ivula. Cofa kwiqhosha elikwilungelo lendawo yokungena yedatha.
Umsebenzi lo msebenzi iimpikiswano ziwile, yaye sisiya liphepha yamagama, uze ukhethe iseli apho sibekwe unobumba wokuqala ilizwi, okuhambelana umgca wesibini sheet kolu xwebhu. Emva kokuba kukhetha ndikwenzileyo, siya nqakraza kwi iqhosha ekhohlo le fomu ngegalelo ukuba abuyele umsebenzi kwiimpikiswano window.
operation esinjalo kwenziwa unobumba ngamnye zelizwi. Xa zonke i data ebhalisele, klikha kwiqhosha "Kulungile" kwi umsebenzi kwiimpikiswano window.
Kodwa, umsebenzisi xa iphazile angasebenzisa zombini negama kunye oonobumba abakhulu, yaye le nkqubo iza nibabeke njengabalinganiswa ezahlukeneyo. Ukuze oku kwenzeke, sibe kwi iseli oyifunayo, kwaye kumqolo kwemisebenzi thina amisele ixabiso "Strach". Ezinye zonke iziqulatho yeseli athathele izibiyeli, njengoko kumfanekiso ngezantsi.
Ngoku, kungakhathaliseki oonobumba akazange abhale abasebenzisi kwi olona kwi "kwangena" umhlathi uya kuguqulwa ube negama.
Loo inkqubo with "Capture" yaye "Strachnic" amatheko makwenziwe kwiseli nganye kwikholam "wamisa", kunye noluhlu ehambelana leseli crossword ngokwayo.
Ngoku, ukuze uthelekise iziphumo ze "Iimpendulo" kwikholam kunye "waqalisa ', kufuneka ukuba usebenzise i" ukuba "function kwikholam. Siba kwiseli ohambelana kwikholam ethi "kuqondana", yaye uqalise umsebenzi ezinomthamo enjalo "= ukuba (uququzelelo le" Iimpendulo "column = zilungelelanise ze kwikholam" wamisa "; 1: 0). Ukuba ityala lethu ethile, loo msebenzi kuya kufuneka ifom "= ukuba (B3 = A3: 1; 0)". Olo tyando lwenziwa kuzo zonke izihlunu isimiso selitye "ukuqondana", ngaphandle xa i "Total" cell.
Emva koko izakuphawula zonke iiseli kwikholam ethi "kuqondana", kuquka "Total" iseli, kwaye nqakraza kwi icon autosummy kwi iribhoni.
Ngoku eli xwebhu ziya kutshekishwa ukuchaneka crossword eqinileyo, kwaye iziphumo iimpendulo ezichanekileyo ziya kuboniswa njenge amanqaku eqhelekileyo. Kwimeko yethu, ukuba crossword iya kuba eqinileyo ngokupheleleyo, ngoko ke inani 9 zinokuvela isixa-mali, ukusukela inani elipheleleyo mibuzo ilingana kule nombolo.
Ukuze ukuba ngenxa slightness ukuze sibonakale kungekuphela ikhasi elifihliweyo, kodwa umntu uyayisombulula le crossword, unako kwakhona usebenzise i "ukuba" function. Yiya iphepha equlethe yamagama. Sikhetha iseli, kwaye ngenisa ixabiso yi template hlobo: "= Ukuba (sheet22 Abadibanisi of iiseli abanamanqaku ekwabelwana = 9;!" Uyazi kusonjululwa ";" Cinga ngakumbi ")". Kwimeko yethu, ifomula lo hlobo: "= ukuba (! Sheet2 C12 = 9;" Uyazi kusonjululwa ";" Cinga ngakumbi ")".
Ke, intetho enqamlezileyo kwiNkqubo yeMicrosoft Excel ilungele ngokupheleleyo. Njengoko ubona, kwesi sicelo awunakukhawuleza wenze intetho enqamlezo, kodwa nenze itshekhi yokuzenzekelayo.