Maitiro ekuita iyo yekutanga tsamba ye capital muExcel

Muzviitiko zvakawanda, zvinodikanwa kuti tsamba yekutanga iri patafura ye tafura yaive yakatumidzwa (capital). Kana mushandisi pakutanga akapinda mutsamba yepazasi kana kuteedzera iyo data kubva kune imwe sosi muExpel, mairi mazwi mashoma, unogona kupedza nguva yakakura kwazvo, iwe unogona kupedza nguva yakakura kwazvo, iwe unogona kupedza nguva yakakura kwazvo, iwe unogona kupedza nguva yakakura kwazvo, iwe unogona kupedza nguva yakawanda uye nguva yekuunza kutaridzika kweiyo tafura kune inodiwa nyika. Asi, pamwe, Excel ine zvishandiso zvakakosha izvo iwe zvaungaita kuti ingoutsa maitiro aya? Chokwadi, chirongwa ichi chine basa rekuchinja mavara akadzika kusvika capital. Ngatitarisei kuti zvinoshanda sei.

Maitiro ekushandurwa kwetsamba yekutanga kune zita racho

Haufanire kutarisira kuti muExcel kuti ibhatani rakaparadzana nekudzvanya iro, iwe unogona otomatiki tsamba yetambo kusvika kune zita racho. Kuti uite izvi, iwe uchafanirwa kushandisa mabasa, uye akati wandei kamwechete. Nekudaro, mune chero mamiriro ezvinhu, iyi nzira ine mubereko ichabhadhara mutengo wenguva pfupi izvo zvaizodikanwa kuti zvive zvinochinja zvine miganho.

Nzira 1: Kutsiva tsamba yekutanga muchitokisi pane zita remusoro

Kugadzirisa basa racho, basa guru rinoshandiswa kutsiva, pamwe nemabasa akaiswa mari eyekutanga uye yechipiri odhi inonyoreswa uye Revsimv.

• Iko kutsiva basa kunotsiva hunhu humwe kana chikamu chetsetse kune vamwe, maererano nenharo dzakataurwa;
• Akanyoreswa - anoita mavara muguta guru, ndiko kuti, guta guru, zvatinoda;
• Revhitiko - Inodzosera iyo nhamba yakatarwa yemavara eimwe mavara muchitokisi.

Ndiko kuti, zvichienderana neiyi seti yemabasa, tinodzosera tsamba yekutanga kuchitokisi chakataurwa, tichishandisa iyo inoshanda, tichaita iyo yepamusoro, uye tidzorere nebasa rekutsiva tsamba yepazasi kuti iyo yepamusoro.

Iyo general templete yekuvhiya uku inotaridzika seizvi:

= Kutsiva (yekare_text; nach_post; nhamba_ chiratidzo; chaiyo (zvinyorwa (zvinyorwa; nhamba))

Asi zviri nani kufunga nezvazvo pane mumwe muenzaniso. Saka, tine tafura yakapera umo mazwi ese akanyorwa aine tsamba diki. Isu tine chiratidzo chekutanga muchitokisi chimwe nechimwe nemazita kuti aite zita racho. Sero rekutanga rine surname rine marongero eB4.

1. Mune chero nzvimbo yemahara yepepa iri kana pane rimwe sheet, nyora iyo inotevera formula:

   = Kutsiva (b4; 1; 1; chaiyo (Revhitiko (B4; 1))



2. Kugadzirisa data uye uone mhedzisiro, tinya bhatani rePeturu pane iyo keyboard. Sezvauri kuona, ikozvino muchitokisi, izwi rekutanga rinotanga ne capital capital.



3. Isu tinova kana kukonzeresa kukona yezasi kuruboshwe kwechitokisi chine formula uye tichishandisa iyo yekuzadza mucherechedzo kopi iyo formula mumasero epazasi. Isu tinofanirwa kutevedzera chaizvo zvinzvimbo zvekudzikisa kuti maseru mangani ane masisitaza ane muzvinyorwa zvaro tafura.



4. Sezvauri kuona, kupihwa izvo zvinongedzo muFormula hama, uye kwete Mhedziso, kutevedzera kwakaitika nekuchinja. Naizvozvo, zviri mukati mechinzvimbo chinotevera mukurongeka kwenzvimbo zvinoratidzwa mumasero epazasi, asi zvakare ne capital capital. Zvino isu tinofanirwa kuisa mhedzisiro yacho tafura yepafura. Sarudza iyo renji ine mafomula. Ini ndinodzvanya pane iyo kurudyi mbeva bhatani uye sarudza "Kopa" mune iyo mamiriro menyu.



5. Mushure meizvozvo, isu tinoratidza masero ekutanga ane mazita ari patafura. Fonera mamiriro emenyu nekudzvanya kurudyi mbeva bhatani. Mu "isa parameter" block, sarudza chinhu "kukosha", izvo zvinomiririrwa semanyorero nenhamba.



6. Sezvauri kuona, mushure meizvozvo, iyo data yatinoda yakaiswa munzvimbo dzenzvimbo dzepafura. Panguva imwecheteyo, mavara akadzika mumashoko ekutanga emasero akatsiviwa neyekumusoro. Zvino, kwete kupamba kutaridzika kweiyo pepa, iwe unofanirwa kubvisa masero ane mafomula. Zvakanyanya kukosha kudzima kana iwe waita kutendeuka pane rimwe pepa. Isu tinoratidza iyo yakatarwa renji, tinya kurudyi-tinya uye mune mamiriro emenyu, imbomira kusarudzwa pane iyo "Delete ..." chinhu.



7. Mubhokisi dialog rakawandisa rinowoneka, iwe unoisa switch kune "tambo" chinzvimbo. Dzvanya pane "OK" bhatani.

Mushure meizvozvo, iyo data yakawedzera ichacheneswa, uye isu tichaita mhedzisiro yakawana: mune yega tafura yetafura, izwi rekutanga rinotanga ne capital capital.

Nzira 2: Izwi rega rega rine tsamba huru

Asi pane zviitiko pazvinenge zvichidikanwa kuti urege kuita chete izwi rekutanga muchitokisi, kutanga ne capital tsamba, asi kazhinji, izwi rega rega. Nekuda kweizvi, kunewo basa rakaparadzana, uye zviri nyore kupfuura zvapfuura. Ichi chimiro chinonzi profant. Yayo syntax iri nyore kwazvo:

= Gadzirira (Kerochair)

Paruenzaniso wedu, kushandiswa kwaro kuchataridzika zvinotevera.

1. Sarudza nzvimbo yemahara yepepa. Dzvanya pane iyo "Insert Basa" icon.



2. Mune iyo inoshanda yemiwiwa yemabasa, isu tiri kutsvaga "Raknach". Awana zita iri, tinozvipira uye tinya pane "OK" bhatani.



3. Iyo hwindo rekupokana rinovhura. Isu tinoisa iyo inotuka mu "zvinyorwa". Sarudza chitunha chekutanga ne surname mune tafura yepafura. Mushure mekunge kero yake yakarova iyo nharo hwindo, tinya pane iyo OK bhatani.

   

   Pane imwe sarudzo yekuita pasina kutanga iyo mabasa wizard. Kuti tiite izvi, tinofanirwa, sekutanga kwenzira yapfuura, pinda iyo basa mumanje muchitokisi nekurekodha kweiyo sosi yedata data. Mune ino kesi, iyi yekupinda ichave iyo inotevera fomu:

   = Gadzirira (B4)

   Ipapo iwe uchazoda kudzvanya bhatani rePeturu.

   Iko kusarudzwa kwenyaya yakatarwa kunoenderana zvachose pane mushandisi. Kune vashandisi ivavo vasiri kushandiswa kuchengetedza mafomu mazhinji akasiyana mumusoro, zvakasikwa, zviri nyore kuita nerubatsiro rwewadhi yemabasa. Panguva imwecheteyo, vamwe vanotenda kuti nekukurumidza nekukurumidza kupfuura bhuku rebasa rekupinda.

4. Chero chipi zvacho chisarudzo chakasarudzwa, muchitokisi chatakawana mhedzisiro yatinoda. Iye zvino izwi rega rega rutsva muchitokisi rinotanga ne capital capital. Sokupedzisira, ko copy the formula pamasero pazasi.



5. Mushure mekopi iyo mhedzisiro ichishandisa mamiriro menyu.



6. Isa iyo data kuburikidza ne "kukosha" chinhu inoisa paramita muThe Song tafura.



7. Bvisa mikana yepakati kuburikidza nemamiriro emenyu.



8. Nwindo idzva, simbisa kubviswa kwemitsara nekuisa switch kune yakakodzera chinzvimbo. Dzvanya bhatani re "OK".

Mushure meizvozvo, tichawana tafura isina kuchinjika tafura, asi mazwi ese chete mumasero akabatwa achafemerwa uye tsamba huru.

Sezvauri kuona, kunyangwe paine chokwadi chekushandurwa kwemapepa emapepa muExcels hazvigone kunzi maitiro ekutanga, zvisinei, zviri nyore uye zvakareruka pane kuchinja mavara, kunyanya kana paine zvakawanda zvacho. Iyo Allgorithms iri pamusoro inochengetedza kwete chete simba remushandisi, asi nguva yakakosha inguva. Naizvozvo, zvinodikanwa kuti mushandisi wechigarire anogona kushandisa izvi zvishandiso mubasa rayo.