Gawoli ndi limodzi mwa magawo anayi omwe amagwiritsidwa ntchito kwambiri. Kawirikawiri pali ziwerengero zovuta zomwe zingachitike popanda iye. Excel ili ndi ntchito zosiyanasiyana kuti mugwiritse ntchito masamu. Tiyeni tipeze momwe tingachitire kugawidwa mu Excel.
Kupanga magawano
Mu Microsoft Excel, magulu angapangidwe pogwiritsa ntchito machitidwe kapena ntchito. Kuwoneka ndi kulongosola ndi nambala ndi maadiresi a maselo.
Njira 1: kugawa nambala ndi nambala
Pulogalamu yachitsulo ikhoza kugwiritsidwa ntchito monga mtundu wa calculator, kungopatula chiwerengero chimodzi ndi chimzake. Chizindikiro chogawanika ndi chipolopolo (kumbuyo kumbuyo) - "/".
- Timakhala selo iliyonse yaulere pa pepala kapena mu mzere wa zolemba. Ife timayika chizindikiro zofanana (=). Timayika chiwerengero cha chigawenga kuchokera ku kiyibodi. Timayika chizindikiro (/). Timayika wagawanika kuchokera ku kiyibodi. Nthaŵi zina, pali alangizi oposa mmodzi. Kenaka, ikani mchenga pamaso pa wogawa aliyense. (/).
- Kuti mupange mawerengedwe ndi kusonyeza zotsatira zake pa pulogalamuyi, dinani pa batani. Lowani.
Pambuyo pake, Excel idzawerengera ndondomekoyi ndikuwonetsa zotsatira za mawerengedwe mu selo losankhidwa.
Ngati chiwerengerocho chikupangidwa ndi zilembo zingapo, ndiye kuti dongosolo lawo likuphedwa ndi pulogalamuyo malinga ndi malamulo a masamu. Izi ndizo, poyamba pa zonse, kugawa ndi kuchulukitsa kumachitidwa, ndipo pokhapo kuwonjezera ndi kuchotsa.
Monga mukudziwira, kugawa ndi 0 ndizolakwika. Choncho, poyesera kupanga mawerengero ofanana mu Excel, zotsatirazo zidzawonekera mu selo "#DEL / 0!".
Phunziro: Gwiritsani ntchito mayina mu Excel
Njira 2: Kugawa kwa maselo
Ndiponso mu Excel, mukhoza kugawana deta mu maselo.
- Sankhani selo momwe zotsatira za mawerengedwe zidzawonetsedwa. Ife timayika mu chizindikiro chake "=". Kenaka, dinani pamalo omwe gawoli lili. Pambuyo pa ichi, adilesi yake imapezeka muzenera zamtunduwu pambuyo pa chizindikiro zofanana. Kenaka, kuchokera ku kibodiboliyi yesani chizindikiro "/". Timangodutsa pa selo imene mgawanizi waikidwa. Ngati pali ogawanitsa angapo, komanso njira yomwe yapita kale, timawawonetsa onse, ndikuyika chizindikiro chogawanitsa kutsogolo kwa maadiresi awo.
- Kuti muchite zogawanika, dinani pa batani Lowani ".
Mukhozanso kuphatikiza, monga kuwonetseredwa kapena kulongosola, pogwiritsa ntchito maadiresi a selo ndi manambala amodzi palimodzi.
Njira 3: Kugawanika ndime ndi ndime
Kwa kuwerengera m'matawuni, nthawi zambiri kumafunika kugawa miyambo ya chigawo chimodzi mu deta yachiwiri. Inde, mukhoza kugawana mtengo wa selo iliyonse monga momwe tafotokozera pamwambapa, koma mungathe kuchita izi mofulumira kwambiri.
- Sankhani selo yoyamba muzitsulo kumene zotsatira ziyenera kuwonetsedwa. Ife timayika chizindikiro "=". Dinani pa selo la gawoli. Chizindikiro choyimira "/". Dinani pa wagawaniza wa selo.
- Timakanikiza batani Lowanikuti muone zotsatira.
- Choncho, zotsatira zake ziwerengedwa, koma ndi mzere umodzi. Pofuna kuchita mawerengedwe mumzere wina, muyenera kuchita masitepewa payekha. Koma mungathe kupulumutsa nthawi yanu mwa kungochita zinthu zina. Ikani cholozera pamakona a kumanja kwa seloyo ndi ndondomekoyi. Monga mukuonera, chithunzi chimapezeka mwa mawonekedwe a mtanda. Icho chimatchedwa chikalata chodzaza. Gwiritsani batani lamanzere la khofi ndikukoka gwiritsani ntchito mpaka kumapeto kwa tebulo.
Monga mukuonera, mutatha izi, ndondomeko yogawa gawo limodzi ndi yachiwiri idzachitidwa mokwanira, ndipo zotsatira zake zidzawonetsedwa mndandanda wosiyana. Chowonadi ndi chakuti mawonekedwewo amalembedwa kumaselo apansi ogwiritsa ntchito chikhomo chodzaza. Koma, poganizira kuti mwachindunji maulumikizano onse ndi ofanana, osati otheradi, ndiye mwa njira, pamene mukuyenda pansi, maadiresi a selo amasintha mogwirizana ndi makonzedwe oyambirira. Zili choncho, ichi ndi chimene tikusowa pachifukwa china.
Phunziro: Momwe mungapangire autocomplete mu Excel
Njira 4: Kugawanika mzere ndi nthawi zonse
Pali zifukwa pamene kuli kofunika kugawa gawo limodzi ndi chiwerengero chimodzimodzi - nthawi zonse, ndipo chikutulutsa chiwerengero cha magawanowo kukhala gawo limodzi.
- Ife timayika chizindikiro zofanana mu selo yoyamba ya chigawo chomaliza. Dinani pa selo logawanika la mzere uno. Ife tikuyika chizindikiro chogawanitsa. Ndiye pamanja ndi kiyibodi muike nambala yomwe mukufuna.
- Dinani pa batani Lowani. Zotsatira za chiwerengero cha mzere woyamba zikuwonetsedwa pazong'onoting'ono.
- Pofuna kuwerengera miyeso ya mizere ina, monga kale, timayitana chizindikiro chodzaza. Mu ndendende momwemo timagwiritsira ntchito.
Monga mukuonera, nthawi ino magawanowa akuchitiranso molondola. Pankhani iyi, pamene mukujambula deta ndi chizindikiro chodzaza, maulumikizanowo adakhalabe achibale. Adilesi ya gawoli pamzere uliwonse imasinthidwa. Koma wogawanika ali mu nambalayi nthawi zonse, zomwe zikutanthauza kuti katundu wa kugwirizana sikugwiranso ntchito kwa izo. Motero, tagawaniza zomwe zili mu maselo a chigawo kukhala nthawi zonse.
Njira 5: Kugawa gawo mu selo
Koma choti muchite ngati mukufuna kugawa gawolo muzomwe zili mu selo limodzi. Pambuyo pa zonse, malinga ndi mfundo yokhudzana ndi kufotokozera, zigawo zogwirizanitsa ndi otsogolera zidzasintha. Tiyenera kupanga adilesi ya selo ndi wotsogolera.
- Ikani cholozera mu selo chapamwamba kwambiri kuti muwonetse zotsatira. Ife timayika chizindikiro "=". Dinani pa malo a chigawenga chimene mtengo wosiyanasiyana ulipo. Timayika (/). Ife timangodutsa pa selo imene mgawanitsi wowonjezera aikidwa.
- Pofuna kutanthawuzira kugawikana kwathunthu, ndiko kuti, nthawi zonse, timayika chizindikiro cha dola ($) mu ndondomeko isanayambe makonzedwe a selo lozungulira ndi lozungulira. Tsopano adilesi iyi idzasintha pamene mukujambula ndi chizindikiro chodzaza.
- Timakanikiza batani Lowani, kusonyeza zotsatira za kuwerengera pa mzere woyamba pawindo.
- Pogwiritsira ntchito chikhomo chodzaza, lembani fomuyi kumaselo otsalira a chigawocho ndi zotsatira zake zonse.
Pambuyo pake, zotsatira zazomwe zili m'kaundula zili zokonzeka. Monga mukuonera, pankhaniyi panali kusiyana pakati pa ndimeyo mu selo ndi adiresi yoyenera.
Phunziro: Mtheradi ndi wachibale zimalumikizana ku Excel
Njira 6: ntchito PRIVATE
Kugawidwa kwa Excel kungachitenso ntchito pogwiritsa ntchito ntchito yapadera yotchedwa PRIVATE. Chidziwikiritso cha ntchitoyi ndi chakuti imagawanika, koma yopanda malire. Izi zikutanthauza kuti mukamagwiritsa ntchito njirayi yogawikana, zotsatira zake zidzakhala nthawi zonse. Pa nthawi yomweyi, kumangidwe sikuchitika molingana ndi malamulo ovomerezeka a masamu kupita kufupi kwambiri, koma kwazing'ono. Ndikokuti, chiwerengero cha 5.8 sichikuzungulira mpaka 6, koma ku 5.
Tiyeni tiwone kugwiritsa ntchito ntchitoyi mwachitsanzo.
- Dinani mu selo komwe chiwerengero cha chiwerengero chidzawonetsedwa. Timakanikiza batani "Ikani ntchito" kumanzere kwa bar.
- Kutsegulidwa Mlaliki Wachipangizo. Mundandanda wa ntchito zomwe zimatipatsa, yang'anani chinthucho "WOPHUNZITSIDWA". Sankhani ndipo dinani pa batani. "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. PRIVATE. Ntchitoyi ili ndi zifukwa ziwiri: chiwerengero ndi chipembedzo. Iwo alowa m'munda ndi mayina oyenerera. Kumunda Nambala lowetsani gawoli. Kumunda Chipembedzo - wogawa. Mukhoza kulumikiza manambala ndi maadiresi enieni a maselo omwe deta ilipo. Zonsezi zitatha, dinani pa batani "Chabwino".
Zitatha izi, ntchitoyo PRIVATE amayendetsa deta ndikupanga yankho ku selo lomwe linatchulidwa muyeso yoyamba ya njirayi yopatukana.
Ntchitoyi ingathenso kulowa mwadongosolo popanda kugwiritsa ntchito wizard. Mawu ake omasulira ndi awa:
= PRIVATE (chiwerengero; chipembedzo)
Phunziro: Wowonjezera Wogwira Ntchito
Monga momwe tikuonera, njira yayikulu yopatulira pulogalamu ya Microsoft Office ndiyo kugwiritsa ntchito mafomu. Chizindikiro chogawanitsa mwa iwo ndi slash - "/". Pa nthawi yomweyi, pazinthu zina, ntchitoyi ingagwiritsidwe ntchito pogawa PRIVATE. Koma, m'pofunika kukumbukira kuti pakuwerengera mwanjira iyi, kusiyana komweku kumapezedwa popanda chotsalira, ngati nambala. Panthawi imodzimodziyo, kuzungulira sikuchitika molingana ndi zikhalidwe zomveka bwino, koma ku intekiti yaing'ono pamtengo wapatali.
