Kuchotsa muzu kuchokera pamambala ndi njira yodziwika bwino pamasamu. Imagwiritsidwanso ntchito kuwerengera kosiyanasiyana mumatafura. Mu Microsoft Excel, pali njira zingapo zowerengera mtengo. Tiyeni tiwone mwatsatanetsatane zosankha zingapo zowerengera pulogalamuyi.
Njira zosinthira
Pali njira ziwiri zazikulu zowerengetsera izi. Chimodzi mwazo ndi choyenera kuwerengera muzu, ndipo chachiwiri chitha kugwiritsidwa ntchito kuwerengera mulingo uliwonse.
Njira 1: Kugwiritsa Ntchito Ntchito
Pofuna kuchotsa muzu wokulira, ntchito imagwiritsidwa ntchito, yomwe imatchedwa ROOT. Matchulidwe ake ndi awa:
= ROOT (chiwerengero)
Kuti mugwiritse ntchito njirayi, ndikokwanira kulemba mawuwa m'selo kapena mu pulogalamu yothandizira pulogalamuyi, ndikusintha liwulo "nambala" ndi nambala inayake kapena adilesi ya foni komwe kuli.
Kuti muwerengere ndikuwonetsa zotsatira zake pazenera, dinani batani ENG.
Kuphatikiza apo, mutha kugwiritsa ntchito fomuloli kudzera pa wizard wogwira ntchito.
- Timadula foni papepala momwe zotsatira zowerengera ziziwonetsedwa. Pitani ku batani "Ikani ntchito"kuyikidwa pafupi ndi mzere wa ntchito.
- Pamndandanda womwe umatsegulira, sankhani MUTHA. Dinani batani "Zabwino".
- Windo la mkangano likutseguka. M'munda wokhawokha wa zenera ili, muyenera kulowetsa mtengo womwe uchotsepo, kapena magwiritsidwe a foni komwe kuli. Ndikokwanira kubwezera patsamba ili kuti adilesi yake ilowe m'mundawo. Mukamalowetsa tsambalo, dinani batani "Zabwino".
Zotsatira zake, zotsatira za kuwerengera zikuwonetsedwa mufoni yomwe akuwonetsedwa.
Mutha kuyimbanso ntchitoyo kudzera pa tabu Mawonekedwe.
- Sankhani khungu kuti muwonetse zotsatira zake. Pitani pa tabu ya "Fomula".
- Mu "Library Library" ya zida pa riboni, dinani batani "Masamu". Pamndandanda womwe umawonekera, sankhani phindu MUTHA.
- Windo la mkangano likutseguka. Zochita zina zonse ndizofanana ndendende ndikugwiritsa ntchito batani "Ikani ntchito".
Njira 2: kufotokozera
Kugwiritsa ntchito njira yomwe ili pamwambapa sikungathandize kuwerengera mizu ya cubic. Poterepa, mtengo wake uyenera kukwezedwa kukhala mphamvu yowononga. Mawonekedwe ambiri amomwe amawerengera ali motere:
= (nambala) ^ 1/3
Ndiye kuti, mwatsatanetsatane izi sizowonjezera ngakhale kutulutsa, koma kukweza mtengo kwa mphamvu 1/3. Koma digiri iyi ndiye muzu wa kiyubiki, motero ndi chifukwa chake izi ku Excel ndizomwe zimagwiritsidwa ntchito kuti zitheke. M'malo mwa nambala inayake, mutha kuyang'ananso zolumikizana ndi ma cell ndi manambala amtunduwu. Zojambulazo zimapangidwa m'mbali iliyonse ya pepalalo kapamwamba.
Musaganize kuti njira iyi ikhoza kugwiritsidwa ntchito pokhapokha kuchotsa mzu wa kiyubiki kuchokera ku nambala. Munjira yomweyo, mutha kuwerengera lalikulu ndi mizu ina iliyonse. Koma pokhapokha ngati muyenera kugwiritsa ntchito njira zotsatirazi:
= (nambala) ^ 1 / n
n kuchuluka kwa madongosolo.
Chifukwa chake, njirayi ndiyachilengedwe chonse kuposa kugwiritsa ntchito njira yoyamba.
Monga mukuwonera, ngakhale kuti Excel ilibe ntchito yapadera yochotsa muzu wa kiyubiki, kuwerengera uku kutha kuchitika pogwiritsa ntchito kukweza kwa gawo lamphamvu, ndilo 1/3. Mutha kugwiritsa ntchito yapadera kuti mupeze muzu wapakati, koma mungathenso kuchita izi pokweza nambala kukhala mphamvu. Pakadali pano adzafunika kukweza mphamvu 1/2. Wogwiritsa ntchitoyo ayenera kudziwa njira yomwe amawerengera.
