Matulidwe Otsitsa Kuchokera pa Deta mu Excel

Mmene Mungagwiritsire ntchito Ntchito ya EXEL LOYO

Ntchito ya Excel RIGHT ikukuthandizani kuchotsa zosafunika zomwe mukufuna kuchokera ku deta yosatumizidwa. Pamene malemba amalembedwa kapena kutumizidwa ku Excel, malemba osokonezeka omwe nthawi zina amawaphatikiza ndi deta yabwino.

Kapena, pali nthawi pamene mbali yokha ya malemba yomwe ili mu selo ikufunika, monga dzina la munthu koma osati dzina lomaliza.

Nthawi ngati izi, Excel ili ndi ntchito zingapo zomwe zingagwiritsidwe ntchito kuchotsa deta zosayenera kuchokera kwa ena onse. Ntchito yomwe mumagwiritsa ntchito imadalira kumene deta yofunikako ilili pafupi ndi zida zosafunikira mu selo.

• Ngati deta yofunidwa ili kumbali yolondola ya deta, gwiritsani ntchito LOWANI ntchito kuti mulitenge. Phunziroli lidzakusonyezani momwe ntchitoyi ikugwiritsidwira ntchito.
• Ngati deta yofunidwa ili kumbali yakumanzere ya deta, gwiritsani ntchito LEFT ntchito kuti muichotse.
• Ngati deta yofunidwa ili ndi malemba osafunika pa mbali zonsezi, gwiritsani ntchito MID ntchito kuti muichotse.

01 a 03

KUYANKHA NTCHITO Ntchito Syntax ndi Arguments

Mu Excel, mawu omasulirawo amatanthauzira momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina, ntchito, maubwenzi, ndi mikangano .

Chidule cha ntchito YAM'MBUYO ndi:

= KUMODZI (Malembo, Num_chars)

Maganizo a ntchitoyo amauza Excel zomwe deta iyenera kugwiritsidwa ntchito pachitali ndi kutalika kwa chingwe kuti chichotsedwe.

Malembo- (Ofunikila) cholowera chomwe chili ndi deta yomwe mukufuna. Mtsutso uwu ukhoza kutanthauzira selo kumalo a deta mu tsamba la ntchito , kapena lingakhale lolemba lenileni lomwe lili mkati mwa zizindikiro zogwidwa.

Num_chars- (Mwachidziwikire) imatanthauzira chiwerengero cha anthu omwe ali pamanja pa chingwe chokakamiza kuti chizisungidwe ; Zithunzi zina zonse zachotsedwa. Mtsutso uwu uyenera kukhala wamkulu kapena wofanana ndi zero. Ngati kukangana kumeneku sikulephereka, mtengo wosasintha wa chikhalidwe 1 umagwiritsidwa ntchito ndi ntchito. Ngati izi zili zazikulu kuposa malemba, ntchitoyo imabwereranso malemba.

02 a 03

Chitsanzo: Kuchotsa Anthu Osafunika ndi Ntchito YOYERA

Chitsanzo mu chithunzi pamwambapa chimagwiritsa ntchito LOWA ntchito

• chotsani mawu akuti Widget kuchokera ku mauthenga akutali * & ^% Widget yomwe ili mu selo B1 mu tsamba la ntchito
• Tengerani 789876 kuchokera ku nambala yochuluka 123456789876 yomwe ili mu selo B2 mu tsamba la ntchito

Pansi pali njira zomwe zikufotokozera momwe zotsatira zoyambirira zinapezera.

Zosankha zolowera ku BUKU la ntchito ndi mfundo zake mu selo B1 zikuphatikizapo:

1. Kujambula ntchito yonse = KUYERA (B1,6) mu selo C1.
2. Kusankha ntchito ndi zifukwa pogwiritsa ntchito bokosi la bokosi la ntchito

Kugwiritsira ntchito bokosilo kuti mulowetse ntchito nthawi zambiri kumachepetsa ntchitoyo, monga bokosilo likuyang'anira mawu ogwira ntchito polemba dzina la ntchito, makina osiyanitsa, ndi mabakita m'malo oyenera ndi ochuluka.

Kuwonetsera pa Mafotokozedwe a Cell

Ziribe kanthu kuti mungasankhe bwanji kulowa ntchitoyo mu selo lamasewero, mwinamwake ndibwino kugwiritsa ntchito kulongosola kuti mulowetse zolemba zonse zomwe zimagwiritsidwa ntchito ngati zifukwa.

Kujambula kumaphatikizapo kugwiritsira ntchito ndondomeko yamagulu kuti mugwirizane ndi selo kuti mulowetse ntchito. Kuchita zimenezi kumathandiza kuthetsa zophophonya zomwe zimapangidwa ndi kulemba mulojekiti yolakwika.

Pogwiritsa ntchito Bokosi la Ntchito Loyenera la Ntchito

Lowani ntchito YOMWEYO ndi mfundo zake mu selo C1 pogwiritsa ntchito bokosi la zokambirana:

1. Dinani pa selo C1 kuti mupange selo yogwira ntchito -ndipamene zotsatira za ntchitoyi zidzawonetsedwa.
2. Dinani pa Fomu labudo la menyu.
3. Sankhani Malemba kuchokera ku kaboni kuti mutsegule ndondomeko yochepetsetsa.
4. Dinani PAMODZI mndandanda kuti mubweretse bokosi lazokambirana.
5. Mu bokosi la bokosi, dinani malembawo .
6. Dinani pa selo B1 mu tsamba la ntchito.
7. Dinani ku Num_chars line.
8. Lembani nambala 6 (6) pa mzerewu popeza tikungofuna kusunga anthu asanu ndi limodzi.
9. Dinani OK kuti mukwaniritse ntchitoyi ndi kubwerera kuntchito.

Mawu olembedwa "Widget" ayenera kuwoneka mu selo C1.

Mukasindikiza pa selo C1, ntchito yonse = KUYERA (B1,6) ikuwoneka mu barra yazenera pamwamba pa tsamba.

03 a 03

Kuwerenga Nambala Ndi Ntchito YOYERA

Monga momwe tawonetsera mu mzere wachiwiri wa chitsanzo pamwambapa, KUWERENGA ntchito kungagwiritsidwe ntchito kuchotsa kachigawo kakang'ono ka deta yamtundu kuchokera ku nambala yochuluka pogwiritsa ntchito ndondomeko zotchulidwa.

Vuto lokha ndiloti deta yochotsedwa imasinthidwa ndipo sungagwiritsidwe ntchito pakuwerengera ntchito zina, monga SUM ndi AVERAGE ntchito.

Njira imodzi yozungulira vuto ili ndigwiritsira ntchito VALUE ntchito kuti mutembenuzire malemba kukhala nambala.

Mwachitsanzo:

= VALUE (RIGHT (B2, 6))

Njira yachiwiri ndigwiritsira ntchito phala lapadera kutembenuza malemba ku manambala .