Njira yolumikizira nambala ndi njira yoyenera masamu. Imagwiritsidwa ntchito powerengera kosiyanasiyana, zonsezi zophunzitsira komanso pochita. Pulogalamu ya Excel yapanga zida zopanga mtengo wake. Tiyeni tiwone momwe tingagwiritsire ntchito nthawi zosiyanasiyana.
Phunziro: Momwe mungasungire chikwangwani mu Microsoft Mawu
Ntchito Zomanga
Kupambana, pali nthawi imodzi nthawi imodzi kuti apange nambala. Izi zitha kuchitika mothandizidwa ndi chizindikiro chotsimikizika, ntchito, kapena kugwiritsa ntchito zina, osati njira wamba, zochita.Njira 1: Ntchito Yogwiritsa Ntchito Chizindikiro
Njira yodziwika bwino komanso yodziwika bwino yomanga nambala yomwe ili pa Excel ndiyo kugwiritsa ntchito chizindikiro chotsimikizika "^" Pa zolinga izi. Njira ya kesi ya mapangidwe imawoneka motere:
= x ^ n
Mu mawonekedwe awa, x ndi nambala yomangidwa, n ndi kuchuluka kwa zomanga.
- Mwachitsanzo, kuti apange digiri ya nambala yachinayi mpaka yachinayi. Ife m'chipinda chilichonse cha pepalalo kapena chingwe chathu timapanga cholowa:
= 5 ^ 4
- Pofuna kuwerengera ndikuwonetsa zotsatira zake pakompyuta, dinani batani la Lowetsani pa kiyibodi. Monga tikuonera, makamaka, zotsatira zake zimakhala zofanana ndi 625.
Ngati zomangamanga ndi gawo limodzi la kuwerengera kovuta kwambiri, njirayi imapangidwa pansi pa malamulo a masamu. Ndiye kuti, ndiye kuti, mwachitsanzo 5 + 4 ^ 3, Excel mwachangu amachititsa kufalitsidwa kwa nambala 4, kenako kuwonjezera.
Kuphatikiza apo, pogwiritsa ntchito wothandizira "^" Simungapange manambala wamba, komanso zomwe zili mu ma sheet osiyanasiyana.
Omangidwa munthawi yachisanu ndi chimodzi ya cell A2.
- Pamalo aliwonse aulere papepala, lembani mawuwo:
= A2 ^ 6
- Dinani batani lolemba. Monga tikuonera, kuwerengetsa kunachitika molondola. Popeza mu cell A2 Panali nambala 7, chifukwa cha kuwerengera zinali 117649.
- Ngati tikufuna kupanga manambala onse mu digiri yomweyo, ndiye kuti siyofunikira kujambula formula ya mtengo uliwonse. Ingotenthe pa mzere woyamba wa tebulo. Kenako mumangofunika kubweretsa cholozera kumanja kwa cell ndi mawonekedwe. Dzazani chikhomo chidzawonekera. Kanikizani batani lakumanzere ndikutambasula mpaka pansi pa tebulo.
Monga mukuwonera, zonse zomwe zimafunikira nthawi yomwe mukufuna zidakhazikitsidwa mu digiri yotchulidwa.
Njirayi ndiyotheka komanso yabwino momwe zingathekere, motero wotchuka kwambiri ndi ogwiritsa ntchito. Ndi zomwe zimagwiritsidwa ntchito pazowerengera zambiri.
Phunziro: Gwirani ntchito ndi njira zambiri
Phunziro: Momwe Mungapangire Autocomple
Njira 2: Ntchito Ntchito
Excel ilinso ndi gawo lapadera pazowerengera izi. Amatchedwa - digiri. Syntax yake imawoneka motere:
= Digiri (nambala; digiri)
Ganizirani izi mwachitsanzo.
- Dinani pa selo, komwe tikukonzekera kuwonetsa zotsatira za kuwerengera. Dinani pa batani la "phala ntchito".
- Wizard akutsegula. Pamndandanda wa zinthu zofunika kuti "digiri". Mukapeza, tikuunikira ndikudina batani la "OK".
- Khomo lachikangano limatseguka. Wogwiritsa ntchitoyu ali ndi mikangano iwiri - chiwerengero ndi digiri. Komanso, monga mkangano woyamba, amatha kukhala ndi tanthauzo la manambala ndi khungu. Ndiye kuti, zochita zimapangidwa ndi fanizo loyambirira. Ngati adilesi ya cell yakhazikitsidwa ngati mkangano woyamba, ndikokwanira kuyika cholozera cha mbewa mu "nambala", kenako dinani malo omwe mukufuna. Pambuyo pake, mtengo wosungidwa umasungidwa udzawonekera m'munda. Mwachidziwikire, adilesi ya foni imatha kugwiritsidwanso ntchito mu "digiri" ngati mkangano, koma pochita sizikugwira ntchito. Pambuyo pazonse zomwe zalembedwazo zimalowetsedwa kuti muwerenge, kanikizani batani la "Ok".
Kutsatira izi, zotsatira za kuwerengetsa ntchitoyi zimawonetsedwa m'malo mwake, zomwe zidagawidwa mu gawo loyamba la zomwe zafotokozedwazo.
Kuphatikiza apo, zenera lokangana zitha kutchedwa potembenukira mu "njira". Pa tepi, dinani batani la "masamu", lomwe lili mu "chida cha library. Pamndandanda wa zinthu zomwe zimatsegulidwa, muyenera kusankha "digiri". Pambuyo pake, zenera lotsutsa lidzayamba.
Ogwiritsa ntchito omwe ali ndi vuto linalake sangapangitse mtundu wa ntchito, koma ingolowetsani formula ya maselo pambuyo pa "=" chizindikiro, malinga ndi syntax yake.
Njirayi imakhala yovuta kwambiri kuposa kale. Kugwiritsa ntchito kwake kumatha kulungamitsidwa ngati kuwerengera kuyenera kupangidwa mkati mwa malire a ntchito yopanga yomwe imapangidwa ndi ogwiritsa ntchito.
Phunziro: Mzere wa Wizard mu Excel
Njira 3: Kukhazikitsidwa kudzera muzu
Zachidziwikire, njirayi sizambiri, komanso imatha kugwiritsidwanso ntchito ngati mukufuna kupanga 0,5. Tidzakambirana za nkhaniyi pankhani inayake.
Tiyenera kumanga 9 kukhala digiri 0,5 kapena mosiyana - ½.
- Sankhani selo momwe zotsatirazi zikuwonetsedwa. Dinani pa batani la "phala ntchito".
- Pazenera logwirira ntchito wa nthiti ya Wizard, ndikuyang'ana gawo la muzu. Tikutsindika ndikusindikiza batani la "OK".
- Khomo lachikangano limatseguka. Kutsutsana kokha kwa mizu ndi nambala. Ntchito yokhayo imagwira chotsani muzu wambiri kuchokera ku nambala yoyambitsidwa. Koma, popeza muzu waukuluwo umadziwika ndi zolimbitsa thupi mpaka digiri, ndiye kuti njirayi ndiyoyenera kwa ife. Mu "nambala", timalowetsa nambala 9 ndikudina batani la "Ok".
- Pambuyo pake, zotsatira zake zimawerengedwa mu khungu. Pankhaniyi, ndizofanana ndi 3. Ndiwo nambala iyi yomwe ndi zotsatira zake zomanga 9 mu 0,5.
Koma, zoona, njira iyi yowerengera kawirikawiri, pogwiritsa ntchito njira zodziwika bwino komanso zodziwika bwino zowerengera.
Phunziro: Momwe Mungawerengere Muzu M'mizere
Njira 4: kujambula nambala yokhala ndi digiri mu cell
Njirayi siyipereka pakukonzekera kugwiritsa ntchito. Zimagwiritsidwa ntchito pokhapokha mukangofuna kulemba nambala yomwe ili ndi digiri.
- Timapanga maselo omwe kulowa kumachitika mu mawonekedwe. Tikuunikira. Kukhala mu tabu "kunyumba" pa nthiti ya "nambala" yodziwika, dinani pamndandanda wotsika. Timadina pa "zolemba".
- Mu khungu limodzi, lembani nambala ndi digiri yake. Mwachitsanzo, ngati tikufunika kulemba zitatu mpaka digiri yachiwiri, kenako lembani "32".
- Tidayika cholembera ku khungu ndikugawa nambala yachiwiri yokha.
- Mwa kukanikiza Ctrl + 1 lalikulu, itanani zenera. Ikani chojambula pafupi ndi "mwachangu". Dinani pa batani la "OK".
- Pambuyo pa izi zonona, nambala yotchulidwa imawonetsedwa pazenera.
Chidwi! Ngakhale kuti kuchuluka kwa digiri mu khungu kudzawonetsedwa mu khungu, kuzindikirika kumazindikira kuti ndi mawu wamba, osati mawu ambiri. Chifukwa chake, kuwerengera, njira iyi siyingagwiritsidwe ntchito. Pazifukwa izi, mbiri ya digirii imagwiritsidwa ntchito mu pulogalamuyi - "^".
Phunziro: Momwe mungasinthire mtundu wa maselo mu Excel
Monga mukuwonera, mu pulogalamu ya Excel pali njira zingapo zowolokera manambala. Pofuna kusankha njira inayake, yoyamba pa zonse, muyenera kusankha chifukwa chomwe mukufuna. Ngati mukufuna kupanga mawu oti mulembe mawu mu formula kapena kungowerengera mtengo, ndiye kuti ndizotheka kujambula kudzera mu "^ ^" chizindikiro. Nthawi zina, mutha kugwiritsa ntchito digiri. Ngati mukufuna kupanga 0,5, ndiye kuti ndizotheka kugwiritsa ntchito muzu. Ngati wogwiritsa ntchito akufuna kuwona mawu opanda mphamvu popanda kuchitiramo kugwiritsa ntchito, kenako kukonzanso kudzapulumutsa.