Momwe Mungapangire Kuyesa Kwambiri: Njira Yotsimikizirika

Nthawi zambiri kuyesa mtundu wa chidziwitso kumagwiritsidwa ntchito pogwiritsa ntchito mayeso. Amagwiritsidwanso ntchito kwa mitundu yamaganizidwe ndi zina zoyesedwa. Pa PC ndi cholinga cholemba mayeso, mapulogalamu osiyanasiyana amagwiritsidwa ntchito nthawi zambiri. Koma ngakhale pulogalamu yodziwika bwino Microsoft imatha kuthana ndi ntchitoyi, yomwe imapezeka pamakompyuta pafupifupi onse ogwiritsa ntchito. Kugwiritsa ntchito kuvomerezedwa ndi pulogalamuyi, mutha kulemba mayeso omwe sikokwanira kugwira ntchito kuti akwaniritse mayankho omwe amapangidwa pogwiritsa ntchito pulogalamu yapadera. Tiyeni tiwone momwe mungachitire ntchitoyi ndi Excel.

Kuyesa

Kuyesedwa kulikonse kumaphatikizapo kusankha kwa imodzi mwa njira zingapo yankho ku funsoli. Monga lamulo, pali ambiri a iwo. Ndikofunikira kuti mukamaliza mayeso a wogwiritsa ntchito adadziwona kale, ngakhale atapirira kuyesa kapena ayi. Mutha kugwira ntchito imeneyi ku ukapolo m'njira zingapo. Tiyeni tifotokoze za algorithm njira zosiyanasiyana zochitira izi.

Njira 1: Gawo lolowera

Choyamba, tikambirana njira yosavuta. Zimatanthawuza mndandanda wazinthu zomwe amayankha. Wogwiritsa ntchitoyo ayenera kufotokozera njira yapadera yoyankhira yankho lomwe amawona mokhulupirika.

1. Tikulemba funso lokha. Tiyeni tigwiritse ntchito mawu a masamu munjira yosavuta imeneyi kuphweka, komanso monga mayankho - njira zosankha zowerengera.



2. Selo linaperekedwa kuti wogwiritsa ntchito athetse nambala ya yankho lomwe amawona kuti anali wokhulupirika. Chifukwa chomveka timayika chikasu.



3. Tsopano tikusamukira ku pepala lachiwiri la chikalatacho. Zili pamenepo kuti mayankho olondola adzakhala, omwe pulogalamuyo ingatumikire wogwiritsa ntchitoyo. Mu khungu limodzi timalemba mawu akuti "Funso 1" Kuti tiyimbire ntchitoyi, tikuwonetsa khungu landamale ndikudina batani la "Intern Accon", lomwe lili pafupi ndi formula.



4. Wizy Wizzard imayamba. Pitani ku gulu la "Logic" ndipo tikufuna dzinalo "ngati". Kufufuza sikuyenera kukhala lalitali, chifukwa dzinali limayikidwa kaye pamndandanda wa ogwiritsa ntchito. Pambuyo pake, timagawa izi ndikudina batani la "OK".



5. Windo la Ogwiritsa ntchito wa ulerment limayambitsidwa ngati. Woperekera opaleshoni ali ndi minda itatu yofananira ndi kuchuluka kwa mikangano yake. Syntax ya izi imatenga fomu iyi:

   = Ngati (chipika_section; mtengo_ieslina_inchina; mtengo_ift)

   Mu "gawo lomveka" gawo la "muyenera kulowa maselo a selo yomwe wosuta amayankha. Kuphatikiza apo, mu gawo lomwelo lomwe muyenera kufotokozera njira yoyenera. Pofuna kupanga mgwirizano wa khungu landamalo, khazikitsani cholozera m'munda. Kenako, timabwereranso ku pepalali 1 ndikulemba chinthucho chomwe tidafuna kulemba nambala ya kusankha. Magwirizano ake amawonekera nthawi yomweyo pawindo lanyumba. Kuphatikiza apo, kuti mufotokozere yankho lolondola mu gawo limodzilo litatha adilesi ya cell, lembani mawu opanda mawu "= 3". Tsopano, ngati wosuta wa chandamale adayika manambala a "3", yankho lidzawonedwa moona, ndipo nthawi zonse - zolakwika.

   Mu "kutanthauza ngati chowonadi" gawo, khazikitsani nambala ya "1", komanso mu "mtengo ngati wonama" 0 ". Tsopano, ngati wosuta amasankha njira yolondola, ilandira gawo limodzi, ndipo ngati sichoncho malinga ndi mfundo 0. Pofuna kupulumutsa deta yomwe idalowa, dinani batani la "OK" pansi pa zenera.



6. Momwemonso, timapanga ntchito zina ziwiri (kapena nambala iliyonse yomwe mukufuna) pa wosuta yemwe akugwiritsa ntchito.



7. Pa pepala 2 pogwiritsa ntchito ntchito, ngati titchulapo zolondola, monga tidachitira m'mbuyomu.



8. Tsopano tikukonzekera kuwerengera kwa mfundo. Itha kuchitika pogwiritsa ntchito autosummy yosavuta. Kuti muchite izi, sankhani zinthu zonse zomwe foremula imadali ngati mungadine chithunzi cha Autosumi, chomwe chili pa riboni mu tiyi yokonza.



9. Monga tikuwona, bola ngati kuchuluka kwake ndi zero mfundo, popeza sitinayankhe moyenerera. Chiwerengero chachikulu kwambiri cha mfundo zomwe zili mu mlanduwu zimatha kuyimba - 3, ngati ili molondola mafunso onse.



10. Ngati mukufuna, zitha kuchitika kuti chiwerengero chambiri chidzawonetsedwa patsamba la wogwiritsa ntchito. Ndiye kuti, wosuta adzaona momwe amapirira ntchitoyo. Kuti tichite izi, timatsindika foni imodzi papepala, yomwe imatchedwa "zotsatira" (kapena dzina lina losayamwitsa). Pofuna kuti musaswe mutu kwa nthawi yayitali, ingoyika mawu oti "= mndandanda2!", Pambuyo pake mumalowa adilesi ya chinthucho pa pepalalo 2, pomwe pali zambiri.



11. Onani momwe mayeso athu amagwirira ntchito, kulola kuti cholakwika chimodzi. Monga tikuwona, zotsatira za mayeso awiriwa, zomwe zikugwirizana ndi cholakwika chimodzi chopangidwa. Mayeso amagwira ntchito molondola.

Phunziro: Kugwira ntchito ngati ndalama

Njira 2: Mndandanda wotsika

Muthanso kukonza mayeso ku ukapolo pogwiritsa ntchito mndandanda womwe watsika. Tiyeni tiwone momwe tingachitire izi.

1. Pangani tebulo. Kumanzere kwa ilo kukakhala ntchito, mu gawo lalikulu - mayankho omwe wosuta ayenera kusankha wopanga mndandanda wa mndandanda wotsika. Zotsatira zake zidzawonetsedwa zotsatira zomwe zimangopangidwa molingana ndi kulondola kwa mayankho osankhidwa ndi wogwiritsa ntchito. Chifukwa chake, pakuyamba, tidzapanga mete ya tebulo ndikuyambitsa mafunso. Ikani ntchito zomwezi zomwe zagwiritsidwa ntchito mwanjira yapita.



2. Tsopano tiyenera kupanga mndandanda wokhala ndi mayankho omwe ali ndi mayankho omwe alipo. Kuti muchite izi, sankhani chinthu choyamba mu "yankho". Pambuyo pake, pitani ku "deta" tabu. Chotsatira, dinani pa chithunzi cha "Data cheke cha data" chomwe chili mu "kugwira ntchito ndi data" chida.



3. Pambuyo pochita izi, mfundo zowoneka bwino zimayang'ana pawindo. Pitani mu "magawo" tabu, ngati ikuyenda mu tabu ina iliyonse. Kenako mu gawo la "Mtundu wa data" kuchokera pamndandanda wotsika, sankhani "mndandanda" mtengo. Mu "Gwero", mpaka kumapeto ndi comma, muyenera kulemba mayankho kuti awonetsere mndandanda wathu wotsika. Kenako dinani batani la "OK" pansi pa zenera logwira.



4. Pambuyo pa zochita izi, chithunzi chofanana ndi makona atatu ndi ngodya yolumikizidwa kumanja kwa foni yomwe ili ndi gawo lolowera limawonekera. Mukamadina pa iyo, mndandanda wokhala ndi zosankha zomwe adalemba kale adzatsegulidwa, imodzi mwazomwe ziyenera kusankhidwa.



5. Mofananamo, timapanga mindandanda ya maselo ena a "yankho" mzere.



6. Tsopano tiyenera kutero kuti m'Zikulu yazotsatira "zotsatira" zowonetsa kuti cholondola ndi yankho la ntchitoyo kapena ayi. Monga mwa njira yapita, izi zitha kuchitika pogwiritsa ntchito wothandizira ngati. Tikuwonetsa foni yoyamba ya "zotsatira" zobwera "ndikuyitanira zingwe za Wizard pokanikiza" ikani ntchito ".



7. Kenako, kudzera mu ntchito zomwe zimagwiritsidwa ntchito mosiyananso zomwe zafotokozedwa mwanjira yapitayo, pitani ku ntchito ya ntchito ngati. Tili ndi zenera lomweli lomwe tawona m'mbuyomu. Mu "gawo lomveka", fotokozerani adilesi ya selo yomwe mungasankhe yankho. Kenako, ikani chizindikirocho "=" ndikulemba yankho lolondola. M'malo mwathu, likhala nambala 113. Mu tanthauzo ngati Choonadi "Munda, timakhazikitsa mfundo zomwe tikufuna kuti zivomerezedwe ndi wosuta. Ziloleni, monga momwe zidalili, ndi nambala yakuti "1". Mu "kutanthauza ngati bodza" munda, Khazikitsani mfundo za mfundo. Pankhani ya yankho lolakwika, lolani kuti akhale zero. Pambuyo pa zotupa pamwambapa zimapangidwa, kanikizani "OK".



8. Momwemonso, tigwiritsa ntchito ntchitoyo ngati "zotsatira" zotsatira. Mwachilengedwe, munjira iliyonse, mu "munda womveka", padzakhala mtundu wanu wa yankho lolondola lomwe likugwirizana ndi vutoli.
9. Pambuyo pake, timapanga chingwe chomaliza chomwe kuchuluka kwa mfundo kumagulidwa. Timagawa maselo onse a chipilala "zotsatira" ndikudina zomwezomwe mumazolowera chifaniziro cha Autosumma mu "Home" tabu.



10. Pambuyo pake, pogwiritsa ntchito mndandanda wotsika mu "yankho" mzere, tikuyesera kunena zisankho zoyenera pa ntchitozo. Monga m'mbuyomu, pamalo amodzi amalola kulakwitsa. Monga mukuwonera, tsopano sitinyalanyaza zoyeserera zonse zokha, komanso funso linalake, mu yankho lomwe likulakwitsa.

Njira 3: Kugwiritsa Ntchito Zowongolera

Mutha kuyesanso mayeso pogwiritsa ntchito zinthu zowongolera mu mawonekedwe a batani kuti musankhe njira.

1. Kuti athe kugwiritsa ntchito mitundu ya zowongolera zinthu, choyamba, muyenera kuthandiza tabu. Mosavomerezeka, imalemala. Chifukwa chake, ngati mu mtundu wanu wa Excel sizinayambike, ndiye kuti zonona zina ziyenera kuchitika. Choyamba, timasamukira ku "fayilo" tabu. Timakwaniritsa gawo la "magawo".



2. Zenera la parament limayambitsidwa. Iyenera kusamukira ku "matepi". Kenako, kumbali yoyenera ya zenera, tinakhazikitsa bokosi pafupi ndi "wopanga". Pofuna kusintha kuti mupange mphamvu, kanikizani "OK" pansi pazenera. Pambuyo pa zochita izi, tabu yopanga mapulogalamuwo idzapezeka pa tepi.



3. Choyamba, lowetsani ntchitoyi. Mukamagwiritsa ntchito njira imeneyi, aliyense wa iwo adzaikidwa papepala lina.



4. Pambuyo pake, pitani ku tsamba latsopano lomwe tayambitsa posachedwapa. Dinani pa chithunzi cha "phala", chomwe chili mu "kuwongolera" chida. Mu chithunzi cha gulu la "Fomu Yoyang'anira", sankhani chinthu chotchedwa "switch". Ili ndi batani lozungulira.



5. Dinani pamalo omwe tikufuna kutumiza mayankho. Ndiko kuti chinthu cha ulamuliro chidzawonekera.



6. Kenako ikani njira imodzi yazoyankhira m'malo mwa dzina la batani.



7. Pambuyo pake, timatsimikizira chinthu ndikudina batani la mbewa lamanja. Kuchokera pazomwe zilipo, sankhani "kope".



8. Sankhani khungu lomwe lili pansipa. Kenako dinani batani lakumanja. Pa mndandanda womwe umawonekera, sankhani "phala".



9. Kenako, timapanga zigawo zinanso kawiri, popeza tinaganiza kuti padzakhala njira zinayi zothetsera mavuto, ngakhale zili choncho.



10. Kenako timadzibwezeranso njira iliyonse kuti isagwirizane ndi wina ndi mnzake. Koma musaiwale kuti imodzi mwazosankha ziyenera kukhala zolondola.



11. Kenako, timakongoletsa chinthu chopita ku ntchito ina yotsatira, ndipo malinga ndi kusintha kwa pepala lotsatira. Apanso, dinani pa chithunzi cha "ikani", yomwe ili mu tsamba la wopanga. Nthawi ino tikupita kukasankha zinthu mu "Activex". Sankhani "batani", lomwe lili ndi mawonekedwe amakona.



12. Dinani padera la chikalatacho, chomwe chili pansipa chomwe chalembedwapo kale. Pambuyo pake, ziwonekera pa chinthu chomwe timafunikira.



13. Tsopano tifunika kusintha zina mwa batani lopangidwa. Ndimadina batani la mbewa kumanja ndi mndandanda womwe umatseguka, sankhani malo "katundu".



14. Kholo lowongolera limatseguka. Mu "Dzinalo", timasinthana ndi munthu amene lidzakhala lofunika kwambiri pa chinthu ichi, pa chitsanzo chathu ndi dzina "chotsatira_Vopros". Dziwani kuti kulibe malo m'munda uno. Mu "gawo" m'munda, lowetsani funso lotsatira. Pamakhala zololedwa kale, ndipo dzinali liwonetsedwa pa batani Lathu. Mu "gawo la Brondcolor", sankhani mtundu womwe chinthucho chidzakhala nacho. Pambuyo pake, mutha kutseka zenera lazinthu podina chithunzi cha kutsekeka mu ngodya yake yakumanja.



15. Tsopano dinani kumanja-dinani pa dzina la pepala lapano. Mumenyu zomwe zimatsegulidwa, sankhani "renuneme".



16. Pambuyo pake, dzina la pepalalo limakhala lachangu, ndipo tili ndi dzina latsopano "funso 1".



17. Apanso, dinani pa batani la mbewa ya mbewa, koma tsopano mumenyu, siyani kusankha pa "kusunthira kapena kope ..." chinthu.



18. Zenera la chilengedwe lakhazikitsidwa. Tidayika chithunzi pafupi naye pafupi ndi "Pangani cholembera" ndikudina batani la "Ok".



19. Pambuyo pake, timasintha dzina la pepalalo kuti "Funso 2" mofananamo chimodzimodzi. Tsamba ili limakhalabe ndi zomwe zili bwino kwambiri monga pepala lapitalo.



20. Timasintha nambala ya ntchitoyi, lembalo, komanso mayankho papepala pa zomwe tikuwona kuti ndizofunikira.



21. Momwemonso, pangani ndikusintha zomwe zili patsamba 23 Funso lachitatu ". Mmenemo, popeza iyi ndi ntchito yomaliza, m'malo mwa dzina la "funso lotsatira", mutha kuyika dzina "Kuyesedwa kwathunthu". Momwe mungachitire kale zidakambidwa kale.



22. Tsopano tikubwerera ku "funso 1". Tiyenera kumangiriza kusinthira ku khungu. Kuti muchite izi, dinani kumanja dinani pamasamba aliwonse. Mumenyu zomwe zimatsegulidwa, sankhani chinthu "cha chinthucho ...".



23. Zenera la kuwongolera limayambitsidwa. Pitani ku "kuwongolera" tabu. Mu "kulumikizana ndi gawo la cell" mwakhazikitsa adilesi ya chilichonse chopanda kanthu. Chiwerengero chidzawonetsedwa mkati mwake molingana ndi zomwe kusinthaku kudzakhala kogwira ntchito.



24. Njira yofananira imachitika pamatayala ndi ntchito zina. Kuti mumveke bwino, ndikofunikira kuti khungu lolumikizidwa likhale pamalo amodzi, koma pamasamba osiyanasiyana. Pambuyo pake, timabwereranso ku pepalalo "Funso 1" kachiwiri. Dinani kumanja pa "funso lotsatira" chinthu. Mu menyu, sankhani "zolemba".



25. Mkongero wolamulira amatsegula. Pakati pa "suble" ya "SEX" ya "Exp Sup", tiyenera kulemba nambala yotsatira ku tabu yotsatira. Pankhaniyi, ziwoneka motere:

    Ntchito ("Funso 2"). Yambitsani

    Pambuyo pake, tsekani zenera la mkonzi.



26. Mankhwala ofanana ndi batani lofanana lomwe timapanga pa "funso 2". Pokhapokha pamakhala lamulo lotsatirali:

    Ntchito ("Funso 3"). Yambitsani



27. Mu mkonzi wolamulira, funso la "Funso 3" limapanga zolowera izi:

    Ntchito ("zotsatira"). Yambitsani



28. Pambuyo pake, timapanga pepala latsopano lotchedwa "Zotsatira". Ikuwonetsa zotsatira za mayeso. Pazifukwa izi, timapanga tebulo la mizati inayi: "Nambala ya funso", "Yankho lolondola", "Yankho" M'munsi woyamba kugwirizaniratu kuti nambala ya ntchitozo "1", "2" ndi "3". Mu mzere wachiwiri, moyang'anizana ndi ntchito iliyonse, lowetsani nambala yosinthira yolingana ndi yankho lolondola.



29. Mu cell yoyamba mu "Kuyambitsa Yankho" Mapulogalamu ofananawo amachitika ndi maselo omwe ali pansipa, okhawo omwe amawonetsa mafotokozedwe a maselo ofananira pa "Funso 2" ndi "Funso 3"



30. Pambuyo pake, tikuwonetsa chinthu choyamba cha "zotsatirapo" ndikuyitanitsa ntchito ya zotsutsana za ntchito ngati njira yomweyo yomwe tidakambirana pamwambapa. Mu "gawo lomveka", fotokozerani adilesi ya "Yankho lomwe lalowa" foni ya mzere wolingana. Kenako timayika chikwangwanicho "=" kenako ndikuwonetsa zogwirizanitsa mu "yankho lolondola" mzere womwewo. M'munda "kutanthauza ngati chowonadi" ndi "kutanthauza ngati bodza" Lowani nambala ya "1 ndi" 0 ", motero. Pambuyo pake, dinani batani la "OK".



31. Pofuna kutengera njirayi pamndandanda womwe uli pansipa, timayika cholozera kumanzere kwa chinthu chomwe ntchitoyo ili. Nthawi yomweyo, chikhomo cha kudzazidwa mu mawonekedwe a mtanda chikuwonekera. Dinani pa batani lakumanzere ndikukoka chizindikiro mpaka kumapeto kwa tebulo.



32. Pambuyo pake, kufotokozera mwachidule zotsatira zake zonse, timagwiritsa ntchito autosum, monga kale kale.

Pa mayeso awa, mayesowo amatha kuganiziridwa kuti watsirizidwa. Ali wokonzeka kutha.

Tinaima m'njira zosiyanasiyana zopangira kuyesedwa pogwiritsa ntchito zida zapamwamba. Zachidziwikire, iyi si mndandanda wathunthu wa zosankha zonse zomwe zingathe kupanga mayeso mu ntchito iyi. Kuphatikiza Zida Zosiyanasiyana ndi Zinthu Zosiyanasiyana, mutha kupanga mayeso mosiyanasiyana molingana ndi magwiridwe antchito. Nthawi yomweyo, ndizosatheka kuzindikira kuti nthawi zonse, popanga mayeso, ntchito yothandiza imagwiritsidwa ntchito ngati.