Momwe mungagwiritsire digiri pamtunda

Anonim

Momwe mungagwiritsire digiri pamtunda

Ngati, mmalo mwa kuphatikiza chithunzi cha digiri pamwamba pa nambalayo, muyenera kupanga nambala inayo, gwiritsani ntchito malembawo, pomwe amafotokoza momwe mungagwiritsire ntchito pogwiritsa ntchito njira zogwiritsira ntchito njira.

Werengani zambiri: kukhazikitsa nambala mu Microsoft Excel

Njira 1: Kusintha Kulembetsa Nambala

Njira yowonjezera yowonjezera digiri imasinthidwa kuti ilembetse kuti ikuwonetsedwa pamwamba, yomwe imakumana ndi zomwe zimakhazikitsidwa. Ndipo ngakhale izi ndizogwira ntchito mwachangu, sinthani khungu lililonse, komwe kuli nambala yomwe imafunikira kuwonetsedwa ngati digiri.

  1. Choyamba, kanikizani batani lakumanzere pa cell kuti musankhidwa, kenako ndikuyika menyu yotsika mu "Nambala" ya "nambala" ya "yomwe ili ndi mawonekedwe a cell.
  2. Sankhani cell kuti musinthe mawonekedwe ake mukamawonjezera digiri imodzi kuchokera kumwamba kuti muwonjezere

  3. Mmenemo, sankhani njira ya "lembalo". Ngati khungu liwonetsedwa ngati nambala, silingathe kukwaniritsa kusintha kwina, kotero sitepe iyi ndiyofunika.
  4. Kusintha mawonekedwe a maselo musanawonjezere digiri imodzi kuchokera kumwamba kuti muwonjezere

  5. Tsopano chiritsani LKM ndikuwunika kwambiri ndi chiwerengero chomwe mukufuna kusankha digiriyi. Ngati zikusowabe, ingolembetsani popanda malo angapo.
  6. Kusankhidwa kwa manambala kuti muwonjezere kusintha kwa dzanja la dzanja la dzanja lanu

  7. Dinani panja-dinani ndi mndandanda womwe umapezeka, sankhani "Fomu Yanu".
  8. Kusintha kukhazikitsa mtundu wa nambala yodzipatulira kuti mupange ngati digiri kuchokera pamwamba pa Excel

  9. Imangolemba chizindikiro cha Pemick mu "kusintha".
  10. Kukhazikitsa gawo la nambala pomufotokozera ngati digiri kuchokera pamwamba pa excel

  11. Ikani makonda atsopano ndikubwerera pagome, onetsetsani kuti mulingo wolondola.
  12. Kuyang'ana kuchuluka kwa manambala ngati digiri kuchokera pamwamba ndi kusintha kwamatumbo ku Excel

Njira 2: Kugwiritsa Ntchito Zolemba Zapadera

Pali zochitika zomwe njira yapitayi siyingagwiritsidwe ntchito, motero tikuwonetsa kuti mudziyankhulira nokha pogwiritsa ntchito kulowetsa chizindikiro chapadera. Zingakhale zofunikira kupeza chiwerengero choyenera chomwe chikuwonetsedwa kale kumtunda, kenako ndikungowonjezera pafoni.

Dziwani kuti patebulo ili ngati repind apamwamba mudzapeza manambala kuyambira 4 mpaka 9, ndiye kuti njira iyi siyoyenera ngati mukufuna kutchulanso lalikulu kapena cube.

  1. Dinani kuyika tabu komwe mumadina pa "zizindikiro" ndikutsegula menyu ndi zizindikiro zonse zomwe zilipo.
  2. Pitani ku gawo loti musankhe chizindikiro chapadera ngati digiri kuchokera pamwamba pa excel

  3. Kuti muchepetse patebulo ili mu "seti" yotsika, tchulani "zapamwamba komanso zotsika".
  4. Kusakaza ma zilembo apadera kuti muwonjezere digiri imodzi kuchokera pamwamba

  5. Pezani apo nambala yomwe mukufuna kugwiritsa ntchito ngati digiri, ndipo dinani kawiri kapena dinani batani la "phala".
  6. Sankhani chizindikiro chapadera kuti muwonjezere kuchokera pamwamba pa excel

  7. Tsekani tebulo ndi zilembo ndikuwona momwe digiri imawonekera mu khungu pambuyo nambala yayikulu.
  8. Kupititsa patsogolo kuwonjezera chizindikiro chapadera ngati digiri kuchokera pamwamba pa excel

Njira 3: Kuwonjezera equation

Kutha kuwonjezera equidel excel kumakupatsani mwayi wopanga masamu osiyanasiyana a masamu ndikuwayika mu tebulo. Magwiridwe a chida chomwe chimapangitsa kuti chitsimikizo chimaphatikizapo chopanda kanthu ndi nambala ndi digiri yake, zowonjezera zomwe zili zowona:

  1. Pitani ku "kuyika" tabu ndikuwonjezera "zifaniziro".
  2. Kusintha ku gawo lolowera kuti muwonjezere mawonekedwe a masamu popanga digiri mu Excel

  3. Nthawi ino sankhani "equation".
  4. Kutsegula menyu kuti muwonjezere mawonekedwe a masamu powonjezera nambala kuchokera pamwambapa kuti muwonjezere

  5. Gome lidzawoneka ngati equation yomwe itha kusunthidwa kudera lililonse, kenako tsegulani "zojambula" zotsalira.
  6. Kutsegulira kwa mapangidwe a mathengo a masamu kuwonjezera manambala kuchokera pamwamba pa excel

  7. Mwa zina zomwe zinkachitika, ndalama zawo zimatha kumvetsetsa kuti tsopano ndikofunikira kusankha "index".
  8. Kusankha kapangidwe ka masamu kuwerengera kuti uwonjezere digiri kuchokera pamwambamwamba kuti muwonjezere

  9. Mndandanda wokhala ndi malo okhala ndi otsika komanso otsika adzawonekera - kulemba digiri yomwe muyenera kusankha kaye.
  10. Kusankha kapangidwe ka kapangidwe ka kapangidwe kake kowonjezera digiri kuchokera pamwamba

  11. Nanunso, dinani pa lalikulu lomwe linawonjezera ndikulemba manambala mwa iwo.
  12. Kukonzanso kapangidwe kowonjezera mukamatchulanso kuchuluka kwa pamwambapa

  13. Gawo la mtundu wa masamu lakonzeka, koma ngati mukufuna kuwonjezera magawo ake, gwiritsani ntchito mkonzi wina wotchulidwa kumene, kusankha zinthu zoyenera.
  14. Kupititsa patsogolo kuchuluka kwa digiri imodzi kuchokera pamwamba pomwe mukukhazikitsa mawonekedwe a masamu mu Excel

Werengani zambiri