Monga mu Excel, yochulukitsani ndimeyo ndi ndime ndi ndime ndi nambala

Anthu omwe nthawi zambiri amagwira ntchito pa kompyuta, posachedwa adzakumana ndi pulogalamu ngati Excel. Koma zokambirana zomwe zili m'nkhaniyi sizidzayenda phindu ndi phindu la pulogalamuyi, koma za mbali yake yosiyana "Fomu." Inde, m'masukulu ndi m'mayunivesites mu maphunziro a ophunzira a sayansi ya sayansi ndi ophunzira amaphunzitsidwa pa mutu uwu, koma kwa iwo amene aiwala, - nkhani yathu.

Kukambirana kudzakhala za momwe mungachulukitsire mzere mu Excel ndi mzere. Mitu yotsatanetsatane idzaperekedwa pa momwe mungachitire izi, ndi kusanthula pang'onopang'ono kwa chinthu chirichonse, kotero kuti aliyense, ngakhale wophunzira woyamba, akhoze kumvetsa funso ili.

Lembani ndondomeko ndi ndime

Monga mu Excel, wonjezerani ndimeyo ndi mzere, tidzasokoneza chitsanzocho. Tiyeni tiyerekeze kuti mu buku la Excel mwalenga tebulo ndi mtengo ndi kuchuluka kwa mankhwala. Ndiponso muli ndi selo pansi ndi ndalama zonse. Monga momwe mungaganizire, muyenera kuwonjezereka maulendo awiri oyambirira ndikupeza kuchuluka kwawo.

Kotero, apa pali malangizo a sitepe ndi sitepe:

1. Sankhani selo lofunidwa ndipo dinani pazithunzi za ntchito, yomwe ili pamwamba pa kachipangizo chachikulu.
2. Musanayambe kukhala mawindo omwe muyenera kusankha "Ntchito zina".
3. Kenaka, muyenera kusankha kuchokera ku gulu la masamu.
4. Sankhani "SUMPRODUCT".

Pambuyo pake, mawindo adzawonekera kuti muzisankha zofunikira ndi deta yofunikira, apa mukhoza kupita m'njira ziwiri. Yoyamba ikusonyeza kuti mumagwiritsa ntchito chithunzithunzi kuti musankhe ndondomeko yoyamba (mtengo) ndipo mndandanda wake udzafotokozedwa mu "Mzere 1", ndipo yachiwiri (mtengo) udzafotokozedwa mu "Mzere 2". Monga momwe mukuonera, kusiyana kwake kunanenedwa mu zizindikiro (C2: C6). Njira yachiwiri imatanthawuza kuti mumalowa mwazimenezi, palibe kusiyana kwa izi.

Tsopano mukudziwa njira imodzi yowonjezerezera chigawo ndi ndondomeko ya Excel, koma siyo yokhayo, ndipo tidzakambirana zazomwezo m'munsimu.

Njira yachiwiri yobweretsera

Kuti muwonjezere zipilala mwanjira yachiwiri, mufunikanso kusankha gulu la "masamu" ntchito, koma tsopano muyenera kugwiritsa ntchito "NTCHITO". Tsopano musanakhale pali minda iwiri: "Nambala 1" ndi "Nambala 2". Dinani pa "Nambala 1" ndi kusankha choyamba choyamba kuchokera m'ndandanda yoyamba, mofananamo kubwereza masitepe ndi "Nambala 2", ingosankha mtengo woyamba pa chigawo chachiwiri.

Pambuyo polemba "OK" mu selo ndi ndondomekoyi, chigulitsidwe cha machitidwe osankhidwa chikuwonekera, zimangokhala kuti zitsimikize maselowo, kuti izi zitheke, sungani chithunzithunzicho pansi pa selo ndikupita nacho ku nambala yofunikira ya mfundo.

Tsopano mwaphunzira njira yachiwiri yowonjezerezera ndimeyo mu Excel ndi mzere. Tsopano tiyeni tiyankhule za momwe tingawonjezere chiwerengero ndi mzere.

Lembani ndimeyo ndi nambala

Kotero, momwe mungachulukitsire mzere mu Excel ndi chiwerengero? Ndipotu, ndizosavuta. Kuti muchite izi:

1. Sankhani selo kumene zotsatira zidzakhazikitsidwe.
2. Lembani chizindikiro "chofanana" mkati mwake.
3. Gwiritsani ntchito chithunzithunzi kuti musankhe mtengo woyambirira kuchokera pa chigawocho, ndiyeno sankhani nambala yomwe mtengo umenewu udzachulukidwe.
4. Pambuyo pake, sutsani cholozera ku nambala iyi ndipo yesani F4.
5. Tsopano mukufunikira kusuntha chithunzithunzi kupita kumanja kumanja kwa selo ndi yankho ndikukoka kwa nambala yofunikira ya mfundo.