Izinombolo zomugqa ezizenzakalelayo ku-Excel. Izindlela ezi-3 zokusetha izinombolo zomugqa ezizenzakalelayo ku-Excel

Lapho usebenza ngetafula, izinombolo zingadingeka. Yakha, ikuvumela ukuthi uzulazule kuyo ngokushesha futhi useshe idatha edingekayo. Ekuqaleni, uhlelo seluvele lunezinombolo, kodwa lumile futhi alukwazi ukushintshwa. Indlela yokufaka izinombolo ngesandla inikezwa, elula, kodwa hhayi njengokwethenjelwa, okunzima ukuyisebenzisa lapho usebenza namatafula amakhulu. Ngakho-ke, kulesi sihloko, sizobheka izindlela ezintathu eziwusizo nezilula zokusebenzisa izinombolo zamatafula ku-Excel.

Indlela 1: Ukubala Ngemva Kokugcwalisa Imigqa Yokuqala

Le ndlela ilula futhi isetshenziswa kakhulu uma usebenza namatafula amancane naphakathi. Kuthatha ubuncane besikhathi futhi kuqinisekisa ukuqedwa kwanoma yimaphi amaphutha ekubaleni izinombolo. Isinyathelo ngesinyathelo imiyalelo yabo imi kanje:

1. Okokuqala udinga ukwakha ikholomu eyengeziwe etafuleni, ezosetshenziselwa izinombolo ezengeziwe.
2. Uma ikholomu isidaliwe, beka inombolo 1 kumugqa wokuqala, bese ubeka inombolo 2 emgqeni wesibili.

3. Khetha amaseli amabili agcwalisiwe bese uhambisa phezulu ekhoneni elingezansi kwesokudla lendawo ekhethiwe.
4. Lapho nje isithonjana esimnyama sivela, bamba i-LMB bese uhudula indawo ekupheleni kwetafula.

Uma konke kwenziwa ngendlela efanele, ikholomu enezinombolo izogcwaliswa ngokuzenzakalelayo. Lokhu kuzokwanela ukufeza umphumela oyifunayo.

Indlela 2: "ROW" opharetha

Manje ake sidlulele endleleni yokufaka izinombolo elandelayo, ehilela ukusetshenziswa komsebenzi okhethekile othi “STRING”:

1. Okokuqala, dala ikholomu yezinombolo, uma ingekho.
2. Kumugqa wokuqala wale kholomu, faka ifomula elandelayo: =UMUGQA(A1).

3. Ngemuva kokufaka ifomula, qiniseka ukuthi ucindezela inkinobho ethi "Enter", evula umsebenzi, futhi uzobona inombolo 1.

4. Manje kusele, ngokufana nendlela yokuqala, ukuhambisa isikhombisi ekhoneni elingezansi kwesokudla sendawo ekhethiwe, linda ukuthi kubonakale isiphambano esimnyama bese welula indawo kuze kube sekupheleni kwetafula lakho.
5. Uma yonke into yenziwe ngendlela efanele, ikholomu izogcwaliswa ngezinombolo futhi ingasetshenziselwa ukubuyisa ulwazi olwengeziwe.

Kukhona enye indlela, ngaphezu kwendlela eshiwo. Yiqiniso, kuzodinga ukusetshenziswa kwemojula ethi "Function Wizard":

1. Ngokufanayo dala ikholomu ukuze uthole izinombolo.
2. Chofoza iseli yokuqala kumugqa wokuqala.
3. Phezulu eduze kwebha yokusesha, chofoza isithonjana "fx".

4. I-"Function Wizard" icushiwe, lapho udinga uchofoze into ethi "Isigaba" bese ukhetha "Izikhombo Nezinhlu".

5. Kusuka kumisebenzi ehlongozwayo, kusala ukukhetha inketho ethi "ROW".

6. Iwindi elengeziwe lokufaka imininingwane lizovela. Udinga ukufaka ikhesa entweni ethi "Xhuma" futhi ensimini ubonise ikheli leseli lokuqala lekholomu yezinombolo (kithi, leli inani A1).

7. Ngenxa yezenzo ezenziwe, inombolo 1 izovela kuseli lokuqala elingenalutho. Kusele ukusebenzisa ikhona elingezansi kwesokudla lendawo ekhethiwe futhi ukuze uyidonsele kulo lonke ithebula.

Lezi zenzo zizokusiza ukuthi uthole zonke izinombolo ezidingekayo futhi zikusize ukuthi ungaphazanyiswa yizinto ezincane ezinjalo ngenkathi usebenza netafula.

Indlela yesi-3: ukusebenzisa inqubekelaphambili

Le ndlela ihlukile kwezinye kulokho iqeda isidingo sokuthi abasebenzisi basebenzise ithokheni yokugcwalisa ngokuzenzakalela. Lo mbuzo ubaluleke kakhulu, ngoba ukusetshenziswa kwawo kungasebenzi lapho usebenza namatafula amakhulu.

1. Sakha ikholomu yokufaka izinombolo bese simaka inombolo 1 kuseli lokuqala.

2. Siya kubha yamathuluzi futhi sisebenzise isigaba "Ekhaya", lapho siya esigatshaneni esithi "Ukuhlela" futhi sibheke isithonjana ngendlela yomcibisholo oya phansi (uma uhambisa phezulu, uzonikeza igama elithi "Gcwalisa").

3. Kumenyu yokudonsela phansi, udinga ukusebenzisa umsebenzi othi "Ukuqhubekela phambili".
4. Ewindini elivelayo, yenza okulandelayo:
   • maka inani “Ngamakholomu”;
   • khetha uhlobo lwe-arithmetic;
   • endaweni ethi "Isinyathelo", maka inombolo 1;
   • esigabeni "Inani elikhawulelwe" kufanele uqaphele ukuthi mingaki imigqa ohlela ukuyizinombolo.

5. Uma konke kwenziwa ngendlela efanele, khona-ke uzobona umphumela wokubala okuzenzakalelayo.

Kukhona enye indlela yokwenza lokhu kufakwa kwezinombolo, ebukeka kanjena:

1. Phinda izinyathelo zokwakha ikholomu bese umaka kuseli lokuqala.
2. Khetha lonke ibanga lethebula ohlele ukulifaka izinombolo.

3. Yiya engxenyeni ethi “Ekhaya” bese ukhetha isigatshana sokuthi “Ukuhlela”.
4. Sibheka into ethi "Gcwalisa" bese ukhetha "Ukuqhubeka".
5. Efasiteleni elivelayo, siphawula idatha efanayo, nakuba manje asiyigcwalisi into ethi "Limit value".

6. Chofoza "OK".

Le nketho ibanzi kakhulu, ngoba ayidingi ukubalwa kwemigqa edinga izinombolo. Yiqiniso, kunoma yikuphi, kuzodingeka ukhethe ububanzi obudinga ukubalwa.

Nakani! Ukuze wenze kube lula ukukhetha uhla lwethebula olulandelwa izinombolo, ungavele ukhethe ikholomu ngokuchofoza unhlokweni we-Excel. Bese usebenzisa indlela yesithathu yokufaka izinombolo bese ukopisha ithebula eshidini elisha. Lokhu kuzokwenza lula izinombolo zamathebula amakhulu.

Isiphetho

Ukufaka izinombolo zomugqa kungenza kube lula ukusebenza ngetafula elidinga ukubuyekezwa njalo noma elidinga ukuthola ulwazi oludingayo. Ngenxa yemiyalo enemininingwane engenhla, uzokwazi ukukhetha isixazululo esifaneleka kakhulu somsebenzi owenziwayo.