Mukati
Zvishandiso zveMicrosoft Excel zvinonyanya kushandiswa kushanda nenhamba. Dzimwe nguva zvinodikanwa kuti nhamba, yakadai sechitsama chemari, inyorwe nemashoko. Izvi zvinonyanya kukosha pakugadzira magwaro ezvemari. Kunyora nhamba imwe neimwe mumashoko nemaoko hazvinakidzi. Mukuwedzera, nhamba mune imwe yenyaya dzakaoma zvikuru, uye havasi vose vanoziva mitemo yekunyora. Kusagona kuverenga mumagwaro kunokuvadza mukurumbira wekambani, saka iwe unofanirwa kushandisa rubatsiro rweExcel masevhisi. Ngationei kuti tingawedzera sei "Chiyero mumashoko" basa kuchirongwa uye rishandise nemazvo.
Usati wagadzira maseru ane masamu mumashoko, iwe unofanirwa kudhawunirodha yekuwedzera-mukati yeMicrosoft Excel. Iko hakuna ma-add-ons pawebhusaiti yepamutemo yevagadziri, asi inogona kutorwa kubva kune mamwe mapeji. Zvakakosha kutarisa mafaira akatorwa kumakombiyuta achishandisa chirongwa cheantivirus, kana zvisina kudaro kune ngozi yekudzivirira hurongwa nehutachiona. Uyewo teerera kune mvumo yefaira. Sarudzo chaiyo ndeye XLA. Kana iyo yekuwedzera yakatodhawunirodwa, isa muforodha umo ichave nyore kuwana. Izvi zvichauya zvinobatsira kana uchibatanidza. Tevere, isu tichaongorora kuisirwa kwekuwedzera-mukati nhanho nhanho:
- Iwe unofanirwa kuvhura iyo "Faira" tebhu muExcel gwaro uye sarudza iyo "Sarudzo" chikamu. Kazhinji inowanikwa pasi pechikamu chechikamu.
- Iwindo rekusarudza richavhura nemenu kuruboshwe. Sarudza chikamu che "Add-ons". Kana iwe ukatarisa kurudyi rwechidzitiro, unogona kuona kuti mamwe acho akaiswa kare, asi haana kukodzera kunyora kwakareruka kwehuwandu mumashoko.
Pazasi pane chikamu che "Management" chine bhatani rekuti "Enda". Tinobaya bhatani iri.
- Hwindo rine ma-add-ons aripo richaonekwa pachiratidziri. Iwe unogona kugonesa mamwe acho kana zvichidikanwa, asi chinangwa mune iyi kesi bhatani reBhurawuza.
- Isu tinowana iyo faira ine-add-on kuburikidza nehwindo rekubhurawuza. Dzvanya pairi kuti usarudze uye tinya OK.
- Chinhu "Num2Text" chichaonekwa mune zvinyorwa zvekuwedzera. Panofanira kunge paine cheki chiratidzo padivi payo. Kana isiri pahwindo, unofanirwa kusarudza iyi yekuwedzera-mukati uye tinya "OK".
Kubatana kwe "Mari mumashoko" kuwedzera-kwapera, ikozvino unogona kuishandisa.
Zviito neadd-on mushure mekubatanidza
Wedzera-pa "Chimwe mumashoko" ndeyekuwedzera kune "Function Manager" Excel. Anowedzera fomula imwe nyowani kune iyo rondedzero, iyo iwe yaunogona kushandura chero nhamba kuita mazwi. Ngatirangarirei maitiro ekushanda ne "Feature Manager" uye titarise iyo yekuwedzera-mukuita.
- Ngatigadzirei tafura ine nhamba dzinoda kunyorwa nemashoko. Kana imwe yatovepo, unongoda kuvhura gwaro payakaunganidzwa.
- Tevere, tinya pane sero isina chinhu uko mari yacho inofanira kuoneka mumashoko, uye vhura iyo "Function Manager".
Zvinokosha! Iwe unogona kusvika kune ichi chikamu cheExcel nenzira dzinoverengeka: kuburikidza nechiratidzo chiri padyo nemutsara webasa kana kuburikidza neFormula tab (iyo Isa Basa bhatani).
- Sarudza chikamu "Yakazara alfabheti runyorwa". Iwe unozofanira kupuruzira pasi kune vara "C" nekuti chimiro hachikwane mune chero emhando nhete. Tevere, iwe unofanirwa kudzvanya pazita rebasa re "Amount_in words" uye tinya "OK".
- Sarudza sero rine nhamba ine kukosha kwemavara kunofanirwa kuoneka musero risina chinhu. Chiratidziro chine animated chinofanirwa kuoneka chakaitenderedza, uye yakachinjika uye yakatwasuka zita inowira mufomula. Dzvanya bhatani rekuti "OK".
- Somugumisiro, huwandu hwemashoko hunooneka musero rakasarudzwa pakutanga. Zvinoita seizvi:
- Iye zvino unogona kuzadza tafura yese usingaite ma operation akafanana nemutsara wega wega. Kana ukadzvanya pane chero sero, dema dema rinoonekwa rakatenderedza (chena kana sero iri mutafura ine miganhu), uye pane dema sikweya marker mukona yezasi yekurudyi. Sarudza sero uko "Sum_in mazwi" basa riripo, bata pasi chikwere ichi wochikwevera kumagumo etafura.
- Iyo fomula inoenda kune ese maseru pazasi akatorwa nesarudzo. Pane kuchinja kwemasero, nekuda kwekuti huwandu hwemashoko hunooneka mumutsara wega wega. Tafura inotora fomu rinotevera:
Kupinda nemaoko kwechinhu mumaseru
Panzvimbo pekupfuura nematanho ekuvhura "Function Manager" uye kutsvaga basa raunoda, unogona kuisa fomura zvakananga muchitokisi. Ngationei kuti tingazadza sei tafura pasina kushandisa toolbar.
- Kutanga iwe unoda kusarudza sero risina chinhu apo fomura ichanyorwa. Dzvanya kaviri pairi - munda wekupinda data kubva kukhibhodi uchaonekwa mukati.
- Ngatinyorei nzira inotevera mundima isina chinhu: =Amount_in words().
Kurudziro! Mushure mekuisa chiratidzo chakaenzana, chirongwa chinopa mazano mumhando yemafomula. Kuwedzera kupinza pamutsetse, ndiko kuwedzera kwakaringana kunoratidza. Izvo zvakanyanya nyore kuwana basa raunoda mune iyi runyorwa uye tinya kaviri pairi.
- Mune maparentheses, unofanirwa kutsanangura sero, izvo zviri mukati zvichanyorwa mumashoko.
Teerera! Zvinokwanisika kunyora mumashoko kwete zvinyorwa zvenhamba zvesero rimwe chete, asiwo mugumisiro wekushanda kwemasvomhu nenhamba kubva kumasero akawanda. Semuenzaniso, kana ukasarudza sero rimwe chete, isa chiratidzo che "+" mushure mekudanwa kwayo uye kuratidza temu yechipiri - imwe sero, zvino chigumisiro chichava nhamba yenhamba mbiri dzakanyorwa mumashoko.
- Dzvanya kiyi "Enter". Masero acharatidza nhamba kana mhedzisiro yechiito, inoratidzwa nemazwi.
Zvinokwanisika kunyora nhamba mumashoko pasina kugadzira tafura - zvose zvaunoda ifomu uye mbeu kana chiito. Izvo zvinodiwawo kunyora fomula musero isina chinhu, asi mumabhuraketi, panzvimbo yeakatwasuka uye akatwasuka zviratidzo, nyora nhamba kana kutaura. Vhara mabhureki uye dzvanya "Enter" - nhamba dzinodiwa dzinoonekwa muchitokisi.
mhedziso
Kuti unyore manhamba mumashoko, unofanirwa kudhawunirodha yekuwedzera yeMicrosoft Excel uye kuibatanidza kuchirongwa uye kuimisa, iyo "Function Manager" inoita basa rakakosha mune zvimwe zviito. Basa racho rinogona kushandiswa zvose kune zviri mukati memaseru uye kune nhamba dziri kunze kwematafura. Nekuisa chirevo chesvomhu mune basa, unogona kuwana mhedzisiro yacho mukutaura kwekutaura.