Kugawa kopambana: 6 Zosankha zosavuta

Mu Microsoft Excel, magawano amatha kupangidwa mothandizidwa ndi njira zopangira ndikugwiritsa ntchito ntchito. Kusakanitsa ndi kusanja kwa manambala ndi maodiwo.

Njira 1: Chiwerengero cha chiwerengerochi

Mapepala apamwamba amatha kugwiritsidwa ntchito ngati mtundu wa zowerengera, kungogawana nambala ina. Chizindikiro cha gulu la Slash (mzere wosinthika) - "/".

1. Timakhala mu khungu lililonse laulere la pepalalo kapena chingwe. Timayika chikwangwani "chofanana" (=). Timalemba nambala yolimba kuchokera pa kiyibodi. Ikani chizindikiro cha magawano (/). Timalembanso gawo la kiyibodi. Nthawi zina, agalu ndi oposa amodzi. Kenako, wogawana aliyense, timayika slash (/).



2. Kuti mupange kuwerengera ndipo kutulutsa zotsatira zake pa polojekiti, timadina batani la Enter.

Pambuyo pake, kuchuluka kwa exprel kumawerengetsa fomula ndipo kwa selo yomwe yatchulidwa idzatulutsa chifukwa cha kuwerengera.

Ngati kuwerengera kumapangidwa ndi zilembo zingapo, ndiye kuti dongosolo la kuphedwa kwawo limapangidwa ndi pulogalamuyo malinga ndi malamulo a masamu. Choyamba, choyambirira, magawikidwe ndi kuchulukitsa chimachitika, kenako kuwonjezera ndi kuchotsera.

Monga momwe amadziwira, kugawa 0 ndi cholondola. Chifukwa chake, poyesa kuwerengera bwino kwambiri mu khungu, zotsatira zake "# del / 0!" Idzawonekera.

Phunziro: Gwirani ntchito ndi njira zambiri

Njira 2: Kugawa zomwe zili m'maselo

Komanso mutha kugawanitsa deta mu maselo.

1. Tigawane mu seloyo momwe zimachitikira kuwerengera kuwonetsedwa. Tidayiyika chikwangwani "=". Kupitilira apo, dinani pamalo pomwe derri ili. Adilesiyi imawonekera mu mawonekedwe pambuyo pa chikwangwani "ofanana." Kenako, mumakhazikitsa chikwangwani cha "/". Dinani pa selo yomwe gawo limakhala. Ngati miliri ili mwanjira ina, monga m'mbuyo, timawatchula onse, ndipo asanabadwe ma adilesi awo, adayika chizindikiro cha magawanoli.



2. Pofuna kupanga chochita (magawano), dinani pa batani "Lowani".

Muthanso kuphatikiza, monganso kugawa kapena sloider pogwiritsa ntchito ma adilesi a cell amodzi ndi manambala wamba.

Njira 3: Gawani gawo pa mzere

Kuti muwerenge m'matebulo, mfundo za mzere umodzi nthawi zambiri zimafunikira kugawa deta yachiwiri. Zachidziwikire, mutha kugawana mtengo wa khungu lililonse munjira yomwe yawonetsedwa pamwambapa, koma mutha kupanga njirayi mwachangu mwachangu.

1. Sankhani selo yoyamba kumbali yomwe ikuyenera kuwonetsedwa. Timayika chikwangwani "=". Dinani pa selo logawika. Timalemba chikwangwani "/". Dinani pa cell yao.



2. Dinani pa batani la Enter kuti muwerenge zotsatira zake.



3. Chifukwa chake, zotsatira zake zimawerengedwa, koma mzere umodzi wokha. Pofuna kuwerengera m'mizere ina, muyenera kuchita zomwe zili pamwambapa. Koma mutha kuwononga nthawi yanu mwakungochita chipongwe chimodzi. Khazikitsani cholembera kumanzere kwa cell ndi formula. Monga mukuwonera, chithunzi chimawonekera mu mawonekedwe a mtanda. Amatchedwa chizindikiritso chodzaza. Dinani batani la Mouse kumanzere ndikukoka chizindikiro chakumapeto kwa tebulo.

Monga tikuwonera, zitatha izi, njira yogawika gawo limodzi lachiwiri lidzathetsedwa kwathunthu, ndipo zotsatira zake zimachotsedwa mu gawo lina. Chowonadi ndi chakuti kudzera mu cholembera chodzaza, mawonekedwe amajambulidwa ku maselo apansi. Koma, poganizira mfundo yoti mwachisawawa, mafotokozedwe onse ndi achibale, osati amthera, ndiye kuti amasunthika, ma adilesi a maselo amasinthidwa ndi ma cell oyamba. Ndiyetu, izi ndizofunikira kwa ife chifukwa cha zomwe zinachitika.

Phunziro: Momwe Mungapangire Autocomple

Njira 4: Chisankho Cholinga Chokhalapo Nthawi Zonse

Pali zochitika pakafunika kugawanitsa mzerewo pa nambala yomwe imakhazikika - yosasinthika, ndikuchotsa kuchuluka kwa magawano kukhala gawo lina.

1. Timayika chikwangwani "ofanana" mu selo loyambirira la mzere wonse. Dinani pa selo logawanika la chingwe. Ikani chizindikiro cha magawano. Kenako pamanja ndi kiyibodi kuyika nambala yomwe mukufuna.



2. Dinani batani lolemba. Zotsatira za kuwerengetsa chingwe choyamba zimawonetsedwa pa wowunikira.



3. Pofuna kuwerengera mfundo zina, monga kale, itanani chizindikiro chodzaza. Momwemonso, tambasulani.

Monga tikuwona, nthawi ino magawano ndilolondola. Pankhaniyi, pokopera deta, Chizindikirocho chinakhalabe wachibale. Adilesi yogawika pamzere iliyonse idasinthidwa. Koma wogawayo ali pachiwopsezo chachikulu, zomwe zikutanthauza kuti chuma choyanjana sichimagwira ntchito kwa icho. Chifukwa chake, tidagawa zomwe zili mu mzere wa zilondazo kwa nthawi zonse.

Njira 5: Chisankho cholembera pa cell

Koma choti ndichite ngati mukufuna kugawanitsa mzere wa cell imodzi. Kupatula apo, malinga ndi mfundo za kuphunzitsidwa bwino, zogwirizana za kugawanika ndi ulomo zidzasunthidwa. Tiyenera kupanga adilesi ya selo yomwe ili ndi malo okhazikika.

1. Ikani chotemberero kwa selo lopambana kwambiri kuti liwonetse zotsatira zake. Timayika chikwangwani "=". Dinani pa gawo la kugawanika, pomwe pali mtengo wosinthika. Timayika slash (/). Dinani pa selo yomwe gawo lokhazikika limapezeka.



2. Kuti afotokozere za gawo loyambira, ndiye kuti, amasungunuka chizindikiro ($) mu formula ($) mu formula a contradings a cell molimba komanso molunjika. Tsopano adilesiyi ipitilira pokopera chizindikiro chodzaza sichisintha.



3. Tadina batani la Enter kuti muwonetse zowerengera pamzere woyamba pazenera.



4. Pogwiritsa ntchito cholembera chodzaza, koperani njira yomwe ili m'manja mwake.

Pambuyo pake, zotsatira zake zilipo ndi gawo lonse. Monga tikuonera, pankhaniyi, mzatiwo udagawidwa mu cell wokhala ndi adilesi yokhazikika.

Phunziro: Maulalo ndi ogwirizana ndi ogwirizana

Njira 6: Ntchito Yachinsinsi

Kutumiza ndalama zambiri kungachitikenso pogwiritsa ntchito ntchito yapadera yotchedwale. Zovuta za izi ndikuti zimagawanika, koma popanda zotsalira. Ndiye kuti, mukamagwiritsa ntchito njirayi yogawa zotsatira zake, nthawi zonse pamakhala ziwerengero. Nthawi yomweyo, kuzungulira sikusinthidwa malinga ndi malamulo a masamu omwe alandila ku chiwerengero chapafupi, koma kwa gawo laling'ono. Ndiye kuti, ntchito ya nambala 5.8 siyifika mpaka 6, ndi 5.

Tiyeni tiwone kugwiritsa ntchito gawoli pachitsanzo.

1. Dinani pa Selo, komwe zotsatira za kuwerengera zidzawonetsedwa. Dinani pa batani la "Inning" kumanzere kwa chingwe.



2. Wizard akutsegula. Pamndandanda wa ntchito zomwe zimatipatsa, tikufuna chinthu "zachinsinsi". Tikutsindika ndikusindikiza batani la "OK".



3. Kuyikana pazenera lotseguka. Izi zili ndi mikangano iwiri: Wolemba manambala ndi chipembedzo. Amayambitsidwa m'minda yomwe ili ndi mayina ofanana. Mu "munda wa" Wolemba "timalowa ku Delmi. Mu gawo la "ngozi" - wogawana. Mutha kulowa manambala onse ndi ma adilesi a maselo omwe data ili. Pambuyo pa zonse zomwe zalembedwa, dinani batani la "OK".

Pambuyo pa zochita izi, mawonekedwe achinsinsi amapanga kukonza kwa deta ndikupereka yankho ku khungu, lomwe limawonetsedwa mu gawo loyamba la njira yogawa iyi.

Izi zitha kulowetsedwanso pamwazi popanda kugwiritsa ntchito wizard. Syntax yake imawoneka motere:

= Zachinsinsi (manambala; chipembedzo)

Phunziro: Mzere wa Wizard mu Excel

Monga tikuwona, njira yayikulu yogawitsira pulogalamu ya Microsoft ndi kugwiritsa ntchito njira. Chizindikiro cha kutsika mwa iwo ndi chipolopolo - "/". Nthawi yomweyo, pazifukwa zina, ndizotheka kugwiritsa ntchito ntchito zachinsinsi m'magawo. Koma, ndikofunikira kuganizira motere powerengera motere, kusiyana kwake kumapezeka popanda zotsalira, nambala. Nthawi yomweyo, kuzungulira sikupangidwa ndi miyezo yovomerezeka, koma kwa gawo laling'ono mu manambala.