Chitani nawo ntchito ndi CLIP mu Microsoft Excel

Chimodzi mwazinthu zosangalatsa za Microsoft Excel ndi ntchito POPANDA. Ntchito yake yayikulu ndikuphatikiza zomwe zili m'maselo awiri kapena kupitilira limodzi. Wogwiritsa ntchito amathandiza kuthana ndi mavuto ena omwe sangathe kugwiritsidwa ntchito pogwiritsa ntchito zida zina. Mwachitsanzo, ndi chithandizo chake ndikofunikira kuchita njira yophatikiza maselo popanda kutayika. Onani mawonekedwe a ntchitoyi ndi zovuta zake momwe zimagwirira ntchito.

Kugwiritsa ntchito wothandizila wa CLICK

Ntchito POPANDA amatanthauza gulu la zolembedwa za Excel. Ntchito yake yayikulu ndikuphatikiza mu cell imodzi zomwe zimakhala ndi ma cell angapo, komanso zilembo zaumwini. Kuyambira kuyambira Excel 2016, ntchitoyo imagwiritsidwa ntchito m'malo mwa opaleshoni iyi SCEP. Koma pofuna kupitilizabe kugwirizira kumbuyo, wothandizira POPANDA nawonso kumanzere, ndipo angagwiritsidwe ntchito limodzi ndi SCEP.

Kapangidwe ka mawu awa ndi motere:

= KONANI (zolemba1; zolemba2; ...)

Zotsutsana zimatha kukhala zonse zolembedwa komanso zolumikizana ndi maselo omwe ali nazo. Chiwerengero cha zotsutsa chimatha kusintha kuchokera pa 1 mpaka 255 kuphatikiza.

Njira 1: kuphatikiza deta m'maselo

Monga mukudziwa, kuphatikiza kwama cell komwe ku Excel kumabweretsa kutayika kwa deta. Ndi data yokhayo yomwe ili kumunsi kumanzere yomwe imasungidwa. Kuti muphatikize zomwe zili ndi maselo awiri kapena kupitilira apo mu Excel osataya, mutha kugwiritsa ntchito ntchitoyi POPANDA.

1. Sankhani khungu lomwe tikukonza kuti tiike zinthu zonse pamodzi. Dinani batani "Ikani ntchito". Ili ndi mawonekedwe a chithunzi ndipo ili kumanzere kwa mzere wa fomula.



2. Kutsegula Fotokozerani Wizard. Gulu "Zolemba" kapena "Mndandanda wathunthu wa zilembo" kuyang'ana wothandizira KONANI. Sankhani dzinali ndikudina batani. "Zabwino".



3. Ntchito yotsutsana ndi ntchito imayamba. Zotsutsana zimatha kukhala zonena za ma cell omwe ali ndi deta kapena mawu osiyana. Ngati ntchitoyi ikuphatikiza kuphatikiza zomwe zili m'maselo, ndiye pamenepa tidzagwira ntchito ndi maulalo okha.

   Khazikitsani chotengera mu gawo loyamba la zenera. Kenako sankhani ulalo womwe uli patsamba, womwe uli ndi zofunika kuzimangira. Pambuyo pazolumikizidwa ziwonetsedwa pazenera, timachita zomwezo ndi gawo lachiwiri. Chifukwa chake, sankhani khungu lina. Timagwiranso ntchito yomweyo mpaka zigwirizano za maselo onse omwe amafunika kuphatikizidwa adalowetsedwa pazenera zotsutsana. Pambuyo pake, dinani batani "Zabwino".



4. Monga mukuwonera, zomwe zili m'madera osankhidwa ziwonetsedwe mu khungu limodzi lokhazikitsidwa kale. Koma njirayi ili ndi zovuta zina. Mukamagwiritsa ntchito, zomwe zimatchedwa "seamless bonding" zimachitika. Ndiye kuti, palibe malo pakati pa mawuwo ndipo amathandizidwa kuti akhale amodzi. Potere, kuwonjezera pamanja sikungathandize, koma kungosintha formula.

Phunziro: Ntchito Wizard ku Excel

Njira 2: kutsatira ntchito ndi malo

Pali mwayi wokonza chilema ichi pokhazikitsa malo pakati pa zotsutsana ndi wothandizira.

1. Timagwira ntchitoyi pogwiritsa ntchito algorithm yomweyo monga tafotokozera pamwambapa.
2. Dinani kawiri batani lakumanzere pa khungu ndi fomula ndikuyiyambitsa kuti isinthe.



3. Pakati pa mfundo iliyonse, lembani mawu amtundu wa malo, omangiriridwa mbali zonse ndi mawu ogwidwa. Mukayika chilichonse chamtunduwu, ikani semicolon. Maganizo owonjezereka akuyenera kukhala motere:

   " ";



4. Kuti muwonetse zotsatira pazenera, dinani batani Lowani.

Monga mukuwonera, pamalo omwe amayikidwa malo omwe panali mawu m'selo, magawano pakati pa mawu adawonekera.

Njira 3: onjezerani danga kudzera pazenera zotsutsana

Zachidziwikire, ngati mulibe malingaliro ambiri osinthika, ndiye njira yomwe ili pamwambapa yopangira gluing palimodzi. Koma zimakhala zovuta kuzikwaniritsa mwachangu ngati pali maselo ambiri omwe amafunika kuphatikizidwa. Makamaka ngati maselo awa alibe mndandanda umodzi. Kuchepetsa kwambiri kuyika danga, mutha kugwiritsa ntchito njirayo kuyiyika kudzera pazenera zotsutsana.

1. Dinani kawiri batani lakumanzere pachiselo chilichonse chopanda papepala. Pogwiritsa ntchito kiyibodi, ikani malo mkati mwake. Ndikofunika kuti musayandikire patali. Ndikofunikira kwambiri kuti foni iyi siyodzazidwa ndi deta pambuyo izi.



2. Timachita zomwezo monga momwe timagwiritsira ntchito poyambira ntchito POPANDA, mpaka kutsegulidwa kwa zenera zotsutsana ndi opareshoni. Onjezani phindu la foni yoyamba ndi deta yomwe ili patsamba latsamba, monga momwe idafotokozedwera kale. Kenako timayika tulo mu gawo lachiwiri, ndikusankha khungu lopanda kanthu ndi danga, lomwe tidakambirana kale. Ulalo umawonekera pagawo la bokosi la mkangano. Kuti muchepetse ndondomekoyi, mutha kukopera mwakuwunikira ndikusindikiza kuphatikiza kiyi Ctrl + C.



3. Kenako timawonjezera ulalo wotsatira kuti uwonjezeredwe. M'munda wotsatira, onjezani ulalo wa khungu lopanda kanthu. Popeza tinatsitsa adilesi yake, titha kuyika tulo mu munda ndikusindikizira kuphatikiza kiyi Ctrl + V. Coordinates adzaikapo. Mwanjira imeneyi, timasinthana minda ndi ma adilesi a zinthuzo ndi khungu lopanda kanthu. Pambuyo polemba data yonse, dinani batani "Zabwino".

Monga mukuwonera, zitatha izi, kujambulidwa kophatikizidwa mu chipinda chandamale, kuphatikiza zomwe zili muzinthu zonse, koma ndi malo pakati pa liwu lililonse.

Yang'anani! Monga mukuwonera, njira yomwe ili pamwambapa imathandizira kwambiri njira yophatikiza deta moyenera m'maselo. Koma dziwani kuti njirayi ili ndi zovuta zambiri. Ndikofunikira kuti chinthu chomwe chili ndi danga, pakapita nthawi chidziwitso china chisawonekere kapena chosasunthidwa.

Njira 4: phatikizani mizati

Kugwiritsa ntchito POPANDA Mutha kuphatikiza mwachangu zosankha zingapo zingapo.

1. Ndi maselo a mzere woyamba wa mizati yolumikizidwa, timasankha zomwe zikuwonetsedwa mu njira yachiwiri ndi yachitatu yogwiritsira ntchito mfundo. Komabe, ngati mungaganize zogwiritsa ntchito njirayo ndi khungu lopanda kanthu, ndiye kuti cholumikizacho chikuyenera kupangidwa chotsimikizika. Kuti muchite izi, ikani chikwangwani cha dollar kutsogolo kwa chizindikiro chilichonse chopingasa ndi chopindika ($). Mwachilengedwe, ndibwino kuti muchite izi kumayambiriro, kuti kumadera ena komwe kuli adilesiyi, wogwiritsa ntchitoyo akhoza kuikopera monga yolumikizana ndi mayina. M'minda yotsalira, siyani zolumikizana. Monga nthawi zonse, pambuyo pa njirayi, dinani batani "Zabwino".



2. Timayika cholozera mu ngodya ya kumunsi kwa chinthucho ndi formula. Chithunzi chimawoneka chomwe chimawoneka ngati mtanda, womwe umatchedwa chizindikiro chodzaza. Gwirani batani lakumanzere ndikulikokera pansi molingana ndi komwe zinthuzo zimaphatikizidwira.



3. Mukamaliza njirayi, deta yomwe ili m'mizati yomwe yatchulidwa idzaphatikizidwa mu mzere umodzi.

Phunziro: Momwe mungaphatikizire mzati mu Excel

Njira 5: onjezerani owonjezera

Ntchito POPANDA itha kugwiritsidwanso ntchito kuwonjezera ena ndi mawu omwe sanali mgulu loyambilira. Komanso, mutha kukhazikitsa othandizira ena pogwiritsa ntchito ntchitoyi.

1. Timachitapo kanthu kuti tiwonjezere mfundo pazenera zotsatsira ntchito pogwiritsa ntchito njira zomwe tafotokozazi. Mu gawo limodzi (ngati kuli kofunikira, pakhoza kukhala angapo) onjezani zolemba zilizonse zomwe wogwiritsa ntchito akuwona kuti ndizofunikira kuwonjezera. Lembali liyenera kukhomedwa m'mawu olemba. Dinani batani "Zabwino".



2. Monga mukuwonera, izi zitatha, zolemba zidawonjezedwa pazosakanikirana.

Wogwiritsa ntchito POPANDA - Njira yokhayo yophatikiza maselo osataya mu Excel. Kuphatikiza apo, itha kugwiritsidwa ntchito kuphatikiza mizati yonse, kuwonjezera zolemba, komanso kuchita zina. Kudziwa za algorithm yogwira ntchito ndi ntchitoyi kungapangitse kuti kusavuta kuthana ndi mavuto ambiri kwa wogwiritsa ntchito pulogalamuyi.