Ntchito Kugwira Kupambana

Chimodzi mwazinthu zosangalatsa za Microsoft Excel Production ndikugwira ntchito mogwirizana. Ntchito yake yayikulu ndikulumikiza zomwe zili m'maselo awiri kapena kupitilira apo. Wogwiritsa ntchitoyu amathandizira kuthetsa ntchito zina zomwe sizingachitike pogwiritsa ntchito zida zina. Mwachitsanzo, ndibwino kutulutsa njira yophatikiza maselo osatayika. Ganizirani mwayi wa ntchitoyi komanso zochulukitsa za kugwiritsa ntchito kwake.

Ntchito Yogwiritsa Ntchito

Ntchito ya ndalama imatanthauzira mawu owerengera a Excel. Ntchito yake yayikulu ndikuphatikiza mu khungu limodzi la maselo angapo, komanso otchulidwa payekha. Kuyambira kuchokera ku Excel 2016, m'malo mwa wothandizirayo, ntchito ya khadi imagwiritsidwa ntchito. Koma kuti asunge kugwirizana kothetseratu, wothandizirayo asiyidwa, ndipo itha kugwiritsidwa ntchito pa bala.

Syntax ya wothandizira uyu akuwoneka motere:

= Kugwira (zolemba1; mawu2; ...)

Monga mkangano womwe amatha kukhala ngati zolemba ndi mafotokozedwe a maselo omwe ali nawo. Chiwerengero cha mikangano chitha kusiyanasiyana 1 mpaka 255.

Njira 1: Zambiri zophatikiza m'maselo

Monga mukudziwa, maselo ophatikizira mwachizolowezi amatsogolera kuwonongeka kwa deta. Deta yokha yokha imasungidwa ku chinthu chapamwamba kumanzere. Kuti muphatikize zomwe zili m'maselo awiri ndipo kuposerapo popanda kutaya, mutha kugwiritsa ntchito ntchito yolanda.

1. Sankhani khungu lomwe tikukonzekera kuyika deta yophatikizidwa. Dinani pa batani la "phala ntchito". Ikuwoneka ngati zithunzi ndi kuyikidwa kumanzere kwa chingwe cha formula.



2. Wizard akutsegula. Mu gulu la "zolemba" kapena "mndandanda wathunthu wa zilembo" tikuyang'ana wothandizira "wogwidwa". Tikutsindika dzina ili ndikudina batani la "OK".



3. Zenera lokangana limayamba. Monga mikangano, zonena za maselo okhala ndi deta kapena gawo lina likhoza kukhala. Ngati ntchitoyo ikuphatikiza kuphatikiza zomwe zili m'maselo, ndiye kuti pankhaniyi tigwira ntchito zokhazokha.

   Ikani chotemberetsa m'munda woyamba wa zenera. Kenako sankhani ulalo pa pepala lomwe data lomwe limafunikira kuti mgwirizano udalipo. Pambuyo pamalumikizidwe akuwonetsedwa pazenera, momwemonso, timachita ndi gawo lachiwiri. Chifukwa chake, timagawana khungu lina. Ifenso timagwiranso ntchito ngati magwiridwe antchito onse omwe amafunika kuphatikizidwa sadzalowetsedwa mu zenera la ntchito. Pambuyo pake, dinani batani la "OK".



4. Monga mukuwonera, zomwe zili m'magawo osankhidwa awonekera mu khungu limodzi lokhalokha. Koma njirayi ili ndi vuto lalikulu. Mukamagwiritsa ntchito, otchedwa "opanga mpweya" osakhala ndi msoko. Ndiye kuti, pakati pa mawu mulibe malo ndipo amakakamizidwa kukhala mndandanda umodzi. Nthawi yomweyo, sizingatheke kuwonjezera payokha kuti muwonjezere danga, koma pokhapokha pokonza formula.

Phunziro: Mzere wa Wizard mu Excel

Njira 2: Kugwiritsa ntchito ntchito ndi danga

Pali mipata yokonza zotsalazo, poika mipata pakati pa zotsutsana.

1. Timagwira ntchitoyo pa algorithm yemweyo amene wafotokozedwa pamwambapa.
2. Dinani kawiri batani la mbewa pafoni ndi formula imayambitsa kusintha.



3. Pakati pa mkangano uliwonse, lembani mawu mu mawonekedwe a malo ochepa kuchokera kumbali ziwiri ndi mawu. Titapanga mtengo uliwonse wotere, timayika mfundo ndi comma. Kuwona kwakukulu kwa mawu omwewo kuyenera kukhala otsatirawa:

   " ";



4. Pofuna kuti zitheke pazenera, dinani batani la Enter.

Monga mukuwonera, pali magawano pakati pa mawu mu cell mu kulowetsa mipata yokhala ndi zolemba.

Njira 3: Kuonjezerani malo kudzera pawindo lotsutsa

Zachidziwikire, ngati palibe mfundo zambiri zosasinthika, ndiye kuti njira yomwe ili pamwambayo ili yangwiro. Koma zingakhale zovuta kukhazikitsa mwachangu ngati maselo ambiri omwe amafunika kuphatikizidwa. Makamaka ngati maselo awa sakhala mndandanda umodzi. Mutha kusintha kwambiri makonzedwe a spacecraft pogwiritsa ntchito njira yake kudzera pazenera.

1. Timatsindika kwambiri dinani lakumanzere kwa mbewa iliyonse yopanda kanthu pa pepalalo. Kugwiritsa ntchito kiyibodi, ikani malowa mkati mwake. Ndikofunikira kuti ndi kutali ndi zazikulu. Ndikofunikira kuti khungu ili lisanathe chilichonse.



2. Timachita zomwezo ngati njira yoyamba yogwiritsira ntchito ntchitoyo kuti apange ntchito, mpaka kutsegulira kwa zenera la wothandizira. Onjezani phindu la selo loyambirira lomwe lili ndi deta m'munda wa zenera, monga zafotokozedwa kale. Kenako kwezani chotengera kumunda wachiwiri, ndipo sankhani khungu lopanda kanthu ndi danga lomwe likufotokozedwa kale. Ulalo umawoneka mu bwalo la zenera. Kuti mufulumizire njirayi, mutha kujambula powunikira ndi kukanikiza kuphatikiza zazikulu ctrl.



3. Kenako onjezani ulalo wa chinthu chotsatira chomwe mukufuna kuwonjezera. M'gawo lotsatira, onjezerani ulalo wa khungu lopanda kanthu. Popeza tinakonzera adilesi yake, mutha kukhazikitsa chotemberero m'munda ndikusindikiza Ctrl + V. Magwiridwe ake adzaikidwa. Mwanjira imeneyi, timathandizanso minda ndi ma adilesi a zinthu ndi khungu lopanda kanthu. Pambuyo pazonse zomwe zidapangidwa, dinani batani la "OK".

Monga mukuwonera, zitachitika izi, mbiri yophatikizika yophatikizidwa mu cell yandamale, yomwe imaphatikizapo zomwe zili mu zinthu zonse, koma ndi malo pakati pa liwu lililonse.

Chidwi! Monga tikuwona, njira yomwe ili pamwambapa imathandizira kwambiri njira yophatikiza deta mu maselo. Koma ndikofunikira kulingalira kuti njira iyi ndi yokha komanso "yopumira". Ndikofunikira kwambiri kuti mu chinthu chomwe chili ndi danga ilibe chilichonse kapena sichinasunthidwe.

Njira 4: Mgwirizano wa Nyanja

Kugwiritsa ntchito kusinthaku, mutha kuphatikizapo kwambiri mizati iyi.

1. Ndi maselo a mzere woyamba wa mizere yophatikizika, tidapeza kusankha kwa zomwe zatchulidwa mu njira yachiwiri komanso yachitatu yogwiritsira ntchito mkangano. Zowona, ngati mungaganize zogwiritsa ntchito njira yokhala ndi khungu lopanda kanthu, ndiye kuti kulumikizana kwa iyenera kuchita mtheradi. Pa izi, chikwangwani chilichonse chisanachitike mozungulira ndipo chofukizira cha khungu lino chimayika chizindikiro cha dollar ($). Mwachilengedwe, ndibwino kuchita izi kumayambiriro kwa magawo ena komwe adilesi ili ndi, wogwiritsa ntchitoyo amatha kutembenukira ngati ulalo wokhazikika. M'magawo otsala, timasiyira maulalo. Monga nthawi zonse, mutatha kuchita njirayi, dinani batani la "OK".



2. Timakhazikitsa cholozera ku mbali yakumanja ya chinthucho ndi mawonekedwe. Icon imawonekera, yomwe ili ndi mawonekedwe a pamtanda, omwe amatchedwa chikhomo chodzaza. Dinani batani lamanzere la mbewa ndikuyika pansi pamalo omwe amaphatikizidwa.



3. Pambuyo pochita njirayi, zomwe zili mumitundu yomwe yafotokozedwayo zimaphatikizidwa mu gawo limodzi.

Phunziro: Momwe mungaphatikizire mzawo

Njira 5: Kuwonjezera zilembo zowonjezera

Muthanso kukakamiza ntchitoyo kuti iwonjezere zilembo zowonjezera ndi mawu omwe sizinali mu gawo loyambirira. Komanso, mutha kukhazikitsa ntchito zina pogwiritsa ntchito izi.

1. Chitani zochita kuti muwonjezere malingaliro pawindo lazokambirana la ntchito ndi njira zilizonse zomwe zidaperekedwa pamwambapa. Mu gawo limodzi (ngati kuli kotheka, pakhoza kukhala angapo a iwo) onjezerani nkhani iliyonse yomwe wosuta amawona kuti ndikofunikira kuwonjezera. Lembali liyenera kutsekedwa m'mawu. Dinani pa batani la "OK".



2. Monga tikuwonera, zitachitika izi pazidziwitso zophatikizika, zolembazo zidawonjezedwa.

Zojambulajambula - njira yokhayo yogwirizira maselo osataya bwino. Kuphatikiza apo, mutha kulumikizana ndi mizati yonse, onjezerani maumboni, gwiritsani ntchito zonona zina. Kudziwa ntchito ya Algorithm ndi izi kumapangitsa kuti zitheke kuthana ndi pulogalamu ya pulogalamuyi.