Kuwerenga maselo anu

Kwa ogwiritsa ntchito Microsoft Excel, palibe chinsinsi chakuti zomwe zalembedwa mu processor iyi imayikidwa m'maselo osiyana. Pofuna kuti wogwiritsa ntchito kutchula izi, adilesiyi imaperekedwa kwa pepala lililonse. Tiyeni tiwone zinthu zomwe zikhalidwe zawerengedwa zowonjezera ndipo ndizotheka kusintha izi.

Mitundu yowerengera mu Microsoft Excel

Choyamba, ziyenera kunenedwa kuti pali mwayi wosintha pakati pa mitundu iwiri yowerengera. Adilesi yazinthu zomwe zimagwiritsidwa ntchito posiyana, zomwe zimakhazikitsidwa mwachisawawa, zimakhala ndi mawonekedwe A1. Mtundu wachiwiri ukuimiridwa ndi mawonekedwe otsatirawa - R1C1. Kugwiritsa ntchito pamafunika kusintha makonda. Kuphatikiza apo, wogwiritsa ntchito amatha kutsanulira maselo amagwiritsa ntchito njira zingapo nthawi imodzi. Tiyeni tiwone izi zonse.

Njira 1: Kusinthanitsa njira

Choyamba, tiyeni tikambirane kusinthanitsa. Monga tanena kale, adilesi ya maselo osasinthika imakhazikitsidwa ndi mtundu A1. Ndiye kuti, mizati imawonetsedwa ndi zilembo za zilembo za Chilatini, ndipo mizere ndi manambala achiarabu. Kusintha kwa R1C1 kumapangitsa kuti manambala azikhala ogwirizana ndi zingwe zokha, komanso zigawo. Tiyeni tiwone momwe mungasinthire.

1. Timasunthira ku "fayilo" tabu.



2. Pazenera lomwe limatseguka kudzera pamenyu ya kumanzere, pitani ku "magawo".



3. Khomo lazowonjezera lambiri limatseguka. Kudutsa mndandandawo, womwe umayikidwa kumanzere, pitani ku forpu.



4. Kusintha, samalani ndi mbali yakumanja ya zenera. Tikuyang'ana gulu la makonda "ntchito ndi njira". Pafupi ndi "Tsimikizanani R1C1" gawo la "Ikani bokosilo. Pambuyo pake, mutha kukanikiza batani la "OK" pansi pazenera.



5. Pambuyo pa kutha kwa pamwamba pa zenera la pazenera, kalembedwe kamene kamasinthira ku R1C1. Tsopano osati mizere yokha, komanso mizati yomwe idzawerengedwa ndi manambala.

Kuti mubwezeretse dzina losintha, muyenera kugwiritsa ntchito njira yomweyo, nthawi ino mumachepetsa bokosi lolemba la R1C1.

Phunziro: Chifukwa Chiyani Kupambana M'malo Makalata Ophunzira

Njira 2: Dzazani Chizindikiro

Kuphatikiza apo, wogwiritsa ntchito yekhayo angawerenge zingwe kapena mizati yomwe maselo amapezeka, malinga ndi zosowa zawo. Ogwiritsa ntchitoyu amatha kugwiritsidwa ntchito popanga mizere kapena mizere ya tebulo, kusamutsa mzerewo ndi ntchito zophatikizika ndi ntchito zina komanso zina. Zachidziwikire, kuchuluka komwe kumatha kuchitika pamanja, kumangoyendetsedwa ndi manambala omwe akufuna kuchokera pa kiyibodi, koma ndizosavuta komanso mwachangu kuchita njirayi pogwiritsa ntchito zida za Autofil. Izi ndizowona makamaka kuti kuchuluka kwa malo ambiri.

Timayang'ana momwe timagwiritsira ntchito chikhomo chomwe mungakwaniritse zodziyimira pawokha.

1. Timayika chiwerengero "1" m'chipindacho chomwe timakonzekera kuyambitsa manambala. Kenako timanyamula cholozera kumanzere kwa chinthucho. Nthawi yomweyo, ayenera kusintha pamtanda wakuda. Amatchedwa chikhomo chodzaza. Tsekani batani lamanzere la mbewa ndikutengako koterera kapena kumanja, kutengera zomwe zikufunika kuti ziwerengeredwe: mizere kapena minda.



2. Pambuyo pa foni yotsiriza, yomwe iyenera kuwerengedwa, ikani batani la mbewa. Koma, monga tikuwona, zinthu zonse ndi zokutira zimadzazidwa ndi mayunitsi okha. Kuti mukonze, kanikizani chithunzi chomwe chili kumapeto kwa magawo omwe awerengedwa. Yesani kusintha pafupi ndi "Dzazani".



3. Pambuyo pochita izi, onse amakhala owerengeredwa.

Njira 3: Kupitilira

Njira ina, yomwe mungawerengere bwino zinthu, ndikugwiritsa ntchito chida chotchedwa "Kukula".

1. Monga mwa njira yapitayi, khazikitsani nambala ya "1" kwa maselo oyamba kuti awerenge. Pambuyo pake, ingosankha gawo ili podina pa iyo ndi batani lakumanzere.



2. Pambuyo pamtundu womwe mukufuna ndikuwunikira, pitani ku "kunyumba". Dinani batani "Dzazani", kuyikidwa pa tepi mu gawo losintha. Mndandanda wazomwe amatsegula. Timasankha kuchokera pamenepo "Kupita patsogolo ...".



3. Windowl zenera limatchedwa "Kukula". Pazenera ili, makonda ambiri. Choyamba, tikambirana za "malo". Mmenemo, thisitsa kuli ndi maudindo awiri: "Ndi mizere" ndi "pamitundu". Ngati mukufuna kupanga chiwerengero chokhazikika, ndiye kuti musankhe njira "ndi zingwe" ngati osimba ndi "pamamimba".

   Mu "mtundu wa" zoikamo, kuti mupeze zolinga zathu, muyenera kuyika kusintha kwa "arithmen". Komabe, iye, ndipo motero mosasunthika amakhala pamalo oterewa, chifukwa chake muyenera kuyang'ana malo ake.

   Makonda a "gawo" amakangalika pokhapokha posankha "tsiku". Popeza tinasankha mtunduwu kuti "masamu", sitidzakhala ndi chidwi ndi chipika pamwambapa.

   Mu "gawo" la "Khazikitsani chiwerengerocho" 1 ". Mu "malire mtengo", timakhazikitsa chiwerengero cha zinthu zowerengedwa.

   Mukamaliza zomwe zalembedwazo, timadina batani la "Ok" pansi pazenera lomwe limadutsa.



4. Monga tikuonera, mitundu ya masamba mu "rosegript" idzawerengedwa mu dongosolo.

Ngati simukufuna kuwerengera nambala ya mapepala omwe amafunika kuwerengedwa kuti afotokozere mundawo " zenera.

Pambuyo pake, mu "Prosegramkhunt" Timachita zinthu zonse zomwe tafotokozazi, koma nthawi ino tichoka kumunda "wopanda phindu.

Zotsatira zake zidzakhala chimodzimodzi: Zinthu zosankhidwa zidzawerengedwa.

Phunziro: Momwe Mungapangire Autocomlete

Njira 4: Kugwiritsa Ntchito Ntchito

Zinthu za manambala, mutha kugwiritsanso ntchito ntchito zophatikizika. Mwachitsanzo, wogwiritsa ntchito chingwe akhoza kugwiritsidwa ntchito polemba mzere.

Chingwe chogwirira ntchito chimanena za "zolemba ndi zojambulazo. Ntchito yake yayikulu ndikubwezera chipinda chambiri kuti ulalo udzayikidwe. Ndiye kuti, ngati tikunena za ntchitoyi Selo iliyonse mu mzere woyamba wa pepalalo, lidzatulutsa mtengo wake "1" m'selo, komwe kuli. Ngati mungafotokozere ulalo wa mzere wachiwiri, wothandizirayo aziwonetsa nambala "2", etc.

Chingwe cha Syntax Chotsatira:

= Chingwe (cholumikizira)

Monga tikuwona, mkangano yekha wa chinthuchi ndi cholumikizira ku khungu, chiwerengero cha mzere womwe uyenera kuwonetsedwa mu chinthu chotchulidwa.

Tiyeni tiwone momwe tingagwiritsire ntchito ndi wothandizira yemwe watchulidwa.

1. Sankhani chinthu chomwe chingakhale choyambirira mumitundu. Dinani pa "ikani ntchito", yomwe ili pamwamba pa pepala la Excel.



2. Ntchito zomwe Mbuye amayamba. Timasinthanitsa ndi maulalo a gulu la "ma arrays". Kuchokera ku mayina omwe ogwiritsa ntchito, sankhani dzina "mzere". Pambuyo popereka dzinali, dongo pa batani la "Ok".



3. Imayendetsa chingwe cha chingwe cholinganiza. Ili ndi gawo limodzi lokha, ndi kuchuluka kwa zotsutsana kwambiri. Mu gawo lolumikizana, tifunika kulowa adilesi ya khungu lililonse, lomwe limapezeka mu mzere woyamba wa pepalalo. Zogwirizanitsa zitha kuyikidwa pamanja powathamangitsa kudzera pa kiyibodi. Koma ndizovutanso kuchita izi, ndikungokhazikitsa cholozera m'munda, kenako ndikutseka batani lamanzere pazinthu zilizonse mu gawo loyambalo. Adilesi yake idzawonetsedwa nthawi yomweyo pawindo la chingwe. Kenako dinani batani la "OK".



4. Mu cell ya pepala pomwe chingwe chogwiritsira ntchito chimapezeka, chiwerengerocho "1" chinawonetsedwa.



5. Tsopano tikufunika kuwerengetsa mizere yonse. Pofuna kuti musapange njira yogwiritsa ntchito zinthu zonse zinthu zonse, zomwe zimatenga nthawi yayitali, zimapangitsa kuti mtunduwu uzidziwika bwino. Timanyamula cholozera m'mphepete mwa ma cell omwe ali ndi formula ya chingwecho ndipo pambuyo poti chizindikiro chodzaza chikuwoneka, chotsani batani lakumanzere. Timatambasula cholembera pamavuto omwe amafunikira kuwerengedwa.



6. Monga tikuwona, atatha kuchita izi, mizere yonse yamitundu yomwe yatchulidwa idzawerengedwa ndi ogwiritsa ntchito.

Koma tidangopanga mizere yokha, ndipo chifukwa cha ntchito yogawa uthenga wa selo mu mawonekedwe a nambala, zigawo ziyenera kuwerengedwa. Itha kuchitikanso pogwiritsa ntchito ntchito yophatikizidwa. Wogwiritsa ntchitoyu akuyembekezeka kukhala ndi dzina "mzati".

Ntchito yolumikizananso imanenanso za gulu la ogwiritsa ntchito "maulalo ndi aris". Monga ndizosavuta kulosera ntchito yake ndikuchotsa chinthu cholumikizira ku chinthu chomwe chatchulidwa, pomwe ulalo umaperekedwa. Syntax ya izi imakhala pafupifupi yofanana ndi yogwiritsa ntchito kale:

= Mzere (ulalo)

Monga tikuwona, dzina la wogwiritsa ntchito yekhayo limasiyana, ndipo mkanganowo, monga nthawi yotsiriza, imakhalabe ndi gawo lina la pepalalo.

Tiyeni tiwone momwe tingagwiritsire ntchito ntchitoyi ndi chida ichi.

1. Sankhani chinthu chomwe gawo loyambalo lidzafanana. Dongo pa "inter Apple".



2. Kuyika mbuye wa ntchito, kusunthira kumalumikizidwe "ndi arrays" ndipo amagawa dzina "Lamulo". Clay pa batani la "Ok".



3. Zenera lotsutsana ndi zenera limayamba. Monga kale, tinayika cholembera mu gawo lolumikizana. Koma pankhaniyi, timagawa chilichonse osati mzere woyamba wa pepalalo, koma mzere woyamba. Amagwirira ntchito nthawi yomweyo m'munda. Kenako mutha kutsatira batani la "OK".



4. Pambuyo pake, nambalayo "1" idzawonetsedwa m'ndende yotsimikizika, yolingana ndi nambala ya nambala ya tebulo, yomwe imafotokozedwa ndi wogwiritsa ntchito. Powerengera mizati yotsala, komanso pakakhala mizere, timayika chikhomo chodzaza. Timabweretsa cholozera m'mphepete mwa mtunda wa foni yomwe ili ndi cholembera. Tikudikirira kuwonekera kwa chikhomo chodzaza ndipo, pogwira batani lakumanzere, cholozerachi ndi cholondola kwa zinthu zomwe mukufuna.

Tsopano maselo onse a tebuloni athu ali ndi zomwe ali ndi omwe akuwerengetsa. Mwachitsanzo, chinthu chomwe chiwerengero pansipa "chakhazikitsidwa nambala 5, chimagwirizana ndi chizolowezi (3; 3), ngakhale adilesi yake yonse mu gawo la pepalali limakhalabe E9.

Phunziro: Master of Actions mu Microsoft Excel

Njira 5: Kupatsa dzina la cell

Kuphatikiza pa njira zomwe tafotokozazi pamwambapa, ziyenera kudziwitsidwa kuti, ngakhale kuti ntchito ndi mizere yazigawo zina, ma cell a cell mkati mwake idzakhazikitsidwa molingana ndi pepala lonse. Izi zitha kuwoneka m'munda wapadera posankha chinthu.

Kuti musinthe dzinalo logwirizana ndi zomwe takambiranazo kwa omwe timakhazikitsa mothandizidwa ndi zikuluzikulu za mndandanda wathu, zikukwanira kuwunikira chinthu choyenera ndi mbewa yakumanzere. Kenako kungochokera ku kiyibodi mu gawo la dzina, mutha kuyendetsa dzina kuti wosuta amawona kuti ndi zofunika. Ikhoza kukhala mawu aliwonse. Koma kwa ife, timangoyambitsa achibale amagwirizana ndi chinthu ichi. M'dzina lathu, timatsimikizira nambala ya mzere ndi zilembo "Tsamba", ndi nambala "tebulo". Talandira dzina la mtundu wotsatirawu: "GLAY3". Yendetsani mu dzina la dzina ndikudina batani la Enter.

Tsopano selo lathu lapatsidwa dzinalo malinga ndi adilesi yake yogwirizana. Momwemonso, mutha kupereka maina ndi zinthu zina za mndandanda.

Phunziro: Momwe Mungapangire dzina lam'manja ku Excel

Monga mukuwonera, pali mitundu iwiri ya zomwe zimamangidwa mu zochuluka: A1 (osasinthika) ndi R1C1 (yothandizidwa ndi makonda). Mitundu iyi yoyankhulirana imagwira ntchito pa pepala lonse lonse. Koma kuwonjezera apo, wogwiritsa ntchito aliyense amatha kupanga wosuta kuti aziwerengera patebulo kapena mtundu wina. Pali njira zingapo zomwe zimatsimikiziridwa ndi manambala a ogwiritsa ntchito: pogwiritsa ntchito cholembera, "kulowerera" chida ndi chida chophatikizika. Pambuyo kukhazikitsidwa, mutha kupatsa dzina la pepala linalo.