Izinombolo ezizenzakalelayo zezintambo ku-Excel. Izindlela ezi-3 zokulungiselela izinombolo ezenzakalelayo zemigqa ku-Excel

Lapho usebenza ngetafula, inani lezinombolo lingadingeka. Izakhiwo, ikuvumela ukuthi uzulazule ngokushesha futhi useshe idatha edingekayo. Ekuqaleni, uhlelo seluvele lunenombolo, kepha luyi-static futhi alunakushintshwa. Kucatshangelwe ukuthi ungene ngesandla ukufaka izinombolo ezilungele, kepha ezithembekile, kunzima ukuzisebenzisa lapho zisebenza ngamatafula amakhulu. Ngakho-ke, kulokhu okubonakalayo sizobheka izindlela ezintathu eziwusizo futhi ezisebenziseka kalula zethebula letafula ku-Excel.

Indlela 1: Inombolo ngemuva kokugcwalisa imigqa yokuqala

Le ndlela ilula futhi isetshenziswa kakhulu lapho usebenza ngamatafula amancane naphakathi. Kuthatha isikhathi esincane futhi kuqinisekisa ngaphandle kwanoma yimaphi amaphutha ekubalweni. Imiyalo yesinyathelo ngesinyathelo ibukeka kanjena:

1. Okokuqala ufuna ukudala ikholomu ongayikhetha etafuleni elizokwakhelwa ngaphezulu kwezinombolo.
2. Lapho nje ikholamu idalwe, emgqeni wokuqala, faka inombolo 1 kwesibili, nangomugqa wesibili, faka idijithi 2.

Dala ikholomu bese ugcwalisa amaseli

1. Khetha amaseli amabili agcwele ama-3 bese uzulazula ekhoneni elingakwesokudla lendawo ekhethiwe.
2. Ngokushesha nje lapho kuvela isithonjana seBlack Cross, bamba i-LKM bese welula le ndawo kuze kube sekupheleni kwetafula.

Welula izinombolo kulo lonke uhla lwethebula

Uma konke kwenziwa kahle, ikholomu yezinombolo izogcwaliswa ngokuzenzakalelayo. Lokhu kuzokwanela ukufeza umphumela oyifunayo.

Umphumela womsebenzi owenziwe

Indlela 2: I-String Operator

Manje siya endleleni elandelayo yokubalwa, esho ukusetshenziswa komsebenzi okhethekile "wentambo":

1. Okokuqala, kufanele wakhe ikholomu yezinombolo, uma kungekho muntu.
2. Ngokwentambo kokuqala kwale kholamu, faka ifomula yokuqukethwe okulandelayo: = Umugqa (A1).

Sethula ifomula esitokisini

1. Ngemuva kokufaka ifomula, qiniseka ukuthi ucindezela ukhiye we- "Enter", owenza umsebenzi, futhi uzobona isibalo 1.

Gcwalisa iseli bese welula izinombolo

1. Manje kusaqhubeka nendlela yokuqala yokuletha isikhombisi esiya ekhoneni elingezansi kwesokudla sendawo ekhethiwe, lindela isiphambano esimnyama bese welula indawo kuze kube sekupheleni kwetafula lakho.
2. Uma konke kwenziwa ngendlela efanele, ikholomu izogcwaliswa ngenombolo futhi ingasetshenziswa ukuqhubeka nokucinga imininingwane.

Silinganisela umphumela

Kunendlela ehlukile, ngaphezu kwendlela ebekiwe. Kuliqiniso, kuzodingeka ukuthi usebenzise i-Module "Master Imisebenzi":

1. Ngokufanayo, dala ikholomu yokubala.
2. Chofoza esitokisini sokuqala somugqa wokuqala.
3. Ukusuka ngaphezulu eduze kwentambo yokusesha chofoza isithonjana se- "FX".

Yenza kusebenze "umsebenzi wezemisebenzi"

1. I- "Work Master" icushiwe, lapho kudingeka uchofoze khona endaweni ethi "isigaba" bese ukhetha "izixhumanisi kanye nama-arrays".

Khetha izingxenye ezidingekayo

1. Ukusuka kwimisebenzi ehlongozwayo, uzokhetha inketho ye- "Line".

Sebenzisa umsebenzi we- "string"

1. Kuzovela iwindi elengeziwe lokufaka imininingwane. Udinga ukubeka ikhesa entweni "yereferensi" bese ucacisa ikheli leseli lokuqala lekholomu yokubala (esimweni sethu kungu-A1).

Gcwalisa idatha edingekayo

1. Ngenxa yezenzo ezenziwa esitokisini esingenalutho sokuqala, kuvela idijithi. 1. Ihlala futhi ukusebenzisa i-angle engesokudla yendawo ekhethiwe ukwelula yonke itafula.

Welula umsebenzi kulo lonke uhla lwethebula

Lezi zenzo zizosiza ukuthola zonke izinombolo ezidingekayo futhi ngeke kusize ukuthi iphazanyiswe yilezo zinto ezikhona ngenkathi zisebenza netafula.

Indlela 3: Ukusetshenziswa kokuthuthuka

Futhi le ndlela ihlukile kwezinye izinto ezisusa abasebenzisi ezidinga usizo ukuze basebenzise umaki we-autofile. Lo mbuzo kufanelekile kakhulu, ngoba isicelo saso asisebenzi lapho sisebenza ngamatafula amakhulu.

1. Dala ikholomu yezinombolo nenothi ngenombolo yokuqala yeseli 1.

Yenza izenzo eziyisisekelo

1. Iya kubha yamathuluzi bese usebenzisa isigaba se- "Ikhaya", lapho siya khona esigatshaneni sokuhlela "futhi sifuna isithonjana somcibisholo phansi (lapho uzulazula uzonikeza igama elithi" Gcwalisa ").

Iya ku "Progression" umsebenzi

1. Kumenyu eyehlayo udinga ukusebenzisa umsebenzi we- "Progression".
2. Ewindini elivelayo, okulandelayo kufanele kwenziwe:

Gcwalisa imininingwane edingekayo

1. Uma konke kwenziwa kahle, uzobona umphumela wenombolo ezenzakalelayo.

Umphumela otholile

Kunye indlela ehlukile yokwenza okubangelayo okufana nalokhu:

1. Siphinda ngezenzo ukudala ikholomu kanye nophawu esitokisini sokuqala.
2. Silwa lonke uhla lwethebula ohlela ukubalwa.

Sigubha lonke uhla lwetafula

1. Iya esigabeni "sasekhaya" bese ukhetha isigatshana esithi "Ukuhlela".
2. Sifuna into ethi "Gcwalisa" bese ukhetha "ukuqhubeka".
3. Efasiteleni elivelayo, siphawula imininingwane efanayo, iqiniso manje aligcwalisi into "umkhawulo okusho ukuthi".

Gcwalisa idatha ewindini elihlukile

1. Chofoza ku- "Kulungile".

Le nketho iguquguqukayo ngokwengeziwe, ngoba ayidingi ukubala okuphoqelekile kwemigqa edinga ukubalwa. Kuliqiniso, nganoma yisiphi isimo kuzodingeka ukuthi wabele uhla olufanele lubalwe.

Umphumela olungile

Ukugcina

Inombolo ye-Row ingenza lula umsebenzi ngetafula elidinga ukubuyekezwa njalo noma ukusesha imininingwane oyifunayo. Ngenxa yemiyalo enemininingwane echazwe ngenhla, ungakhetha isixazululo esifanele kakhulu sokuxazulula umsebenzi.

Umlayezo othomathikhi wezintambo ku-Excel. Izindlela ezi-3 zokulungiselela izintambo ezizenzakalelayo zenombolo ku-Excel zivele kuqala kubuchwepheshe bolwazi.