Mfundo za Kuwerengera Zam'manja mu Microsoft Excel

Kwa ogwiritsa ntchito Microsoft Excel, sichinsinsi kuti chidziwitso chomwe chili mu purosesa iyi timayikidwa m'maselo osiyana. Kuti wosuta azitha kupeza izi, gawo lililonse la pepalali limapatsidwa adilesi. Tiyeni tiwone mfundo yomwe zinthu za mu Excel zidawerengeredwa ndikuti manambala amatha kusintha.

Mitundu Yowerengera mu Microsoft Excel

Choyamba, ziyenera kunenedwa kuti ku Excel pali mwayi wosintha pakati pa mitundu iwiri ya manambala. Adilesi ya zinthuzo mukamagwiritsa ntchito njira yoyamba, yomwe imayikidwa mwachisawawa, ili ndi mawonekedwe A1. Njira yachiwiri ikufotokozedwa motere - R1C1. Kuti mugwiritse ntchito, muyenera kusintha pazokonda. Kuphatikiza apo, wogwiritsa ntchito amatha kuwerengera maselowo, pogwiritsa ntchito njira zingapo nthawi imodzi. Tiyeni tiwone mbali zonsezi mwatsatanetsatane.

Njira 1: sinthani mawonekedwe

Choyamba, tiyeni tiwone mwayi wosintha manambala. Monga tanena kale, adilesi yoyenera ya maselo imakhazikitsidwa ndi mtundu A1. Ndiye kuti, mzati umawonetsedwa ndi zilembo za Chilatini, ndipo mizereyo ikutchulidwa manambala achiarabu. Sinthani ku mtundu R1C1 akuwonetsa njira yomwe manambala sanakhazikitsidwe osati mizere yolumikizana, komanso mizati. Tiyeni tiwone momwe angasinthire.

1. Pitani ku tabu Fayilo.



2. Pazenera lomwe limatseguka, kudzera pamanzere ofukula kumanzere, pitani pagawo "Zosankha".



3. Tsamba la zosankha za Excel limatseguka. Kupyola menyu, yomwe ili kumanzere, pitani kumunsi Mawonekedwe.



4. Pambuyo pa kusinthaku, yang'anani kumanja kwa zenera. Tikuyang'ana gulu lazokonda pamenepo "Kugwira ntchito ndi ma formula". Pafupifupi paramu "R1C1 Lumikizano Waumwini" ikani chizindikiro. Pambuyo pake, mutha kukanikiza batani "Zabwino" pansi pazenera.



5. Pambuyo pamanambala pamwambapa pazenera, njira yolumikizira idzasinthira R1C1. Tsopano, osati mizere yokha, komanso mzati udzawerengedwa.

Kuti mubwezeretse kusankhidwa kwanu koyenera, muyenera kuchita zomwezo, pokhapokha ngati simukutsata bokosi "R1C1 Lumikizano Waumwini".

Phunziro: Chifukwa chiyani mu Excel m'malo mwa zilembo, manambala

Njira 2: lembani chikhomo

Kuphatikiza apo, wogwiritsa ntchitoyo amatha kuwerengera mizere yomwe maselo amapezeka, malinga ndi zosowa zake. Kuwerengera kwamtunduwu kungagwiritsidwe ntchito kuwonetsa mizere kapena mizati ya tebulo, kudutsa nambala mzere ku ntchito za Excel zopangidwa, ndi zina. Zachidziwikire, kuwerengera kumatha kuchitika pamanja, kungoyendetsa manambala ofunikira ku kiyibodi, koma ndikosavuta komanso kuthamanga kuchita njirayi pogwiritsa ntchito zida zomangira zokha. Izi ndizofunikira makamaka polemba nambala yayikulu.

Tiyeni tiwone momwe, pogwiritsa ntchito cholembera chodzaza, mungathe kupanga ziwerengero zamitundu yanu.

1. Timayika nambala "1" ku khungu lomwe tikukonzekera kuyamba kuwerengera. Kenako kusuntha chotembezera kumunsi kumanzere kwa chinthucho. Nthawi yomweyo, iyenera kusinthidwa kukhala mtanda wakuda. Amatchedwa chikhomo chodzaza. Timagwira batani lamanzere lakumanzere ndikokera kounikira pansi kapena kumanja, kutengera zomwe muyenera kudziwa: mizere kapena mizati.



2. Pambuyo pofikira foni yomaliza, yomwe iyenera kuwerengedwa ,amasula batani la mbewa. Koma, monga momwe tikuonera, zinthu zonse zopanda manambala zimangodzala ndi mayunitsi. Kuti muthe kukonza izi, dinani pazizindikiro kumapeto kwa manambala. Khazikitsani switch pafupi ndi chinthucho Dzazani.



3. Mukatha kuchita izi, mndandanda wonsewo udzawerengedwa ndikuyenera.

Njira 3: kupita patsogolo

Njira ina yomwe mungerengere zinthu mu Excel ndikugwiritsa ntchito chida chomwe chimatchedwa "Kupita patsogolo".

1. Monga momwe munachitira kale, khazikitsani nambala "1" mu khungu loyamba kuti awerenge. Pambuyo pake, ingosankha gawo ili la pepalalo podina ndi ilo batani lakumanzere.



2. Pambuyo pazomwe mukufuna zikusankhidwa, pitani ku tabu "Pofikira". Dinani batani Dzazanikuyikidwa pa tepi mu chipika "Kusintha". Mndandanda wa zochita umatseguka. Sankhani malo kuchokera pamenepo "Kupita patsogolo ...".



3. Windo la Excel limatsegulidwa lotchedwa "Kupita patsogolo". Pali makonda ambiri pazenera ili. Choyamba, tiyeni tiime pamalo "Malo". Kusinthaku kuli ndi malo awiri mmenemo: Mzere ndi mzere ndi Column ndi safu. Ngati mukufuna kupanga manambala oyang'ana patali, sankhani njira Mzere ndi mzerengati ofukula - ndiye Column ndi safu.

   Mu makatani "Mtundu" Zolinga zathu tikuyenera kukhazikitsa "Arithmetic". Komabe, ili kale pamalopo posankha, kotero muyenera kungoyang'anira malo ake.

   Zokonda zimaletsa "Mgwirizano" imangokhala yogwira mtundu ukasankhidwa Madeti. Popeza tidasankha mtundu "Arithmetic", chapamwamba sichingatisangalatse.

   M'munda "Khwerero" chithunzi chiyenera kukhazikitsidwa "1". M'munda "Mtengo wochepera" ikani nambala ya zinthu zowerengeka.

   Pambuyo pochita izi pamwambapa, dinani batani "Zabwino" pansi pazenera "Kupita patsogolo".



4. Monga tikuwona, atchulidwa pawindo "Kupita patsogolo" mndandanda wazinthu zingapo udzawerengedwa mu dongosolo.

Ngati simukufuna kuwerengetsa manambala azinthu zomwe zimayenera kuwerengeka kuti muwasonyeze mundawo "Mtengo wochepera" pa zenera "Kupita patsogolo", pamenepo pankhaniyi, musanayambe zenera lokhazikitsidwa, sankhani mtundu wonse kuti uwerenge.

Pambuyo pake, pazenera "Kupita patsogolo" timachita zofananira zonse zomwe zidafotokozedwa pamwambapa, koma nthawi ino tichoke kumunda "Mtengo wochepera" chopanda kanthu.

Zotsatira zake zidzakhala zofanana: zinthu zomwe zasankhidwa zidzawerengedwa.

Phunziro: Momwe mungapangire kuti zikwaniritsidwe mu Excel

Njira 4: gwiritsani ntchito ntchito

Mutha kuthandizanso kupanga manambala pazithunzi pogwiritsa ntchito Excel. Mwachitsanzo, mutha kugwiritsa ntchito opaleshoni pakuwerenga manambala. LERO.

Ntchito LERO amatanthauza chipika cha ogwiritsira ntchito Malingaliro ndi Kufika. Ntchito yake yayikulu ndikubwezeretsa nambala ya mzere wa pepala la Excel pomwe ulalo udzaikidwe. Ndiye kuti, ngati titalongosola ngati mfundo yantchito imeneyi selo lililonse pamzere woyamba wa pepalalo, liziwonetsa mtengo wake "1" muchipinda momwe chimakhalamo chokha. Mukatchula ulalo woloza mzere wachiwiri, wothandizirayo akuwonetsa nambala "2" etc.
Ntchito Syntax LERO kutsatira:

= LINE (cholumikizira)

Monga mukuwonera, mfundo yokhayo yogwirapo ndi ulalo wa khungu lomwe nambala ya mzere wake ikuyenera kuwonetsedwa pazomwe zidalembedwazi.

Tiyeni tiwone momwe mungagwirire ntchito ndi wofotokozedwayo pakuchita.

1. Sankhani chinthu chomwe chikhala choyamba pamndandanda. Dinani pachizindikiro "Ikani ntchito", yomwe ili pamwamba pa malo ogwiritsira ntchito pepala lothandizira la Excel.



2. Iyamba Fotokozerani Wizard. Timasinthiramo mu gulu Malingaliro ndi Kufika. Kuchokera pa mayina omwe adalembedwa, sankhani dzinalo LERO. Pambuyo powunikira dzinali, dinani batani "Zabwino".



3. Kukhazikitsa zenera chotsutsa cha ntchito LERO. Ili ndi gawo limodzi lokha, molingana ndi kuchuluka kwa zotsutsana zomwezi. M'munda Lumikizani tiyenera kulowa adilesi ya foni iliyonse yomwe ili pamzere woyamba wa pepalalo. Coordinates amatha kulowetsedwa pamanja ndikuwayendetsa kudzera pa kiyibodi. Koma komabe ndizosavuta kuchita izi mwa kungoyika chikwangwani m'munda kenako ndikudina-kumanzere pachinthu chilichonse chomwe chili pamzere woyamba wa pepalalo. Adilesi yake iwonetsedwa pomwepo pazenera la mkangano LERO. Kenako dinani batani "Zabwino".



4. Mu khungu la pepala momwe ntchitoyo imapangidwira LERO, nambala inawonetsedwa "1".



5. Tsopano tikuyenera kuwerengera mizere yonseyo. Pofuna kuti tisachite momwe timagwiritsira ntchito othandizira pazinthu zonse, zomwe, zimatenga nthawi yambiri, tidzalemba chilinganizo pogwiritsa ntchito chizindikirochi chomwe tikudziwa kale. Yendani pansi m'mphepete lamanja la foni ndi kachitidwe LERO ndipo chizindikirocho chikadzaza, gwiritsani batani lakumanzere. Tikhazikitsa chikhazikitso pansi pazomwe zingwe ziwerenge.



6. Monga mukuwonera, mutatha kuchita izi, mizere yonse ya manenedwayi idzawerengeredwa ndi manambala a ogwiritsa ntchito.

Koma tinangowerengera mizereyo, ndipo kuti tikwaniritse ntchito yogawa nambala yafoni kuti ikhale nambala mkati mwa tebulo, tiyenera kuwerengeranso nsanamira. Izi zitha kuchitika pogwiritsa ntchito Excel yomwe idamangidwa. Wogwiritsa ntchitoyu akuyembekezeka kutchedwa STOLBETS.

Ntchito NKHANI ilinso m'gulu la ogwiritsira ntchito Malingaliro ndi Kufika. Monga momwe mungaganizire, ntchito yake ndikuwonetsa nambala yamizere kuzinthu zomwe zikusungidwira pepala kuti foni ilumikizidwe. Kuphatikizika kwa ntchitoyi kuli pafupifupi kofanana ndi mawu am'mbuyomu:

= COLUMN (cholumikizira)

Monga mukuwonera, dzina la wothandiziralo limasiyana basi, ndipo mkanganowo, monga nthawi yomaliza, ndi ulalo wololeza patsamba linalake.

Tiyeni tiwone momwe mungakwaniritsire ntchitoyi pogwiritsa ntchito chida ichi.

1. Sankhani chinthu chomwe gawo loyambirira la mitundu yomwe yakonzedwa lifananira. Dinani pachizindikiro "Ikani ntchito".



2. Kupita ku Fotokozerani Wizardpitani ku gululi Malingaliro ndi Kufika ndipo pamenepo tidalitsa dzinalo STOLBETS. Dinani batani "Zabwino".



3. Kugundana Kwawindo la Window NKHANI. Monga nthawi yapita, ikani chotembezera m'munda Lumikizani. Koma pankhaniyi, timasankha chilichonse osati mzere woyamba wa pepalali, koma mzere woyamba. Ogwirizanitsa amawonetsedwa nthawi yomweyo m'munda. Kenako mutha dinani batani. "Zabwino".



4. Pambuyo pake, manambala adzawonetsedwa mu khungu lomwe latchulidwa "1"lolingana ndi nambala yolumikizana ya patebulo yomwe yatchulidwa ndi wogwiritsa ntchito. Kuwerengera mizati yotsala, komanso pamizere, timagwiritsa ntchito chikhomo. Yendani m'mphepete lamanja lamanja la foni yomwe ili ndi ntchito NKHANI. Tikuyembekezera kuti chikhomo chizidzaza, ndikugwira batani lakumanzere, ndikukokera kutemberera kumanja ndi chiwerengero chomwe mukufuna.

Tsopano maselo onse omwe ali patebulo lathu labwino ali ndi ziwerengero zake. Mwachitsanzo, chinthu chomwe chithunzi 5 chimayikidwa pachithunzi pansipa chimakhala ndi ogwirizana (3;3), ngakhale adilesi yawo yonse mu lingaliro la pepalali idatsalira E9.

Phunziro: Wizard wa Zinthu mu Microsoft Excel

Njira 5: kutchulanso dzina la foni

Kuphatikiza pa njira zomwe zili pamwambapa, ziyenera kudziwika kuti, ngakhale atapatsidwa manambala pazipilara ndi mizere ya gulu linalake, mayina amaselo mkati mwake adzaikidwa molingana ndi kuchuluka kwa pepala lonse. Izi zitha kuwoneka m'munda wapadera wosankha dzina.

Kuti tisinthe dzina lomwe likugwirizana ndi zogwirizanitsa ndi pepalali kukhala lomwe tidalongosola pogwiritsa ntchito zofananira ndi zomwe tili nazo, ndikokwanira kusankha chinthu chofananira ndikudina batani lakumanzere. Kenako, kungochotsa pa kiyibodi mu gawo la dzina, kuyendetsa mu dzina lomwe wogwiritsa ntchitoyo akuwona kuti ndilofunika. Itha kukhala liwu lililonse. Koma m'malo mwathu, timangolumikizana ndi izi zogwirizana ndi izi. M'dzina lathu, timatanthauzira manambala ndi zilembo "Tsamba", ndi nambala ya mzere "Gome". Timalandira dzina la mtundu wotsatira: "Table3Str3". Timayendetsa mu gawo la dzina ndikusindikiza fungulo Lowani.

Tsopano selo yathu yapatsidwa dzina malinga ndi adilesi yake yapafupipo. Momwemonso, mutha kupereka mayina kuzinthu zina zamtunduwu.

Phunziro: Momwe mungatchulire dzina la foni ku Excel

Monga mukuwonera, pali mitundu iwiri ya manambala omwe adapangidwa ku Excel: A1 (zosakwanira) ndi R1C1 (ophatikizidwa pazokonza). Mitundu iyi yothetsera imakhudza pepala lonse. Kuphatikiza apo, wogwiritsa ntchito aliyense akhoza kupanga owerenga ake mkati mwa tebulo kapena gulu lenileni. Pali njira zingapo zotsimikiziridwa zoperekera manambala ku maselo: kugwiritsa ntchito cholembera, chida "Kupita patsogolo" ndi ntchito zapadera zopangidwa mu Excel. Manambala akakhazikitsidwa, mutha kusankha dzina la chinthu china chazomwecho.