Ngokuvamile, uma udala amatafula ku-Excel, kunekholomu ehlukile lapho, ukuze kube lula, ubonise izinombolo zomugqa. Uma itafula alilona isikhathi eside, akusiyona inkinga enkulu ukwenza izinombolo zamakhompiyutha ngokufaka izinombolo ezivela kubhobhodi. Kodwa yini okufanele uyenze uma ingenayo eyodwa eyishumi, noma ngisho nemigqa eyikhulu? Kulesi simo, ukubalwa okuzenzakalelayo kuyasiza. Ake sithole ukuthi singenza kanjani ukulandelela okuzenzakalelayo ku-Microsoft Excel.
Ukubala
I-Microsoft Excel inikeza abasebenzisi ngezindlela eziningana ukuze ulandele imigqa ngokuzenzakalelayo. Ezinye zazo zilula ngangokunokwenzeka, zombili ekusebenzeni nasekusebenzeni, kuyilapho ezinye ziyinkimbinkimbi, kodwa futhi zihlanganisa amathuba amakhulu.
Indlela 1: gcwalisa imigqa emibili yokuqala
Indlela yokuqala ihilela ukugcwalisa ngesandla emigqeni emibili yokuqala ngezinombolo.
- Kukholomu eligqanyisiwe lomugqa wokuqala, faka inombolo - "1", okwesibili (ikholomu efanayo) - "2".
- Khetha lawa maseli amabili agcwele. Siba yikhoneni elingezansi elingezansi lalabo abaphansi kakhulu. Uphawu lokugcwalisa luvela. Sichofoza inkinobho yesinxele yesinxele futhi inkinobho icindezelwe, uyihudule phansi ekugcineni kwetafula.
Njengoba ungabona, ukubalwa kwenamba kugcwaliswa ngokuzenzakalelayo ngendlela.
Le ndlela ilula futhi ilula, kodwa kuhle kumatafula ambalwa, ngoba ukudonsa uphawu kumataji wamakhulu amaningana, noma ngisho nezinkulungwane zemigqa, kusalokhu kunzima.
Indlela 2: sebenzisa umsebenzi
Indlela yesibili yokugcwalisa okuzenzakalelayo kuhilela ukusebenzisa lo msebenzi "LINE".
- Khetha iseli elizoqukatha inombolo yedijithi "1" yokubala. Faka inkulumo ekhoneni ukuze uthole amafomula "= LINE (A1)"Chofoza kusihluthulelo ENTER kwikhibhodi.
- Njengokwesikhashana esidlule, kopisha ifomula kumaseli aphansi etafuleni laleli kholomu usebenzisa uphawu lokugcwalisa. Kuphela lesi sikhathi asikhethi amaseli amabili okuqala, kodwa kuphela.
Njengoba ungabona, ukubalwa kwemigqa futhi kulokhu kuhlelwe ngokuhlelekile.
Kodwa, ngokubanzi, le ndlela ayifani neze neyaphambilini futhi ayixazululi inkinga ngesidingo sokuhudula umaka kuyo yonke ithebula.
Indlela 3: Ukusebenzisa ukuqhubekela phambili
Indlela yesithathu yokubala ukusebenzisa ukuqhubekela phambili ifaneleka amathebula amade anemigqa eminingi.
- Iseli yokuqala ibalwa ngendlela evamile kakhulu, ingene lapho inombolo "1" kusuka kukhibhodi.
- Ebhebheni ku-"Ibha yokuhlela" yamathuluzi, esendaweni "Ikhaya"cindezela inkinobho "Gcwalisa". Emenyu ebonakalayo, chofoza ku-intwana "Ukuqhubeka".
- Iwindi ivula "Ukuqhubeka". Kupharamitha "Indawo" udinga ukusetha inkinobho ukuma "Ngamakholomu". Ukushintsha kwepharamitha "Thayipha" kumele ibe sesikhundleni "I-Arithmetic". Ensimini "Isinyathelo" kudingeka ukusetha inombolo "1", uma ifakwe enye. Qiniseka ukuthi ugcwalisa insimu "Inani elilinganiselwe". Lapha kufanele ucacise inani lemigqa okufanele libalwe. Uma le parameter ingenalutho, ukubalwa okuzenzakalelayo ngeke kwenziwe. Ekupheleni, chofoza inkinobho ethi "Kulungile".
Njengoba ungabona, insimu yale yonke imigqa etafuleni lakho izobalwa ngokuzenzakalelayo. Kulesi simo, akukho lutho lokudonsa aludingeki.
Ngokunye, ungasebenzisa uhlelo olulandelayo lwenqubo efanayo:
- Esitokisini sokuqala faka inombolo "1", bese ukhetha lonke uhla lwamaseli ofuna ukulibala.
- Iwindi yamathuluzi ekholi "Ukuqhubeka" ngendlela efanayo esayikhuluma ngayo ngenhla. Kodwa manje awudingi ukungena noma ukushintsha noma yini. Kubandakanya, faka idatha ensimini "Inani elilinganiselwe" Akudingeki, ngoba ibanga elifunayo selivele likhethiwe. Chofoza nje inkinobho ethi "Kulungile".
Lolu khetho lungcono ngoba akudingeki ukuthi uhlole ukuthi zingaki imigqa etafuleni. Ngesikhathi esifanayo, kuzodingeka ukhethe wonke amangqamuzana ekholomu ngezinombolo, okusho ukuthi sibuyela enye into efana nokusebenzisa izindlela zokuqala: isidingo sokupheqa itafula kuze kube phansi.
Njengoba ungabona, kunezindlela ezintathu eziyinhloko zokuzila imigqa ngokuzenzakalela ohlelweni. Kulezi zici, ukuhluka okufana nokubalwa kwemigqa emibili yokuqala nokukopisha okulandelayo (njengokulula) kanye nokuhluka okusebenzisa ukuqhubekela phambili (ngenxa yokukwazi ukusebenza ngamatafula amakhulu) kunenani elikhulu kakhulu.
