Ntchito yoyendetsa ndi ntchito yopeza njira zabwino kwambiri zotengera zonyamula katundu kuchokera kwa wotsatsa kupita kwa wogula. Maziko ake ndi mtundu womwe umagwiritsidwa ntchito kwambiri pamasamu osiyanasiyana azachuma komanso azachuma. Microsoft Excel ili ndi zida zomwe zimathandizira kwambiri yankho lavuto loyendetsa. Tipeza momwe angagwiritsire ntchito pochita.
Kufotokozera mwatsatanetsatane za vuto la mayendedwe
Cholinga chachikulu cha ntchito yoyendetsa ndi kupeza njira yoyenera yoyendera kuchokera kwa omwe akutsatsa kupita kwa ogula pamtengo wotsika mtengo. Mikhalidwe ya ntchito yotereyi imalembedwa mwajambulidwe kapena matrix. Excel imagwiritsa ntchito mtundu wa matrix.
Ngati kuchuluka kwazinthu zonse zomwe zili m'manja yosungiramo othandizira ndizofanana ndi zomwe zimafunidwa, ntchito yoyendetsayo imatchedwa yotsekedwa. Ngati zizindikirozi sizili zofanana, ndiye kuti vuto lotere limayambira lotseguka. Kuti muthane ndi vutoli, zinthu ziyenera kuchepetsedwa kukhala zotsekeka. Kuti muchite izi, onjezerani wogulitsa wabodza kapena wogula mwachinyengo wokhala ndi masheya kapena akufunika ofanana ndikusiyana pakati pakupereka ndi kufunikira muzochitika zenizeni. Nthawi yomweyo, mzati wowonjezera kapena mzere wokhala ndi zero zero umawonjezedwa pa tebulo la mtengo.
Zida zakuthana ndi vuto loyendetsa ku Excel
Kuti muthane ndi vuto la mayendedwe ku Excel, gwiritsani ntchito ntchitoyi “Kupeza yankho”. Vuto ndilakuti limaletseka mosalephera. Kuti mupeze chida ichi, muyenera kuchita zinthu zina.
- Chitani tabu Fayilo.
- Dinani pa gawo laling'ono "Zosankha".
- Pa zenera latsopano, pitani pomwepo "Zowonjezera".
- Mu block "Management", yomwe ili pansi pazenera lomwe limatseguka, mndandanda wotsika, siyani kusankha komweko Wonjezerani-Ex. Dinani batani "Pita ...".
- Windo lowonjezera likuyamba. Chongani bokosi pafupi "Kupeza yankho". Dinani batani "Zabwino".
- Chifukwa cha izi, tabu "Zambiri" mumazisungidwe "Kusanthula" batani liziwoneka padzulu "Kupeza yankho". Tidzazifunafuna tikamafufuza njira yothetsera vuto la mayendedwe.
Phunziro: Ntchito ya "Fufuzani yankho" mu Excel
Chitsanzo chothetsa vuto la mayendedwe ku Excel
Tsopano tiyeni tiwone chitsanzo china chothetsera vuto la mayendedwe.
Ntchito
Tili ndi othandizira 5 komanso ogula 6. Ma voliyumu opanga awa ndi ophatikizira 48, 65, 51, 61, 53. Ogula amafuna: 43, 47, 42, 46, 41, 59 mayunitsi. Chifukwa chake, kuperekera kwathunthu kuli kofanana ndi kufunika kwa kufunikira, ndiye kuti, tikulimbana ndi vuto lotha kuyenda.
Kuphatikiza apo, vutoli limapereka mtengo wonyamula mayendedwe kuchokera pamalo amodzi kupita kwina, omwe akuwonetsedwa zobiriwira m'fanizo ili pansipa.
Kuthetsa mavuto
Tikuyang'anizana ndi ntchitoyi, pansi pa zikhalidwe zomwe tafotokozazi, kuti tichepetse ndalama zoyendera.
- Kuti athane ndi vutoli, timapanga tebulo lokhala ndi nambala yofanana ya maselo monga mtengo wa matrix pamwambapa.
- Sankhani selo iliyonse yopanda pepala. Dinani pachizindikiro "Ikani ntchito"ili kumanzere kwa baramu yamu formula.
- "Wizard Wogwira Ntchito" amatsegula. Pamndandanda womwe amapereka, tikuyenera kupeza ntchito SUMPRONT. Sankhani ndikudina batani. "Zabwino".
- Tsamba lolowera ntchito limatseguka SUMPRONT. Monga mkangano woyamba, timayambitsa maselo osiyanasiyana amtundu wa matrix. Kuti muchite izi, ingosankha foni yam'manja ndi cholozera. Mtsutso wachiwiri ndi kuchuluka kwa maselo patebulo omwe adakonzekera kuwerengera. Kenako, dinani batani "Zabwino".
- Timadula khungu, lomwe lili kumanzere kwa selo lamanzere lakumanzere kwa tebulo kuti kuwerengetsa. Pomaliza pomwe timatcha Wizard wa Ntchito, tsegulani zotsutsana za ntchito mmenemo SUM. Mwa kuwonekera pa gawo la mfundo yoyamba, sankhani mzere wonse wapamwamba wa maselo patebulo kuti muwerenge. Mapulogalamu awo akalowa m'munda woyenera, dinani batani "Zabwino".
- Timalowa m'makona akumunsi a cell ndi ntchito SUM. Chizindikiro Dinani batani lakumanzere ndikukokera chikhomo mpaka kumapeto kwa tebulo kuti muwerenge. Chifukwa chake tinatsata njira.
- Timadula khungu lomwe lili pamwamba pa chipinda chakumanzere kwa tebulo kuti chiwerengedwe. Monga nthawi yapita, timayitanitsa ntchitoyo SUM, koma nthawi ino, monga mkangano, timagwiritsa ntchito mzati woyamba wa tebulo powerengera. Dinani batani "Zabwino".
- Koperani formula kuti mudzaze mzere wonse ndi chikhomo.
- Pitani ku tabu "Zambiri". Pamenepo m'bokosi la chida "Kusanthula" dinani batani "Kupeza yankho".
- Njira zosakira zotseguka zimatsegulidwa. M'munda "Konzani ntchito cholinga" tchulani khungu lomwe lili ndi ntchitoyo SUMPRONT. Mu block "Ku" mtengo wokhazikitsidwa "Ochepera ". M'munda "Kusintha Maselo Osiyanasiyana" tchulani mtundu wonse wa tebulo kuti muwerenge. Mu makatani "Malinga ndi zoletsa" dinani batani Onjezanikuwonjezera malire ofunikira.
- Zowonjezera zoletsa zimayamba. Choyamba, tifunika kuwonjezera kuti kuchuluka kwa kuchuluka kwa deta m'mizere ya tebulo yowerengera kuyenera kufanana ndi kuchuluka kwa deta yomwe ili m'mizere ya tebulo ndi momwe muliri. M'munda Cell Link sonyezani kuchuluka kwa kuchuluka kwa mizere ya tebulo lowerengera. Kenako ikani chizindikiro chofanana (=). M'munda "Kuletsa" fotokozani kuchuluka kwa mizere ya tebulo ndi momwe muliri. Pambuyo pake, dinani batani "Zabwino".
- Momwemonso, timawonjezera kuti mawonekedwe a mizati iwiri ayenera kukhala ofanana. Timawonjezera kunena kuti kuchuluka kwa maselo onse omwe ali pagome kuti awerengere ayenera kukhala okulirapo kapena ofanana ndi 0, komanso kuti athe kukhala achiwonetsero. Mawonedwe apakati pazoletsa azikhala monga akuwonetsera pansipa. Onetsetsani kuti mwatsimikiza "Pangani zosintha kukhala zopanda pake" panali cheke, ndipo njira yankho idasankhidwa "Sakani njira zothetsera mavuto osayenerana ndi magulu aupandu olinganizidwa". Pambuyo mawonekedwe onse asonyezedwa, dinani batani "Pezani yankho".
- Pambuyo pake, kuwerengera kumachitika. Zambiri zimawonetsedwa muma cell a tebulo kuti awerengere. Zenera lofufuza zotsatira limatsegulidwa. Ngati zotsatira zakukhutitsani, dinani batani. "Zabwino".
Monga mukuwonera, yankho la vuto la mayendedwe ku Excel limatsikira pakupanga kolondola kwa zidziwitso. Mawerengi pawokha amachitidwa ndi pulogalamu m'malo mwa wogwiritsa ntchito.
