Ntchito yomanga bwino

Chimodzi mwazinthu zomwe zimagwiritsidwa ntchito pafupipafupi zomwe zimagwiritsidwa ntchito ndi mainjiniya komanso kuwerengera zina ndi njira ya nambala yachiwiri, yomwe imasiyana mu lalikulu. Mwachitsanzo, njirayi imawerengera dera la chinthu kapena chithunzi. Tsoka ilo, palibe chida chosiyana mu pulogalamu yopambana yomwe ingapangitse nambala yotchulidwa mu lalikulu. Komabe, opaleshoniyi imatha kuchitidwa pogwiritsa ntchito zida zomwezi zomwe zimagwiritsidwa ntchito pomanga digiri iliyonse. Tiyeni tiwone momwe mungagwiritsire ntchito kuwerengetsa lalikulu kuchokera ku nambala yomwe yatchulidwa.

Njira Yomanga Yomanga

Monga mukudziwa, lalikulu la manambala limawerengeredwa ndi kuchulukitsa kwake. Mfundozi mwachilengedwe zimayang'aniridwanso kuwerengera kwa chisonyezo chodziwika bwino. Mu pulogalamuyi, titha kupanga nambala mu lalikulu munjira ziwiri: pogwiritsa ntchito chizindikiro cha zolimbitsa thupi mpaka muyezo wofikira pamapulogalamu "^" ndikugwiritsa ntchito digiriyi. Ganizirani za algorithm yogwiritsa ntchito njira izi pofuna kuzindikira kuti ndiyabwino.

Njira 1: Kukula ndi thandizo la formula

Choyamba, lingalirani njira yosavuta komanso yofala kwambiri yomangira digiri yachiwiri ku Excel, yomwe imaphatikizapo kugwiritsa ntchito formula ndi chizindikiro "^". Nthawi yomweyo, monga chinthu, chomwe chidzakwezedwa ku lalikulu, mutha kugwiritsa ntchito nambala kapena ulalo wa cell, komwe mtengo wa manambala ukupezeka.

Maganizo ambiri a formula pomanga bwaloli ndi motere:

= N ^ 2

Mmenemo, mmalo mwa "n", ndikofunikira kuloweza nambala yomwe iyenera kukwezedwa mu lalikulu.

Tiyeni tiwone momwe zimagwirira ntchito zitsanzo zina. Kuyamba ndi, kumangidwa nambala yomwe idzakhala gawo la fomula.

1. Tikutsindika khungu lomwe lili pa pepala lomwe kuwerengera lidzapangidwe. Tidayiyika chikwangwani "=". Kenako timalemba kuchuluka kwa manambala omwe timafuna kupanga digiri lalikulu. Lolani kuti akhale nambala 5. Kenako, ikani chizindikiro. Ndi chisonyezo "^" Opanda zolemba. Kenako tiyenera kunena kuti ndi chinthu chiti chomwe chiyenera kumangidwa. Popeza lalikulu ndiye digiri yachiwiri, ndiye kuti tikukhazikitsa nambala ya "2" popanda mawu. Zotsatira zake, kwa ife, mawonekedwe adatulutsidwa:

   = 5 ^ 2



2. Kuti muwonetse zotsatira za kuwerengetsa pazenera, dinani kiyi ya Enter pa kiyibodi. Monga mukuwonera, pulogalamuyo imawerengetsa kuti nambala 5 mu lalikulu lidzakhala lofanana ndi 25.

Tsopano tiyeni tiwone momwe mungapangire mtengo mu lalikulu yomwe ili mu chipinda china.

1. Ikani chizindikiro "chofanana" (=) mu selo yomwe idatulutsa kuwerengetsa. Chotsatira, dinani pa chinthucho, komwe nambala yomwe mukufuna kupanga. Pambuyo pake, kuchokera pa kiyibodi, timalemba mawu akuti "^ 2". Kwa ife, njira yotsatirayi idachokera:

   = A2 ^ 2



2. Kuti muwerenge zotsatira, ngati nthawi yomaliza, dinani batani la Lower. Pulogalamuyi imawerengedwa ndikuwonetsa zotsatira zomwe zimasungidwa.

Njira 2: Kugwiritsa ntchito digiri

Komanso, kuti apange nambala mu lalikulu, mutha kugwiritsa ntchito ntchito yophatikizidwa. Wogwiritsa ntchitoyu amalowa mgulu la ntchito za masamu ndi ntchito yake ndikupanga kuchuluka kwa manambala ku digiri. Syntax ya ntchitoyo ndi motere:

= Digiri (nambala; digiri)

Mtsutso "ukhoza kukhala nambala kapena kufotokozera kwa gawo la pepalalo, komwe ili.

Mfundo "digiri" ikuwonetsa kuchuluka komwe nambala iyenera kuyikiridwa. Popeza tikukumana ndi funso lomanga bwalo, ndiye kuti mkanganowu udzakhala wofanana ndi 2.

Tsopano tiyeni tiwone chitsanzo chenicheni, momwe mungapangire lalikulu pogwiritsa ntchito ogwiritsa ntchito digiri.

1. Sankhani khungu momwe zotsatirazi zimawerengedwa. Pambuyo pake, dinani pa "ikani ntchito". Ili kumanzere kwa chingwe.



2. Zenera la Wizard limayamba kuthamanga. Timapanga kusintha mmenemo "masamu". M'ndandanda wotayidwa, sankhani "digiri". Kenako dinani batani la "OK".



3. Zenera la zokangana za opaleshoni yakhazikitsidwa. Monga tikuwonera, pali magawo awiri mmenemo, akugwirizana ndi kuchuluka kwa zotsutsana mu masamu.

   Mu "nambala", fotokozerani kuchuluka kwa manambala omwe amayenera kukwezedwa mu lalikulu.

   Mu "digiri", timatchula nambala ya "2", popeza tikufunika kuchita ndendende.

   Pambuyo pake, timadina batani la "Ok" m'munsi mwa zenera.



4. Monga mukuwonera, zitachitika izi, zotsatira za kumanga kwa lalikulu zimawonetsedwa mu masamba otsogola.

Komanso, kuti muthetse ntchitoyi, m'malo mwa mkangano angapo, mutha kugwiritsa ntchito ulalo wa selo yomwe ili.

1. Kuti muchite izi, itanani zenera la zotsutsana za kugwira ntchito pamwambapa momwemonso tidachita izi. Pawindo loyendetsa mu "nambala", tchulani ulalo wa cell, komwe mtengo wa manambala umapezeka ku lalikulu. Izi zitha kuchitika pongokhazikitsa cholozera m'munda ndikudina batani la mbewa lamanzere pa chivundikiro. Adilesiyo idzaonekera nthawi yomweyo pazenera.

   Mu "digiri", ngati nthawi yomaliza, timayika chiwerengerocho "2" chabwino ".



2. Wogwiritsa ntchitoyo amasintha deta yomwe idalowetsedwa ndikuwonetsa zowerengera pazenera. Monga tikuwona, pankhaniyi, zotsatira zake ndizofanana ndi 36.

Onaninso: Momwe mungapangire digiri mu Excel

Monga mukuwonera, pali njira ziwiri zowolokera nambala mu lalikulu: pogwiritsa ntchito "^" "ndikugwiritsa ntchito ntchito yomanga. Zosankha zonsezi zitha kugwiritsidwanso ntchito kumanga nambala ina iliyonse, koma kuwerengera lalikuluzo m'njira zonse zomwe muyenera kutchula digiri "2". Njira zake zonse zomwe zafotokozedwazo zitha kuwerengera, mogwirizana ndi kuchuluka kwa manambala, kotero gwiritsani ntchito chilulu cha selo yomwe ili mu zolinga izi. Mokulira, zosankha izi ndizofanana pakugwira ntchito, chifukwa ndizovuta kunena kuti ndi iti yabwino. Zili choncho ndi machitidwe ndi zinthu zofunika kwambiri kwa munthu aliyense, koma njira yokhala ndi chisonyezo "^" akadali akadali kwambiri.