Nkuko tubizi, akenshi nimero isanzwe yanditswe numubare wa Roman. Rimwe na rimwe, bakeneye gukoreshwa kandi iyo bakora muri gahunda ya Excel. Ikibazo nuko kuri clavier isanzwe ya mudasobwa, itsinda rya digitale rigaragajwe nimibare yicyarabu. Reka tumenye uburyo bwo gucapa imibare y'Abaroma muri Excel.
Isomo: Kwandika Imibare y'Abaroma mu Ijambo rya Microsoft
Gucapa Imibare y'Abaroma
Mbere ya byose, ugomba kumenya icyo ushaka gukoresha imibare y'Abaroma. Ibi bizakoreshwa cyangwa gukenera guhindura misa yindangagaciro zihari zanditswe nimibare yicyarabu. Ku rubanza rwa mbere, igisubizo kizabaroroshye rwose, kandi ku wa kabiri ugomba gukoresha formulaile idasanzwe. Byongeye kandi, imikorere izafasha niba uyikoresha atumva amategeko yo kwandika ubu bwoko bwimibare.Uburyo 1: Icapa kuri clavier
Abakoresha benshi bibagirwa ko umubare w'Abaroma urimo gusa inyuguti z'inyuguti z'ikilatini. Na none, ibimenyetso byose byinyuguti yikilatini zirahari mucyongereza. Igisubizo cyoroshye rero, niba wumva neza amategeko yo kwandika ubu bwoko bwo kubara, bizahinduka imiterere ya clavier ivuga icyongereza. Kuri Kanda gusa CTRL + shift urufunguzo. Noneho andika umubare wa roman winjiza inyuguti zicyongereza ziva muri clavier murwego rwo hejuru, ni ukuvuga muburyo bwa Caps "bushoboje" cyangwa hamwe nurufunguzo rwa Shift.
Uburyo 2: Kwinjiza ikimenyetso
Hariho ubundi buryo bwo gushyiramo imibare y'Abaroma mugihe udateganya gukoresha misa yumubare. Ibi birashobora gukorwa binyuze mumadirishya yinjiza inyuguti.
- Turagaragaza selile duteganya gushyiramo ikimenyetso. Kuba muri tab "shyiramo", kanda kuri buto kuri rubbon, ikimenyetso ", giherereye mububiko bwibikoresho.
- Inyuguti zinjiza idirishya ritangira. Kuba mu tab "ibimenyetso", hitamo ikintu icyo ari cyo cyose cy'imyandikire (Arial, kalibri, inshuro nshya z'Abaroma cyangwa izindi "zishyirwaho" kuva kurutonde rwamanutse, hitamo umwanya wa "Ikilatini". Ibikurikira, hitandiwe kanda kuri ibyo bimenyetso ishusho ya roman idukeneye. Nyuma ya buri kanda ku kimenyetso, tukanda kuri buto "Paste". Nyuma yo kwinjiza inyuguti birangiye, kanda kuri buto yo gusoza idirishya ryikimenyetso mu mfuruka iburyo.
Nyuma yibi manipilations, imibare y'Abaroma iragaragara mu Kagari mbere yatoranijwe n'umukoresha.
Ariko, byumvikane, ubu buryo buragoye kuruta ibyabanjirije kandi bisobanura kubikoresha gusa mugihe kubwimpamvu runaka idahujwe cyangwa clavier idakora.
Uburyo bwa 3: Imikorere yo gusaba
Byongeye kandi, hari amahirwe yo gukuramo imibare y'Abaroma ku rupapuro rwitwa interineti binyuze mu mikorere idasanzwe, yitwa "Umuroma". Iyi formula irashobora kwinjizwa haba mu idirishya ryimpaka hamwe ninteruro ishushanyije, hanyuma wandike intoki mukagari kerekana indangagaciro ukurikiza syntax ikurikira:
= Roman (umubare; [imiterere])
Aho kugirango "umubare" wibipimo, birakenewe gusimbuza umubare wagaragajwe nimibare yicyarabu ushaka guhindura ku nyandiko y'Abaroma. Ibipimo bya "Ifishi" ntabwo ari impaka ziteganijwe kandi zigaragaza ubwoko bwo kwandika umubare.
Ariko nanone, kubakoresha benshi, mugihe bakoresheje formulaire, biroroshye gukoresha imikorere wizard kuruta kubyara igitabo.
- Hitamo Akagari aho ibisubizo byarangiye bizerekanwa. Kanda kuri Button "Shyira imikorere", ushyizwe ibumoso bwumugozi wa formula.
- Imikorere yinzird idirishya rirakorwa. Mu cyiciro "Urutonde rw'Imyandikire yuzuye" cyangwa "imibare" bashaka ikintu "Umuroma". Turabigaragaza hanyuma ukande kuri buto ya "ok" hepfo yidirishya.
- Idirishya ry'impaka rifungura. Impaka zonyine ni "umubare". Kubwibyo, wandike numero yicyarabu ukeneye mukibuga cyizina rimwe. Kandi nkimpaka, urashobora gukoresha umurongo ugana akagari aho umubare uherereye. Impaka ya kabiri yitwa "Ifishi" ntabwo ari itegeko ryo kuzura. Nyuma yamakuru yinjiye, kanda buto "OK".
- Nkuko tubibona, umubare muburyo ukeneye urerekanwa muri selire yabanjirije yatoranijwe.
Ubu buryo bworoshye cyane mugihe uyikoresha atazi inyandiko nyayo yumubare muri verisiyo y'Abaroma. Muri iki gihe, bituma kwinjira mumibare yicyarabu, kandi gahunda ubwayo irabahindura ubwoko bwerekana.
Isomo: Umukozi wa Wizard muri Excel
Isomo: Imibare yimibare muri Excel
Uburyo 4: Guhindura rusange
Ariko, ikibabaje, nubwo umurimo w'Abaroma uvuga ko itsinda ryabakora imibare, ritanga ibarwa n'imibare ryinjiye hamwe n'ubufasha bwayo, kimwe no mu buryo bwavuzwe haruguru, ntibishoboka. Kubwibyo, kugirango utangire umubare, gukoresha imikorere ntabwo byoroshye. Byihuta cyane kandi byoroshye kwandika umubare wifuza muburyo bwa roman yanditse muri clavier ukoresheje imiterere yicyongereza. Ariko, niba ukeneye guhindura umugozi cyangwa inkingi yuzuyemo imibare yicyarabu kumiterere yavuzwe haruguru, hanyuma muriki gihe gusaba formulaire yihutisha cyane inzira.
- Dutanga ihinduka ryagaciro ryambere mu nkingi cyangwa umurongo uva mumyandikire yicyarabu muburyo bwo kwinjiza imfashanyigisho nuburyo bwo kwinjiza imfashanyigisho, nkuko byasobanuwe haruguru. Nkimpaka, dukoresha umurongo ujya muri kasho, ntabwo ari umubare.
- Nyuma yo guhindura umubare, shyira indanga kuruhande rwiburyo bwiburyo bwa selire ya formula. Yahinduwe mubintu muburyo bwumusaraba, bwitwa Ikimenyetso cyuzuye. Kanda buto yimbeba yibumoso hanyuma ukayikurura hamwe na selile zifite numero yicyarabu.
- Nkuko tubibona, formula yandukuwe muri kasho, kandi indangagaciro muri zo zerekanwa nkimibare rwabaroma.
Isomo: Nigute ushobora gukora autocomplete muri excel
Hariho uburyo bwinshi bwo kwandika imibare y'Abaroma kugirango tuvuge ko ari indashyikirwa, byoroshye muri byo ni urutonde rwimibare kuri clavier mu cyiciro kivuga icyongereza. Mugihe ukoresheje imikorere y'Abaroma, ntibikenewe ningingo zuyu mubare, kuko gahunda zose zifata. Ariko, ikibabaje, ntakintu cyibanze kizwi kurubu gitanga amahirwe yo gukora imibare muri gahunda ukoresheje ubu bwoko.