Chimodzi mwa zinthu zotchuka kwambiri za Excel ikugwira ntchito ndi malemba. Chifukwa cha ntchitoyi, pulogalamuyi imapanga mawerengedwe osiyanasiyana m'matawuni. Koma nthawi zina zimakhala kuti wogwiritsa ntchito fomu mu selo, koma sichikukwaniritsa cholinga chake - chiwerengero cha zotsatira. Tiyeni tiwone zomwe zingagwirizane nazo, ndi momwe tingathetsere vutoli.
Kuthetsa mavuto owerengetsera
Zifukwa za mavuto ndi mawerengedwe a mayina a Excel zingakhale zosiyana kwambiri. Zingatheke chifukwa cha zochitika za buku linalake kapena ngakhale maselo enaake, komanso zolakwika zosiyanasiyana mu syntax.
Njira 1: kusintha mtundu wa maselo
Chimodzi mwa zifukwa zowonjezera zomwe Excel silingaganizire kapena ayi molondola mawonekedwe onse ndi osalongosola selo mtundu. Ngati mtunduwu uli ndi mawonekedwe a malemba, ndiye kuti chiwerengero cha mawu omwe ali mmenemo sichinachitike konse, ndiko kuti, amawonetsedwa ngati malemba omveka bwino. Nthawi zina, ngati mawonekedwe sakugwirizana ndi chiwerengero cha deta yowerengedwa, zotsatira zomwe zasonyezedwa mu selo sizingasonyezedwe molondola. Tiyeni tione momwe tingathetsere vutoli.
- Kuti muwone kuti selo kapena mtundu wina uli ndi mtundu wanji, pitani ku tabu "Kunyumba". Pa tepiyi mu chida cha zipangizo "Nambala" Pali munda kuti muwonetse mawonekedwe omwe alipo. Ngati pali phindu "Malembo", ndondomekoyi sichiwerengedwa ndendende.
- Kuti mupange kusintha kwa maonekedwe, dinani pamtundawu. Mndandanda wa maonekedwe omwe angasankhidwe adzatsegulidwa, pomwe mungasankhe mtengo womwe umagwirizana ndi zomwe zimapangidwa.
- Koma kusankha mitundu ya mawonekedwe kupyolera mu tepi sikumveka monga kudzera pawindo lapadera. Choncho, ndi bwino kugwiritsa ntchito njira yachiwiri yokometsera. Sankhani zolingazo. Timangosinthanitsa ndi batani lamanja la mouse. Mu menyu yachidule, sankhani chinthucho "Sezani maselo". Mukhozanso kusindikiza njira yothetsera pambuyo mutasankha mtunduwu. Ctrl + 1.
- Zowonetsera zojambula zimatsegula. Pitani ku tabu "Nambala". Mu chipika "Maofomu Owerengeka" sankhani mtundu umene tikusowa. Kuphatikizanso, pambali yawindo, n'zotheka kusankha mtundu wa maonekedwe a mtundu wina. Mutatha kusankha, dinani pa batani "Chabwino"anaikidwa pansi.
- Sankhani imodzi mwa maselo omwe ntchitoyo sinayambe kuwerengedwa, ndi kubwezeretsanso, pindani makiyi a ntchito F2.
Tsopano ndondomekoyi idzawerengedwa mu dongosolo lokhazikika ndi zotsatira zomwe zasonyezedwa mu selo losankhidwa.
Njira 2: Khutsani "mawonekedwe awonetsera" mawonekedwe
Koma mwinamwake chifukwa chomwe mmalo mwa zotsatira za chiwerengerocho muli ndi mawu omwe amasonyezedwa, ndiye kuti pulogalamuyi ili ndi machitidwe "Onetsani Maonekedwe".
- Kuti muwonetse kuwonetsera kwa totals, pitani ku tabu "Maonekedwe". Pa tepiyi mu chida cha zipangizo "Makhalidwe Oyenera"ngati batani "Onetsani Maonekedwe" yogwira, ndiye dinani pa izo.
- Pambuyo pazimenezi, maselo adzawonetsanso zotsatira mmalo mwa chiwonetsero cha ntchitozo.
Njira 3: Konzani zolakwika za syntax
Fomu ikhoza kuwonetsedwanso monga malembo ngati mawu ake olakwika ali olakwika, mwachitsanzo, ngati kalata ikusowa kapena yosinthidwa. Ngati mwalowa mwapamwamba, osati kudzera Mlaliki Wachipangizo, ndithudi. Kulakwitsa kwakukulu komwe kumagwirizanitsidwa ndi kuwonetsera mawu monga malemba ndi danga asanayambe chizindikiro "=".
Zikatero, muyenera kufufuza mosamalitsa mawu ofanana omwe amawonetsedwa molakwika, ndikupanga kusintha koyenera kwa iwo.
Njira 4: Onetsetsani njira yowonjezeretsa
Zimakhalanso kuti mawonekedwewo akuwoneka kuti akuwonetsa mtengo, koma pamene maselo ogwirizana nawo amasintha, sizimasintha zokha, ndiko kuti, zotsatira zake sizinasinthidwe. Izi zikutanthauza kuti mwakonza molakwika magawo owerengera m'buku lino.
- Dinani tabu "Foni". Pamene muli mmenemo, dinani pa chinthucho "Zosankha".
- Fenje lazitali lidzatsegulidwa. Muyenera kupita ku gawolo "Maonekedwe". Mu bokosi lokhalamo "Mawerengedwe Owerengetsera"yomwe ili pamwamba pawindo, ngati muyeso "Kuwerengera m'buku", osintha kuti musayime "Mwachangu"ndiye ichi ndi chifukwa chake zotsatira za kuwerengera sizothandiza. Sinthani kusinthira ku malo omwe mukufuna. Pambuyo popanga makonzedwe pamwambawa kuti muwapulumutse pansi pawindo, dinani pakani "Chabwino".
Tsopano mawu onse omwe ali m'buku lino adzasinthidwa pokhapokha ngati akusintha mtengo uliwonse.
Njira 5: Cholakwika mu njirayi
Ngati pulogalamuyo ikuchitabe, koma zotsatira zake zikuwonetsa zolakwika, ndiye kuti mwinamwake wogwiritsa ntchitoyo amangopanga kulakwitsa pamene akulowetsa. Zolinga zolakwika ndizo za kuwerengera zomwe zikhalidwe zotsatirazi zikuwoneka mu selo:
- #NUM!;
- #VALUE!;
- # NULL!;
- # DEL / 0!;
- # N / a.
Pankhaniyi, muyenera kufufuza ngati deta ili kulembedwa molingana ndi mafotokozedwe, kaya pali zolakwika mu syntax kapena ngati pali cholakwika chilichonse mwa njira yokha (mwachitsanzo, kugawa ndi 0).
Ngati ntchitoyi ndi yovuta, ndi maselo ambiri okhudzana, ndiye kuti n'zosavuta kufufuza ziwerengero pogwiritsa ntchito chida chapadera.
- Sankhani selo ndi vuto. Pitani ku tabu "Maonekedwe". Pa tepiyi mu chida cha zipangizo "Makhalidwe Oyenera" dinani pa batani "Yerengani Mpangidwe".
- Mawindo amatsegulira momwe chiwerengero chonse chikufotokozedwa. Sakani batani "Yerengani" ndipo yang'anani kupyolera mu sitepe ya chiwerengero. Tikuyang'ana zolakwitsa ndikuzikonza.
Monga mukuonera, zifukwa zomwe Excel silingaganizire kapena molakwika ziganizo zingakhale zosiyana kwambiri. Ngati mmalo mwa kuwerengera, wogwiritsa ntchitoyo amasonyeza ntchito yakeyo, ndiye pakadali pano, mwinamwake seloyo imapangidwira ngati malemba, kapena mawonekedwe akuwonetsedwa. Ndiponso, pangakhale cholakwika mu syntax (mwachitsanzo, kupezeka kwa malo asanayambe chizindikiro "="). Ngati mutasintha deta mu maselo okhudzana ndi zotsatirazi sizinasinthidwe, ndiye muyenera kuyang'ana momwe kusinthidwa kwasinthidwe kumakhazikitsira m'buku. Ndiponso, nthawi zambiri, mmalo mwa zotsatira zolondola, cholakwika chikuwonetsedwa mu selo. Pano muyenera kuwona malingaliro onse omwe atchulidwa ndi ntchitoyi. Ngati cholakwika chikupezeka, chiyenera kukhazikitsidwa.
