Abantu benshi bakunda gukemura crosswords, hariho nabantu bakunda gukora. Rimwe na rimwe, inyandiko ya Corys irasabwa kubwo kwidagadura gusa, ahubwo, nk'urugero, kugenzura ubumenyi bw'abanyeshuri mu buryo budasanzwe. Ariko, abantu bake bakeka ko igikoresho cyiza cyo gukora umurongo wambukiranya ni gahunda ya Microsoft Excel. Kandi, mubyukuri, selile kurupapuro rwiyi porogaramu, nkaho zagenewe guhuza inyuguti zumwanditsi wamagambo. Reka tumenye uburyo bwo gukora vuba puzzle ya crossword muri gahunda ya Microsoft Excel.
Gukora ijambo rya Cross
Mbere ya byose, ugomba kubona ijambo ryiteguye, aho uzakora kopi muri gahunda ya Excel, cyangwa suzuma imiterere yijambo ryambukiranya, niba uzanye rwose.
Kubisobanuro, ukeneye selile kare, ntabwo urukiramende, nkuko bisanzwe muri Microsoft Excel. Tugomba guhindura imiterere yabo. Kugirango ukore ibi, ukanda Ctrl + clavier kuri clavier. Ibi turagaragaza urupapuro rwose. Noneho, ukanze buto yimbeba iburyo, bisaba ibikubiyemo. Muri yo, kanda kumurongo "uburebure bwumurongo".
Idirishya rito rifungura aho ukeneye gushiraho uburebure bwumugozi. Shyira ahabigenewe 18. Twakanze kuri buto "OK".
Guhindura ubugari, kanda kumwanya hamwe nizina ryinkingi, kandi muri menu zigaragara, hitamo "ubugari bwinkingi ...".
Nko mu rubanza rwabanje, idirishya rigaragara aho amakuru agomba kongerwaho. Iki gihe kizaba numero 3. Kanda kuri buto ya "OK".
Ibikurikira, ugomba kubara umubare wingirabuzimafatizo ku nyuguti mu gitabo cyambukiranya mu butambitse kandi uhagaritse. Hitamo umubare ujyanye ningirabuzimafatizo kurupapuro rwa Excel. Kuba muri tab ya Murugo, kanda ahanditse "umupaka", uherereye kuri kaseti mugihe cyimyandikire yimyandikire. Muri menu igaragara, hitamo ikintu "umupaka wose".
Nkuko tubibona, imbibi zerekana ko kwambukiranya kwambukiranya.
Noneho, ugomba gukuraho izi mbaraga ahantu hamwe kuburyo rero ijambo rya cross rituma ubwoko bukenewe. Ibi birashobora gukorwa hakoreshejwe nkibi, uburyo bwo "gusiba", agatsiko katoroshye gafite uburyo bwo gusiba, kandi kiri muri Toolbar Toolbar, tab "imwe" murugo ". Turagaragaza imipaka ya selile dushaka gusiba no gukanda kuriyi buto.
Rero, turagenda dushushanya buhoro buhoro, tugakuraho imipaka, kandi tubona ibisubizo byiteguye.
Urebye, muritwe, urashobora kwerekana umurongo utambitse wamagambo hamwe nindi bara, kurugero, umuhondo, ukoresheje buto "yuzuye" kuri kaseti.
Ibikurikira, dushyira umubare wibibazo kumagambo yambukiranya. Nibyiza gukora ibi ntabwo ari imyandikire myinshi. Ku bitureba, imyandikire ikoreshwa 8.
Kugirango ushireho ibibazo, urashobora gukanda agace kose kakagari kuruhande rwa crossword. Hanyuma ukande kuri buto "
Byongeye kandi, mu kagari gakomeye, urashobora gucapura, cyangwa gukoporora ibibazo bivuye mubitabo.
Mubyukuri, ijambo rya crosswo ubwaryo ryiteguye kubibi. Irashobora gucapwa, cyangwa gukemura neza muri excel.
Kurema Igenzura ryimodoka
Ariko, excel igufasha gukora ijambo ryambukiranya gusa, ahubwo rinone ijambo ryambukiranyamo hamwe na cheque bizahita byerekana uwukoresha yakemuye ijambo cyangwa atari.
Kubwibi, mugitabo kimwe kurupapuro rushya dukora ameza. Inkingi ye yambere izitwa "Ibisubizo", kandi tuzinjira mubisubizo byijambo ryambukiranya. Inkingi ya kabiri izitwa "yinjiye". Hano haragaragara amakuru yinjiye numukoresha uzakurwa mumagambo yambukiranya. Inkingi ya gatatu izitwa "guhura". Muri yo, niba selile yinkingi ya mbere izahurira hamwe na selile ijyanye ninkingi ya kabiri, ishusho "1" irerekanwa, kandi ukundi - ". Mu nkingi imwe hepfo, urashobora gukora selile kugirango ubone ibisubizo byemewe.
Noneho, dukurikiza ameza kurupapuro rumwe hamwe nimbonerahamwe kurupapuro rwa kabiri.
Byaba gusa niba buri jambo ryambukirano ryinjiye muri selire imwe. Noneho twahambiriye gusa selile muri "yinjiye" hamwe na selile zihuye. Ariko, nkuko tubizi, nta jambo na rimwe rihuye na buri selile ya crossword, ariko ibaruwa imwe. Dukoresha imikorere "gufata" kugirango duhuze aya mabaruwa mu ijambo rimwe.
Noneho, kanda kuri selire ya mbere muri "yinjiye", hanyuma ukande kuri buto kugirango uhamagare imitsi.
Mubikorwa Wizard Idirishya rifungura, dusangamo imikorere "ifatwa", hitamo, hanyuma ukande kuri buto "OK".
Imikorere irafungura. Kanda kuri buto iherereye iburyo bwamakuru yinjira.
Imikorere yimikorere yimikorere irasenyutse, kandi twimukira kurupapuro rwa Crossword, hanyuma tugahitamo selile aho inyuguti yambere yijambo ihereretse, ihuye numurongo kurupapuro rwa kabiri rwinyandiko. Nyuma yo guhitamo byakozwe, tugacambi kuri buto ibumoso bwimikorere yinjiza kugirango tugaruke kubikorwa.
Igikorwa nkiki cyakozwe na buri nyuguti yijambo. Iyo amakuru yose yinjiye, kanda kuri buto ya "OK" mumikorere yimpapuro.
Ariko, uyikoresha mugihe puzzle ya crossword ishobora gukoresha inyuguti ntoya ninyuguti nkuru, kandi gahunda izabifata nkinyuguti zitandukanye. Kugirango ibi bitabaye, duhinduka ku kagari ukeneye, kandi bikurikiranye imirimo tuyandiza agaciro "umuzimu". Ibisigaye byose birimo selile bifata mumutwe, nko mu ishusho hepfo.
Noneho, amabaruwa yose atanditse abakoresha mumagambo yambukiranya, muri "inkingi" yinjiye "izahindurwa mu nyuguti nto.
Inzira nkizo "gufata" na "Stracchnic" bigomba gukorwa na buri selire muri "inkingi itamenyerejwe", hamwe na selile zijyanye na service ubwayo.
Noneho, kugirango ugereranye ibisubizo bya "Ibisubizo" n "" byatangijwe ", dukeneye gukoresha" niba "umurimo mu nkingi. Duhinduka ku kagari gahuye k'inkingi ya "guhura", kandi tumenyekanisha imikorere y'ibirimo "= niba (guhuza" inkingi = ihuriro ry'inkingi "; 0; 0). Ku rubanza rwihariye, imikorere izaba ifite ifishi "= niba (B3 = A3; 1; 0)". Igikorwa nkiki cyakorewe ingirabuzimafatizo zose zinkingi ya "guhura", usibye "ibika".
Noneho tugaragaza selile zose mu nkingi ya "coinccut", harimo "selile" yose ", hanyuma ukande kuri autosummy ku gishushanyo.
Noneho uru rupapuro ruzagenzurwa neza rwijambo rikomeye, kandi ibisubizo byibisubizo nyabyo bizerekanwa nkamanota rusange. Ku bitureba, niba crossword izakomera rwose, hanyuma umubare 9 ugomba kugaragara mumafaranga, kubera ko umubare wibibazo byose uhwanye niyi numero.
Kugirango ibisubizo byubusa bitagaragara ku rupapuro rwihishe gusa, ariko umuntu ukemura ijambo rya Cross, urashobora kongera gukoresha "niba" imikorere. Jya ku rupapuro rurimo ijambo ryambukiranya. Duhitamo selile, kandi twinjire ku gaciro ku cyitegererezo cy'ikigereranyo: "= Niba (urupapuro22! Guhuza ingirabuzimafatizo bifite amanota asangirwa = 9;" Tekereza byinshi ")". Ku bitureba, formula ifite ubwoko: "= niba (urupapuro2! C12 = 9;" Tekereza byinshi ")".
Rero, ijambo rya cross muri gahunda ya Microsoft Excel Excel ryiteguye byimazeyo. Nkuko mubibona, muriyi porogaramu ntushobora guhita ukora vuba gusa, ahubwo unareme kugenzura imodoka.