Njira yamtengo wapatali ndi nambala iliyonse. Ngakhale nambala yoipa nthawi zonse imakhala ndi gawo labwino. Tiyeni tipeze momwe tingawerengere mtengo wa module mu Microsoft Excel.
ABS ntchito
Kuti muŵerengere mtengo wa gawo mu Excel, pali ntchito yapadera yotchedwa ABS. Chidule cha ntchitoyi ndi chophweka: "ABS (nambala)". Kapena, njirayi ingatenge mawonekedwe akuti "ABS (adilesi ya nambala ndi nambala)".
Kuti muwerenge, mwachitsanzo, gawolo kuchokera ku nambala -8, muyenera kuyendetsa galamala kapena mu selo iliyonse pa pepala, ndondomeko yotsatirayi: "= ABS (-8)".
Kuti muwerenge, dinani ENTER. Monga mukuonera, pulogalamuyi ikuyankha ndi nambala 8.
Pali njira ina yowerengera gawoli. Ndi oyenera kwa ogwiritsira ntchito omwe sakhala akudziŵika m'maganizo osiyanasiyana. Timakani pa selo limene tikufuna kuti zotsatira zizisungidwe. Dinani pa batani "Yesani ntchito", yomwe ili kumanzere kwa bar.
Function Wizard yayamba. Mu mndandanda, umene uli mmenemo, muyenera kupeza ntchito ABS, ndipo musankhe. Kenako dinani batani "OK".
Ntchito yotsutsana yenera ikutsegula. Ntchito ya ABS imakhala ndi mtsutso umodzi - nambala. Timalowa. Ngati mukufuna kutenga nambala kuchokera ku deta yosungidwa mu selo la chikalatacho, dinani pa batani yomwe ili kumanja kwa mawonekedwe olowera.
Pambuyo pake, zenera likuchepetsedwa, ndipo muyenera kudinkhani pa selo yomwe ili ndi nambala yomwe mukufuna kuwerengera. Pambuyo pa nambalayi, dinani kachiwiri pa batani kupita kumanja kwa gawo lopatsidwa.
Zenera lomwe limagwira ntchito limayambanso. Monga mukuonera, munda wa "Number" uli ndi mtengo. Dinani pa batani "OK".
Pambuyo pazimenezi, nambala ya nambala yomwe mwasankha ikuwonetsedwa mu selo yomwe munayimilira poyamba.
Ngati mtengo uli patebulo, ndiye kuti njira yamakono ingakopilidwe kwa maselo ena. Kuti muchite izi, muyenera kuima kumbali ya kumanzere ya selo, momwe muli kale ndondomeko, gwiritsani pansi batani ndi kuikweza mpaka kumapeto kwa tebulo. Kotero, mu ndime iyi, mtengo wa modulo womwe deta ya deta idzawonekera mu maselo.
Ndikofunika kuzindikira kuti ena ogwiritsa ntchito amayesa kulemba gawo, monga mwambo mu masamu, ndiko, | (nambala) |, mwachitsanzo | -48 |. Koma, poyankhidwa, amapeza cholakwika, chifukwa Excel samvetsa mawuwa.
Monga mukuonera, palibe chovuta kuwerengera gawo kuchokera ku chiwerengero ku Microsoft Excel, chifukwa ichi chikuchitidwa pogwiritsa ntchito ntchito yosavuta. Chinthu chokha ndichokuti muyenera kungodziwa ntchitoyi.
