Inkhulumo yesikhombisa ivela ku-Excel uma:
- Ifomula iqukethe ireferensi yeseli kweseli equkethe ifomula ngokwayo. Isibonelo salolu hlobo lwesibonakaliso esiyindilinga siboniswa esithombeni ngenhla lapho ifomula eliseli cell C1 liqukethe ireferensi yeleso kwifomula: = A1 + A2 + A3 + C1
- Ikhombandlela yefomula enye ifomula ekugcineni ibhekisela esitokisini equkethe ifomu langempela. Isibonelo salolu hlobo lokubhekisela okungaziwa njengoba kuyaziwa kuboniswa kusibonelo sesibili esithombeni lapho imicibisholo eluhlaza okwesibhakabhaka exhumanisa amaseli A7, B7, no-B9 kubonisa ukuthi amafomula kulawa maseli asho ukuthintana.
Isexwayiso Esiyisixwayiso
Njengoba kuboniswe esithombeni esingenhla, uma kubonakala isethenjwa esisekelweni kuphepha lokusebenzela le-Excel, uhlelo lubonisa ibhokisi lengxoxo ye- Alert ebonisa inkinga.
Umlayezo ebhokisini lamabhokisi ucaciswe ngokuqondile ngoba akuzona zonke izikhombisi eziyinkimbinkimbi emafomulini azenzanga ngokweqile njengoba kuchazwe ngezansi.
"Ngokucophelela, sithole okukodwa noma okuningi okubhekiselweyo okuyi-circular ebhokisini lakho lokusebenzela okungabangela ifomula yakho ukubala ngokungalungile"
Izinketho zomsebenzisi
Izinketho zomsebenzisi uma leli bhokisi lebhokisi libonakala lizochofoza u- OK noma Usizo, akekho okuzolungisa inkinga yenkomba yombuthano.
Uma ufunda umlayezo omude futhi odidekile ebhokisini lengxoxo uzothola ukuthi:
- ukuchofoza ku- Usizo kuhloswe ukuthi kusetshenziswe uma kubonakala inqubo yesikhala esingenalutho; lokhu kukuthatha kulwazi lwefayela le-Excel lokusiza ngezikhombisi eziyindilinga;
- Ukuchofoza ku- OK kusetshenziselwa ukutshela i-Excel ukuthi ireferensi yesikhombisa yenzelwe ngenhloso futhi kufanele ishiye endaweni yayo.
Izinkomba Zengqayizivele Engenalutho
Uma ireferensi yesikhombisa yenziwe ngokungenhloso, ulwazi lwefayela losizo luzokutshela ukuthi ungahamba kanjani ngokuthola nokususa izinkomba eziyindilinga.
Ifayela losizo lizokuqondisa ukusebenzisa ithuluzi lokuhlola iphutha le-Excel elitholakala ngaphansi kwefomula> Ukucubungula i-Formula ku-Ribbon.
Izingqikithi eziningi ezingenanjongo zamangqamuzana zingalungiswa ngaphandle kwesidingo sephutha ngokuhlola nje ngokulungisa izikhombisi zeseli ezisetshenziselwa ifomula. Esikhundleni sokuthayipha izingqikithi zamangqamuzana kwifomula, sebenzisa ukukhomba ------------------ ngokuchofoza ezinkomba ezigciniwe negundane -------------- -------- ukungena izingcaphuno zibe ifomula.
Izinkomba Zengqikithi Engokomqondo
I-Excel yereferensi ye-circular ayinikezi ukulungiswa kwenkinga yereferensi yesikhombisi ngoba akuzona zonke izikhombisi ze-circular amaphutha.
Ngenkathi lezi zikhombisi eziyinkimbinkimbi zenzalo zingavamile kakhulu kunezingalindelekile, zingasetshenziswa uma ufuna i-Excel ukuba iqhubekele noma isebenzise ifomula izikhathi eziningi ngaphambi kokukhiqiza umphumela.
Ukunika amandla izibalo ezilinganayo
I-Excel inenkululeko yokwenza lezi zibalo zokuhlela uma uhlela ukuyisebenzisa.
Ukuze unike amandla izibalo zokuphendula:
- Chofoza kuthebhu yefayela (noma inkinobho ye-Office ku-Excel 2007)
- Chofoza Izinketho ukuvula ibhokisi lengxoxo ye- Excel Izinketho
- Kwiphepha lesokunxele lebhokisi lebhokisi, chofoza amafomula
- Esikhathini sangakwesokudla-iphaneli yebhokisi lebhokisi, khetha Ivumela ukuhlola ibhokisi lokuhlola lokubheka
Ngezansi kokukhethwa kwebhokisi lokuhlola kuyatholakala ku:
- ukubeka inombolo enkulu yokubheka: inani lama-Excel kufanele liphinde lenze kabusha ifomula
- ukubeka inani elikhulu lokushintsha elamukelekayo phakathi kwemiphumela yokubala: encane inombolo, imphumela enembile kakhulu
Ukubonisa i-Zero kumaseli athintekile
Ngamaseli aqukethe izinkomba eziyindilinga, i-Excel ibonisa noma i-zero njengoba kuboniswa kuseli C1 kusibonelo noma inani lokugcina elibalwe kuseli.
Kwezinye izimo, amafomula angaphumelela ngempumelelo ngaphambi kokuba azame ukubala ukubaluleka kwereferensi yeseli lapho atholakala khona. Uma lokho kwenzeka, iseli eliqukethe ifomula libonisa inani kusukela ekubalweni kokugcina okuphumelelayo.
Okuningi Esikhathini Sesixwayiso Sokwexwayisa
Ngemuva kokuqala kwesifomula esine-reference yochungechunge ebhukwini , i-Excel ngeke ibuye iphinde ibonise umlayezo wokuxwayisa. Kuxhomeke ezimweni zendlela nokuthi kuphi okunye okubhekiselwe khona okuyiketshezi okudalwa khona.
Izibonelo lapho ibhokisi lokuxwayisa eliqukethe umlayezo oyisixwayiso lizoboniswa izinkomba eziyinkimbinkimbi ezilandelayo zihlanganisa:
- Isibonelo sokuqala sereferensi yesikhombisa kunoma iyiphi incwadi yokusebenzela;
- Ngemuva kokukhipha zonke izikhombisi eziyindilinga kuzo zonke izincwadi zokusebenzela ezivuliwe, intsha entsha yereferensi iyadalwa;
- Ngemuva kokuvala zonke izincwadi zokusebenzela, ifomula eline-reference yereduli idalwe encwadini entsha yokusebenzela;
- Incwadi yokusebenzela equkethe inqubo yesikhombisa ivuliwe.