Anthu ambiri amakonda kuthetsa mawu, koma palinso anthu omwe amakonda kupanga. Nthawi zina, kupanga kujambula pamutu sikufunika kungosangalatsa, koma, mwachitsanzo, kuyesa chidziwitso cha ophunzira m'njira yosagwirizana. Koma anthu ochepa amadziwa kuti Microsoft Excel ndi chida chabwino kwambiri popanga puzzles. Ndipo, ndithudi, maselo omwe ali pa pepala la ntchitoyi, ngati kuti akukonzekera kuti alowe mmenemo makalata a mawu oganiziridwa. Tiyeni tipeze momwe tingayambire msangamsanga mawu a Microsoft Excel.
Pangani jambulani yopanga mawu
Choyamba, muyenera kupeza pepala lopangidwa mokonzekera, limene mungapangeko mu Excel, kapena kuganizira za kapangidwe kake, ngati mumayambitsa nokha.
Pakuti kujambulana kwapadera kumafunikira maselo apakati, m'malo mwakwangwani, monga osasinthika mu Microsoft Excel. Tiyenera kusintha mawonekedwe awo. Kuti muchite izi, yesani njira yachinsinsi ya Ctrl + A pa makina. Izi timasankha pepala lonse. Kenaka, dinani batani lamanja la mouse, zomwe zimayambitsa mndandanda wa mauthenga. Momwemo timatsindikiza pa chinthucho "Kutalika kwa mzere".
Fasilo yaing'ono imatsegulidwa kumene muyenera kuyika kutalika kwa mzere. Ikani mtengo ku 18. Dinani pa batani "OK".
Kuti musinthe m'lifupi, dinani pazenerali ndi dzina la zipilala, ndipo mu menyu omwe akuwonekera, sankhani chinthu "Mbali yazitali ...".
Monga momwe zinalili kale, mawindo amawoneka momwe muyenera kuitanitsira deta. Nthawi ino idzakhala nambala 3. Dinani pa batani "OK".
Chotsatira, muyenera kuwerenga chiwerengero cha maselo pamakalata ophatikizidwa mumsewu wosakanikirana ndi wowongoka. Sankhani nambala yoyenera ya maselo mu pepala la Excel. Ali mu tabu la "Home", dinani pa "Border" batani, yomwe ili pamtambo mu bokosi la zida. Mu menyu yomwe ikuwonekera, sankhani chinthucho "Zonse malire".
Monga momwe mukuonera, malire opotoza zojambulazo zathu zimayikidwa.
Tsopano, tifunika kuchotsa malire awa kumalo ena, kotero kuti kujambulana kwapachiyambi kumatithandiza. Izi zikhoza kuchitika pogwiritsira ntchito chida monga "Chotsani", chomwe chithunzi chake chowonekera chiri ndi mawonekedwe a eraser, ndipo chiri mu barabu a "Edit" a "Tsamba" la "Home" lomwelo. Sankhani malire a maselo omwe tikufuna kuwachotsa ndikusindikiza pa batani ili.
Motero, pang'onopang'ono timatulutsa zojambulajambula, ndikuchotsa malire mosiyana, ndipo timapeza zotsatira zomaliza.
Kuti tifotokoze bwino, mwa ife, mungasankhe mzere wolumikiza wa pepala lojambula ndi mtundu wosiyana, mwachitsanzo, wachikasu, pogwiritsa ntchito botani Yodzaza Mtundu pa ndodo.
Kenaka, lekani chiwerengero cha mafunso pa mtanda. Koposa zonse, chitani mu fonti yayikulu kwambiri. Kwa ife, mndandanda wagwiritsidwa ntchito ndi 8.
Kuti muike mafunso okha, mukhoza kudinkhani mbali iliyonse ya maselo kutali ndi kujambulana, ndipo dinani pa "Sakanizani maselo", omwe ali pa leboni, onse pa tebulo lomwelo mu bokosi la zida.
Komanso, mu selo lalikulu lophatikizidwa, mukhoza kusindikiza, kapena kujambula mafunso olowera mmunsimo.
Kwenikweni, mtanda wokha uli wokonzeka izi. Ikhoza kusindikizidwa kapena kuthetsedwa mwachindunji ku Excel.
Pangani AutoCheck
Koma, Excel imakulolani kuti musagwirizane ndi zojambulajambula zokha, koma ndi mtanda womwe uli ndi cheke, momwe wogwiritsa ntchitoyo adzawonetsera bwino mawuwo kapena ayi.
Kwa ichi, m'buku lomwelo pa pepala latsopano timapanga tebulo. Chigawo chake choyamba chidzatchedwa "Mayankho", ndipo tidzalowa mndandanda wa zojambulazo. Mzere wachiwiri udzatchedwa "Walowa". Izi zikuwonetsa deta yomwe imalowa ndi wogwiritsa ntchito, yomwe ingachotsedwe kuchoka pamsewu womwewo. Gawo lachitatu lidzatchedwa "Matches". Mmenemo, ngati selo loyamba la ndime likugwirizana ndi selo lofanana la chigawo chachiwiri, chiwerengero "1" chikuwonetsedwa, ndipo mwina - "0". Mu ndime yomweyi pansipa mungathe kupanga selo kwa mayankho onse omwe akudziwikiratu.
Tsopano, tifunika kugwiritsa ntchito njirayi kuti tigwirizanitse tebulo pa pepala limodzi ndi tebulo pa pepala lachiwiri.
Zikanakhala zophweka ngati wogwiritsa ntchito amalowa mawu onse a chipangizo chojambula mumsewu umodzi. Kenaka tikangolumikiza maselo omwe ali muzati "Entered" ndi maselo ofanana nawo. Koma, monga ife tikudziwira, palibe mawu amodzi, koma kalata imodzi imalowa mu selo iliyonse ya zojambulajambula. Tidzagwiritsa ntchito ntchito "CLUTCH" kuti tiyanjanitse makalata awa kukhala mawu amodzi.
Choncho, dinani selo yoyamba mukholo la "Chilolezo," ndipo dinani pa batani kuti muyitane Wachipangizo Wothandizira.
Muwindo lawindo la wizara lomwe limatsegulidwa, timapeza ntchito "CLICK", sankhasinkhani, ndipo dinani "Bwino".
Ntchito yotsutsana yenera ikutsegula. Dinani pa batani yomwe ili kumanja kwa gawo lolowera deta.
Ntchito yotsutsana ndiwindo imachepetsedwa, ndipo timapita ku pepala ndi pepala lojambula, ndikusankha selo kumene kalata yoyamba ya mawu ili, yomwe ikufanana ndi mzere pa pepala lachiwiri la chilembacho. Pambuyo pasankhidwayo, dinani kachiwiri pa batani kumanzere kwa mawonekedwe olembera kuti mubwerere ku zenera zokhudzana ndi zenera.
Timachita ntchito yofanana ndi liwu lililonse la mawu. Deta yonse ikadalowa, dinani "Bwino" pakani pazenera zowonjezera.
Koma, pothetsa mtanda, wosuta akhoza kugwiritsa ntchito makalata awiri ochepa komanso ochepa, ndipo pulogalamuyi idzawaona ngati osiyana. Pofuna kuteteza izi kuti zisakwaniritsidwe, timadula selo lomwe tikulifuna, ndipo m'ndondomeko ya ntchito timalemba phindu "LINE". Zonse zomwe zili mu selo zimatengedwa mu mabakia, monga mu chithunzi pansipa.
Tsopano, ziribe kanthu kuti makalata omwe akugwiritsa ntchito amalemba mu crossword, muzati "Entered" iwo adzatembenuzidwa kukhala pansi.
Njira yofananamo ndi ntchito "CLUTCH" ndi "LINE" ziyenera kuchitika ndi selo iliyonse mulowetsamo "Entered", ndipo ili ndi maselo angapo omwe ali mumsewu womwewo.
Tsopano, kuti tifanizire zotsatira za "Mayankho" ndi "Zolowera" zigawo, tikuyenera kugwiritsa ntchito "IF" ntchito mu "Matches" column. Tikafika pa selo lofanana la "Machesi" ndikulowa ntchitoyi "= IF (zolemba za" Mayankho "= zigawo za" Kulowa "; 1; 0) Kwachitsanzo, ntchitoyi idzawoneka ngati" = IF ( B3 = A3; 1; 0) "Ife timachita ntchito yomweyo kwa maselo onse a" Matches "column, kupatula" selo "lonse.
Kenaka sankhani maselo onse mu gawo la "Matches", kuphatikizapo "Total" selo, ndipo dinani pa chithunzi cha auto-sum pa riboni.
Tsopano pa pepala ili lidzayang'ananso kulondola kwa chojambula chamkati, ndipo zotsatira za mayankho olondola zidzawonetsedwa mwa mawonekedwe a chiwerengero chonse. Kwa ife, ngati jambulani ya crossword yathetsedwa kwathunthu, ndiye nambala 9 iyenera kuwonetsedwa mu selo yonse, chifukwa chiwerengero cha mafunso ndi ofanana ndi chiwerengero ichi.
Kotero kuti zotsatira za kulingalira zikuwoneka osati pa pepala lobisika, komanso kwa munthu yemwe amachita pepala loloweza, mungagwiritsenso ntchito "IF" ntchito. Pitani ku pepala lokhala ndi pepala lolowera. Timasankha selo ndikuika phindu pogwiritsa ntchito njira yotsatirayi: "= IF (Mapepala 2! Maofesi a selo ndi chiwerengero chonse = 9;" Crossword yothetsedwa ";" Ganiziraninso ")". Kwa ife, njirayi ili ndi mawonekedwe otsatirawa: "= IF (Sheet2! C12 = 9;" Crossword yothetsedwa ";" Ganiziraninso ")". "
Motero, kujambulidwa kwasewero mu Microsoft Excel kukonzeka kwathunthu. Monga momwe mukuonera, mukugwiritsa ntchitoyi, simungathe kuchitapo kanthu mwamsanga, koma mupangenso kujambula komweko.
