Onani m'mawu a Microsoft Excel

Mukadzaza zikalata zosiyanasiyana zachuma, nthawi zambiri zimafunikira kulembetsa kuchuluka osati m'chiwerengero, komanso m'mawu. Zachidziwikire, izi zimatenga nthawi yayitali kuposa momwe spelling yachibadwa imakhalira ndi manambala. Ngati mwanjira imeneyi ndikofunikira kuti mudzaze osati imodzi, koma zikalata zambiri, ndiye kuti kutaya kwakanthawi kumakhala kwakukulu. Kuphatikiza apo, zili mkaundula wa mawu m'mawu omwe zolakwika zazikulu kwambiri za galamala zimachitika. Tiyeni tiwone momwe angapange manambala m'mawu omwe adalowa okha.

Kugwiritsa ntchito

Ku Excel kulibe chida chokhazikitsidwa chomwe chingathandizire kumasulira manambala kukhala mawu. Chifukwa chake, kuthetsa vutoli, zowonjezera zapadera zimagwiritsidwa ntchito.

Chimodzi mwazofunikira kwambiri ndikuwonjezera-NUM2TEXT. Zimakuthandizani kuti musinthe manambala kukhala zilembo kudzera pa Wizard Yogwira Ntchito.

1. Tsegulani pulogalamu ya Excel ndikupita pa tabu Fayilo.



2. Timasunthira ku gawo "Zosankha".



3. Pazenera lochita, pitani kuchigawocho "Zowonjezera".



4. Kenako, mu paramitha ya zoikamo "Management" mtengo wokhazikitsidwa Wonjezerani-Ex. Dinani batani "Pita ...".



5. Windo laling'ono la Excel Add-ins limatseguka. Dinani batani "Ndemanga ...".



6. Pazenera lomwe limatsegulira, yang'anani fayilo yowonjezera ya NUM2TEXT.xla yomwe idatsitsidwa kale ndikusungidwa pa hard disk ya kompyuta. Sankhani ndikudina batani. "Zabwino".



7. Tikuwona kuti izi zidawonekera pakati pazowonjezera. Onani bokosi pafupi ndi NUM2TEXT ndikudina batani. "Zabwino".



8. Kuti tiwone momwe pulogalamu yowonjezera yatsopanoyi imagwirira ntchito, timalemba nambala yolimbirana mu foni iliyonse yaulere. Sankhani khungu lina lililonse. Dinani pachizindikiro "Ikani ntchito". Ili kumanzere kwa baramu ya formula.



9. Ntchito mfiti imayamba. Mndandanda wonse wazomwe tikulemba tikufuna kujambula "Sum_Account". Sanapezekepo kale, koma adawonekera atakhazikitsa zowonjezera. Timatsimikizira ntchito iyi. Dinani batani "Zabwino".



10. Tsamba la kutsutsana kwa ntchito limatseguka Ndalama Zapamwamba. Ili ndi gawo limodzi lokha. "Ndalama". Mutha kulemba nambala yanthawi pano. Ziziwonetsedwa mu khungu losankhidwa mwanjira zolembedwa m'mawu amali ndalama m'm ruble ndi kopecks.



Mutha kulowa adilesi ya foni iliyonse m'munda. Izi zimachitika ndikujambulitsa pamanja zolumikizana za foniyo, kapena kungodina pang'ono pomwe chidziwitso chili mundawo "Ndalama". Dinani batani "Zabwino".



11. Pambuyo pake, nambala iliyonse yomwe yalembedwa mu foni yomwe mukutchulidwa idzawonetsedwa mu ndalama m'malo mwa malo omwe amayikira ntchito.

Mutha kujambulanso ntchito pamanja popanda kuyitanitsa wizard wa ntchito. Ili ndi syntax Ndalama Zopangira (kuchuluka) kapena Ndalama Zopangira (cell_ zogwirizanitsa). Chifukwa chake, ngati mulemba mawonekedwe mu cell= Record Record (5)ndiye pambuyo kukanikiza batani ENG mu cell iyi mawu akuti "Rubles zisanu 00 kopecks" akuwonetsedwa.

Ngati mwalowa chilinganizo mu khungu= Record Record (A2), ndiye pankhaniyi, nambala iliyonse yolowetsedwa mu foni A2 iwonetsedwa pano ndi ndalama m'mawu.

Monga mukuwonera, ngakhale kuti Excel ilibe chida chomangira chosinthira manambala kuti chigwirizane m'mawu, izi zitha kupezeka mosavuta ndikungokhazikitsa zowonjezera mu pulogalamuyi.