Momwe mungasinthire chiwerengerocho kuchokera kwa Eale

Pulogalamu yapamwamba pogwiritsa ntchito chida chotere, monga crumula, limalola zochitika zingapo za masamu pakati pa deta m'maselo. Zochita zimaphatikizapo kuchotsa. Tiyeni tisanthule mwatsatanetsatane mwatsatanetsatane njira zomwe zingapangitse kuwerengeraku.

Gwiritsani Ntchito Kuchotsa

Kuchotsa bwino ntchito kungagwiritsidwe ntchito manambala apadera ndi ma adilesi a maselo omwe data ili. Kuchita izi kumachitika chifukwa cha njira zapadera. Monga kuwerengera kwina kokhala mu pulogalamuyi, chizolowezi chofuka chisanachitike, muyenera kukhazikitsa chikwangwani chofanana ndi (=). Kenako ochepetsedwa (mu mawonekedwe a nambala kapena adilesi ya selo), minus (-) chizindikiro choyambirira (mu mawonekedwe a nambala kapena adilesi ina pambuyo pake?

Tiyeni tikambirane zitsanzo za zitsanzo za momwe arrithmetic amachitidwa mwachangu.

Njira 1: Kuphatikiza manambala

Chitsanzo chophweka ndi kulandidwa kwa manambala. Pankhaniyi, machitidwe onse amachitidwa pakati pa manambala enieni monga mu calturm yachilendo, osati pakati pa maselo.

1. Sankhani khungu lililonse kapena kukhazikitsa cholozera mu Chingwe cha Formula. Timayika chikwangwani "ofanana." Tidasindikiza zotsatira za masamu ndi kuchotsera, monga momwe timachitira papepala. Mwachitsanzo, lembani njira yotsatirayi:

   = 895-45-69



2. Pofuna kupanga njira yowerengera, kanikizani batani la Enter pa kiyibodi.

Izi zitapangidwa, zotsatira zake zimawonetsedwa mu khungu lomwe lasankha. Monga momwe, ili ndi nambala 781. Ngati mwagwiritsa ntchito deta ina yowerengera, motero, zotsatira zanu zidzakhala zosiyana.

Njira 2: Kuchotsa manambala kuchokera ku maselo

Koma, monga mukudziwa, Excel ndi, woyamba, pulogalamu yogwirira ntchito matebulo. Chifukwa chake, ma opareshoni okhala ndi maselo amasewera ofunika kwambiri. Makamaka, atha kugwiritsidwa ntchito pochotsa mankhwalawa.

1. Tikutsindika maselo omwe chizolowezi choperewera chidzakhala. Timayika chikwangwani "=". Dinani pa cell yomwe ili ndi deta. Monga mukuwonera, zitachitika izi, adilesi yake imalowetsedwa mu chingwe cha fomula ndikuwonjezera chizindikiro cha "ofanana". Timasindikiza nambala yomwe muyenera kuchotsa.



2. Monga momwe zidayambira kale, kuti mupeze zotsatira za kuwerengetsa, kanikizani batani la Enter.

Njira 3: Selo limodzi loyeretsa

Mutha kuchititsapo zopopa ndipo nthawi zambiri osakhala ndi manambala, kupusitsa ma adilesi ndi deta. Mfundo yochita ndizofanana.

1. Sankhani foni kuti iwonetse zotsatira za kuwerengera ndikuyika "ofanana". Dinani pa cell yomwe ili ndi yochepetsedwa. Timayika chizindikirocho "-". Dinani pa cell yomwe ili ndi zowononga. Ngati opareshoniyo iyenera kuchitika ndi zingapo zotsika, kenako yikani chizindikiro cha "minus" ndikuchita zomwezo.



2. Pambuyo pa deta yonse yaikidwa, chifukwa chotulutsa chotsatira, dinani batani la Lowetsani.

Phunziro: Gwirani ntchito ndi njira zambiri

Njira 4: Kukonzekera Kugwira Ntchito Yapakatikati

Nthawi zambiri, pogwira ntchito ndi pulogalamu yopambana, zimachitika kuti ndikofunikira kuwerengera kuchotsera mbali yonse ya maselo pachipinda china. Zachidziwikire, ndizotheka kuti chilichonse chizichita kulemba njira yosiyana, koma zimatenga nthawi yayitali. Mwamwayi, magwiridwe antchito amagwiritsa ntchito amatha kugwira ntchito kwambiri kuwerengera, chifukwa cha ntchito ya autofile.

Pa chitsanzochi, timawerengera phindu la bizinesi m'malo osiyanasiyana, kudziwa ndalama zonse ndi mtengo wopangidwa. Pa izi, ndalamazo ziyenera kuwululidwa.

1. Timagawana khungu lapamwamba kwambiri kuti muwerenge phindu. Timayika chikwangwani "=". Dinani pa cell yomwe ili ndi mtengo wofanananso. Timayika chizindikirocho "-". Tikutsindika khungu ndi mtengo wake.



2. Pofuna kutulutsa phindu pamzerewu pazenera, dinani batani la Enter.



3. Tsopano tikufunika kukopera formula iyi mumitundu yotsika kuti iwerengere. Kuti tichite izi, timayika cholozera kumanja kwa khungu lomwe lili ndi formula. Chizindikiro chodzaza chikuwonekera. Tikudina batani la mbewa lamanzere komanso mu cungung povuta pokoka cholembera mpaka kumapeto kwa tebulo.



4. Monga mukuwonera, izi zitatha izi, njirayi idakopera pamtunda wonse pansipa. Nthawi yomweyo, chifukwa cha malowa, monga kuphunzitsidwa ma adilesi, izi zidachitika chifukwa chosamuka, chomwe chinapangitsa kuti zitheke kuwerengetsa kolondola komanso m'maselo oyandikana nawo.

Phunziro: Momwe Mungapangire Autocomple

Njira 5: Kuchotsa Kwapa Aips Kuchimwa cha selo imodzi kuchokera pamtunda

Koma nthawi zina muyenera kuchita izi, kuti adilesi siyisintha pokopera, koma osasinthika, polozera khungu. Momwe mungachitire izi?

1. Timakhala mu khungu loyamba kuti zitheke chifukwa cha kuchuluka kwa mitundu. Timayika chikwangwani "ofanana." Dinani pa selo yomwe imachepetsedwa. Ikani chizindikiro "minus". Timakhala ndi dinani pa foni yopulumuka m'selo, adilesi ya zomwe siziyenera kusinthidwa.



2. Ndipo tsopano tikutembenukira ku kusiyana kwakukulu kwa njirayi kuyambira kale. Ndi izi zotsatirazi zomwe zimakupatsani mwayi kutembenuza ulalo kuchokera kwa wachibale. Tinaika chikwangwani cha dollar kutsogolo kwa malo ofukula ndi chopingasa cha selo yomwe adilesi yawo siyenera kusintha.



3. Dinani pa kiyibodi pa kiyi ya ENTER, yomwe imakupatsani mwayi wonena kuti muwerengere mzerewo pazenera.



4. Kuti mupange kuwerengera komanso mizere ina, chimodzimodzi monga momwe zidakhalira, timatcha cholembera ndikukokera pansi.



5. Monga tikuwona, njira zoperewera zopsinjika zidapangidwa ndendende momwe tikufunira. Ndiye kuti, pomusamutsa adilesi yazotsirizira deta yasinthidwa, koma kuchotsedwapo kosasinthika.

Chitsanzo pamwambapa ndi mlandu wapadera. Mofananamo, zitha kuchitika mosiyana ndi izi, kotero kuti kuchepetsedwa kumapitilirabe, ndipo kuchotsedwa ntchito zidalibe.

Phunziro: Maulalo ndi ogwirizana ndi ogwirizana

Monga mukuwonera, pakukula kwa njira zopulumutsidwira mu pulogalamu ya Excel palibe vuto. Imachitika molingana ndi malamulowa monga kuwerengera kwina kogwiritsa ntchito. Kudziwa zina zosangalatsa kumapangitsa kuti wogwiritsa ntchitoyo azitha kukonza masamu a masamu ambiri, omwe adzapulumutse nthawi yake.