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.
- Choyamba, kanikizani batani lakumanzere pa cell kuti musankhidwa, kenako ndikuyika menyu yotsika mu "Nambala" ya "nambala" ya "yomwe ili ndi mawonekedwe a cell.
- Mmenemo, sankhani njira ya "lembalo". Ngati khungu liwonetsedwa ngati nambala, silingathe kukwaniritsa kusintha kwina, kotero sitepe iyi ndiyofunika.
- Tsopano chiritsani LKM ndikuwunika kwambiri ndi chiwerengero chomwe mukufuna kusankha digiriyi. Ngati zikusowabe, ingolembetsani popanda malo angapo.
- Dinani panja-dinani ndi mndandanda womwe umapezeka, sankhani "Fomu Yanu".
- Imangolemba chizindikiro cha Pemick mu "kusintha".
- Ikani makonda atsopano ndikubwerera pagome, onetsetsani kuti mulingo wolondola.
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.
- Dinani kuyika tabu komwe mumadina pa "zizindikiro" ndikutsegula menyu ndi zizindikiro zonse zomwe zilipo.
- Kuti muchepetse patebulo ili mu "seti" yotsika, tchulani "zapamwamba komanso zotsika".
- Pezani apo nambala yomwe mukufuna kugwiritsa ntchito ngati digiri, ndipo dinani kawiri kapena dinani batani la "phala".
- Tsekani tebulo ndi zilembo ndikuwona momwe digiri imawonekera mu khungu pambuyo nambala yayikulu.
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:
- Pitani ku "kuyika" tabu ndikuwonjezera "zifaniziro".
- Nthawi ino sankhani "equation".
- Gome lidzawoneka ngati equation yomwe itha kusunthidwa kudera lililonse, kenako tsegulani "zojambula" zotsalira.
- Mwa zina zomwe zinkachitika, ndalama zawo zimatha kumvetsetsa kuti tsopano ndikofunikira kusankha "index".
- Mndandanda wokhala ndi malo okhala ndi otsika komanso otsika adzawonekera - kulemba digiri yomwe muyenera kusankha kaye.
- Nanunso, dinani pa lalikulu lomwe linawonjezera ndikulemba manambala mwa iwo.
- Gawo la mtundu wa masamu lakonzeka, koma ngati mukufuna kuwonjezera magawo ake, gwiritsani ntchito mkonzi wina wotchulidwa kumene, kusankha zinthu zoyenera.