Gawoli ndi imodzi mwazinthu zinayi zomwe zimakonda kuchita. Kuwerengera kovuta kumakhala kosowa, komwe kumatha kuchita popanda iwo. Excel ili ndi magwiridwe antchito ambiri ogwiritsa ntchito masamu. Tiyeni tiwone momwe magawanidwe angapangidwire mu Excel.
Kugawa
Mu Microsoft Excel, kugawanika kumatha kuchitidwa pogwiritsa ntchito njira komanso kugwiritsa ntchito ntchito. Poterepa, manambala ndi ma adilesi amaselo amadziwika komanso amasiyana.
Njira 1: gawani manambala ndi manambala
Tsamba la Excel lingagwiritsidwe ntchito ngati mtundu wa chowerengera, kungogawa nambala imodzi ndi inzake. Kutsetsako kuyimira chizindikiro chogawa (kubwerera) - "/".
- Timalowa mu pepala lililonse laulere kapena la mzere. Timayika chikwangwani zofanana (=). Tikulemba pa kiyibodi nambala yowoneka. Timayika chogawa (/). Timayala kugawanitsa kuchokera kubulogu. Nthawi zina, pali magawano oposa amodzi. Kenako, pamaso pa gawo lililonse timayika (/).
- Kuti muwerengere ndikuwonetsa zotsatira zake pazowunikira, dinani batani Lowani.
Pambuyo pake, Excel amawerengera fomuloyo ndipo mu cell yomwe ikutchulidwa iwonetse zotsatira zake.
Kuwerengera kumachitika ndi anthu angapo, kenako motsatira momwe iwo amathandizira amachitidwa ndi pulogalamuyo malinga ndi malamulo a masamu. Ndiko kuti, choyambirira, kugawanika ndi kuchulukitsa kumachitika, ndipo pokhapokha - kuwonjezera ndi kuchotsa.
Monga mukudziwa, kugawanitsa ndi 0 ndi njira yolakwika. Chifukwa chake, poyesera kupanga kuwerengera kofananako ku Excel, zotsatira zake zidzawonekeranso "#DEL / 0!".
Phunziro: Kugwira ntchito ndi mafomu ku Excel
Njira 2: kugawa zomwe zili m'maselo
Komanso ku Excel, mutha kugawa zomwezo mu maselo.
- Timasankha mu cell momwe zotsatira za mawerengeredwe zimawonetsedwa. Timayika chikwangwani "=". Kenako, dinani malo omwe gawoli lili. Pambuyo pake, adilesi yake imawonekera mu mzere wa njira pambuyo chikwangwani zofanana. Kenako, ikani chikwangwani kuchokera pa kiyibodi "/". Dinani pa cell yomwe wogawana ikupezeka. Ngati pali ogawa angapo, monga momwe adachitira kale, timawaonetsa onse, ndikuyika chikwangwani patsogolo pa adilesi yawo.
- Kuti muchite kanthu (gawani), dinani batani "Lowani".
Mutha kuphatikiza, ngati gawo kapena gawo, pogwiritsa ntchito maadiresi onse am'manja ndi manambala amitundu.
Njira 3: Kugawa mzere ndi mzati
Kuwerengera m'matafura, nthawi zambiri ndikofunikira kugawa zomwe zili mu gawo limodzi muzolemba zachiwiri. Zachidziwikire, mutha kugawa mtengo wa foni iliyonse momwe tafotokozera pamwambapa, koma mutha kuchita izi mwachangu kwambiri.
- Sankhani khungu loyamba mu mzere momwe zotsatirazo zikuyenera kuwonetsedwa. Timayika chikwangwani "=". Dinani pa cell ya gawoli. Tikulemba chikwangwani "/". Dinani pazogawana foni.
- Dinani batani Lowanikuwerengera zotsatira.
- Chifukwa chake, zotsatira zake zimawerengeredwa, koma mzere umodzi wokha. Pofuna kuwerengera mzere wina, muyenera kuchita njira zingapo pamwambazi. Koma mutha kupulumutsa nthawi yanu mwakuwononga kamodzi. Khazikitsani cholowezera kumunsi chakumanja kwa foniyo ndi kachitidwe kake. Monga mukuwonera, chithunzi chimawoneka ngati mtanda. Amatchedwa chikhomo chodzaza. Gwirani pansi batani lakumanzere ndikukokera chikhomo mpaka kumapeto kwa tebulo.
Monga mukuwonera, izi zitachitika, njira yogawa gawo limodzi motsatana ichitidwa kwathunthu, ndipo zotsatira zake zidzawonetsedwa. Chowonadi ndi chakuti kugwiritsa ntchito chikhomo chodzaza, fomuloli imakopeka m'maselo apansi. Koma, poganizira kuti mosamalitsa maulalo onse ndi achibale, osati amtheradi, ndiye mwanjira mukamatsika, ma adilesi amaselo amasinthana ndi oyanjana oyambirirawo. Ndipo izi ndizomwe timafunikira pamlandu winawake.
Phunziro: Momwe mungachite mosamalitsa mu Excel
Njira 4: kugawa mzere ndi wokhazikika
Pali nthawi zina pamene muyenera kugawa mzere kukhala nambala yolingana - yokhazikika, ndikuwonetsa kuchuluka kogawidwa mgawo.
- Timayika chikwangwani zofanana mu cell yoyamba ya chidule chachidule. Dinani pa khungu lowoneka la mzerewu. Timayika chogawa. Kenako pamanja kuchokera ku kiyibodi timayika nambala yomwe mukufuna.
- Dinani batani Lowani. Zotsatira zowerengera mzere woyamba zikuwonetsedwa pazowunikira.
- Kuti tiwerenge zomwe mizera ina, monga momwe idalili kale, timatcha chikhomo. Mwanjira yomweyo timatambasulira pansi.
Monga mukuwonera, nthawi ino mgawanowu umachitidwanso moyenera. Pankhaniyi, mukamakopera deta ndi chikhomo chodzaza, maulalo amakhalanso acibale. Adilesi yamagawo iliyonse mzere uliwonse idasinthidwa zokha. Koma divisor ili pamenepa nambala yokhazikika, zomwe zikutanthauza kuti chuma chogwirizananso sichikugwira ntchito kwa iwo. Chifukwa chake, tidagawa zomwe zili m'maseramu nthawi zonse.
Njira 5: Kugawa mzati ndi khungu
Koma chochita ngati mukufuna kugawa mzere muzomwe zili mu foni imodzi. Zowonadi, molingana ndi mfundo ya kuyanjana kwa maulalo, magwirizano a magawikidwe ndi wogawikayo adzasunthidwa. Tiyenera kupanga adilesi ya foniyo ndi wogawana.
- Khazikitsani chidziwitso ku chipinda chachikulu kwambiri mu mzere kuti muwonetse zotsatira. Timayika chikwangwani "=". Timasankha kuyika kwa gawoli, komwe phindu losinthika limapezeka. Timayika (/). Dinani pa foni yomwe gawoli limakhala nthawi zonse.
- Pofuna kunena zofunikira mtheradi, ndiko kuti, mosalekeza, ikani chikwangwani cha dollar ($) mwanjira yotsogola yolumikizana ndi selo molunjika komanso molunjika. Tsopano adilesi iyi siyikhala yosasinthika pomwe chikhomo cha zolemba chidzakopera.
- Dinani batani Lowanikuwonetsa zotsatira za kuwerengera mzere woyamba pazenera.
- Kugwiritsa ntchito chikhomo, koperani chilinganizo muma cell otsala a mzere ndi zotsatira zonse.
Zitatha izi, zotsatira za gawo lonselo zakonzeka. Monga mukuwonera, panthawiyi, mzerewu udagawidwa kukhala cell wokhala ndi adilesi yosasinthika.
Phunziro: Zolumikizana kwathunthu ndi abale ku Excel
Njira 6: ntchito yopewera
Gawoli la Excel limathanso kuchitidwa pogwiritsa ntchito ntchito ina yotchedwa TSOGOLO. Chachilendo cha ntchitoyi ndikuti imagawana, koma popanda yotsalira. Ndiye kuti, mukamagwiritsa ntchito njira imeneyi yogawa, zotsatira zake zimakhala zochulukirapo. Nthawi yomweyo, kuzungulira kumachitika osati molingana ndi malamulo achibalo omwe amalandiridwa kawiri kawiri, koma modulus yaying'ono. Ndiye kuti, chiwerengero cha 5.8 sichingakhale 6, koma 5.
Tiyeni tiwone momwe ntchito iyi ikugwiritsidwira ntchito mwachitsanzo.
- Dinani pa foni yomwe yowerengera ikuwonetsedwa. Dinani batani "Ikani ntchito" kumanzere kwa baramu yamu formula.
- Kutsegula Fotokozerani Wizard. Mndandanda wazinthu zomwe amatipatsa, tikuyang'ana chinthu CHASTNOE. Sankhani ndikudina batani. "Zabwino".
- Ntchito yotsutsana ndi ntchito imatsegulidwa TSOGOLO. Ntchitoyi imakhala ndi mfundo ziwiri: nambala ndi chipembedzo. Adalowa m'minda ndi mayina ofanana. M'munda Chiwerengero kuyambitsa zopatsa. M'munda Wotsogolera - divisiti. Mutha kuyika nambala nambala ndi maadiresi am'melo momwe maselo amapezekamo. Pambuyo kuti mfundo zonse zalowetsedwa, dinani batani "Zabwino".
Pambuyo pa izi, ntchito TSOGOLO imagwira ntchito ndikusintha yankho mu selo yomwe idafotokozedwa gawo loyamba la njira yogawikirayi.
Mutha kuyikanso ntchito iyi pamanja popanda kugwiritsa ntchito Wizard. Matchulidwe ake ndi awa:
= PRIVATE (manambala; mbiri)
Phunziro: Ntchito Wizard ku Excel
Monga mukuwonera, njira yayikulu yogawa mu pulogalamu ya Microsoft Office ndikugwiritsa ntchito njira. Chizindikiro cha kugawanika mwa iwo ndi kuzimiririka - "/". Nthawi yomweyo, pazifukwa zina, mutha kugwiritsa ntchito ntchitoyo pakugawa. TSOGOLO. Koma, muyenera kuganizira kuti mukawerengera motere kusiyana kumapezeka popanda zotsalira, zowerengera. Nthawi yomweyo, kuzungulira kumachitika osati molingana ndi chikhalidwe chovomerezeka, koma kochepa kofunikira kwambiri.
