How kuverenga mativi midzi Excel?

Microsoft Excel Software ane zvakawanda kwemasvomhu mashandiro inokubvumirai kugadzirisa mabasa dzakaoma. Vanoverengeka nyore zviito - Uyezve, chokuwanziridza, uye vamwe - zviri nyore chaizvo kuita, vachishandisa chaiyo vanotaurwa. Zvisinei, pane avo kuti zvinoda tsanangudzo anokosha - saka, kwete vose anoziva sei kuverenga yaiungana mudzi muna Excel.

Chii pamudzi mativi?

Pamberi pakutanga zvatinokanganisa, sei kuwana mativi mudzi kuna Excel, vanofanira kuwana Kunyatsoziva chokwadi kuti ichi chinhu kwemasvomhu basa. By tsanangudzo, sikweya mudzi nhamba - iri nhamba ane mativi akaenzana nhamba imwe. In sayenzi kuti akarongeka anogona kuonekwa kwete chete midzi dzakaenzana. Ivowo vangauya neimwe dhigirii, saka pachivara mudzi zvinowanzooneka nezvavo savakuru mudzi dzeboka rechipiri.

mudzi basa

In kugadzirisa dambudziko chokuita kuwana yaiungana mudzi "Eksele" kuwana zvinodiwa kunoguma munzira dzakawanda. Functionality purogiramu anobvumira zvose kushandisa akavaka-rokuita algorithms, unyore pariri pachako, uchishandisa anokosha theorems uye zvivako zviri mudzi. Nzira nyore kuwana mhinduro iri muchivara mudzi ishande. In Excel, rinogona kuwanikwa nokuvhura nzira Muterere kana varwere manually.

The nemarongerwo iri nyore chaizvo - pashure chaiyo kushandiswa rimwe mashandiro (chiratidzo wakaenzana) Zvakakodzera kuti kunyoresa shoko guru "mudzi", chichiratidza kudanwa murayiro rakakodzera. Next achanyorwa mu mumabhuraketi shanduka kubva izvo zvaunoda kutora mativi mudzi. In Excel somunhu nharo pamusoro basa rinogona kushandiswa kusanganiswa ukoshi yakajeka uye nezve muchitokisi, uye akarongeka mashoko kuti Anoongorora kuti nhamba.

Kushandisa kwemasvomhu ehupfumi

The mativi midzi Excel, unogona ngaaverenge zvinoverengeka dzimwe nzira kuti murege zvinoda ruzivo rwakadzama mune zvesayenzi ari akarongeka. Zviri zvakakwana kuziva chii mudzi - nyaya iyi wakarwadziwa pamusoro muchikamu rokutanga nyaya. Uchishandisa tsanangudzo sikweya mudzi kungaratidzwa sezvo itirana masimba nhamba mbiri kunodiwa. Saka, kuwana mativi mudzi pasina kushandisa "mudzi" inogona nyore paisimuka nhamba kuti simba.

Izvi zvinogona kuitwa uyewo munzira mbiri. Rokutanga kushandisa mamwe mabasa - "Danho". It kunokwidza nhamba inotaurwa kana mugumisiro kwemasvomhu mashoko ari dhigirii dzakasarudzwa. Panyaya iyi, mu "dhigirii" anoratidza nhamba 1/2 kana 0.5. Kumisa vanoverengeka pamwero napo uye pasina kushandiswa chero zvinhu - "Eksele" ndiwo hunhu unokosha mutariri kushanda ichi: "^". Muchiitiko chino, kuti yaiungana mudzi, zvakakwanira kugumisa mashoko ari muzvikomberedzo, vakatevera nokuwedzera "^ (1/2)" kana "* (0.5)." Mugumisiro chiito ichi zvichava zvakafanana pakuvaka simba pamwe kushanda uye kushandiswa "mudzi" basa.

Zvinofanira kucherechedzwa kuti nzira yokuwana mudzi Exponentiation iri vasununguka. Chikonzero ichi ndechokuti nokubatsira remapazi izvi, unogona kuwana chero mudzi pasina kushandisa chero inokosha yokuwedzera Masvomhu.

mienzaniso

To pakupedzisira kubata sei kuverenga Square mudzi kuna Excel, unofanira kufunga vaviri mienzaniso nzira mbiri pamusoro apa.

Muchiitiko chokutanga tinoshandisa inoti "mudzi", ichiiti nokushandisa "Insert Rinoshanda" bhatani. Pahwindo kuti zvichaita kutaridzwa Data nokuda kukarukureta, dzakadai musiyano pakati zvinokosheswa maviri masero, uye ipapo baya 'OK ".

Kana yechipiri, uchishandisa munhu-verengeka shanduro, pamwe yakajeka basa rimwe simba, zvinotevera mashoko yokuwana yaiungana pamudzi nhamba, somuenzaniso 9:

Mugumisiro chiito ichi chichange kuisa kuti "3".