Ibha yefomula ingenye yezakhi eziyinhloko ze-Excel. Ngalo, ungenza izibalo uphinde uhlele okuqukethwe kwamaseli. Ngaphezu kwalokho, uma iseli likhethiwe, lapho kuphela inani elibonakala khona, isibalo sizoboniswa kubha yamatomu, besebenzisa ukuthi iyiphi inani elitholakalayo. Kodwa ngezinye izikhathi lesi sici esibonakalayo se-Excel sinyamalalala. Ake sibone ukuthi kungani lokhu kwenzeka, nokuthi yini okufanele uyenze kule simo.
Ukulahlekelwa ibha yefomula
Eqinisweni, umugqa wefomula unganyamalala nje ngezizathu ezimbili eziyinhloko: ukushintsha izilungiselelo zesicelo nokuhluleka kohlelo. Ngesikhathi esifanayo, lezi zizathu zihlukaniswe ngamacala aqondile.
Isizathu soku-1: shintsha izilungiselelo kuthebhu
Ezimweni eziningi, ukunyamalala kwebha yefomula kubangelwa ukuthi umsebenzisi, ngokunganaki, ususile uphawu lokuhlola olubhekele umsebenzi wakhe kutheyipu. Thola ukuthi ungalungisa kanjani isimo.
- Iya kuthebhu "Buka". On the tape ebhodini amathuluzi "Bonisa" eduze kwepharamitha Ibha yefomula hlola ibhokisi uma ingahlolwa.
- Emva kwalezi zenzo, umugqa wefomula uzobuyela endaweni yawo yasekuqaleni. Asikho isidingo sokuqalisa uhlelo noma ukwenza noma yiziphi izenzo ezengeziwe.
Isizathu sesi-2: Izilungiselelo ze-Excel
Esinye isizathu sokunyamalala kwe-tape singakhubaza kumingcele ye-Excel. Kulesi simo, ingavulelwa ngendlela efanayo njengoba kuchazwe ngenhla, noma ingashintshwa ngendlela efanayo evuliwe, okungukuthi, ngokusebenzisa isigaba semingcele. Ngakho, umsebenzisi unenkululeko.
- Iya kuthebhu "Ifayela". Chofoza entweni "Izinketho".
- Ewindini le-Excel yemingcele evuliwe sithuthela esigatshaneni "Okuthuthukisiwe". Ngakwesokudla kwefasitela kwalesi sigatshana sibheke iqembu lezilungiselelo. "Isikrini". Iphuzu eliphikisayo "Bonisa ibha yefomula" setha uphawu. Ngokungafani nendlela eyedlule, kulokhu kuyadingeka ukuqinisekisa ukushintsha kwezilungiselelo. Ukwenza lokhu, chofoza inkinobho "Kulungile" phansi kwefasitela. Ngemuva kwalokho, umugqa wefomula uzofakwa futhi.
Isizathu sesi-3: umonakalo ohlelweni
Njengoba ungabona, uma isizathu sisezilungiselelweni, khona-ke lihleliwe kalula. Kubi nakakhulu uma ukunyamalala komugqa wamakhemikhali kubangelwa ukungasebenzi noma ukulimala ohlelweni ngokwayo, futhi izindlela ezichazwe ngenhla azizisi. Kulesi simo, kunengqondo ukufeza inqubo yokuvuselela i-Excel.
- Ngenkinobho Qala iya ku- Iphaneli yokulawula.
- Okulandelayo, hamba kusigaba "Khipha Izinhlelo".
- Emva kwalokho, ukukhipha ifasitela yezinkinobho ukukhipha nokuguqula kuqala uhlu olugcwele lwezicelo ezifakiwe kwi-PC. Thola irekhodi "I-Microsoft Excel"ukhethe bese uchofoza inkinobho "Shintsha"itholakala ku-bar enezingqimba.
- Ifasitela lokushintsha i-Microsoft Office liqala. Setha inkinobho ukuma "Buyisela" bese uchofoza inkinobho "Qhubekani".
- Emva kwalokhu, inqubo yokutakula kwezinhlelo ze-Microsoft Office, kuhlanganise ne-Excel, yenziwa. Ngemva kokuqedela, akufanele kube nezinkinga ngokubonisa umugqa wefomula.
Njengoba ungabona, umugqa wefomula unganyamalala ngenxa yezizathu ezimbili ezibalulekile. Uma lokhu kuwukuhlelwa okungalungile (ku-ribbon noma kwimigomo ye-Excel), khona-ke inkinga ixazululwa ngokushesha futhi kalula. Uma inkinga ihlobene nomonakalo noma ukungasebenzi kahle kwalolu hlelo, kuzodingeka ukuthi uhambe ngenqubo yokutakula.
