Momwe mungasinthire zilembo kukhala manambala. Kodi mudayamba mwakopera manambala kuchokera pa fayilo ina kupita ku imzake ndipo mumakhala ndi vuto kuwerengera kapena kusokonezeka mwatsatanetsatane momwe pulogalamuyo imawagwirira molakwika ndikusintha ngati malembedwe, mutatha kulipira, m'malo mwa ziwerengero? Kodi mudagwirapo ntchito yomwe idafunikira kusintha zilembo kukhala nambala zamakina ndipo simukudziwa momwe mungapangire? Ndikukhulupirira kuti inde, popeza wafika pano ndipo ukuwerenganso izi momwe mungasinthire zilembo kukhala manambala Komabe, palibe vuto: kaya ndinu wophunzira, katswiri kapena wokonda zosavuta, tsopano ndikuwonetsani njira zopezera yankho lomwe liri losavuta kwa inu.
Ponena za Excell, ziwerengero zomwe zimakopedwa mu worksheet nthawi zina zimasungidwa m'maselo ngati kuti ndizolemba. Mtundu wavutoli nthawi zambiri umachitika poitanitsa deta kuchokera kumagwero akunja, mwina chifukwa idapangidwa mosiyanasiyana. Potere, manambala omwe adasungidwa monga malembawo amasunthidwa kumanzere osati kumanja, ndipo amawonetsedwa ndi chizindikiro cholakwika. Komabe, ndi vuto losavuta kuthana.
Ponena za mapulojekiti omwe amaphatikizapo chithandizo cha manambala a binary kapena kusindikiza kwa lembalo kusintha zilembo kukhala nambala, zothetsera zomwe zimapezekanso ndizambiri komanso zosavuta kugwiritsa ntchito. Tiyeni tonse tizimvera momwe tingachitire.
Momwe mungasinthire zilembo kukhala manambala mu Excel
Kodi mukuvutikira kukopera manambala kuchokera pa pepala limodzi kupita ku linzake pomwe manambala, pomwe amawalemba, kodi ali mumalemba? Ndifotokoza momwe mungathetsere vutoli m'njira zosiyanasiyana pogwiritsa ntchito Microsoft Excel. Ndi pulogalamu yotchuka yotambasulira yomwe imaphatikizidwa muofesi ya Office (komanso ikupezeka mu mtundu wamaimidwe m'masitolo a Windows ndi MacOS) komanso yogwirizana ndi Windows ndi MacOS.
Kutembenuka ndikulakwitsa
Njira yoyamba yothetsera vuto lomwe ndikulipangira idachokera kuyang'ana zolakwika kupezeka mwa kupambana, pakupezeka kwa mitundu desktop ntchito
Monga momwe mungazindikire kale, manambala omwe amasungidwa monga malembawo amawalumikiza kumanzere kwa maselo amunthu. Kenako sankhani foni kapena maselo omwe mukufuna kusintha, dinani chizindikirocho ndi chizindikiritso pafupi ndi chiwerengerocho, kenako ndikupeza zosankha zomwe zimapezeka, dinani Sinthani kukhala nambala.
Ngati izi sizikupezeka, sankhani khungu kapena khungu kuti lisinthe (kapena gawo lonse, ngati kuli kofunikira; chinthu chofunikira ndichakuti maselo onse omwe ali mgulu limodzilo), ndiye patsamba deta ili kumanja kumtunda, dinani batani Mawu m'mizere. Pazenera lomwe likuwoneka, dinani batani pomwepo. yomalizakotero ngati mugwiritsa ntchito mawindo kanikizani batani Ctrl pamodzi ndi batani 1.
Ngati, kumbali ina, gwiritsani ntchito a Mac, kanikizani batani lamulo pamodzi ndi batani 1. Kuchokera pawindo lomwe likuwoneka, lotchedwa Maselo amtundu, sankhani gulu kumanzere nambala, kenako lembani m'bokosi chapakati kuti ndi angati Malo abwino mukufuna kuwona ndipo pamapeto pake mu bokosi lili munsi mwa mawonekedwe a Manambala olakwika. Mukatsimikiza kuti mwasintha makonda omwe akuwonetsa manambala, dinani batani Bueno, pansi kumanja.
Njira ina yazomwe tafotokozazi kale (imagwiranso Excel pa intaneti ) ndikutsegula kuchokera ku khadi kunyumba chosankha chotsitsa chapakati ndikanikiza muvi kumanja kwa mawu ambiri, kenako sankhani njira yotsiriza Mitundu ina ya nambala. Kuchokera pazenera Mawonekedwe kuti mutsegule, sankhani gulu kumanzere nambalaKusintha nambala yamitundu yonse kumawonetsedwa monga mukufuna pa desktop. Pomaliza dinani Bueno, pansi kumanja, kusintha cell kapena maselo omwe amafunikira kuti akhale manambala.
Ngati mukugwiritsa ntchito Excel kudzera pulogalamuyi Android mwa ake foni yam'manja, dinani m'malo mwake muvi ili pansi kumanja (kuonetsetsa kuti mndandanda wazakumanzere wakonzedwa kunyumba ), kapena ngati ikugwira ntchito ngati piritsi, dinikizani tabu kunyumba kuyikidwa pamwamba. Kenako falitsani zosankhazi kufikira mutafika pagawo Mawonekedwekanikizani ndikukhudza nambala, ndikuwonetsa momwe mukufuna kuwonetsera manambala osasangalatsa.
Pogwiritsa ntchito pulogalamu ya Excel ku iOS kapena iPadOS, muyenera kupita ku gawolo kunyumba (kudzera pamenyu pansi pa iPhone kapena tabu pamwamba pa iPad), dinani batani ABC123 yomwe ili pansi pa batani vista ndipo kenako sankhani chiwerengero.
Kutembenuka kudzera pa "Mtengo" ntchito
Monga njira ina kuzomwe tidawonera m'mutu wapitawu, mutha kugwiritsa ntchito fomu yakunyumba ya Excel kuti musinthe zilembo kukhala nambala: ndi Ntchito yaphindu, chomwe chimabwezeretsa kuchuluka kwa zolemba zomwe zalembedwa. Njira yotsatirayi ndiyothandiza kwa onse awiri mitundu yamakompyuta zochuluka za Excel pa intaneti, pomwe imasiyanasiyana mu mafoni Baibulo.
Choyamba, ikani gawo limodzi latsopanolo ndi zilembo zomwe zilembozo zisinthidwe ndikudina batani lamanja la mbewa mu chizindikiritso kalata, kenako kusankha njira lowani kuchokera menyu yotsikira. Onetsetsani kuti simukupanga zatsopano zomwe mukufuna kutembenuza; ngati sichoncho.
M'kati mwa selo yatsopano, lembani mawuwo = VALUE () ndiyeno, kuyika cholozera cha mbewa pakati pamabulaketi awiriwo, dinani khungu lomwe lili ndi phindu lomwe mukufuna kusintha kukhala mtundu wa nambala (pamenepa, selo E3); mawonekedwe a selo akuyenera kuwonekera pakati pamabulaketi awiriwa. Pomaliza pezani Enter kuti phindu liwonekere pamitundu.
Tsopano sunthani chotengera cha mbewa kwa icho m'munsi ngodya kumanja ya khungu losinthidwa, mpaka litenga mawonekedwe a kuphatikiza chizindikiro (+) : Dinani ndi kukokera pansi, pogwiritsa ntchito batani lakumanzere.
Pakadali pano, mudzakhala mutapeza mzere wazikhalidwe zatsopano pamitundu; mutha kuzigwiritsa ntchito mwachindunji, kapena mutha kukopera ndikuziika mu gulu loyambirira pachifuniro chanu.
Ngati mukufuna kuwakopera iwo kumalire omwe mudayamba nawo, sankhani maselo mwangodzaza ndi ntchito ya Mtengo, Press Ctrl pamodzi ndi batani C ( lamulo pamodzi ndi batani c, ngati mukugwiritsa ntchito Mac), dinani pa foni yoyamba ya mzati woyambayo. Mu desktop desktop sankhani khadi kunyumba, pakona yakumanzere kumtundu, ndiye dinani muvi pafupi ndi batani Kuyika, sankhani chinthu chomaliza kuchokera pagulu lotsika Phala lapadera ndikusankha mundawo miyezo, pamwamba kumanzere, pamapeto pake mwa kuwonekera kuvomereza mtundu wa pa intaneti sankhani khadi kunyumba, kumanzere kumtunda, dinani muvi pansi pa batani Kuyika ndikusankha mwachindunji Matani mfundo.
Ngati mukugwiritsa ntchito Mtundu wa Android wa Excelikani gawo lina pafupi ndi maselo omwe ali ndi zilembozo. Kukhudza mzere womwe ulipo kupatula womwe ungasinthidwe, pitani pagawo Nyumba, kanikiza Ikani ndikuchotsandiye kukhudza lowetsani mizati
Tsopano dinani kawiri paselo yatsopano, lembani mawuwo pogwiritsa ntchito kiyibodi manambala = VALUE (), ikani chidziwitso pakati pa mabatani awiri apakati, ndikanikizani khungu ndi phindu lotembenuza ndikumaliza kukhudza batani ndi Mafunso zobiriwira pamwamba kumanja. Bwerezani zomwe zili pamwambazi payokha pafoni iliyonse yomwe mukufuna kusintha, mpaka mutapeza mtundu watsopano wamakhalidwe mu manambala.
Ngati mukufuna kuzijambula kuti ziziyenda, sankhani foni yoyamba yomwe mwatembenuza, ndiye ena onse pakukoka dontho lobiriwira pansi kumanja kwa khungu pafupi ndi khola lonse; kuchokera pamenyu yomwe idzatsegule, sankhani njira koperani (oyimiridwa ndi ma sheet awiri pambali ). Kenako dinani kawiri pafoni yoyamba, ndikusankha muvi wapansi pafupi ndi ndemanga zomwe zimatsegulidwa, kenako sankhani makhalidwe abwino.
Ngati ndinu ogwiritsa ntchito m'malo mwake IOS / iPad OS, Dinani mzere womwe ulipo kupatula womwe ungasinthidwe, kenako sankhani lowani. Dinani kawiri pa selo yoyamba ya gawo latsopano, lembani mawuwo ndi kiyibodi = VALUE (), ikani cholozera pakati pa mabatani awiri apakati, sankhani khungu kuti lisinthe ndikudina batani lobiriwira ndi chekeni ili pamwamba kumanja. Kuti mzere watsopano ukhale ndi mfundo zowerengera, muyenera kubwereza chilichonse mwanjira zomwe tafotokozazi.
Kukopera mfundo zatsopano mgulu loyambilira, dinani foni yoyamba yosinthidwa, kenako sankhani ena onse, ndikukoka dontho lobiriwira pansi kumanja kwa khungu monse. Kuchokera pamenyu omwe adzatsegule, sankhani njira koperani, kenako dinani cell yoyamba, sankhani Matani mwapadera ndipo pamapeto pake kusankha makhalidwe abwino.
Kutembenuka pogwiritsa ntchito "Ikani Zapadera" ndi "Kuchulukitsa" ntchito
Ngati simunathe kusintha zilembo kukhala manambala ku Excel ndi njira zomwe zili pamwambapa ndiye izi zitha kukhala zanu - ndizothandiza kwambiri makamaka pakusintha mizati yambiri nthawi imodzi.
Choyamba sankhani chimodzi khungu lopanda kanthu osatengera vuto la kutembenuka, mtundu batani 1 mkati ndikanikizani batani kupezeka. Mphoto Ctrl pamodzi ndi batani C ( lamulo ndi chifungulo c, ngati mugwiritsa ntchito Mac) kuti muzikopera, sankhani maselo omwe mukufuna kusintha kuchokera ku zilembo kupita ku manambala.
Mwa khadi kunyumba, pakona yakumanzere kumtundu, ndiye dinani muvi pafupi ndi batani Kuyikadinani pazomaliza Phala lapadera, kenako kuchokera pamenyu ntchito dinani pamunda Kuchulukitsa ndipo kenako kanikizani Bueno (pansi kumanja).
Pochita izi, mwalangiza Excel kuti ichulukitse foni iliyonse ndi 1, ndikusintha zilembozo kuti zizikhala manambala. Ngati mukufuna kusintha mawonekedwe ake, akanikizire Ctrl pamodzi ndi batani 1 ( lamulo pamodzi ndi batani 1, ngati mugwiritsa ntchito Mac) kuti mutsegule zenera Maselo amtundu, sankhani mtundu womwe mukufuna kuchokera pamenyu gulu lamanzere ndipo pamapeto pake dinani Bueno pansi kumanja.
Njira iyi ndiyoyenera kumasulira. desktop Excel; pa mitundu m'malo mwake pa Intaneti, Android e iOS, mutha kugwiritsa ntchito malangizo otsatirawa potengera maphunziro anga momwe mungachulukitsire mu Excel.
Momwe mungaletsere kufufuzira zolakwika
Ngati mukulowetsa nambala mu foni mutha kuona a makona atatu obiriwira chakumanzere kwa khungu lenilenilo, zimatanthawuza kuti kuyang'ana zolakwika ndikumagwira (magwiridwe antchito amangogwira mtundu wokha desktop Excel). Mutha kuyimitsa chiwonetserochi posankha mndandanda wazonse njira, kenako ndikudina batani Panali zovuta kutsimikizira, kenako pa batani zosankha, pansi kumanzere, ndipo pamapeto pake ndikuchotsa chekeni Manambala opangidwa ngati mawu.
Sinthani zilembo kukhala manambala a binary
Ngati mukuyang'ana m'malo Sinthani zilembo kukhala manambala a binary, pofuna kusangalatsa kapena kugwira ntchito, dziwani kuti pali zida zingapo zoyenera kuchita izi: tiyeni tipeze zina zosangalatsa kwambiri ndipo muwona kuti mupeza zomwe zili zoyenera kwa inu. Kaya mukugwira ntchito yodula poyendetsa IT kapena mukufuna kuphunzira zoyambira zamakina a binary, ndili ndi chitsimikizo kuti mudzakhutira.
Sinthani zilembo kukhala zonema (pa intaneti)
Kutembenuza mawu kukhala binary ndi ntchito yothandiza pa intaneti yomwe imalola kusintha kwa zilembo kukhala manambala a binary. Pogwiritsa ntchito ulalo womwe ndakupatsani, mufika patsamba lokonzekera kulandira zomwe mukufuna kusintha, kuti zilembedwe Lowetsani deta.
Choyamba onetsetsani kuti chida mutembenuzire, pakati pa tsamba, ili m'malo mwanjira kulembera manambala ndine (Monga momwe mungaganizire, kusankha kwa manambala ena a zilembo zamtundu wa mameseji kumatanthauza chimodzimodzi), kenako lembani pamanja kapena kukopera ndi kuyika zilembo zomwe mukufuna kusintha. Mudzazindikira mwachangu, m'munda pansipa. tulukani, zomwe mudalemba zidasinthidwa kukhala code ya binary.
Mtanthauzira wa Binary Code (Android)
Binary Code Translator ndi njira yosinthira yotumiza makalata kukhala manambala a binary omwe amapezeka ndi ogwiritsa ntchito Android Ngati mumagwiritsa ntchito foni kapena piritsi yanu pa ulalo womwe uli pamwambapa, mudzalumikizana nawo nthawi yomweyo Sungani Play, kuchokera pomwe mungathe kutsitsa pulogalamuyi ndikanikiza batani khazikitsa.
Kamodzi anaika pa chipangizo chanu, kukanikiza batani tsegulani Mudzakhala pamaso ndi omasulira kwa Binary Code Translator: yang'anani kuti muli m'gawoli Lembani mpaka pa binary (woyamba kumanzere) osati mu "Binary to text", chifukwa chake lembani kapena lembani kuti zilembedwe mwatsatanetsatane. Mukamaliza, dinani lamulolo encode Pamunsi kumanzere: Nthawi yomweyo mudzazindikira zolemba zomasuliridwa pansipa zomwe mudalemba pakalipano.
Pulogalamuyi ilinso ndi malamulo ena awiri ofunikira: koperani (mutha kuyipeza pafupi ndi Encode) imakupatsani mwayi wofanizira zomwe zamasuliridwa ku clipboard ndipo pamanja muiike m'mapulogalamu ena pafoni yanu, pomwe gawana (yomaliza kumanja) imakuthandizaninso kugawana nambala yanu ya binary mwachangu ndi mapulogalamu ena omwe adaika.
Lemba ku Binary (iOS / iPadOS)
Text To Binary ndi chida chabwino kwambiri chosinthira zilembo kukhala manambala a binary, koma odzipereka kokha kwa ogwiritsa ntchito omwe amakonda kugwiritsa ntchito iPhone kapena iPad. Kuti mugwiritse ntchito, dinani pa ulalo womwe ndangopereka, kenako dinani batani Pezani / Kukhazikitsa de A La Store App, onetsetsani kuti ndinu ndani kudzera Foni ya nkhope, Gwiritsani ID kapena chinsinsi cha Apple ID (ngati kuli kofunikira) ndipo pamapeto pake dinani batani tsegulani.
Chitha lemba nthawi yomweyo zomwe mumakonda mu bar yomwe ili pamwambapa, ngakhale zitakhala zofunikira potengera ndikulemba zolemba za pulogalamu ina yomwe ikugwiritsidwa ntchito. Mwina mwazindikira kuti pulogalamuyi imamasulira zomwe mumalemba munthawi yeniyeni, chifukwa chake simuyenera kuchita kuyika kapena kuchita zina - zosavuta, sichoncho?
Tsopano mutha kukopa mosavuta nambala yamabizinesi yomwe muli nayo, pogwiritsa ntchito lamulo Lembani ku clipboard ingoikani pansipa mawu omasuliridwa. Mudzakhala ndi chitsimikizo kuti mwazikopera molondola ngati ziwonetsero zikupezeka ndi uthenga wolembedwa Anakopera bwino pa bolodi.