Kukweza mphamvu kukhala chinthu chofunikira kwambiri. Amagwiritsidwa ntchito kuwerengera kosiyanasiyana, onse pazophunzitsa komanso pochita. Excel ili ndi zida zopangira zotsimikizira mtengo wake. Tiyeni tiwone momwe mungazigwiritsire ntchito pazinthu zosiyanasiyana.
Phunziro: Momwe mungayikitsire digirii mu Microsoft Mawu
Kukonzekera kwa manambala
Ku Excel, pali njira zingapo zakukweza mphamvu kwa angapo nthawi imodzi. Izi zitha kuchitika pogwiritsa ntchito chizindikiro chokhazikika, ntchito, kapena kugwiritsa ntchito zina, osati zingapo, zosankha.
Njira 1: kapangidwe kogwiritsa ntchito chizindikiro
Njira yodziwika komanso yodziwika kwambiri yokweza mphamvu ku chiwerengero ku Excel ikugwiritsa ntchito mawonekedwe wamba "^" chifukwa cha izi. Ndondomeko ya kapangidwe kameneka ndi motere:
= x ^ n
Mwanjira iyi x nambala yomwe ikukwera, n - kukula kwa mawonekedwe.
- Mwachitsanzo, kuti tikweze nambala 5 mpaka mphamvu yachinayi, timapanga zolemba zotsatirazi mu selo lililonse la pepala kapena mu baramu yokhazikitsidwa:
=5^4 - Kuti muwerenge ndi kuwonetsa zotsatira zake pakompyuta pakompyuta, dinani batani Lowani pa kiyibodi. Monga mukuwonera, mwanjira yathu, zotsatira zake zidzakhala 625.
Ngati ntchitoyo ndi yofunika kuwerengera zovuta, ndiye kuti njirayi imachitika molingana ndi malamulo apadera a masamu. Ndiye, mwachitsanzo, m'zitsanzo 5+4^3 Excel nthawi yomweyo imakweza mphamvu ya 4, kenako kuwonjezera.
Kuphatikiza apo, kugwiritsa ntchito wothandizira "^" Simungathe kupanga manambala wamba, komanso deta yomwe ili patsamba lina.
Timakwezera ku chisanu ndi chimodzi mphamvu zomwe zili mu cell A2.
- Pa malo aliwonse omasuka pa pepalalo, lembani mawu oti:
= A2 ^ 6 - Dinani batani Lowani. Monga mukuwonera, kuwerengera kunachitika molondola. Popeza nambala 7 inali mu cell A2, zotulukazo zidawerengeka zinali 117649.
- Ngati tikufuna kukweza manambala onse pamlingo wofanana, ndiye kuti sikofunikira kulemba formula iliyonse. Ndikokwanira kuzilemba mzere woyamba wa tebulo. Kenako mukungoyendayenda pakona yakumunsi kwa khungu ndi kakhazikitsidwe. Chizindikiro Gwirani batani lakumanzere ndikulikokera pansi penipeni pa tebulo.
Monga mukuwonera, zofunikira zonse za nthawi yomwe zimafunikira zidakwezedwa pamlingo womwe wawonetsedwa.
Njira iyi ndiyosavuta komanso yosavuta momwe mungathere, chifukwa chake ndiyotchuka pakati pa ogwiritsa ntchito. Ndi omwe amagwiritsidwa ntchito powerengera milandu yambiri.
Phunziro: Kugwira ntchito ndi mafomu ku Excel
Phunziro: Momwe mungachite mosamalitsa mu Excel
Njira 2: kutsatira ntchito
Excel ilinso ndi ntchito yapadera pochita kuwerengera kumeneku. Amatchedwa kuti - ZOCHITITSA. Matchulidwe ake ndi awa:
= DEGREE (chiwerengero; digiri)
Tiyeni tiwone momwe angagwiritsire ntchito pa konkrati.
- Timadula pafoni momwe tikufuna kuwonetsera zotsatira. Dinani batani "Ikani ntchito".
- Kutsegula Fotokozerani Wizard. Pamndandanda wazinthu zomwe tikufuna kulowa "DEGREE". Tikapeza, sankhani ndikudina batani "Zabwino".
- Windo la mkangano likutseguka. Wogwiritsa ntchitoyo ali ndi mfundo ziwiri - chiwerengero ndi mphamvu. Kuphatikiza apo, kuchuluka kwa manambala komanso khungu zimatha kukhala ngati mkangano woyamba. Ndiye kuti, zochita zimachitidwa ndi fanizo ndi njira yoyamba. Ngati adilesi ya foni ikhala ngati mkangano woyamba, ndiye ingoikani cholowetsa mbewa m'munda "Chiwerengero", kenako dinani malo omwe mukufuna. Pambuyo pake, mtengo wamasamba womwe udasungidwamo udawonetsedwa m'munda. Mwachangu m'munda "Degree" adilesi yafoni itha kugwiritsidwanso ntchito ngati mfundo, koma pochita izi sizigwira ntchito kwenikweni. Pambuyo polemba zonse zomwe zalowetsedwa, kuti muchite kuwerengera, dinani batani "Zabwino".
Kutsatira izi, zotsatira za kuwerengera kwa ntchitoyi zimawonetsedwa m'malo omwe adayikidwa gawo loyamba la zomwe zafotokozedwazi.
Kuphatikiza apo, zenera zotsutsana zimatha kuyitanidwa ndikupita ku tabu Mawonekedwe. Pa tepi, dinani "Masamu"ili mu chipangizo Laibulale ya Feature. Pamndandanda wazinthu zomwe zikupezeka zomwe zimatseguka, sankhani "DEGREE". Pambuyo pake, zenera zotsutsa za ntchitoyi ziyamba.
Ogwiritsa ntchito omwe akudziwa kale sangayimbire Fotokozerani Wizard, koma ingolowetsani chinsinsi mu cell pambuyo chikwangwani "="kutengera kapangidwe kake.
Njira iyi ndiyovuta kwambiri kuposa yoyamba ija. Kugwiritsa ntchito kwake kungakhale koyenera ngati kuwerengera kuyenera kuchitika mkati mwa malire a ntchito yopangidwa ndi opanga angapo.
Phunziro: Ntchito Wizard ku Excel
Njira 3: kufotokozera kudzera muzu
Zachidziwikire, njirayi si yachilendo kwenikweni, koma mutha kuyigwiritsanso ntchito ngati mukufuna kukweza manambala ku mphamvu ya 0.5. Tisanthula nkhaniyi ndi zitsanzo zenizeni.
Tiyenera kukweza 9 ku mphamvu ya 0.5, kapena mwanjira ina - ½.
- Sankhani khungu lomwe zotsatira zikuwonetsedwa. Dinani batani "Ikani ntchito".
- Pazenera lomwe limatseguka Ogwira Ntchito kufunafuna chinthu MUTHA. Sankhani ndikudina batani. "Zabwino".
- Windo la mkangano likutseguka. Ntchito imodzi MUTHA ndi nambala. Chochita chokha chimagwira ntchito yochotsa muzu wazikuta wa nambala yolowetsedwa. Koma, popeza muzu wapakatiwo ndi wofanana ndikukweza ku mphamvu ya this, njira iyi ndiyabwino kwa ife. M'munda "Chiwerengero" lowetsani nambala 9 ndikudina batani "Zabwino".
- Pambuyo pake, zotsatira zake zimawerengedwa mu cell. Poterepa, ndikofanana ndi 3. Ndi nambala iyi yomwe ndi yomwe ikukweza 9 ku mphamvu ya 0.5.
Koma, zoona, amatengera njira yowerengera nthawi zambiri, pogwiritsa ntchito njira zowerengera zodziwika bwino.
Phunziro: Momwe mungawerengere muzu mu Excel
Njira 4: lembani manambala ndi digirii m'selo
Njirayi silipereka mawerengero omanga. Zimagwira pokhapokha mukangofunikira kulemba nambala ndi digirii mu cell.
- Timasanja foni yomwe kujambula idzapangidwira, molemba. Sankhani. Kukhala mu em tabu "Home" pa tepi mu bokosi la chida "Chiwerengero", dinani pamndandanda wosankha wosankha. Dinani pazinthuzo "Zolemba".
- Mu foni imodzi, lembani manambala ndi kuchuluka kwake. Mwachitsanzo, ngati tikufunika kulemba atatu digiri yachiwiri ndiye kuti tikulemba "32".
- Timayika cholozera mu chipangizocho ndikusankha nambala yachiwiri yokha.
- Pakukanikiza njira yaying'ono Ctrl + 1 Imbani zenera. Chongani bokosi pafupi ndi gawo "Superscript". Dinani batani "Zabwino".
- Pambuyo pamanambala awa, chophimba chidzawonetsa nambala yomwe ili ndi mphamvu.
Yang'anani! Ngakhale kuti manambala adzawonetsedwa mu cell mu digiri, Excel amamuwona ngati wolemba, osati wowerengera. Chifukwa chake, njira iyi siyingagwiritsidwe ntchito kuwerengera. Pazifukwa izi, kulowa muyezo mu pulogalamuyi kumagwiritsidwa ntchito - "^".
Phunziro: Momwe mungasinthire mawonekedwe amtundu mu Excel
Monga mukuwonera, ku Excel pali njira zingapo zopezera mphamvu zamagetsi. Kuti musankhe njira inayake, choyambirira, muyenera kusankha zomwe mukufuna mawuwo. Ngati mukufuna kumanga kuti alembe mawuwo mwanjira imodzi kapena kungowerengera mtengo wake, ndiye kuti ndiosavuta kulemba chizindikiro "^". Nthawi zina, mutha kuyika ntchitoyo ZOCHITITSA. Ngati mukufuna kukweza manambala ku mphamvu ya 0.5, ndiye kuti ndizotheka kugwiritsa ntchito ntchitoyi MUTHA. Ngati wogwiritsa ntchito akufuna kuwonetsa mawonekedwe osachita mwatsatanetsatane, kuphatikiza kumathandiza.
