Module ndi mtengo wofunikira zedi wa chiwerengero chilichonse. Ngakhale nambala yolakwika imakhala ndi modulus yabwino. Tiyeni tiwone momwe mungawerengere kukula kwa gawo mu Microsoft Excel.
Ntchito ya ABS
Pali ntchito yapadera yotchedwa ABS yowerengera kukula kwa gawo mu Excel. Syntax yantchitoyi ndi yosavuta: "ABS (nambala)". Kapena, fomuloli itha kukhala "ABS (cell_address_with_number)".
Kuti muwerenge, mwachitsanzo, modulus ya manambala -8, muyenera kuyendetsa mumzere wa formula kapena mu khungu lililonse papepala, kachitidwe kotsatira: "= ABS (-8)".
Kuti muwerenge, dinani batani la ENTER. Monga mukuwonera, pulogalamuyi imayankha moyenera nambala ya 8.
Pali njira inanso yowerengetsera gawo. Ndizoyenera kwa ogwiritsa ntchito omwe samazolowera kusunga mitu yawo m'mitu yawo. Timadula mu cell momwe tikufuna kuti zotsatira zisungidwe. Dinani pa batani la "Insert Function" lomwe lili kumanzere kwa barula ya fomula.
Windo la Ntchito Wizard liyamba. Pamndandanda womwe uli mmenemo, muyenera kupeza ntchito ya ABS, ndikuwunikira. Kenako dinani batani "Chabwino".
Ntchito yotsutsana ndi ntchito imatsegulidwa. Ntchito ya ABS ili ndi mkangano umodzi wokha - chiwerengero. Timayambitsa. Ngati mukufuna kutenga nambala kuchokera ku deta yomwe imasungidwa mu cell iliyonse ya chikalatacho, dinani batani lomwe lili kumanja kwa fomuyo.
Pambuyo pake, zenera limachepetsedwa, ndipo muyenera dinani foni yomwe ili ndi nambala yomwe mukufuna kuwerengera gawo. Pambuyo kuchuluka kwa manambala, dinani batani kumanja kwa gawo lolowera.
Zenera lokhala ndi mfundo zotsutsana limayambiranso. Monga mukuwonera, gawo la Nambala limadzaza ndi mtengo. Dinani pa "Chabwino" batani.
Kutsatira izi, mu foni yoonetsedwa kale, mtengo wa nambala yomwe mwasankha umawonetsedwa.
Ngati mtengo wake uli patebulopo, mafomulewo angapangidwe pamaselo ena. Kuti muchite izi, muyenera kuyimirira pakona yakumanzere kwa foni momwe muli fomula kale, gwiritsani batani la mbewa, ndikuyikoka mpaka kumapeto kwa tebulo. Chifukwa chake, m'ndime iyi m'maselo maselo ofotokozera omwe amapezeka amapezeka.
Ndikofunikira kuzindikira kuti ogwiritsa ntchito ena amayesa kulemba gawo, monga momwe zimakhalira masamu, ndiye, | (nambala) |, mwachitsanzo | -48 |. Koma, poyankha, amapeza cholakwika, chifukwa Excel samamvetsetsa izi.
Monga mukuwonera, palibe chovuta kuwerengera gawo kuchokera ku Microsoft Excel, popeza izi zimachitika pogwiritsa ntchito ntchito yosavuta. Chokhacho ndikuti muyenera kungodziwa ntchito iyi.
