Anthu ambiri amakonda kuthana ndi zopinga, palinso anthu omwe amakonda kupanga. Nthawi zina, mawu a mtanda safunikira osati chifukwa cha zosangalatsa, koma mwachitsanzo, kuyang'ana chidziwitso cha ophunzira mwanjira zosagwirizana. Koma, ndi anthu ochepa omwe akuganiza kuti chida chabwino kwambiri pakupanga pulogalamu yapansi ndi pulogalamu ya Microsoft. Ndipo, zowonadi, maselo papepala la ntchitoyi, ngati kuti mwapanga makamaka kuti likwaniritse makalata a mawu owopsa pamenepo. Tiyeni tiwone momwe mungapangire mwachangu kuwonetsa pulogalamu ya Microsoft Excel.
Kupanga Mtanda
Choyamba, muyenera kupeza mawu opangidwa opangidwa, omwe mudzapanga pulogalamu yopambana, kapena muone ngati njira ya mtanda, ngati mutsika nawo kwathunthu.
Pakadutsa mtanda, mumafunikira maselo okwera, osati makona akona, monga kukhazikika mu Microsoft Excel. Tiyenera kusintha mawonekedwe awo. Kuti muchite izi, mukanikizire Ctrl + kiyibodi pa kiyibodi. Izi tikutsindika pepala lonse. Kenako, podina batani la mbewa lamanja, lomwe limatcha menyu. Mmenemo, dinani pamzere "mzere kutalika".
Windo laling'ono limatsegulidwa lomwe muyenera kukhazikitsa kutalika kwa chingwe. Ikani mtengo 18. Timadina batani la "OK".
Kusintha m'lifupi, dinani gulu ndi dzina la mizamu, ndipo mumenyu zomwe zikuwoneka, sankhani "chimbalangondo ...".
Monga momwe zidayambira kale, zenera limawonekera momwe liyenera kuwonjezeredwa. Nthawi ino idzakhala nambala 3. Dinani batani la "OK".
Kenako, muyenera kuwerengetsa maselo a makalata mu mtanda mu njira yopingasa ndi yopirira. Sankhani kuchuluka kwa maselo ofananira pa pepala labwino. Kukhala pa tabu yakunyumba, dinani pa batani la "malire", lomwe limapezeka pa tepi mu chinsinsi chazopanda. Mumenyu yomwe imawoneka, sankhani chinthucho "malire onse".
Monga tikuwonera, malire omwe amafotokoza mawu athu pamtambo.
Tsopano, muyenera kuchotsa malire awa m'malo ena kuti mtanda ukhale wofunikira kwa ife. Izi zitha kuchitika pogwiritsa ntchito chida chotere, momwe mungadziwikire, chomwe chithunzi chake chimakhala ndi chofufutira, ndipo chili mu "kusintha", tabu "yomweyo" kunyumba "kunyumba" kunyumba ". Tikuwonetsa malire a maselo omwe tikufuna kufufuta ndikudina batani ili.
Chifukwa chake, pang'onopang'ono timajambula mawu athu pamtanda, ndikuchotsa malire, ndipo timapeza zotsatira zopangidwa mwakonze.
Chifukwa chomveka, kwa ife, mutha kutsimikiza chingwe cha mzere wopingasa ndi mtundu wina, mwachitsanzo, chikaso, pogwiritsa ntchito batani la "Mtundu" pa tepi.
Kenako, tinapeza chiwerengero cha mafunso omwe ali pamtanda. Ndi bwino kuchita izi osati zowonjezera. Kwa ife, font imagwiritsidwa ntchito 8.
Pofuna kuyika mafunso okha, mutha kudina malo aliwonse a maselo ake pambali kuchokera ku batani la mtanda.
Kupitilira apo, m'chipinda chachikulu chophatikizidwa, mutha kusindikiza, kapena kukopera mafunso kuchokera ku mtanda.
Kwenikweni, mtanda pawokha wakonzeka izi. Itha kusindikizidwa, kapena kuyesetsa mwachindunji.
Kupanga cheke cha auto
Koma, expl imakupatsani mwayi kuti musangopanga mawu otayika, komanso mawu opumira omwe amawunikira nthawi yomweyo wosuta woyenera adathetsa mawuwo kapena ayi.
Pachifukwa ichi, m'buku lomweli pa pepala latsopano timapanga tebulo. Mbali yake yoyamba idzatchedwa "Mayankho", ndipo tidzayankha mayankho a mtanda. Gawo lachiwiri lidzatchedwa "adalowa". Pali deta yowonetsedwa ndi wosuta yemwe adzakokedwe ku mtanda wa mtanda. Mzere wachitatu udzatchedwa "Zochitika". Mmenemo, ngati khungu la mzati woyamba limagwirizana ndi foni yofananira ya mzere wachiwiri, chiwerengerocho "1" chikuwonetsedwa, ndipo china ". Mu mzere womwewo pansipa, mutha kupanga foni kuti mupeze mayankho onse ovomerezeka.
Tsopano, tili pansi patebulo pa tebulo limodzi ndi tebulo pa pepala lachiwiri.
Zingokhala ngati mawu aliwonse omwe mawu amodzi adalowa mu khungu limodzi. Kenako tinangomangirira ma cell 'omwe adalowa "ndi maselo ofananira. Koma, monga tikudziwira, palibe liwu limodzilo la khungu lirilonse la mtanda wa mtanda, koma kalata imodzi. Timagwiritsa ntchito ntchito "yolanda" kuphatikiza makalata awa mu liwu limodzi.
Chifukwa chake, dinani pa selo loyamba mu "mzere" womwe walowa, ndikudina batani kuti muyimbire wizard.
Muzogwira pawindo la Wizard lomwe limatsegulira, timapeza ntchito "yolanda" yosankha iyo, ndikudina batani la "Ok".
Kukangana kwa ntchito kumatseguka. Dinani batani lopezeka kumanja kwa gawo lolowera data.
Ntchito ya zotsutsana ndi ntchito zidagwa, ndipo timasamukira ku pepala lokhala ndi cellyword, ndikusankha foni yomwe kalata yoyamba ya mawu ili, yomwe ikufanana ndi mzere wachiwiri wa chikalatachi. Pambuyo posankha kupangidwa, timadina batani kumanzere kwa fomu yolowera kuti mubwerere ku Phokoso la Ntchito.
Ntchito yotereyi imachitika ndi chilembo chilichonse cha Mawu. Zomwe zidalowetsedwa zonse zikaikidwa, dinani batani la "Ok" mu zenera la ntchito.
Koma, wogwiritsa ntchito pomwe chithunzi cha mtanda chimatha kugwiritsa ntchito zilembo zazing'ono komanso zapamwamba, ndipo pulogalamuyi iwaonetsa ngati zilembo zosiyanasiyana. Kuti izi zisachitike, timakhala mchipinda chomwe mumafunikira, komanso motsatana timapereka mtengo "Strach". Zonsezi zonse za khungu zimatengera mabakiketi, monga m'chithunzichi pansipa.
Tsopano, zilizonse zomwe zilembo sizinalembetse ogwiritsa ntchito pamtanda, mu "mzere" womwe adzasandutsidwa kukhala wotsika.
Njira ngati "kugwidwa" ndi "strachcheni" iyenera kuchitika ndi gawo lililonse mu "mzere" wa "zomwe adayambitsa", komanso ndi maselo osiyanasiyana omwe ali mu mtanda pawokha.
Tsopano, kuti afanane ndi zotsatira za "Mayankho" mzati ndi "wokhazikitsidwa", tifunika kugwiritsa ntchito "ngati" ntchito pamunsi. Timakhala padelo lolingana la mzati "zomwe mwangolera" Kwathu, ntchitoyo idzakhala ndi mawonekedwe "= ngati (B3 = A3; 1; 0)". Ntchito yotereyi imachitidwa maselo onse a "Mwangozi wa" Kamwambowu "kupatula" zonse ".
Kenako tikutsindika maselo onse pa mzere wa "Mwangozi", kuphatikizapo "kwathunthu", ndikudina chithunzi cha Autosummy pa riboni.
Tsopano pepala ili lidzayang'aniridwa kulondola kwa mawu olimba, ndipo zotsatira za mayankho olondola ziwonetsedwa ngati gawo wamba. Kwa ife, ngati mawu a mtanda adzakhala olimba, ndiye kuti nambala 9 iyenera kuwonekera kuchuluka kwa kuchuluka kwake, popeza kuchuluka kwa mafunso ndikofanana ndi nambala iyi.
Kuti chifukwa cha kuchepa pang'ono kuti uziwoneka osati pa pepala lobisika, koma munthu amene amathetsa mtanda, mutha kugwiritsanso ntchito "ngati" ntchito. Pitani pa pepala lomwe lili ndi mtanda. Timasankha foni, ndikulowetsa mtengo ndi template yotere: "= ngati (mapepala ogwirira ntchito ma cell omwe ali ndi gawo logawana =;" Kwa ife, mawonekedwe ali ndi mtundu woterewu: "= ngati (pepala2! C12 = 9;" ndroww adathetsedwa ";" Ganizirani zambiri ")".
Chifukwa chake, gawo la mtanda mu pulogalamu ya Microsoft Excess ili wokonzeka. Monga mukuwonera, mu ntchito iyi simungangongopanga mawu otalika, komanso pangani cheke.