Umugqa wamafomula ungenye yezinto eziphambili zohlelo lokusebenza lwe-Excel. Ngosizo lwayo, ungenza ukubala bese uhlela okuqukethwe amaseli. Ngaphezu kwalokho, lapho kukhethwa iseli lapho kuphela inani elibonakala khona, ukubalwa okutholwe ngalo leli nani kuzoboniswa kubha yefomula. Kodwa kwesinye isikhathi, le nto yokuxhuma i-Axel inyamalala. Ake sibone ukuthi kungani lokhu kwenzeka nokuthi kufanele enzeni kulesi simo.
Umugqa olahlekile wamafomula
Empeleni, umugqa wefomula unganyamalala ngenxa yezizathu ezimbili ezinkulu nje: ukushintsha izilungiselelo zohlelo lokusebenza nokungasebenzi kahle kohlelo. Ngasikhathi sinye, lezi zizathu zihlukaniswe ngamacala athile acacisiwe.
Isizathu 1: Ukushintsha izilungiselelo ethepheni
Esikhathini esiningi, ukunyamalala kwebha yefomula kungenxa yokuthi umsebenzisi ngokunganqamuki angahloli ibhokisi elibhekene nomsebenzi walo kwitheyipu. Thola ukuthi ungasilungisa kanjani isimo.
- Iya kuthebhu "Buka". Kubambo olubekwe ebhokisini lamathuluzi Khombisa eduze kwepharamitha "Umugqa wamafomula" hlola ibhokisi uma lingahloliwe.
- Ngemuva kwalezi zenzo, umugqa wamafomula uzobuyela endaweni yawo yangempela. Awudingi ukuqala kabusha uhlelo noma ukwenza ezinye izinto ezengeziwe.
Isizathu 2: Izilungiselelo zepharamitha ye-Excel
Esinye isizathu sokunyamalala kwetheyiphu kungaba ukuxhuma kwayo kuzilungiselelo ze-Excel. Kulokhu, ingavulwa ngendlela efanayo naleyo echazwe ngenhla, noma ingavulwa ngendlela efanayo lapho icishiwe, okungukuthi, ngesigaba sepharamitha. Ngakho-ke, umsebenzisi unokuzikhethela.
- Iya kuthebhu Ifayela. Chofoza entweni "Izinketho".
- Ewindini lezinketho le-Excel elivuliwe, dlulela esigatshaneni "Kuthuthukile". Engxenyeni kwesokudla yewindi lalesi sigatshana sifuna iqembu lezilungiselelo Isikrini. Into ephikisayo Khombisa Ibha Yefomula setha uphawu. Ngokungafani nendlela yangaphambilini, kuleli cala, udinga ukuqinisekisa ushintsho kuzilungiselelo. Ukuze wenze lokhu, chofoza inkinobho "Kulungile" phansi kwewindi. Ngemuva kwalokho, umugqa wefomula uzophinda ufakwe.
Isizathu 3: ukukhohlakala kohlelo
Njengoba ubona, uma isizathu besisezilungiselelweni, khona-ke silungiswa kalula nje. Kubi kakhulu lapho kunyamalala umugqa wamafomula kungumphumela wokungasebenzi kahle noma ukulimala kohlelo uqobo, futhi izindlela ezingenhla azisizi. Kulokhu, kunengqondo ukwenza inqubo yokutakula i-Excel.
- Ngenkinobho Qala iya ku Iphaneli yokulawula.
- Okulandelayo sidlulela esigabeni "Khipha izinhlelo".
- Ngemuva kwalokho, iwindi lokukhipha nokukhipha izinhlelo ngohlu oluphelele lwezicelo ezifakwe kwi-PC liqala. Thola irekhodi "I-Microsoft Excel", ikhethe bese uchofoza inkinobho "Shintsha"etholakala kuphaneli enezingqimba.
- Kuvulwa iwindi leMicrosoft Office Suite Change. Setha ukushintshela esikhundleni Buyisela bese uchofoza inkinobho Qhubeka.
- Ngemuva kwalokho, kwenziwa inqubo yokubuyiselwa kwezinhlelo ze-Microsoft Office suite, kufaka phakathi i-Excel. Ngemuva kokuphothulwa kwayo, akumele kube nezinkinga ngokubonisa umugqa wefomula.
Njengoba ubona, umugqa wamafomula unganyamalala ngenxa yezizathu ezimbili ezinkulu. Uma ngabe lezi zilungiselelo esingalungile (kubambo noma kuzilungiselelo ze-Excel), khona-ke inkinga ixazululwa kalula futhi ngokushesha. Uma inkinga ibangelwa ukulimala noma ukungasebenzi kahle kohlelo, kuzodingeka ukuthi uqhubeke nenqubo yokutakula.
