Sezvo mu "Eksele" kutsiva koma pfungwa? kugadzira Excel

Maitiro kushandiswa aivapo hurongwa hwezvinhu, isu vasingafungisisi kuti munhu anogona kurarama pasi dzimwe mitemo. Kutaura zvazviri, izvi hazvina vachiti Dalai Lama, uye rondedzero rimwe matambudziko hofisi chinogona kukonzera Excel remunharaunda ezvinhu. Chaizvoizvo Its iri chokuti munyika dzakawanda, kunyange kushandisa chete sezviverengo Arabic, nhamba iri kazhinji zvakanyorwa zvishoma zvakasiyana. Muenzaniso unoshamisa musiyano uyu, izvo kazhinji kunotungamirira kune matambudziko, ndicho chiratidzo chokuti wakapatsanura kubva fractional chikamu yose. MuRussia, uye zvirokwazvo mune yaimbova nzvimbo Soviet, zviri dzose koma, asi munyika Western - pfungwa.

Meaning yematemu muna Excel

Ngatitarisei kuti migumisiro chisingadiwi hungaguma pamberi kwegadziriro "zvakaipa" kana, asi kutaura, sizvo delimiter. Kazhinji, nhamba ine pfungwa, Excel chichange sokureva zuva, uye maererano, pane "25.11" iwe kuwana "25.noyab" muchitokisi.

Kana kushanda yakawanda mashoko ari tafura, haugoni wangoona kuchinja ichi. The zvakawanda nokuti haana nhamba yose inogona kukanganiswa saka. Somuenzaniso, "25.13" richaramba kuchinja. Sezvo waita pamwe wafungidzira kutendeuka kuchachinja nhamba chete izvo, asati kana pashure pfungwa dziri kuwanda kubva 1 kusvika 12. Hazvina Range ichi rinoshandiswa kureva mwedzi pagore uye, naizvozvo, iwo kunonzwisiswa kuva zuva. Kana nhamba dzakadaro vachawa mumwe kana mazana maviri, zvichava unooneka zvose oga dzemaitirwe rwakazara.

tsiva pfungwa

Kune nzira dzakawanda sei kuisa nezvitura befu ari "Eksele". We funga chete kupfuura nyore uye anobatsira, izvo zvinogona kushandiswa chero anoishandisa, zvisinei padanho kombiyuta kuverenga.

• Sezvo mu "Eksele" kutsiva koma pfungwa, vachishandisa parameters yepurogiramu? Kuti aite izvi, enda pakanzi "Parameters" tafura mupepeti uye kuenda "Advanced" Muterere. Muchikamu ichi, unofanira kubvisa cheki bhokisi pasi "Use kwegadziriro separators". Saka anokiyinura anotevera mbiri pfungwa, unogona kushandura nokupesana mavanga nezvokudiwa kushanda mashoko enyu.

• Sezvo mu "Eksele" kutsiva koma pfungwa, kushandisa uchishandisa hurongwa wacho waivako? Muna Windows Control Panel vanofanira kuwana chikamu "Regional uye Mutauro Options." Se kuti "Format" Tab nepahwindo kuti anovhura, chinja pamusoro kusvika submenu "Advanced Settings" Tab uye "Numbers" kuchinja grade mugove anodiwa.

• Sezvo mu "Eksele" kutsiva koma pfungwa pakushandisa "Wana uye Tsiva" basa? Muterere Izvi zvichida zvaizivikanwa vanoshandisa vakawanda, uye kushandiswa kwayo haatarisiri mashoko okuwedzera. The chete inokosha kuti zvinoda kuita kusimbisa kudiwa pre-editable nharaunda. Kana musingadi kuita kuvhiyiwa uku, "Excel" ichachinja dzose iripo pfungwa pamusoro jira uye kubvisa disparity muchikamu rimwe tafura, unogona kuwana mune dzimwe.

Imwe nzira yekare asi yakaonekwa kuti ndeyechokwadi ndiko kwerubwinyo rwakagara rwuripo-yokutsiva separators chero nyore chinyorwa mupepeti. Staff "nebhuku rokunyorera" kubva mureza Windows zvirongwa zvinogona zvakakwana kukurira basa iri. The mashandiro chiito zvakafanana okupedzisira akatsanangura nzira iri nyore yaitsiva nezviratidzo mazuva ako spreadsheet mupepeti.

Kusiyana Muterere mahofisi Inn

Muhofisi Suite kubva Microsoft nomumwe shanduro itsva siyanei urongwa Muterere zvinhu. Ndozvakaitikawo uye Excel 2013. Kunze kugadzira kuchinja kuti akabata ruvara zano uye pakuonekwa kwemifananidzo pamusoro Ribbon murayiro yave haachatauri chinhu "Options". Akatamira kusvikira pasi huru donhwe-pasi Muterere kudivi kwayo chikamu.

Mune zvimwe zvose User zviito Excel 2013 vachishandisa mazano ari yapfuura chikamu, zvineringanidzo chose kushanda mushanduro adarika. Kamwe iwe kuzarura akaita zvava pazviruva Muterere, uchawana uri yaizivikanwa inowanikwa.

Aunganidze pamwe, ipapo zvose Office shanduro namavara akasiyana mumwe chirongwa yaizogara chinhu parameters ari sidebar. Izvi zvinosanganisira shanduro 2013 uye vose vaivapo, zvikuru yepamusoro zvokusarudza.

misungo

Zvino, kunzwisisa sezvo mu "Eksele" anotsiviwa ane koma pfungwa, kubata pamwe peculiarities dzokudzidzisa kurondedzerwa. Kuchinja uchishandisa hurongwa Kurongwa kana chirongwa zviruva Chokwadi, vanogona kubatsira panyaya imwe chete-nguva vanoda, asi nguva dzose zviri nzira iyi takasununguka zvikuru haashandi.

Zvikuru zvinodiwa mumaonero kushanda anotarira imwe-nguva Data Exchange ari kutsvakwa nzvimbo tichishandisa kutsvaka Muterere. Muchiitiko chino, iwe usamhanya ngozi kukanganisa mashoko avo dzimwe matafura uye anogona nemaziso kudzora muitiro kwokuchinja fractional vanokamura.

Text urongwa uye kukarukureta

Kunze zvose zvinorondedzerwa, pane chimwe chinofadza chepfungwa tafura mupepeti "Excel". The acho akapinda kubudikidza kukopa, arege kuzivikanwa sezvo digitaalinen ruzivo mune zvimwe zviitiko. Cell umo nhamba yaichengetwa sezvo wenyaya, achaiswa anozivikanwa ne munyoro, triangle iri repamusoro rworuboshwe wekona. Nechokunze, zvose anotarira vakadzikama, nenhamba zvisina kunaka, asi zvinyorwa havaendi kana kuedza kubudisa Zvinofungidzirwa Data ane sero akadaro.

Saka, netafura kodzero-achitarisa vachapa zvakaipa zvaitika, kana iwe kuidya dzemaitirwe. dambudziko iri kugadziriswa nguva rinoreva "Excel". Uchisarudza muchitokisi rwegirini pakona pedyo supernatant anogona kuonekwa okushamisika okuti chiratidzo yero Triangle. Nekudzvanya pariri achaita chiduku chechinyorwa Muterere. By kusarudza izvozvo pamusoro nzira "Exchange kuti nhamba", iwe uri pasina mashoko kurasikirwa, vachinje maonero.

Mushure yakadaro zvakananga oparesheni, Masvomhu vose kuitwa nemazvo. Kuti rikurumidze unogona kusarudza vanopfuura mumwe muchitokisi kwakadaro, uye vanoverengeka pedyo uye pakarepo kushandura muzviruva vachishandisa akapoteredza Muterere.

In mhedziso

Munyaya ino isu vakauya kutsanya uye chaizvoizvo kushanda nzira kururamisa inofananidza wechinhu digitaalinen Data mu "Excel". Chikumbiro chavo uchidzidzira chichabatsira kuchengeta tsinga dzako uye nguva apo kushanda spreadsheet.