Kulera nambala ku mphamvu ndizochita masamu ovomerezeka. Amagwiritsidwa ntchito paziwerengero zosiyanasiyana, potsata zolinga komanso maphunziro. Excel yakhazikitsa zida zowerengera izi. Tiyeni tiwone momwe tingawagwiritsire ntchito nthawi zosiyanasiyana.
Phunziro: Momwe mungaike chizindikiro cha digiri ku Microsoft Word
Kulera manambala
Mu Excel, pali njira zingapo zowonjezera nambala ku mphamvu panthawi yomweyo. Izi zikhoza kuchitika mothandizidwa ndi chizindikiro choyimira, ntchito kapena kugwiritsa ntchito zina, osati zachibadwa, zosankha.
Njira 1: Erection pogwiritsa ntchito chizindikiro
Njira yodziwika bwino komanso yodziwika bwino ya kufotokoza kwa chiwerengero ku Excel ndiyo kugwiritsa ntchito chizindikiro choyimira. "^" chifukwa cha izi. Pulogalamu yamakono yokonzekera erection ndi iyi:
= x ^ n
Mwachidule ichi x - iyi ndi nambala yomanga n - mlingo wa erection.
- Mwachitsanzo, kukweza nambala 5 mpaka mphamvu yachinayi, timapanga chotsatira mu chipinda chirichonse cha pepala kapena mu baranja lamulo:
=5^4 - Kuti muwerenge ndi kusonyeza zotsatira zake pa makompyuta, dinani pa batani. Lowani pabokosi. Monga momwe tikuonera, mwaife, zotsatira zake zidzakhala zofanana ndi 625.
Ngati ntchitoyi ndi mbali yovuta kwambiri, ndiye kuti ndondomekoyi ikuchitika malinga ndi malamulo a masamu. Izi ndizo, mwachitsanzo, mu chitsanzo 5+4^3 Nthawi yomweyo Excel imapanga chitsimikiziro ku mphamvu ya nambala 4, kenako kuwonjezera.
Kuphatikiza apo, pogwiritsira ntchito woyendetsa "^" N'zotheka kumanga nambala wamba chabe, komanso deta yomwe ili mu pepala lapadera.
Kwezani zomwe zili mu selo A2 mpaka digiri sikisi.
- Mu danga lililonse laulere pa pepala lembani mawu akuti:
= A2 ^ 6 - Timakanikiza batani Lowani. Monga mukuonera, mawerengedwewo anachitidwa molondola. Popeza nambala 7 inali mu selo A2, zotsatira za chiwerengero chinali 117649.
- Ngati tikufuna kumanga digiri yomweyi, ndiye kuti sikofunika kulemba chiwerengero cha mtengo uliwonse. Zokwanira kuzilemba mzere woyamba wa tebulo. Ndiye mumangofunika kusuntha chithunzithunzi kumbali yakumanja ya selo ndi ndondomekoyo. Chizindikiro chodzaza chikuwonekera. Lembani batani lamanzere la batani ndikukakokera mpaka pansi pa tebulo.
Monga momwe mukuonera, malingaliro onse a nthawi yofunikila adakwezedwa ku mphamvu yeniyeni.
Njirayi ndi yophweka komanso yabwino ngati n'kotheka, choncho ndi yotchuka kwambiri ndi ogwiritsa ntchito. Amagwiritsidwa ntchito pamabuku ambirimbiri.
Phunziro: Gwiritsani ntchito mayina mu Excel
Phunziro: Momwe mungapangire autocomplete mu Excel
Njira 2: Gwiritsani ntchito ntchitoyi
Mu Excel palinso ntchito yapadera yokwaniritsa izi. Amatchedwa - ZINTHU. Mawu ake omasulira ndi awa:
= ZOFUNIKA (nambala; digiri)
Ganizirani ntchito yake pachitsanzo.
- Timakani pa selo kumene tikukonzekera kusonyeza zotsatira za kuwerengera. Timakanikiza batani "Ikani ntchito".
- Kutsegulidwa Mlaliki Wachipangizo. Pa mndandanda wa zinthu zomwe tikufunafuna mbiri. "ZINTHU". Tikapeza, sankhani ndipo dinani pa batani "Chabwino".
- Fesholo yotsutsana ikutsegula. Wogwiritsa ntchitoyi ali ndi zifukwa ziwiri - chiwerengero ndi digiri. Ndipo monga kutsutsana koyamba kungathe kuchita, zonse zamtengo, ndi selo. Izi ndizo, zochita zimachitidwa mofanana ndi njira yoyamba. Ngati kukangana koyamba ndi adiresi ya selo, ingoikani mndandanda mmunda "Nambala", ndiyeno dinani pamalo omwe mukufuna. Pambuyo pake, chiwerengero cha nambala yosungidwa mmenemo chikuwonetsedwa m'munda. Theoretically kumunda "Degree" Adilesi yamaselo ikhoza kugwiritsidwanso ntchito ngati mkangano, koma pakuchita izi sizikugwiranso ntchito. Deta yonse italowa, kuti muthe kuwerengera, dinani pa batani "Chabwino".
Pambuyo pa izi, zotsatira za chiwerengero cha ntchitoyi zikuwonetsedwa m'malo omwe adayikidwa pa sitepe yoyamba ya zofotokozedwa.
Kuwonjezera apo, zenera zotsutsa zingatchulidwe popita ku tabu "Maonekedwe". Pa tepi, dinani batani "Masamu"ili m'bokosi la zida "Laibulale ya Ntchito". Mundandanda wa zinthu zomwe mukufunikira kusankha "ZINTHU". Pambuyo pake, zenera zotsutsa za ntchitoyi ziyamba.
Ogwiritsira ntchito ena sangathe kuwaitana Mlaliki Wachipangizo, ndi kungowonongeka mu selo pambuyo pa chizindikirocho "="malinga ndi mawu ake ofanana.
Njirayi ndi yovuta kwambiri kuposa yoyamba. Kugwiritsiridwa ntchito kwake kungakhale koyenera ngati kuwerengera kumafunika kupangidwa mkati mwa malire a ntchito yomwe ili ndi ogwira ntchito angapo.
Phunziro: Wowonjezera Wogwira Ntchito
Njira 3: kuwonetsetseratu kupyolera muzu
Inde, njira iyi si yachilendo, koma mukhoza kuyigwiritsa ntchito ngati mukufuna kumanga nambala ku mphamvu ya 0,5. Tiyeni tikambirane nkhaniyi ndi chitsanzo cha konkire.
Tifunika kukweza 9 ku mphamvu 0.5 kapena, apo ayi, mpaka ½.
- Sankhani selo limene zotsatira zake zidzawonetsedwa. Dinani pa batani "Ikani ntchito".
- Pawindo lomwe limatsegula Oyang'anira ntchito ndikuyang'ana chinthu MALO. Sankhani ndipo dinani pa batani. "Chabwino".
- Fesholo yotsutsana ikutsegula. Kusakanikirana komodzi MALO ndi nambala. Ntchitoyo yokha imapangitsa kuchotsa kwa mizere yokhalapo ya nambala yolembedwera. Koma, popeza mizu yaying'ono ikufanana ndi kuukitsidwa ku mphamvu ya ½, ndiye kuti njirayi ndi yabwino kwa ife. Kumunda "Nambala" lowetsani nambala 9 ndipo dinani pa batani "Chabwino".
- Pambuyo pake, zotsatira zake ziwerengedwa mu selo. Pankhani iyi, ndi ofanana ndi 3. Ndi nambala iyi yomwe ndi zotsatira zowonjezera 9 ku mphamvu 0.5.
Koma, ndithudi, iwo amagwiritsa ntchito njira iyi yowerengera mobwerezabwereza, pogwiritsa ntchito mitundu yosiyanasiyana yodziŵika bwino ndi intuitively yomvetsa.
Phunziro: Momwe mungawerengere muzu mu Excel
Njira 4: Lembani Nambala ndi Dipatimenti mu Cell
Njira iyi siyikupereka kuwerengera pa zomangamanga. Zimagwira ntchito pokhapokha mutangofunika kulemba nambala ndi digiri mu selo.
- Pangani selo kuti lilembedwe m'mawonekedwe a malemba. Sankhani. Kukhala mu em tab "Home" pa tepiyi mu zida za zipangizo "Nambala", dinani pamndandanda wosankhidwa pansi. Dinani pa chinthucho "Malembo".
- Mu selo imodzi, lembani nambala ndi digiri yake. Mwachitsanzo, ngati tifunika kulemba katatu pa digiri yachiwiri, ndiye kuti timalemba "32".
- Ikani cholozera mu selo ndikusankha chiwerengero chachiwiri chokha.
- Chinthu chachikulu Ctrl + 1 itanani mawindo okonza. Ikani nkhuni pafupi ndi parameter "Superscript". Timakanikiza batani "Chabwino".
- Zitatha izi, chiwerengero chomwe chili ndi digiriyi chidzawonetsedwa pazenera.
Chenjerani! Ngakhale kuti chiwerengerochi chidzawonetsedwa poyera mu selo mpaka digiri, Excel imaigwira mwatsatanetsatane, osati malemba. Choncho, njira iyi siingagwiritsidwe ntchito paziwerengero. Pachifukwa chimenechi, chiwerengero cha digiri yoyenera chimagwiritsidwa ntchito pulogalamuyi - "^".
Phunziro: Mmene mungasinthire selo mtundu mu Excel
Monga mukuonera, mu Excel pali njira zingapo zowonjezera nambala ku mphamvu. Pofuna kusankha njira yeniyeni, choyamba, muyenera kusankha zomwe mukufuna zosonyeza. Ngati mukufunikira kupanga zolemba kuti mulembe mawu mu chiwerengero kapena kuti muwerenge phindu, ndiye bwino kuti mulembe kupyolera mu chizindikiro "^". Nthawi zina, mungagwiritse ntchito ntchitoyi ZINTHU. Ngati mukufuna kulemba nambalayi ku mphamvu ya 0,5, ndiye kuti mutha kugwiritsa ntchito ntchitoyo MALO. Ngati wogwiritsa ntchito akufuna kuwonekera akuwonetsera mphamvu popanda kugwiritsa ntchito njira zamakhalidwe, ndiye kuti kujambula kudzapulumutsidwa.
