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.
- Kutanga, tinya bhatani rekuruboshwe pachiteshi kuti usasarudzwe, uye wozoendesa iyo yekudonha-pasi menyu mu "nhamba" block, iyo ine mutoro wechero cell fomati.
- Mariri, sarudza iyo "zvinyorwa" sarudzo. Kana sero racho riratidzwe sehuwandu, hadzizoitigone kuita kuti riwedzere kurongedza, saka nhanho iyi inosungirwa.
- Zvino poresa iyo lkm uye kujekesa nemufananidzo wauri kuda kusarudza degree. Kana ichiripo, ingozvinyora pasina nzvimbo mushure meiyo huru nhamba.
- Dzvanya pazviri kurudyi-tinya uye mune iyo mamiriro menyu inoonekwa, sarudza "cell fomati".
- Iyo inoramba ichingotarisa paramende ye pemick mu "shanduko".
- Nyorera zvigadziriso zvitsva uye dzokera patafura, uchiita chokwadi chekuratidzira chakarurama.
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.
- Dzvanya iyo Insert tabu uko iwe unodzvanya pane "zviratidzo" uye vhura iyo menyu ine zvese zviratidzo zviripo.
- Kuti uwane kusununguka kwekutora patafura iyi mu "set" yekudonha-pasi menyu, taura "kumusoro uye yakadzika uye yakaderera indekisi".
- Tsvaga ikoko iyo nhamba yaunoda kushandisa seyero, uye kaviri-tinya pairi kana tinya pane "Paste" bhatani.
- Vhara tafura ine mavara uye ona kuti sei iyo degree inoratidzwa muchitokisi mushure meiyo huru nhamba.
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:
- Enda kune "Insert" tab uye kuwedzera "zviratidzo" block.
- Ino nguva sarudza "equation".
- Iyo tafura ichaonekwa yeiyo equation inogona kuendeswa kune chero nzvimbo, uye wozarura "zvivakwa" kudonhedza-pasi menyu.
- Pakati pezvivakwa zvazvino, madiki madiki anogona kutonzwisisa kuti ikozvino zvinodikanwa kusarudza iyo "indekisi".
- Rondedzero ine kumusoro uye yakaderera indekisi ichaonekwa - kunyora degree raunoda kusarudza yekutanga sarudzo.
- Mukudzoka, tinya pane imwe neimwe yakawedzerwa mativi uye nyora nhamba mavari.
- Chikamu chemasvomhu gadziriro chakagadzirira, asi kana iwe uchifanira kuwedzera zvimwe zvikamu zvaro, shandisa iyo ichangobva kurondedzerwa mupepeti, kusarudza yakakodzera zvivakwa.