Manambala a mzere wokha mu Excel. Njira zitatu zokhazikitsira manambala a mzere mu Excel

Pogwira ntchito ndi tebulo, kuwerengera kungakhale kofunikira. Zimapanga, zimakupatsani mwayi woyendamo mwachangu ndikufufuza zofunikira. Poyamba, pulogalamuyi ili ndi manambala, koma imakhala yokhazikika ndipo singasinthidwe. Njira yolowera manambala pamanja imaperekedwa, yomwe ili yabwino, koma osati yodalirika, ndizovuta kugwiritsa ntchito pogwira ntchito ndi matebulo akulu. Chifukwa chake, m'nkhaniyi, tiwona njira zitatu zothandiza komanso zosavuta kugwiritsa ntchito zowerengera matebulo mu Excel.

Njira 1: Kuwerengera Pambuyo Kudzaza Mzere Woyamba

Njirayi ndi yosavuta komanso yogwiritsidwa ntchito kwambiri pogwira ntchito ndi matebulo ang'onoang'ono ndi apakatikati. Zimatenga nthawi yochepa ndikutsimikizira kuchotsedwa kwa zolakwika zilizonse pakuwerengera. Malangizo awo a sitepe ndi sitepe ndi awa:

1. Choyamba muyenera kupanga ndime yowonjezera patebulo, yomwe idzagwiritsidwe ntchito powonjezera manambala.
2. Gawoli likapangidwa, ikani nambala 1 pamzere woyamba, ndikuyika nambala 2 pamzere wachiwiri.

3. Sankhani odzazidwa awiri maselo ndi fungatirani pa m'munsi pomwe ngodya ya osankhidwa dera.
4. Chizindikiro cha mtanda wakuda chikangowoneka, gwira LMB ndikukokera malowo kumapeto kwa tebulo.

Ngati zonse zachitika molondola, ndiye kuti ndime yowerengeka idzadzazidwa yokha. Izi zidzakhala zokwanira kukwaniritsa zotsatira zomwe mukufuna.

Njira 2: Wogwiritsa ntchito "ROW".

Tsopano tiyeni tipitirire ku njira yotsatira yowerengera, yomwe ikukhudza kugwiritsa ntchito “STRING” yapadera:

1. Choyamba, pangani mzere wowerengera manambala, ngati palibe.
2. Pamzere woyamba wagawoli, lowetsani njira iyi: =ROW(A1).

3. Mukalowa fomula, onetsetsani kuti mwasindikiza batani la "Enter", lomwe limayambitsa ntchitoyi, ndipo muwona nambala 1.

4. Tsopano imakhalabe, mofanana ndi njira yoyamba, kusuntha cholozera kumunsi kumanja kwa malo osankhidwa, dikirani kuti mtanda wakuda uwoneke ndi kutambasula dera mpaka kumapeto kwa tebulo lanu.
5. Ngati zonse zachitika molondola, ndiye kuti gawoli lidzadzazidwa ndi manambala ndipo lingagwiritsidwe ntchito popezanso zambiri.

Pali njira ina, kuwonjezera pa njira yotchulidwa. Zowona, zidzafunika kugwiritsa ntchito gawo la "Function Wizard":

1. Momwemonso pangani ndime yowerengera manambala.
2. Dinani pa selo yoyamba pamzere woyamba.
3. Pamwamba pafupi ndi malo osakira, dinani chizindikiro cha "fx".

4. "Function Wizard" yatsegulidwa, momwe muyenera kudina chinthu cha "Category" ndikusankha "References and Arrays".

5. Kuchokera pazolinga zomwe zaperekedwa, zimatsalira kusankha "ROW".

6. Zenera lowonjezera lolowera zambiri lidzawonekera. Muyenera kuyika cholozera mu chinthu cha "Link" ndipo m'mundamo sonyezani adilesi ya cell yoyamba ya nambala yowerengera (kwa ife, iyi ndiye mtengo wa A1).

7. Chifukwa cha zochita zomwe zachitika, nambala 1 idzawonekera mu cell yoyamba yopanda kanthu. Zimatsaliranso kugwiritsa ntchito ngodya yakumanja ya malo osankhidwa kachiwiri kuti muzikokera ku tebulo lonse.

Izi zikuthandizani kuti mupeze manambala onse ofunikira ndikukuthandizani kuti musasokonezedwe ndi zazing'ono ngati mukugwira ntchito ndi tebulo.

Njira 3: kugwiritsa ntchito kuwonjezera

Njira imeneyi ndi yosiyana ndi ina amachotsa kufunikira kwa ogwiritsa ntchito chizindikiro chodzaza okha. Funso ili ndilofunika kwambiri, chifukwa kugwiritsidwa ntchito kwake sikokwanira pogwira ntchito ndi matebulo akuluakulu.

1. Timapanga gawo lowerengera ndikulemba nambala 1 mu cell yoyamba.

2. Timapita ku toolbar ndikugwiritsa ntchito gawo la "Home", kumene timapita ku gawo la "Sinthani" ndikuyang'ana chithunzicho ngati muvi wapansi (pamene mukuyendayenda, chidzatchedwa "Dzazani").

3. Mu menyu otsika, muyenera kugwiritsa ntchito "Kupititsa patsogolo".
4. Pawindo lomwe likuwoneka, chitani izi:
   • sungani mtengowo “Ndi mizati”;
   • sankhani mtundu wa masamu;
   • m'munda "Masitepe", lembani nambala 1;
   • m'ndime "Kuchepetsa mtengo" muyenera kuzindikira mizere ingati yomwe mukufuna kuwerengera.

5. Ngati zonse zachitika molondola, mudzawona zotsatira za manambala odziwikiratu.

Pali njira ina yochitira manambala awa, omwe amawoneka motere:

1. Bwerezani masitepe kuti mupange mzati ndikuyika chizindikiro mu selo yoyamba.
2. Sankhani mndandanda wonse wa tebulo womwe mukufuna kuwerengera.

3. Pitani ku gawo la "Home" ndikusankha "Kusintha".
4. Tikuyang'ana chinthucho "Dzazani" ndikusankha "Kupititsa patsogolo".
5. Pazenera lomwe likuwoneka, timawonanso zomwezo, ngakhale tsopano sitidzaza chinthu cha "Limit value".

6. Dinani "Chabwino".

Njira imeneyi ndi yapadziko lonse lapansi, chifukwa sifunikira kuwerengera mizere yomwe ikufunika manambala. Zowona, mulimonse, muyenera kusankha mtundu womwe uyenera kuwerengedwa.

Tcherani khutu! Kuti zikhale zosavuta kusankha tebulo lotsatiridwa ndi manambala, mutha kungosankha gawo podina pamutu wa Excel. Kenako gwiritsani ntchito njira yachitatu yowerengera ndikukopera tebulolo papepala latsopano. Izi zithandizira kuwerengetsa kwamatebulo akulu kukhala kosavuta.

Kutsiliza

Manambala amizere angapangitse kuti zikhale zosavuta kugwira ntchito ndi tebulo lomwe likufunika kusinthidwa nthawi zonse kapena lomwe likufunika kupeza zomwe mukufuna. Chifukwa cha malangizo mwatsatanetsatane pamwambapa, mudzatha kusankha njira yabwino kwambiri yothetsera ntchito yomwe muli nayo.