Okuqukethwe
Ngenkathi usebenza ku-Excel, akuvamile ukuthi udinge izinombolo zomugqa kukholamu ehlukile. Lokhu kungenziwa ngokufaka izinombolo ze-serial mathupha, ngamanye amazwi, ngokuzibhala kukhibhodi. Kodwa-ke, lapho usebenza ngenani elikhulu lolwazi, ukufaka izinombolo ngesandla akuyona inqubo emnandi kakhulu futhi esheshayo, lapho, ngaphezu kwalokho, amaphutha nama-typos angenziwa. Ngenhlanhla, i-Excel ikuvumela ukuthi wenze le nqubo ngokuzenzakalelayo, futhi ngezansi sizobheka ukuthi lokhu kungenziwa kanjani ngezindlela ezahlukahlukene.
Okuqukethwe
Indlela 1: Ukubala Ngemva Kokugcwalisa Imigqa Yokuqala
Le ndlela mhlawumbe ilula kakhulu. Lapho uyisebenzisa, udinga kuphela ukugcwalisa imigqa emibili yokuqala yekholomu, ngemva kwalokho ungakwazi ukwelula izinombolo emigqeni esele. Nokho, kuwusizo kuphela lapho usebenza namatafula amancane.
- Okokuqala, dala ikholomu entsha yezinombolo zomugqa. Esitokisini sokuqala (singabali unhlokweni) sibhala inombolo 1, bese siya kweyesibili, lapho sifaka khona inombolo yesi-2.
- Manje udinga ukukhetha lawa maseli amabili, emva kwalokho sihambisa ikhesa yegundane ekhoneni elingezansi kwesokudla lendawo ekhethiwe. Lapho nje isikhombisi sishintsha ukubukeka kwaso sibe isiphambano, cindezela inkinobho yegundane kwesokunxele bese usihudulela emugqeni wokugcina wekholomu.
- Sikhulula inkinobho yegundane engakwesokunxele, futhi izinombolo ze-serial zemigqa zizovela ngokushesha emigqeni esiyimbozile lapho sinwetshwa.
Indlela 2: STRING opharetha
Le ndlela yokufaka izinombolo zomugqa othomathikhi ihlanganisa ukusetshenziswa komsebenzi "ULayini".
- Sikhuphukela kuseli lokuqala lekholomu, esifuna ukuyinikeza inombolo ye-serial 1. Bese sibhala ifomula elandelayo kuyo:
=СТРОКА(A1)
. - Ngokushesha nje lapho sichofoza Faka, inombolo yomkhiqizo izovela kuseli ekhethiwe. Kuhlala, ngokufanayo nendlela yokuqala, ukwelula ifomula emigqeni engezansi. Kodwa manje udinga ukuhambisa ikhesa yegundane uye ekhoneni elingezansi kwesokudla seseli ngefomula.
- Konke sekumi ngomumo, siye sabala ngokuzenzakalelayo yonke imigqa yetafula, okwakudingeka.
Esikhundleni sokufaka ifomula mathupha, ungasebenzisa Iwizadi Yomsebenzi.
- Siphinde sikhethe iseli yokuqala yekholomu lapho sifuna ukufaka khona inombolo. Bese sichofoza inkinobho "Faka umsebenzi" (ngakwesokunxele kwebha yefomula).
- Iwindi le-Function Wizard liyavuleka. Chofoza esigabeni samanje semisebenzi bese ukhetha ohlwini oluvulayo "Amareferensi kanye ne-Arrays".
- Manje, ohlwini lwama-opharetha ahlongozwayo, khetha umsebenzi "ULayini", bese ucindezela OK.
- Iwindi lizovela esikrinini elinezimpikiswano zomsebenzi okufanele zigcwaliswe. Chofoza indawo yokufaka ukuze uthole ipharamitha "Umugqa" futhi ucacise ikheli leseli yokuqala kukholomu esifuna ukwabela yona inombolo. Ikheli lingafakwa ngesandla noma umane uchofoze kuseli oyifunayo. Chofoza okulandelayo OK.
- Inombolo yomugqa ifakwa kuseli ekhethiwe. Indlela yokwelula izinombolo kuyo yonke imigqa, sixoxile ngenhla.
Indlela yesi-3: ukusebenzisa inqubekelaphambili
Ububi bezindlela zokuqala nezesibili ukuthi kufanele welule izinombolo kweminye imigqa, engafaneleki kakhulu kumasayizi amakhulu wetafula aqondile. Ngakho-ke, ake sibheke enye indlela eqeda isidingo sokwenza isenzo esinjalo.
- Sibonisa kuseli lokuqala lekholomu inombolo yayo yochungechunge, elingana nenombolo 1.
- Shintshela kuthebhu "Ikhaya", cindezela inkinobho "Gcwalisa" (isigaba “Ukuhlela”) futhi ohlwini oluvulayo, chofoza inketho “Inqubekelaphambili…”.
- Iwindi lizovela phambi kwethu elinamapharamitha wokuqhubeka adinga ukulungiswa, ngemva kwalokho sicindezela OK.
- khetha ukuhlelwa “ngamakholomu”;
- cacisa uhlobo "i-arithmetic";
- kwinani lesinyathelo sibhala inombolo "1";
- kunkambu ethi “Inani elilinganiselwe”, bonisa inombolo yemigqa yethebula okudingeka ibalwe.
- Ukufakwa kwezinombolo komugqa okuzenzakalelayo kwenziwa, futhi sithole umphumela esiwufunayo.
Le ndlela ingenziwa ngendlela ehlukile.
- Siphinda isinyathelo sokuqala, okungukuthi Bhala inombolo 1 kuseli lokuqala lekholomu.
- Sikhetha ububanzi obuhlanganisa wonke amaseli esifuna ukufaka kuwo izinombolo.
- Ukuvula iwindi futhi "Intuthuko". Amapharamitha ahlelwa ngokuzenzakalelayo ngokuya ngebanga esilikhethile, ngakho kufanele sichofoze OK.
- Futhi futhi, ngenxa yalezi zenzo ezilula, sithola izinombolo zemigqa ebangeni elikhethiwe.
Ukufaneleka kwale ndlela ukuthi awudingi ukubala nokubhala inombolo yemigqa ofuna ukufaka kuyo izinombolo. Futhi okubi ukuthi, njengasezindleleni zokuqala nezesibili, kuzodingeka ukhethe uhla lwamaseli kusengaphambili, olungelula kangako lapho usebenza namatafula amakhulu.
Isiphetho
Izinombolo zomugqa zingenza kube lula kakhulu ukusebenza ku-Excel lapho usebenza nenani elikhulu ledatha. Kungenziwa ngezindlela eziningi, kusukela ekugcwaliseni okwenziwa ngesandla kuya ohlelweni oluzenzakalelayo oluzoqeda noma yimaphi amaphutha angenzeka kanye nama-typos.