Kuchuluka kwa mawu mu Excel. Momwe mungalembe kuchuluka kwa mawu mu Excel

Zida za Microsoft Excel zimagwiritsidwa ntchito kwambiri polemba manambala. Nthawi zina pamafunika kuti nambala, monga ndalama, zilembedwe m’mawu. Izi zimakhala zofunikira makamaka polemba zikalata zachuma. Kulemba nambala iliyonse m'mawu pamanja ndikovuta. Komanso, manambala mu nkhani zovuta kwambiri, ndipo si aliyense amadziwa malamulo kulemba iwo. Kusaphunzira m'zikalata kumawononga mbiri ya kampaniyo, chifukwa chake muyenera kugwiritsa ntchito thandizo la mautumiki a Excel. Tiyeni tiwone momwe mungawonjezere ntchito ya "Ndalama m'mawu" pulogalamuyo ndikuigwiritsa ntchito moyenera.

Yambitsani kuwonjezera NUM2TEXT mumndandanda wa Excel

Musanapange ma cell okhala ndi ma sums m'mawu, muyenera kutsitsa chowonjezera cha Microsoft Excel. Palibe zowonjezera pa webusayiti yovomerezeka ya opanga, koma zitha kutsitsidwa kuchokera kumasamba ena. Ndikofunika kuyang'ana mafayilo omwe amatsitsidwa ku kompyuta pogwiritsa ntchito pulogalamu ya antivayirasi, apo ayi pali chiopsezo chopatsira dongosolo ndi kachilombo. Komanso tcherani khutu ku chilolezo cha fayilo. Kusamvana kolondola ndi Xla. Ngati chowonjezeracho chatsitsidwa kale, chiyikeni mufoda momwe chidzakhala chosavuta kupeza. Izi zidzathandiza pamene mukugwirizanitsa. Kenako, tisanthula kuphatikizika kwa chowonjezera pang'onopang'ono:

1. Muyenera kutsegula tabu "Fayilo" mu chikalata cha Excel ndikusankha gawo la "Zosankha". Nthawi zambiri amapezeka pansi pa mndandanda wagawo.

2. Zenera la zosankha lidzatsegulidwa ndi menyu kumanzere. Sankhani gawo la "Zowonjezera". Ngati muyang'ana kumanja kwa chinsalu, mukhoza kuona kuti zina mwazo zimayikidwa kale, koma sizoyenera kulemba mosavuta kuchuluka kwa mawu.

Pansi pake pali kagawo ka "Management" ndi batani la "Pitani". Timadina batani ili.

3. Zenera lomwe lili ndi zowonjezera zowonjezera lidzawonekera pazenera. Mutha kuloleza zina ngati zikufunika, koma cholinga chake ndi batani la Sakatulani.

4. Timapeza fayilo yokhala ndi zowonjezera kudzera pawindo losakatula. Dinani pa izo kuti musankhe ndikudina Chabwino.

5. Chinthu "Num2Text" chidzawonekera pamndandanda wazowonjezera. Payenera kukhala cholembera pafupi ndi icho. Ngati si pa zenera, muyenera kusankha izi kuwonjezera-pamanja ndi kumadula "Chabwino".

Kulumikizana kwa "Chiwerengero m'mawu" kwatha, tsopano mutha kuchigwiritsa ntchito.

Zochita ndi zowonjezera pambuyo kugwirizana

Zowonjezera "Kuchuluka kwa mawu" ndikuwonjezera kwa "Function Manager" Excel. Amawonjezera njira yatsopano pamndandanda, yomwe mutha kusintha nambala iliyonse kukhala mawu. Tiyeni tikumbukire momwe tingagwirire ntchito ndi "Feature Manager" ndikuwona zowonjezera zomwe zikuchitika.

1. Tiyeni tipange tebulo ndi manambala omwe ayenera kulembedwa m'mawu. Ngati wina alipo kale, muyenera kungotsegula chikalata chomwe chidapangidwa.
2. Kenaka, dinani pa selo lopanda kanthu komwe ndalamazo ziyenera kuwoneka m'mawu, ndikutsegula "Function Manager".

Zofunika! Mutha kufika ku gawo ili la Excel m'njira zingapo: kudzera pachithunzi chomwe chili pafupi ndi mzere wogwira ntchito kapena kudzera pa tabu ya Mafomula (batani la Insert Function).

3. Sankhani gulu "Full alfabetical list". Muyenera kusunthira mpaka ku chilembo "C" chifukwa mawonekedwewo samakwanira m'magulu ang'onoang'ono. Kenako, muyenera dinani dzina la ntchitoyo "Amount_in words" ndikudina "Chabwino".

4. Sankhani selo yokhala ndi nambala yomwe mawu ake akuyenera kuwoneka mu cell yopanda kanthu. Chojambula chojambula chiyenera kuwoneka mozungulira, ndipo mawonekedwe opingasa ndi ofukula adzagwera mu fomula. Dinani batani "Chabwino".

5. Zotsatira zake, kuchuluka kwa mawu kumawonekera m'selo yomwe idasankhidwa poyambirira. Zikuwoneka motere:

6. Tsopano mutha kudzaza tebulo lonse popanda kuchita chimodzimodzi ndi mzere uliwonse. Mukadina pa selo iliyonse, autilaini yakuda imawonekera mozungulira (yoyera ngati selo ili patebulo lokhala ndi malire), ndipo pakona yakumanja yakumanja pali cholembera chakuda. Sankhani cell yomwe "Sum_in words" ilipo, gwirani mbali iyi ndikuikokera kumapeto kwa tebulo.

7. Fomula imasunthira ku ma cell onse omwe ali pansipa omwe atengedwa ndi zomwe zasankhidwa. Pali kusintha kwa maselo, chifukwa chomwe kuchuluka kwa mawu kumawonekera pamzere uliwonse. Tebulo ili ndi mawonekedwe awa:

Kulowetsa pamanja kwa ntchito m'maselo

M'malo modutsa masitepe otsegula "Function Manager" ndikufufuza zomwe mukufuna, mutha kulowetsa fomuyo mwachindunji muselo. Tiyeni tiwone momwe tingadzazire tebulo popanda kugwiritsa ntchito chida.

1. Choyamba muyenera kusankha selo yopanda kanthu komwe fomula idzalembedwera. Dinani kawiri pa izo - gawo lolowera deta kuchokera ku kiyibodi lidzawonekera mkati.
2. Tiyeni tilembe fomula ili m'gawo lopanda kanthu: =Kuchuluka_m'mawu ().

Malangizo! Pambuyo kukhazikitsa chizindikiro chofanana, pulogalamuyo ipereka malingaliro mu mawonekedwe a mafomu. Kuyika kochulukira pamzere uliwonse, m'pamenenso lingaliro limakhala lolondola kwambiri. Ndizosavuta kupeza ntchito yomwe mukufuna pamndandandawu ndikudina kawiri pamenepo.

3. M'makolo, muyenera kutchula selo, zomwe zili mkati mwake zidzalembedwa m'mawu.

Tcherani khutu! N'zotheka kulemba m'mawu osati chiwerengero cha selo limodzi, komanso zotsatira za ntchito ya masamu ndi manambala ochokera ku maselo angapo. Mwachitsanzo, ngati mwasankha selo limodzi, ikani chizindikiro "+" pambuyo pa kutchulidwa kwake ndikuwonetsa chigawo chachiwiri - selo lina, ndiye zotsatira zake zidzakhala chiwerengero cha manambala awiri olembedwa m'mawu.

4. Dinani batani la "Enter". Maselo adzawonetsa nambala kapena zotsatira za chochitika, chofotokozedwa m'mawu.

Ndizotheka kulemba nambala m'mawu osapanga tebulo - zomwe mungafune ndi chilinganizo ndi mbewu kapena zochita. M'pofunikanso kulemba chilinganizo mu selo chopanda kanthu, koma m'mabulaketi, m'malo mwa zopingasa ndi zoimirira zizindikiro, kulemba nambala kapena mawu. Tsekani mabatani ndikusindikiza "Lowani" - manambala ofunikira amawonekera mu selo.

Kutsiliza

Kuti mulembe manambala m'mawu, muyenera kutsitsa chowonjezera cha Microsoft Excel ndikuchilumikiza ku pulogalamuyi ndikuyiyambitsa, "Function Manager" imakhala ndi gawo lofunikira pakuchita zina. Ntchitoyi ingagwiritsidwe ntchito pazomwe zili m'maselo ndi manambala akunja kwa matebulo. Poyika mawu a masamu mu ntchito, mutha kupeza zotsatira zake m'mawu.