Pezani ntchito mu Microsoft Excel

Mmodzi mwa omwe amagwiritsidwa ntchito kwambiri pakati pa ogwiritsira ntchito Excel ndi ntchito GANIZANI. Ntchito yake ndi kudziwa malo omwe alipo mu deta yapadera. Zimabweretsa phindu lalikulu pogwiritsidwa ntchito pamodzi ndi ogwira ntchito ena. Tiyeni tiwone chomwe ntchito ili GANIZANIkomanso momwe angagwiritsire ntchito pochita.

KUSANKHA KWA MTSOGOLERI WOTSATIRA

Woyendetsa GANIZANI ndi a gulu la ntchito "Zolumikizana ndi zolemba". Imafufuza zinthu zomwe zafotokozedwa muzithunzi zomwe zafotokozedwa ndipo zimapereka chiwerengero cha malo ake mu selo losiyana. Kwenikweni, ngakhale dzina lake limasonyeza izi. Komanso, akagwiritsidwa ntchito mogwirizana ndi ogwira ntchito ena, ntchitoyi imadziwitsa za chiwerengero cha chinthu china chomwe chimapangidwanso ndikukonzekera deta iyi.

Opaleshoni yamagetsi GANIZANI zikuwoneka ngati izi:

= MATCHA (kuyeza kosaka; kujambula mzere; [match_type])

Tsopano ganizirani chimodzi mwazifukwa zitatu izi mosiyana.

"Ndalama yamtengo wapatali" - Ichi ndicho chofunikira chomwe chiyenera kupezeka. Ikhoza kukhala ndi malemba, mawonekedwe azinthu, komanso kutenga phindu lenileni. Mtsutso uwu ukhozanso kukhala kutanthauza selo yomwe ili ndi zikhulupiliro ziri pamwambazi.

"Zowonongeka" ndi adiresi ya mtundu umene mtengo ulipo. Ndilo gawo la chinthu ichi m'zinthu izi zomwe wogwiritsira ntchito ayenera kufotokozera. GANIZANI.

"Mapu Mtundu" imasonyeza masewero enieni kuti afufuze kapena osakwanira. Mtsutso uwu ukhoza kukhala ndi mfundo zitatu: "1", "0" ndi "-1". Ngati "0" Wogwira ntchitoyo amangoyang'ana mzere wokhawokha. Ngati mtengo uli "1", ngati palibe masewero enieni GANIZANI imapereka chinthu choyandikana nacho poyerekeza. Ngati mtengo uli "-1", ndiye ngati palibe mndandanda womwe umapezeka, ntchitoyo imabweretsanso chinthu chomwe chili pafupi kwambiri ndizokwera. Ndikofunika ngati simukufunafuna phindu lenileni, koma ndiyomweyo, kuti mndandanda womwe mukuwonera udzalamulidwa mu kukwera dongosolo (mtundu wofanana "1") kapena kutsika (mapu mtundu "-1").

Kutsutsana "Mapu Mtundu" sizinayesedwe. Zingasokonezeke ngati sizikusowa. Pankhaniyi, mtengo wake wosasintha ndi "1". Ikani mkangano "Mapu Mtundu"Choyamba, n'zomveka pokhapokha ngati manambala akutsatiridwa, osati malemba.

Ngati GANIZANI ndi malonda omwe atchulidwa sangathe kupeza chinthu chofunikirako, woyendetsa amasonyeza cholakwika mu selo "# N / A".

Pofufuza, wogwiritsira ntchito samasiyanitsa pakati pa makalata olemba. Ngati pali zofanana zowonongeka, GANIZANI imasonyeza malo omwe ali oyamba mu selo.

Njira 1: Onetsetsani malo a chinthucho m'dongosolo la malemba

Tiyeni tiwone chitsanzo cha nkhani yosavuta, pogwiritsa ntchito GANIZANI Mukhoza kudziwa malo omwe alipo pazinthu zolemba. Pezani malo omwe maina a katunduyo ali, ndiwo mawu "Shuga".

  1. Sankhani selo imene zotsatira zotsatiridwa zidzawonetsedwa. Dinani pazithunzi "Ikani ntchito" pafupi ndi bar yokupangira.

  2. Yambani Oyang'anira ntchito. Tsegulani gulu "Mndandanda wathunthu wa alfabeti" kapena "Zolumikizana ndi zolemba". Pa mndandanda wa ogwira ntchito tikuyang'ana dzina "KUKHALA". Kupeza ndi kusankha, dinani pa batani. "Chabwino" pansi pazenera.

  3. Festile yotsutsana ndi ogwira ntchito imatsekedwa. GANIZANI. Monga mukuonera, pawindo ili ndi chiwerengero cha zifukwa pali malo atatu. Tiyenera kuzidzaza.

    Popeza tikufunikira kupeza malo a mawu "Shuga" mmalo mwake, ndiye gwiritsani ntchito dzina ili kumunda "Ndalama yamtengo wapatali".

    Kumunda "Zowonongeka" muyenera kufotokoza zochitika zazomwezo. Ikhoza kuthamangitsidwa mwadongosolo, koma ndi kosavuta kuika cholojekiti kumtunda ndikusankha izi pa pepala pamene mukugwedeza batani lamanzere. Pambuyo pake, adiresi yake ikuwonetsedwa muzenera zotsutsana.

    Mu gawo lachitatu "Mapu Mtundu" ikani chiwerengerocho "0", popeza tidzagwira ntchito ndi malemba, ndipo chifukwa chake tikusowa zotsatira zenizeni.

    Pambuyo pa deta yonseyi, dinani pa batani. "Chabwino".

  4. Pulogalamuyi imachita chiwerengerochi ndikuwonetsera malo ovomerezeka "Shuga" mu gulu losankhidwa mu selo lomwe tanena mu sitepe yoyamba ya malangizo awa. Nambala yanu idzakhala yofanana "4".

Phunziro: Excel ntchito wizara

Njira 2: Sinthani kugwiritsa ntchito wogwiritsa ntchito MATCH

Pamwamba, takhala tikuganiza kuti ndizovuta kwambiri kugwiritsa ntchito wogwiritsira ntchito GANIZANI, koma ngakhale ikhoza kukhala yosinthika.

  1. Kuti tipeze mosavuta, timaphatikizapo zina ziwiri pa pepala: "Ikani Malo" ndi "Nambala". Kumunda "Ikani Malo" timayendetsa m'dzina lomwe liyenera kupezeka. Lolani zikhale tsopano "Nyama". Kumunda "Nambala" ikani chithunzithunzi ndikupita kuwindo la zofunikirako zomwe zikufotokozedwa pamwambapa.

  2. Mugwirizano la ntchito yogwirira ntchito "Ndalama yamtengo wapatali" tchulani adiresi ya selo limene mawuwo alowa "Nyama". M'minda "Zowonongeka" ndi "Mapu Mtundu" timasonyeza deta yomweyi monga njira yapitayi - adiresi ya zowerengeka ndi nambala "0" motero. Pambuyo pake, dinani pa batani "Chabwino".

  3. Titatha kuchita zochitika pamwambapa, kumunda "Nambala" mawu amodzi akuwonetsedwa "Nyama" m'masankhidwe osiyanasiyana. Pankhaniyi, ndi "3".

  4. Njirayi ndi yabwino chifukwa ngati tikufuna kudziwa malo a dzina lina lililonse, ndiye kuti sitidzasintha kapena kusintha machitidwe nthawi iliyonse. Zokwanira m'munda "Ikani Malo" lowetsani mawu atsopano ofufuzira m'malo mmbuyomu. Kukonzekera ndi kubweretsa zotsatirapo izi zitachitika mosavuta.

Mchitidwe 3: Gwiritsani ntchito WOTSATIRA kwa malemba

Tsopano tiyeni tiwone momwe mungagwiritsire ntchito GANIZANI kuti agwire ntchito ndi mawu owerengeka.

Ntchitoyi ndi kupeza mankhwala opangidwa ndi ruble 400 kapena pafupi ndi kuchuluka kwa ndalamazi.

  1. Choyamba, tifunika kukonza zinthu zomwe zili m'ndandanda "Mtengo" akutsika. Sankhani ndimeyi ndikupita ku tabu "Kunyumba". Dinani pazithunzi "Sankhani ndi kusefera"zomwe ziri pa tepi mu chipika Kusintha. Mundandanda womwe ukuwonekera, sankhani chinthucho "Yambani kuchokera pazitali kufika pazomwe".

  2. Pambuyo pokonzekera, sankhani selo pomwe zotsatira zake ziwonetsedwe, ndipo yambitsani zenera la ndewu mofanana momwe tafotokozera mu njira yoyamba.

    Kumunda "Ndalama yamtengo wapatali" timayendetsa mu nambala "400". Kumunda "Zowonongeka" tchulani zogwirizanitsa za ndimeyi "Mtengo". Kumunda "Mapu Mtundu" ikani mtengo "-1"pamene tikufufuzira mtengo wofanana kapena wofunika kuchokera kwa wofunayo. Pambuyo pokonza zonsezi dinani pa batani "Chabwino".

  3. Chotsatira cha kukonza chikuwonetsedwa mu selo lomwe latchulidwa kale. Uwu ndiye malo "3". Izo zikugwirizana "Mbatata". Inde, kuchuluka kwa ndalama zogulitsidwa kwa mankhwalawa ndi pafupi ndi nambala 400 mu kukwera dongosolo ndi kuchuluka kwa ruble 450.

Mofananamo, mukhoza kufufuza malo oyandikana nawo "400" akutsika. Chokhacho muyenera kufotokozera deta mukukwera, komanso kumunda "Mapu Mtundu" zifukwa zogwira ntchito zimayika phindu "1".

Phunziro: Sakanizani ndi kusinkhira deta mu Excel

Njira 4: Gwiritsani ntchito pamodzi ndi ogwira ntchito ena

Ntchitoyi ndi yogwira ntchito kwambiri ndi ogwira ntchito ena monga gawo la zovuta. Nthawi zambiri amagwiritsidwa ntchito mogwirizana ndi ntchitoyi INDEX. Mtsutso uwu umayika ku selo losankhidwa zomwe zili m'ndondomeko zomwe zafotokozedwa ndi chiwerengero cha mzere kapena ndime yake. Komanso, kuwerengera, monga momwe akuchitira ndi wogwira ntchitoyo GANIZANI, samachitidwa osati pa pepala lonse, koma m'kati mwake. Chidule cha ntchitoyi ndi ichi:

= INDEX (mzere; mndandanda_mndandanda; ndondomeko_mndandanda)

Komanso, ngati gululi ndilo gawo limodzi, ndiye chimodzi mwa zifukwa ziwiri zomwe zingagwiritsidwe ntchito: "Nambala ya mzere" kapena "Nambala ya column".

Bundle la ntchito INDEX ndi GANIZANI ndiye kuti yomaliza angagwiritsidwe ntchito monga kutsutsana kwa woyamba, ndiko kuti, kusonyeza malo a mzere kapena ndime.

Tiyeni tiwone m'mene izi zingagwiritsidwe ntchito, pogwiritsa ntchito tebulo limodzi. Ntchito yathu ndi kubweretsa pepala lowonjezera "Mtundu" dzina la katundu, chiwerengero cha ndalama zomwe zimakhala zofanana ndi ruble 350 kapena pafupi ndi mtengo uwu pofika pansi. Kutsutsana uku kunanenedwa mmunda. "Ndalama zamtengo wapatali pa pepala".

  1. Sungani zinthu mu column "Kuchuluka kwa ndalama" kukwera. Kuti muchite izi, sankhani kalata yofunikira komanso, pokhala pa tab "Kunyumba", dinani pazithunzi "Sankhani ndi kusefera"ndiyeno mu mawonekedwe omwe akuwonekera awonekera pa chinthucho "Sungani kuyambira pazitali kufika pamtunda".

  2. Sankhani selo kumunda "Mtundu" ndi kuyitana Mlaliki Wachipangizo mwachizolowezi kudzera mu batani "Ikani ntchito".

  3. Pawindo lomwe limatsegula Oyang'anira ntchito m'gulu "Zolumikizana ndi zolemba" fufuzani dzina INDEXsankhani ndipo dinani pa batani "Chabwino".

  4. Kenaka, zenera zikutsegulira zomwe zimapatsa kusankha kosankha. INDEX: zolemba kapena zolemba. Tikufuna njira yoyamba. Choncho, timachoka pazenera zonse zosasinthika ndikusindikiza pa batani "Chabwino".

  5. Ntchito yotsutsana yenera ikutsegula. INDEX. Kumunda "Mzere" tchulani adiresi ya mtundu umene woyendetsa INDEX adzafufuza dzina la mankhwala. Kwa ife, iyi ndi mzere. "Dzina la Zamalonda".

    Kumunda "Nambala ya mzere" Ntchito yamtendere idzapezeka GANIZANI. Icho chiyenera kuyendetsedwa mwadongosolo pogwiritsira ntchito syntax yomwe yatchulidwa kumayambiriro kwa nkhaniyo. Nthawi yomweyo lembani dzina la ntchito - "KUKHALA" popanda ndemanga. Kenaka mutsegule pakani. Mtsutso woyamba woyendetsa ntchitoyi ndi "Ndalama yamtengo wapatali". Ili pa pepala pamunda. "Za ndalama zambiri". Tchulani makonzedwe a selo okhala ndi chiwerengero 350. Timayika semicolon. Kukangana kwachiwiri ndi "Zowonongeka". GANIZANI adzawona mtundu umene ndalamazo zilipo ndikuyang'ana pafupi ndi ma ruble 350. Kotero, mu nkhaniyi, ife timatanthauzira zogwirizana za ndimeyo "Kuchuluka kwa ndalama". Apanso timaika semicolon. Mtsutso wachitatu ndi "Mapu Mtundu". Popeza tifunafuna chiwerengero chofanana ndi chopatsidwa kapena chapafupi, timayika nambala apa. "1". Tsekani mabotolo.

    Kutsutsana kwachitatu ntchito INDEX "Nambala ya column" chokani chopanda kanthu. Pambuyo pake, dinani pa batani "Chabwino".

  6. Monga mukuonera, ntchitoyi INDEX mothandizidwa ndi wogwiritsira ntchito GANIZANI mu selo yoyimiliridwa kale imasonyeza dzina "Tea". Inde, ndalama zogulitsidwa ndi tiyi (300 rubles) ndizo zowonjezera poyerekeza ndi kuchuluka kwa ma ruble 350 kuchokera kuzinthu zonse zomwe zikugwiritsidwa ntchito patebulo.

  7. Ngati titasintha chiwerengero m'mundawu "Za ndalama zambiri" kwa wina, zomwe zili m'munda zidzasinthidwa molingana. "Mtundu".

Phunziro: Excel ntchito mu Excel

Monga mukuonera, woyendetsa GANIZANI ndi ntchito yabwino kwambiri yodziwitsa kuwerengera kwa chiwerengero cha zinthu zomwe zafotokozedwa pazomwe zilipo. Koma phindu lake limakula kwambiri ngati likugwiritsidwa ntchito m'mawonekedwe ovuta.

Posts Popular

https://termotools.com ny.termotools.com © Excel 2024