Ngezinye izikhathi uma udala idokhumenti ngezibalo, umsebenzisi udinga ukufihla amafomula ekuhloleni amehlo. Okokuqala, isidingo esinjalo sibangelwa ukungathandi komsebenzisi kumuntu ongaziwayo ukuze aqonde isakhiwo sedokhumenti. Ku-Excel, ungafihla amafomula. Sizoqonda ukuthi lokhu kungenziwa kanjani ngezindlela ezihlukahlukene.
Izindlela zokufihla ifomula
Akuyona imfihlo kunoma ubani ukuthi uma kukhona ifomula esitokisini setafula le-Excel, khona-ke lingabonakala kubha yefomula ngokumane ukhethe le seli. Ezimweni ezithile, lokhu akusifisi. Isibonelo, uma umsebenzisi efuna ukufihla ulwazi mayelana nesakhiwo sokubala, noma afune ukuthi lezi zibalo ziguquke. Kulesi simo, kunengqondo ukufihla umsebenzi.
Kunezindlela ezimbili eziyinhloko zokwenza lokhu. Okokuqala ukufihla okuqukethwe kweseli, indlela yesibili idlula kakhulu. Uma isetshenziswe, ukuvinjelwa kukhishwa ekunikezeni amaseli.
Indlela 1: Fihla okuqukethwe
Le ndlela ihambisana kakhulu nemisebenzi ebekwe kule sihloko. Ukusebenzisa kuphela kufihla okuqukethwe kwamaseli, kodwa akufaki imingcele eyengeziwe.
- Khetha ububanzi obani ofuna ukufihla okuqukethwe. Chofoza inkinobho yesokudla yegundane endaweni ekhethiwe. Imenyu yomongo ivulwa. Khetha into "Fometha amaseli". Ungenza okuthile okuhlukile. Ngemva kokukhetha ibanga, vele uthayiphe isinqamuleli sekhibhodi Ctrl + 1. Umphumela uzoba okufanayo.
- Iwindi ivula "Fometha amaseli". Iya kuthebhu "Isivikelo". Beka uphawu eduze kwento "Fihla amafomula". Thepha ipharamitha "Iseli elivikelwe" kungasuswa uma ungahle uhlele ukuvimba ibanga kusuka ekushintsheni. Kodwa, kaningi, ukuvikelwa ekushintsheni kungumsebenzi oyinhloko, futhi ukufihla amafomula kuyakhethwa. Ngakho-ke, ezimweni eziningi kokubili amabhokisi okuhlola asele asebenzayo. Sicindezela inkinobho "Kulungile".
- Ngemuva kokuthi iwindi ivaliwe, iya kuthebhu "Ukubukeza". Sicindezela inkinobho "Vikela ishidi"itholakala ebhokisini lamathuluzi "Izinguquko" kwi-tape.
- Ifasitela ivula emkhakheni okudingayo ukufaka iphasiwedi engenakuphikisana. Uzodinga uma ufuna ukususa ukuvikelwa esikhathini esizayo. Zonke ezinye izilungiselelo zinconywa ukushiya okuzenzakalelayo. Bese uchofoza inkinobho. "Kulungile".
- Olunye iwindi luvula ukuthi kufanele uphinde uphinde ufake iphasiwedi yangena ngaphambilini. Lokhu kwenziwa ukuze umsebenzisi, ngenxa yokungeniswa kwephasiwedi engalungile (ngokwesibonelo, kushintshiwe kwesakhiwo), akalahlekelwa ukufinyelela kokushintshwa kweshidi. Lapha, futhi ngemuva kokusungulwa kwenkulumo eyinhloko, chofoza inkinobho "Kulungile".
Emva kwalezi zenzo, amafomula azofihlwa. Akukho okuzoboniswa kubha yamatomu ebangeni elivikelwe uma likhethiwe.
Indlela 2: Ungakhethi amaseli
Lena indlela engcono kakhulu. Ukusetshenziswa kwalo kugxila ekuvinjweni hhayi kuphela ekuboneni amafomula noma ukuhlela amaseli, kodwa ngisho nasekukhethweni kwabo.
- Okokuqala, kudingeka uhlole ukuthi ibhokisi lokuhlola lihlolwe yini "Iseli elivikelwe" kuthebhu "Isivikelo" sesivele sijwayele indlela esedlule kithi ifomathi yokufometha ibanga elikhethiwe. Ngokuzenzakalelayo, le ngxenye kufanele inikwe amandla, kodwa ukuhlola isimo sayo akulimazi. Uma kungekho umkhawulo kuleli phuzu, kufanele lithathwe. Uma konke kulungile, futhi kufakwe, bese uchofoza inkinobho nje "Kulungile"etholakala phansi kwefasitela.
- Ngaphezu kwalokho, njengokwesimo esidlule, chofoza inkinobho "Vikela ishidi"itholakala kuthebhu "Ukubukeza".
- Ngokufanayo, indlela yangaphambilini ivula iwindi lokufaka iphasiwedi. Kodwa ngalesi sikhathi sidinga ukukhetha ukukhetha "Ukunikezwa kwamaseli avinjelwe". Ngakho-ke, sizovimbela ukukhishwa kwalenqubo kumkhawulo okhethiwe. Emva kwalokho faka iphasiwedi bese uchofoza inkinobho "Kulungile".
- Ewindini elilandelayo, kanye nesikhathi sokugcina, siphindaphinda iphasiwedi bese uchofoza inkinobho "Kulungile".
Manje engxenyeni ekhethiwe yeshidi, angeke nje sikwazi ukubuka okuqukethwe kwemisebenzi kumaseli, kodwa ngisho nje ukhethe. Uma uzama ukwenza ukhetho, umlayezo uzovela okhombisa ukuthi ibanga livikelwe kusuka kushintsho.
Ngakho-ke, sithole ukuthi ungakwazi ukuvala ukubonisa kwemisebenzi kubha yefomula futhi ngqo esitokeni ngezindlela ezimbili. Ngokuqukethwe okujwayelekile okufihliwe, amafomula kuphela afihlekile, njengengxenye eyengeziwe ongabeka ukuvinjelwa ekuhleleni kwabo. Indlela yesibili ibonisa ukuba khona kwezivimbelo eziqinile. Ukusebenzisa akuvimbeli kuphela amandla okubuka okuqukethwe noma ukuyihlela, kodwa noma ukhethe iseli. Yikuphi kulababili ongakhetha ukukhetha kuncike, okokuqala, kwimisebenzi. Kodwa-ke, ezimweni eziningi, ukhetho lokuqala luqinisekisa izinga lokuvikelwa okunokwethenjelwa, futhi ukuvimba ukukhethwa ngokuvamile kuyindlela engadingekile yokuqapha.
