How kuverenga mudzi mu "Eksele"?

Microsoft Excel chirongwa ane akapfuma vanochengeta mitambo. Unogona kurishandisa kuti pave zvinoverengeka zvakasiyana masvomhu. Zvisinei, kana nheyo kushanda nyore zviito zvinzwisiswe vakawanda, sei kuverenga mudzi mu "Eksele" handizivi zvose.

"Root" shanda

Nzira kuverenga yaiungana mudzi mu "Eksele" vashoma, uye zvikuru zvakakunakira vavo - kushandisa chaiyo kushanda "mudzi", rakatangwa muna nepurogiramu. Nokuti zvinokosha kudana muchitokisi pachahwo kana kuti nzira bhaa kunyoresa nemarongerwo kwayo, kana tinya "Insert Rinoshanda" bhatani.

Kana uchisarudza nzira yokutanga, sero inyorwe "= SQRT (X)", apo pane "X" vanofanira kuva nhamba kana foni ane nhamba kukosha, mudzi zvinofanira kuwanikwa. Kana yechipiri, pashure vachisundira "Insert Rinoshanda" bhatani zvakafanira nyora kutsvaka munda "mudzi" uye kusarudza yaida basa. Izvi zvichaita akavhura hwindo wakavigira kana kuti vanyorese nhamba manually, kana kusarudza sero rine nhamba inodiwa.

kwemasvomhu minimini

Zvisinei, kana basa iri kuverenga mudzi mu "Eksele" nguva dzose harirevi ane mativi. Kuti ngaaverenge mudzi dhigirii chero vanofanira kushandisa imwe nzira - kushandiswa kwemasvomhu zvinoreva mudzi. By tsanangudzo, kukosha mudzi N-hydrochloric papi - nhamba kuti anofanira kumutswa kune simba N, kuwana mashoko riri pasi mudzi.

Saka, kuti kuwana kukosha mudzi dhigirii N-hydrochloric zvakakwana kuzomisa zvinoverengeka Ivan Kuchin dhigirii - 1 / n. Kuverenga mudzi mu "Eksele" seizvi, unogona kushandisa rimwe dzinobvira algorithms. Chokutanga izvi ndiko kushandisa basa, wechipiri - mune mirayiridzo yakajeka nezvezvakaitwa.

By nekudzvanya "Insert Rinoshanda" bhatani, unyore search bhokisi "dhigirii" uye wasarudza zvakakodzera kuzvipedza. Pahwindo kuti anovhura, pachava minda maviri - First unofanira kutaridzwa nhamba, uye wechipiri - pakuti zvinofanira vachamutswa. To tsanangurai zvakajeka Exponentiation vanofanira kushandisa "^" hunhu, uchiteverwa dhigirii. Zvinokosha kucherechedza kuti pane zvakaitika fractional simba, unofanira komberedza payo mumabhuraketi kuti zvakarurama mugumisiro. Saka, kuti compute yaiungana mudzi inyorwe nemamiriro fomu: x ^ (1/2).