Momwe Mungawerengere Muzu M'mizere

Anonim

Kuchotsa muzu mu Microsoft Excel

Kuchotsa muzu kuchokera pakati ndikufala kwenikweni kwa masamu. Zimakhudza kuwerengera kosiyanasiyana m'matebulo. Microsoft Excel ili ndi njira zingapo zowerengera mtengo wake. Tiyeni tilingalire mwatsatanetsatane zolumikizira zowerengera izi mu pulogalamuyi.

Njira Zowonjezera

Pali njira ziwiri zowerengera zowerengera izi. Chimodzi mwa izo ndi choyenera kuwerengera muzu waukulu, ndipo chachiwiri chitha kugwiritsidwa ntchito kuwerengera mtengo wamlingo uliwonse.

Njira 1: Ntchito Ntchito

Pofuna kuchotsa muzu waukulu, ntchitoyo imagwiritsidwa ntchito, yomwe imatchedwa muzu. Syntax yake imawoneka motere:

= Muzu (nambala)

Pofuna kugwiritsa ntchito njirayi, ndikokwanira kulembera ku selo kapena mu pulogalamu ya pulogalamuyi mawuwa, kusintha mawu oti "nambala" ku nambala kapena ku adilesi ya foni komwe ili.

Muzu muzu wa Microsoft Excel

Kuti muchite kuwerengera ndi kutulutsa kwa zotsatira pazenera, dinani batani la Enter.

Zotsatira za kuwerengetsa kwa gawo la muzu mu Microsoft Excel

Kuphatikiza apo, mutha kugwiritsa ntchito njirayi kudzera mwa Mwini ntchito.

  1. Dinani pa cell pa pepala pomwe zotsatira za kuwerengedwa zidzawonetsedwa. Pitani pa batani "Ikani ntchito", yoyikidwa pafupi ndi mzere wa ntchito.
  2. Pitani ku mbuye wa ntchito mu Microsoft Excel

  3. M'ndandanda womwe umatsegulira, sankhani muzu. Dinani pa batani la "OK".
  4. Pitani ku mizu yogwira ntchito mu Microsoft Excel

  5. Khomo lachikangano limatseguka. Mu gawo lokhalo la zenera ili, muyenera kulowa mtengo wapadera womwe udzatulutsidwe kapena mgwirizano wa cell pomwe uli. Ndikokwanira dinani khungu ili kuti adilesi yake yalowetsedwa m'munda. Pambuyo polowa data, kanikizani batani la "OK".

Oc malingaliro a ntchito ku Microsoft Excel

Zotsatira zake, chifukwa cha kuwerengera zidzawonetsedwa mu selo.

Zotsatira za kuwerengetsa kwa mizu ntchito mu Microsoft Excel

Komanso, ntchitoyi imatha kuyitanidwa kudzera mu "formula" tabu.

  1. Sankhani khungu kuti muwonetse zotsatira za kuwerengera. Pitani ku "njira".
  2. Kusintha kwa Formula Tab mu Microsoft Excel

  3. Mu "Ntchito ya Library" pa tepi dinani batani la "masamu". Pa mndandanda womwe umawonekera, sankhani phindu "muzu".
  4. Kuyimbira formula Muzu mu Microsoft Excel

  5. Khomo lachikangano limatseguka. Zochita zina zonse ndendende ndizofanana ndi zomwe zachitika kudzera mu batani la "phala ntchito".

Zokambirana zomangira mu Microsoft Excel

Njira 2: Kukhazikitsidwa

Werengani kuwerengera mizu ya cubic pogwiritsa ntchito njira yomwe ili pamwambapa siyithandiza. Pankhaniyi, kukula kumafunikira kumangidwa kukhala digiri ya Fractoal. Mtundu Wa General of Foremula Yowerengera ndi:

= (nambala) ^ 1/3

Kuchotsa muzu wa cubic mu Microsoft Excel

Ndiye kuti, sikukuchotsa ngakhale phindu la 1/3. Koma digiri iyi ndipo ndi muzu wa kebic, chifukwa chake, izi zomwe zimagwiritsidwa ntchito bwino kwambiri zimagwiritsidwa ntchito pochilandira. M'malo mwa nambala inayake, ndizothekanso kuloweza magwiridwe antchito a maselo omwe ali ndi chidziwitso cha manambala. Zojambulazo zimapangidwa m'mbali iliyonse ya pepalalo kapena mu formula.

Sayenera kuganiziridwa kuti njirayi ingagwiritsidwe ntchito pongochotsa muzu wa Cubic pakati. Munjira yomweyo, lalikulu ndi muzu wina uliwonse ungawerengedwe. Koma pokhapokha ngati izi muyenera kugwiritsa ntchito njira yotsatirayi:

= (nambala) ^ 1 / n

n ndi kuchuluka kwa erection.

Ogwirira muzu mu Microsoft Excel

Chifukwa chake, kusankha kumeneku ndi kovuta kwambiri kuposa kugwiritsa ntchito njira yoyamba.

Monga tikuwonera, ngakhale kuti palibe ntchito yapadera yomwe ingatenge muzu wa cubic muzu, kuwerengetsa uku kumachitika pogwiritsa ntchito kapangidwe kake kachulukidwe ka quecal digirical, kutanthauza 1/3. Kuti muchotse muzu waukulu, mutha kugwiritsa ntchito ntchito yapadera, koma palinso mwayi wochita izi pomanga nambala. Nthawi ino muyenera kuyikika ku 1/2. Wogwiritsa ntchito yekhayo ayenera kudziwa momwe njira yowerengera ndiyofunika kwambiri.

Werengani zambiri