Monga "Eksele" m'malo koma mfundo? sintha Excel

Ndikuzolowera dongosolo alipo zinthu, ife saganiza chakuti munthu akhoza kukhala pansi pa malamulo ena. Ndipotu, sindikunena wotchedwa Dalai Lama, ndi za limodzi mwa mavuto a ofesi zomwe zingachititse kupambana kolowera dera. Kwenikweni ake kwagona kuti m'mayiko ambiri, ngakhale ntchito chimodzimodzi mawerengero Arabic, chiwerengero nthawi olembedwa penapake mosiyana. A chitsanzo chapadera cha kusiyana izi, zomwe kawirikawiri zimabweretsa mavuto, ndi chizindikiro kuti umatilekanitsa mbali fractional chonsecho. Mu Russia, ndipo ndithudi mu malo Union, nthaŵi zonse koma, koma m'mayiko Western - mfundo.

Tanthauzo la mawu mu kupambana

Tiyeni tione mmene mavuto osafunika angachotsedwe pamaso pa dongosolo la "cholakwika" kapena tinene kuti, delimiter pachithunzichi. Nthawi zambiri, nambala munali mfundo, kupambana adzakhala kutanthauziridwa monga tsiku, ndipo mogwirizana, m'malo "25,11" inu kupeza "25.noyab" selo.

Pamene akugwira ntchito yambiri deta mu gome, simungathe yomweyo zindikirani kusintha. The kwambiri chifukwa chiwerengero aliyense akhoza kotero molakwika. Mwachitsanzo, "25,13" lizidzachita sichinasinthe. Mwina anaganiza kutembenuka zidzakhudza yekha manambala amene, isanayambe kapena itatha mfundo zochuluka kuchokera 1 mpaka 12. osiyanasiyana ili ntchito pofotokoza miyezi chaka ndi Choncho, amaona ngati chibwenzi. Ngati nambala ngati idzagwa imodzi kapena mazana awiri, izo kuonekera onse mu siteji mawerengedwe.

m'malo mfundo

Pali zingapo zimene mungachite a m'mene mipatuliro mu "Eksele". Tikambirana yekha mophweka kwambiri ndi zothandiza, amene angagwiritsidwe ntchito ndi wosuta aliyense, kaya mlingo wa kulemba kompyuta.

• Monga "Eksele" m'malo koma mfundo, ntchito magawo a dongosolo? Kuchita izi, kupita ku gawo "magawo" tebulo mkonzi ndi kupita "mwaukadauloZida" menyu. M'chigawo chino, muyenera kuchotsa bokosi cheke pansi "Ntchito dongosolo separators". Choncho potsekula wotsatira mfundo ziwiri, mungathe kusintha mudapholiwa magawano kufunika ntchito deta yanu.

• Monga "Eksele" m'malo koma mfundo pogwiritsa ntchito ntchito opaleshoni dongosolo la? Mu Windows gulu Control ayenera kupeza gawo "Regional ndi Language Mungasankhe." Ponena za "Mtundu" tsamba pawindo kuti atsegula, kusinthana kwa submenu "mwaukadauloZida Zikhazikiko" tsamba ndi "Numeri" kusintha mbali decimal kwa kutero.

• Monga "Eksele" m'malo koma mfundo pogwiritsa ntchito "Pezani ndi Sinthanitsani" ntchito? menyu Izi mwina bwino kuti owerenga ambiri, ndipo ntchito zake sikutanthauza ndemanga zina. Mfundo kokha zofunika kuti adzafuna kuchita ndi zimasonyeza kuti malo chisanadze editable. Ngati mulibe opaleshoni imeneyi, "kupambana" idzasintha mfundo zonse za zilipo pa pepala ndi kuchotsa disparity mbali ina ya gome, mukhoza kupeza izo mu zina.

lakale koma chotsimikiziridwa njira ina ndi Pre-m'malo separators m'lemba mkonzi aliyense yosavuta. Ndodo "kope" ku muyeso wa mapulogalamu Windows angathe kupirira ntchito imeneyi. Limagwirira kanthu akufanana ndi anafotokoza njira otsiriza lagona m'malo yosavuta zizindikiro pa masiku a spreadsheet mkonzi wanu.

Kusiyana menyu ya zipinda zazikulu zokhala ndi ofesi

Mu Maapatimenti ofesi ku Microsoft ndi wina Baibulo latsopanoli ndi yosiyana dongosolo la zinthu menyu. Anali nazonso ndi kupambana 2013. Kuwonjezera kupanga kusintha kuti akhudza mtundu chiwembu ndi maonekedwe a zithunzi pa lamulo riboni ali ankatembenukira katunduyo "Mungasankhe". Anasamukira pansi waukulu menyu dontho-pansi kumbali ya mbali.

Mu zonse zochita zina wosuta mu kupambana 2013 ntchito nsonga mu gawo lathali, ndi analogous kwathunthu ntchito ndi Mabaibulo kale. Mukakhala kutsegula ali ankatembenukira kwa menyu makonda, mudzapezeka mu mawonekedwe bwino.

Kulonga n'cigwagwa, ndiye Mabaibulo onse Office, ndi mitundu yosiyanasiyana aliyense pulogalamu lili ndi magawo item mu sidebar lapansi. Zikuphatikizapo buku la 2013 ndipo wotsatira, mungachite onse patsogolo kwambiri.

mbuna

Tsopano, kumvetsa monga "Eksele" m'malo ndi mfundo koma, kuthana ndi peculiarities njira anafotokoza. Kusintha zoikamo opaleshoni dongosolo kapena zoikamo pulogalamu, ndithudi, atha kuthandiza pa nkhani ya munthu amene nthawi kufunika, koma nthawi zonse mode uyu alibe ntchito zabwino kwambiri.

Kwambiri poyerekeza kwambiri pamaso pa zothandiza amayang'ana mwa nthawi deta kuwombola m'dera anakhumba pogwiritsa ntchito kufufuza menyu. Pankhaniyi, mulibe kuthamanga chiopsezo kupotozedwa deta awo matebulo zina ndipo zowoneka kulamulira ndondomeko ya kusintha kwa dividers fractional.

Text mtundu ndi mawerengedwe

Kuwonjezeranso anafotokoza, pali mbali ina chidwi tebulo mkonzi "kupambana". lemba analowa ndi kukopera, mwina kutchulidwa nkhani digito zina. Cell imene chiwerengero kusungidwa monga malemba, siidzasoŵa ndi kansalu wobiriwira mu chapamwamba kumanzere ngodya. Kunja, zonse zikuwoneka bwino, kanjedza si molakwika, koma timva sapita pamene kuyesera kubala akuti deta umenewu selo.

Choncho, kumanja kuyang'ana tebulo adzakupatsani zotsatira cholakwika, ngati mukhala mu mawerengedwe a. Vuto limeneli lingathetsedwe kudzera zonse "kupambana". Posankha khungu ndi ngodya wobiriwira pafupi supernatant akhoza wapezeka chilemba modabwa mu kansalu chikasu. Kuwonekera pa izo adzachititsa menyu yaing'ono nkhani. Ndi kusankha izo njira pamwamba "Sinthani kukhala chiwerengero", ndinu popanda imfa deta, kusintha maganizo awo.

Pambuyo pa ntchito m'mbali anapezazo onse adzachitidwa molondola. Mofulumira mukhoza kusankha kuposa khungu zotere, ndipo angapo moyandikana ndi yomweyo sinthani pogwiritsa ntchito menyu nkhani.

pomaliza

M'nkhani ino sitinatenga njira kudya ndi kwenikweni ntchito kukonza zoimira mawonekedwe a deta digito mu "kupambana". ntchito yawo kuchita kudzakuthandizani kukhalabe misempha yanu ndi nthawi pamene ntchito mu spreadsheet ndi.