Zokambirana zachitsulo cha Microsoft Excel

Mukamagwira ntchito ndi matebulo, nthawi zina muyenera kusintha maonekedwe awo. Chinthu chimodzi mwa njira izi ndizowunikira. Pankhaniyi, zinthu zophatikizidwa zimasinthidwa kukhala mzere umodzi. Kuwonjezera apo, pali kuthekera kogawa magawo oyandikana ndi zingwe. Tiyeni tipeze kuti ndi njira ziti zomwe zingatheke kupanga maubwenzi ofanana mu Microsoft Excel.

Onaninso:
Momwe mungagwirizanitse zipilala mu Excel
Momwe mungagwirizanitse maselo mu Excel

Mitundu yogwirizana

Monga tafotokozera pamwambapa, pali mitundu iwiri ikuluikulu ya chingwe - pamene mizere ingapo imasandulika imodzi ndipo ikagawidwa. Pachiyambi choyamba, ngati chingwecho chidzadza ndi deta, ndiye onse atayika, kupatula awo omwe anali pamutu wapamwamba. Pachifukwa chachiwiri, mizere ikhalebe momwemo, imangowonongeka kukhala magulu, zinthu zomwe zingabisike podalira chizindikiro ngati chizindikiro "sungani". Palinso njira ina yothandizira popanda kuperewera kwa deta pogwiritsira ntchito ndondomeko, yomwe tidzakulongosola mosiyana. Ndicho chifukwa cha mitundu iyi ya kusintha komwe njira zosiyanasiyana zowumikizira mizere zimapangidwira. Tiyeni tipitirizebe kuwona iwo mwatsatanetsatane.

Njira 1: gwirizanitsani kudzera pazenera lopangidwira

Choyamba, tiyeni tione momwe tingagwiritsire ntchito mizere pa pepala kudzera muzenera zowonetsera. Koma musanayambe kutsogolo kwachindunji, muyenera kusankha mizere yomwe mukukonzekera kuti mugwirizanitse.

1. Pofuna kufotokozera mizere yomwe iyenera kuphatikizidwa, mungagwiritse ntchito njira ziwiri. Choyamba mwa izi ndikuti muzitsulola batani lakumanzere la mchenga ndikukoka kudera la magawo omwewo pazowonongeka zomwe mukufuna kuziphatikiza. Adzafotokozedwa.

   

   Komanso, chirichonse chomwe chili pazowonongeka chimodzimodzi chingasindikizidwe ndi batani lamanzere la nambala pa chiwerengero cha mzere woyamba kuti ukhale nawo. Kenaka dinani pamzere womaliza, koma panthawi yomweyi mutsegule fungulo Shift pabokosi. Izi zidzakambilana zonsezi pakati pa magulu awiriwa.



2. Pokhapokha ngati mukufuna kusankhapo, mungathe kuchita chimodzimodzi kuti mugwirizane. Kuti muchite izi, dinani kumene kulikonse muchisankho. Mndandanda wamakono umatsegulidwa. Pitani pa icho pa chinthucho "Sezani maselo".



3. Imayambitsa mawonekedwe awindo. Pitani ku tabu "Kugwirizana". Ndiye mu gulu la zoyimira "Onetsani" onani bokosi "Kugwirizanitsa Magulu". Pambuyo pake, mukhoza kudina pa batani "Chabwino" pansi pazenera.



4. Potsatira izi, mizere yosankhidwa idzaphatikizidwa. Komanso, maselo angagwirizane mpaka kumapeto kwa pepala.

Palinso njira zina zomwe mungasinthire kuti mutsegule pazenera. Mwachitsanzo, mutasankha mizere, pokhala pa tab "Kunyumba", mukhoza kudina pazithunzi "Format"yomwe ili pa tepiyi muzitsulo "Maselo". Kuchokera pamndandanda wa zochitika zosankhidwa, sankhani chinthucho "Sungani maselo ...".

Ndiponso, mu tabu lomwelo "Kunyumba" Mukhoza kudula pavivi la oblique, lomwe liri paketi ku kondomu ya kumanja kwa bokosilo. "Kugwirizana". Ndipo pakadali pano, kusintha kumeneku kudzapangidwe mwachindunji ku tab "Kugwirizana" mawindo apangidwe, ndiko kuti, wosuta sayenera kusintha kwina pakati pa ma tabo.

Mukhozanso kupita kuzenera zowonongeka mwa kukakamiza kuphatikiza. Ctrl + 1mutasankha zinthu zofunika. Koma panopa, kusinthaku kudzachitika pazenera lazenera "Sezani maselo"yomwe idapitsidwanso nthawi yotsiriza.

Mulimonse kusiyana kwa kusintha kwawindo lazithunzi, zochitika zonse zogwirizanitsa mizere ziyenera kuchitidwa molingana ndi ndondomeko yomwe ili pamwambapa.

Njira 2: Gwiritsani ntchito zipangizo pa tepi

Mukhozanso kuphatikiza mizere pogwiritsa ntchito batani pa ndodo.

1. Choyamba, timasankha mzere wofunikira ndi imodzi mwa zosankha zomwe takambirana Njira 1. Kenaka pita ku tabu "Kunyumba" ndipo dinani pa batani pamzere "Gwirizanitsani ndikuyika pakati". Icho chiri mu zida za zipangizo. "Kugwirizana".



2. Pambuyo pake, mizere yambiri yosankhidwa idzaphatikizidwa kumapeto kwa pepala. Pankhaniyi, zolemba zonse zomwe zidzapangidwe mu mzerewu pamodzi zidzapezeka pakati.

Koma osati nthawi zonse zimafunika kuti lemba liyike pakati. Kodi mungatani ngati mukufuna kuikidwa mu fomu yoyenera?

1. Sankhani mzere wa mizere kuti uyanjane. Pitani ku tabu "Kunyumba". Dinani pa riboni pa katatu, komwe kuli kumanja kwa batani "Gwirizanitsani ndikuyika pakati". Mndandanda wa zochitika zosiyanasiyana zimatsegulidwa. Sankhani dzina "Gwirizanitsani maselo".



2. Pambuyo pake, mizere idzaphatikizidwira kukhala imodzi, ndipo malemba kapena mawerengedwe amtundu adzayikidwa ngati ali ndi chiwerengero chawo chosasintha.

Njira 3: tumikizani zingwe mkati mwa tebulo

Koma sikuti nthawi zonse amafunika kuti aphatikize mizere mpaka kumapeto kwa pepala. Nthawi zambiri kugwirizanitsa kumapangidwa mkati mwa tebulo lapadera. Tiyeni tione momwe tingachitire izi.

1. Sankhani maselo onse m'mizere ya tebulo yomwe tikufuna kuphatikiza. Izi zingachitenso mwa njira ziwiri. Yoyamba mwa izi ndikuti mumagwiritsa ntchito batani lamanzere ndikukankhira malo onse kuti muwonetsedwe ndi ndondomeko.

   

   Njira yachiwiri idzakhala yothandiza kwambiri pakuphatikiza deta yambiri mu mzere umodzi. Dinani mwamsanga pa selo lakumtunda lakumanzere lazitali kuti muphatikizidwe, ndiyeno, mutagwira batani Shift - pansi kumanja. Mungathe kuchita zosiyana: dinani pamwamba kumanja ndi kumunsi selo lakumanzere. Zotsatira zake zidzakhala chimodzimodzi.



2. Pambuyo kusankha, tipitiliza kugwiritsa ntchito njira zomwe tazifotokoza Njira 1, muwindo la mawonekedwe a selo. M'menemo timachita zofanana zomwe takambirana pamwambapa. Pambuyo pake, mizere mkati mwa tebulo idzaphatikizidwa. Pachifukwa ichi, deta yokha yomwe ili kumtunda wakumanzere wa selo ya gulu lophatikizidwa idzasungidwa.

Kulowa mkati mwa tebulo kungathenso kuchitidwa pogwiritsira ntchito zipangizo pa riboni.

1. Timasankha mizere yofunikira pa tebulo ndi njira iliyonse yomwe idafotokozedwa pamwambapa. Ndiye mu tab "Kunyumba" dinani pa batani "Gwirizanitsani ndikuyika pakati".

   

   Kapena dinani pa katatu kumanzere kwa batani iyi, kenako dinani pa chinthucho "Gwirizanitsani maselo" menyu yowonjezera.



2. Chigwirizano chidzapangidwa mogwirizana ndi mtundu umene wosankha wasankha.

Njira 4: Kuphatikiza Chidziwitso Chokhazikika Popanda Kutaya Chidziwitso

Njira zonsezi zogwirizanitsa zikutanthauza kuti mutatha kukonza, deta yonse muzomwe ziphatikizidwa zidzawonongedwa, kupatulapo zomwe ziri mu selo lakumanzere lakumanzere laderalo. Koma nthawi zina mumasowa zopanda malire kuphatikiza mfundo zina zomwe zili pamzere wosiyanasiyana pa tebulo. Izi zikhoza kuchitika pogwiritsa ntchito ntchito yapadera yokonzedweratu. Kuti mutenge.

Ntchito Kuti mutenge ndi a gulu la olemba mauthenga. Ntchito yake ndi kugwirizanitsa malemba ambiri kukhala chinthu chimodzi. Chidule cha ntchitoyi ndi ichi:

= CLUTCH (malemba1; text2; ...)

Gulu Lotsutsana "Malembo" Zingakhale zolemba zosiyana kapena zogwirizana ndi zinthu za pepala kumene zimapezeka. Ndilo chinthu chotsiriza chomwe chidzagwiritsidwe ntchito ndi ife kukwaniritsa ntchitoyi. Mpaka 255 zifukwa zoterezi zingagwiritsidwe ntchito.

Kotero, tiri ndi tebulo yomwe imatchula zipangizo zamakinala ndi mtengo wake. Ntchito yathu ndi kugwirizanitsa zonse zomwe zili m'ndandanda "Chipangizo", mu mzere umodzi wopanda malire.

1. Ikani cholozera pamakalata omwe pamapeto pake zotsatirazi ziwonetsedwe, ndipo dinani pa batani "Ikani ntchito".



2. Kuyamba kumapezeka Oyang'anira ntchito. Tiyenera kusunthira ku malo ogwira ntchito. "Malembo". Kenako, fufuzani ndi kusankha dzina "CLICK". Kenaka dinani pa batani. "Chabwino".



3. Ntchito yotsutsana zenera ikuwonekera. Kuti mutenge. Mwa chiwerengero cha zifukwa, mukhoza kugwiritsa ntchito minda yokwana 255 ndi dzina "Malembo", koma kuti tikwaniritse ntchitoyi, tikufunikira mizere yambiri monga momwe tebulo lirili. Pankhani iyi, pali 6 mwa iwo. Timayika malonda mmunda "Text1" ndipo, titagwiritsa ntchito batani lamanzere, timakani pa gawo loyambirira lomwe lili ndi dzina la njirayi m'kalembedwe "Chipangizo". Pambuyo pake, adiresi ya chinthu chosankhidwa idzawonetsedwa m'munda wawindo. Mofananamo, ife tikuwonjezera maadiresi a mndandanda wazotsatira mndandanda. "Chipangizo"mofanana pamunda "Text2", "Text3", "Text4", "Text5" ndi "Mawu". Ndiye, pamene maadiresi a zinthu zonse akuwonetsedwa m'minda yawindo, dinani pa batani "Chabwino".



4. Pambuyo pake, ntchito yonse ya deta idzawonetsedwa mu mzere umodzi. Koma, monga tikuonera, palibe malo pakati pa mayina osiyanasiyana, koma izi sizikugwirizana ndi ife. Pofuna kuthetsa vutoli, sankhani mzere wokhala ndi ndondomekoyi, ndipo pewani batani "Ikani ntchito".



5. Fesholo yotsutsana imayambiranso nthawi ino popanda kuyamba Mlaliki Wachipangizo. M'munda uliwonse wawindo lotseguka, kupatula limodzi lomaliza, pambuyo pa adilesi ya selo ife tikuwonjezera mawu awa:

   &" "

   Mawu awa ndi mtundu wa malo apadera pa ntchitoyi. Kuti mutenge. Ndicho chifukwa chake simukufunikira kuwonjezera pa munda wachisanu ndi chimodzi. Ndondomekoyi ikatha, dinani pa batani. "Chabwino".



6. Pambuyo pake, monga tikuonera, deta yonse siyiyikidwa pa mzere umodzi, koma imasiyananso ndi danga.

Palinso njira ina yopangira ndondomeko yolumikizira deta kuchokera mitsinje ingapo mpaka imodzi yopanda malire. Simukusowa kugwiritsa ntchito ntchitoyi, koma mungathe kupeza njirayi.

1. Timayika chizindikiro "=" kumalo kumene zotsatira zidzasonyezedwe. Dinani pa chinthu choyamba m'ndandanda. Pambuyo pa adiresi yake ikupezeka mu barra yotsatira komanso mu selo yotulutsa zotsatira, yesani mawu otsatirawa pa kibokosilo:

   &" "&

   Pambuyo pake, dinani pa chigawo chachiwiri cha mzerewo ndikulowetsani mawuwa pamwambapa. Motero, timagwiritsa ntchito maselo onse omwe deta iyenera kuikidwa mumzere umodzi. Kwa ife, ife timapeza mawu awa:

   = "A4 &" "& A5 &" "& A6 &" "& A7 &" "& A8 &" "& A9



2. Kuti muwonetse zotsatira pamsankhulidwe dinani pa batani. Lowani. Monga momwe mukuonera, ngakhale kuti mu njira iyi njira ina idagwiritsidwira ntchito, mtengo wotsiriza umawonetsedwa mofanana ndi pamene ntchitoyi ikugwiritsidwa ntchito Kuti mutenge.

Phunziro: NTCHITO YOTCHITSA ku Excel

Njira 5: Kugawa

Kuphatikizanso, mungathe kugawa mizere popanda kutaya chikhulupiliro chawo. Tiyeni tiwone momwe tingachitire izo.

1. Choyamba, sankhani zinthu zomwe zili pafupi ndi chingwe zomwe ziyenera kugawidwa. Mukhoza kusankha maselo payekha, osati mzere wonse. Pambuyo pake kusamukira ku tabu "Deta". Dinani pa batani "Gulu"yomwe ili mu chida chogwiritsa ntchito "Chikhalidwe". Pogwiritsa ntchito mndandanda wa zinthu ziwiri, sankhani malo. "Gulu ...".



2. Pambuyo pake, mawindo aang'ono angatsegulidwe kumene muyenera kusankha chomwe tifunikira gulu: mizere kapena zipilala. Popeza tikufunika kukhazikitsa mizere, timasuntha njira yoyenera ndikusindikiza batani "Chabwino".



3. Pambuyo pachitsiriza chomaliza, mizere yosankhidwa pafupi idzagwirizanitsidwa ndi gululo. Kuti mubisala, dinani pazithunzi ngati chizindikiro "sungani"ili kumanzere kwa gulu loyang'anizana.



4. Kuti muwonetsenso zinthu zonsezi, muyenera kutsegula chizindikiro "+" inakhazikitsidwa pamalo amodzi kumene chizindikiro chinali poyamba "-".

PHUNZIRO: Momwe mungapangire gulu mu Excel

Monga mukuonera, njira yowunjikira mizere imodzi imadalira mtundu womwe umasankha wogwiritsa ntchito, ndi zomwe akufuna kuti apite kumapeto. Mungathe kuphatikiza mizere kumapeto kwa pepala, mkati mwa tebulo, pangani ndondomeko popanda kutaya deta pogwiritsa ntchito ntchito kapena ndondomeko, komanso pangani mizere. Kuwonjezera pamenepo, pali zosiyana za ntchitozi, koma zokhazokha zogwiritsira ntchito mwazinthu zokha zimakhudza kale zosankha zawo.