Maitiro ekuisa degree kumusoro kumusoro muExcel

Anonim

Maitiro ekuisa degree kumusoro kumusoro muExcel

Kana, pane zvakajairwa nekuwedzera kwegiracel icon kumusoro kweiyo nhamba muExcel, iwe unofanirwa kuvaka imwe zvinyorwa, uko kwarondedzerwa kugadzira kuverenga kwakadaro uchishandisa mafomula.

Verenga Zvimwe: Kugadzira nhamba muMicrosoft Excel

Nzira 1: Shanduko yeNhamba yehuwandu

Sarudzo inokurumidza yekuwedzera iyo degree inoshandurwa rejista kuitira kuti inaratidzwa kumusoro, iyo inosangana nemamiriro ezvinhu akaiswa. Uye kunyangwe izvi kuri kushanda kwekukurumidza, kurongedza cell yega yega, uko kune nhamba iyo inoda kuongororwa sedanho.

  1. Kutanga, tinya bhatani rekuruboshwe pachiteshi kuti usasarudzwe, uye wozoendesa iyo yekudonha-pasi menyu mu "nhamba" block, iyo ine mutoro wechero cell fomati.
  2. Sarudza iyo sero kuti ichinje chimiro yayo kana uchiwedzera dhigirii kubva kumusoro kusvika kune Excel

  3. Mariri, sarudza iyo "zvinyorwa" sarudzo. Kana sero racho riratidzwe sehuwandu, hadzizoitigone kuita kuti riwedzere kurongedza, saka nhanho iyi inosungirwa.
  4. Kuchinjisa iyo cell fomati usati wawedzera dhigirii kubva kumusoro kusvika kune Excel

  5. Zvino poresa iyo lkm uye kujekesa nemufananidzo wauri kuda kusarudza degree. Kana ichiripo, ingozvinyora pasina nzvimbo mushure meiyo huru nhamba.
  6. Kusarudzwa kwenhamba yekuwedzera kurovedza muviri kusvika pamwero weruoko-kune-bhuku rekurongedza kwechimiro muExcel

  7. Dzvanya pazviri kurudyi-tinya uye mune iyo mamiriro menyu inoonekwa, sarudza "cell fomati".
  8. Shanduko yekuisa chimiro chenhamba yakatsaurwa kuti igadzirise seyero kubva kumusoro mune excel

  9. Iyo inoramba ichingotarisa paramende ye pemick mu "shanduko".
  10. Kuisa paramende yeiyo nhamba kana ichitsanangura sedanho kubva kumusoro muExcel

  11. Nyorera zvigadziriso zvitsva uye dzokera patafura, uchiita chokwadi chekuratidzira chakarurama.
  12. Kuongorora huwandu hwehuwandu seyero kubva kumusoro nebhuku rekugadzirisa muExcel

Nzira 2: Uchishandisa mavara akakosha

Pane mamiriro ezvinhu umo sarudzo yapfuura haigone kushandiswa, saka isu tinoratidza kuzvijaira neimwe nzira yekushandisa iyo yekuisa chiratidzo chakakosha. Izvo zvinongofanira kungoda kuwana nhamba yakakodzera iyo yatove yakaratidzwa mune yepamusoro kesi, wobva wangozviwedzera kuchitokisi.

Cherekedza kuti mune iyi tafura yejista yako iwe unowana nhamba chete kubva pa4 kusvika ku9, saka sarudzo iyi haina kukodzera kana iwe uchida kudoma mraba kana cube.

  1. Dzvanya iyo Insert tabu uko iwe unodzvanya pane "zviratidzo" uye vhura iyo menyu ine zvese zviratidzo zviripo.
  2. Enda kune iyo isa chikamu kuti usarudze chiratidzo chakakosha sedanho kubva kumusoro muExcel

  3. Kuti uwane kusununguka kwekutora patafura iyi mu "set" yekudonha-pasi menyu, taura "kumusoro uye yakadzika uye yakaderera indekisi".
  4. Kusimuka kwemavara anokosha kuti uwedzere degree kubva kumusoro kusvika kune Excel

  5. Tsvaga ikoko iyo nhamba yaunoda kushandisa seyero, uye kaviri-tinya pairi kana tinya pane "Paste" bhatani.
  6. Sarudza chiratidzo chakakosha kuti uwedzere kunge uri pamusoro muExcel

  7. Vhara tafura ine mavara uye ona kuti sei iyo degree inoratidzwa muchitokisi mushure meiyo huru nhamba.
  8. Kubudirira kuwedzera chiratidzo chakakosha senge degree kubva kumusoro muExcel

Nzira 3: Kuwedzera equation

Iko kugona kwekuwedzera exation equation inokutendera kuti ugadzire akasiyana siyana emasvomhu mafomula e chero kuomarara uye agadzire patafura. Iko kushanda kwezvinhu zvekushandisa kune iyo equation inosanganisira isina chinhu nehuwandu uye dhigirii yacho, iyo ichokwadi:

  1. Enda kune "Insert" tab uye kuwedzera "zviratidzo" block.
  2. Shanduko kune iyo yekuisa chikamu kuti uwedzere iyo yemasvomhu equation kana uchigadzira degree muExcel

  3. Ino nguva sarudza "equation".
  4. Kuvhura menyu kuti uwedzere kuenzana kwemasvomhu paunenge uchiwedzera nhamba kubva kumusoro kusvika kumusoro

  5. Iyo tafura ichaonekwa yeiyo equation inogona kuendeswa kune chero nzvimbo, uye wozarura "zvivakwa" kudonhedza-pasi menyu.
  6. Kuvhura kwematterns yemasvomhu equatical equatical equatical equatical ehuwandu hwehuwandu hwehuwandu kubva kumusoro muExcel

  7. Pakati pezvivakwa zvazvino, madiki madiki anogona kutonzwisisa kuti ikozvino zvinodikanwa kusarudza iyo "indekisi".
  8. Kusarudzwa kwechimiro chemasvomhu equation yekuwedzera dhigiri kubva kumusoro kusvika kune Excel

  9. Rondedzero ine kumusoro uye yakaderera indekisi ichaonekwa - kunyora degree raunoda kusarudza yekutanga sarudzo.
  10. Kusarudza chimiro chechimiro kuti uwedzere degree kubva kumusoro kusvika kune Excel

  11. Mukudzoka, tinya pane imwe neimwe yakawedzerwa mativi uye nyora nhamba mavari.
  12. Editing yakawedzerwa chimiro paunenge uchitsanangura nhamba kubva kumusoro muExcel

  13. Chikamu chemasvomhu gadziriro chakagadzirira, asi kana iwe uchifanira kuwedzera zvimwe zvikamu zvaro, shandisa iyo ichangobva kurondedzerwa mupepeti, kusarudza yakakodzera zvivakwa.
  14. Rakabudirira kuwedzera degree kubva kumusoro uchiisa kumusoro kwemasvomhu equation muExcel

Verenga zvimwe