Kwesinye isikhathi lapho edala idokhumenti enezibalo, umsebenzisi udinga ukufihla amafomula emehlweni enyama. Okokuqala, lesi sidingo sibangelwa ukungafuni komsebenzisi ukuze umuntu wangaphandle aqonde ukwakheka kombhalo. Uhlelo lwe-Excel lunamandla okufihla amafomula. Ake sibheke ukuthi lokhu kungenziwa kanjani ngezindlela ezahlukahlukene.
Izindlela zokufihla ifomula
Akuyona imfihlo ukuthi uma kunefomula esitokisini samaspredishithi e-Excel, ungayibona kubha yefomula ngokuqokomisa lesi seli. Ezimweni ezithile, lokhu akufanele. Isibonelo, uma umsebenzisi efuna ukufihla imininingwane ngesakhiwo sezibalo noma akafuni ukuthi lezi zibalo zishintshe. Kulokhu, isenzo esinengqondo ukufihla umsebenzi.
Kunezindlela ezimbili eziyinhloko zokwenza lokhu. Owokuqala ufihla okuqukethwe esitokisini, indlela yesibili ilunge ngokwengeziwe. Lapho usisebenzisa, kuvinjelwa ukukhethwa kwamaseli.
Indlela yoku-1: fihla okuqukethwe
Le ndlela ifana kakhulu nemisebenzi enikezwe kulesi sihloko. Uma uyisebenzisa, kufakwa okuqukethwe amangqamuzana kuphela, kepha akukho mikhawulo eyengeziwe ebekiwe.
- Khetha ibanga lokuqukethwe ofuna ukukufihla. Qhafaza kwesokudla endaweni ekhethiwe. Imenyu yokuqukethwe iyavula. Khetha into Uhlobo Lweseli. Ungenza okuhlukile. Ngemuva kokuqokomisa ububanzi, vele uthayiphe isinqamuleli sekhibhodi I-Ctrl + 1. Umphumela uzofana.
- Kuvulwa iwindi Uhlobo Lweseli. Iya kuthebhu "Ukuvikelwa". Bheka ibhokisi eliseduze Fihla amafomula. Yenza uphawu ngenketho "Iseli elivikelwe" ingasuswa uma ungahleleli ukuvimba uhla kusuka kuzinguquko. Kepha imvamisa, ukuvikela izinguquko kumane kungumsebenzi oyinhloko, futhi amafomela wokufihla awengeziwe. Ngakho-ke, ezimweni eziningi, womabili amamaki ashiywe esebenza. Chofoza inkinobho "Kulungile".
- Ngemuva kokuthi iwindi livaliwe, iya kuthebhu "Buyekeza". Chofoza inkinobho Vikela Ishidietholakala kwibhulokhi yamathuluzi "Shintsha" ekhasethini.
- Iwindi livuleka emkhakheni lapho udinga ukufaka i-password yokuphikisana. Izodingeka uma ufuna ukususa ukuvikelwa ngokuzayo. Zonke ezinye izilungiselelo zinconywa ukushiyelwa ngokuzenzakalelayo. Bese ucindezela inkinobho "Kulungile".
- Kuvula elinye iwindi lapho kufanele ufake kabusha iphasiwedi efakwe ngaphambili. Lokhu kwenziwa ukuze umsebenzisi, ngenxa yokwethulwa kwephasiwedi engalungile (ngokwesibonelo, ngesakhiwo esishintshiwe), angalahlekelwa ukufinyelela kokushintsha ishidi. Lapha, futhi ngemuva kokufaka inkulumo ebalulekile, chofoza inkinobho "Kulungile".
Ngemuva kwalezi zenzo, amafomula azofihlwa. Emugqeni wefomula webanga elivikelwe, lapho kukhethiwe, akukho lutho oluzokhonjiswa.
Indlela 2: kwenqabela ukukhetha amaseli
Le yindlela enkudlwana. Ukusetshenziswa kwayo kubeka ukuvinjwa hhayi ekubukeni amafomula kuphela noma kumaseli wokuhlela, kodwa nasekukhethweni kwawo.
- Okokuqala, udinga ukubheka ukuthi umkhaza uhlolwe eduze kwepharamitha "Iseli elivikelwe" kuthebhu "Ukuvikelwa" usuvele wazi ngendlela yangaphambilini kithi ifasitela lokufometha lebanga elikhethiwe. Ngokuzenzakalelayo, le ngxenye kufanele ngabe inikwe amandla, kepha ukuhlola isimo sayo ngeke kulimaze. Uma, noma kunjalo, kungekho uphawu lokuhlola kule ndima, khona-ke kufanele ihlolwe. Uma konke kuhamba kahle futhi kufakiwe, vele uchofoze inkinobho "Kulungile"etholakala ezansi kwewindi.
- Okulandelayo, njengasekuqaleni, chofoza inkinobho Vikela Ishidietholakala kuthebhu "Buyekeza".
- Ngokunjalo nangendlela edlule, iwindi lokungena le-password liyavula. Kepha kulokhu kudingeka sihlolisise inketho "Khetha amaseli akhiyiwe". Ngakho-ke, sizokwenqabela ukwenziwa kwale nqubo ebangeni elikhethiwe. Ngemuva kwalokho faka iphasiwedi bese uchofoza inkinobho "Kulungile".
- Kuwindi elilandelayo, njengokugcina, phinda iphasiwedi bese uchofoza inkinobho "Kulungile".
Manje, engxenyeni ekhethiwe yeshidi ngaphambili, ngeke nje sikubone okuqukethwe yimisebenzi esitokisini, kodwa nje sizikhethe. Uma uzama ukukhetha, kuvela umyalezo othi uhla luvikelekile ezinguquko.
Ngakho-ke, sithole ukuthi ungavimbela ukubonisa imisebenzi kubha yefomula futhi ngqo esitokisini ngezindlela ezimbili. Ekufihleni okujwayelekile kokuqukethwe, amafomula kuphela afihliwe, njengethuba elingeziwe ungacacisa ukunqatshelwa kokukuhlela. Indlela yesibili ifaka ukuba khona kwenqatshelwe okwengeziwe. Lapho uyisebenzisa, hhayi kuphela ikhono lokubuka okuqukethwe noma ukuhlela kuvinjelwe, kodwa noma ukhethe iseli. Yikuphi kulezi zinketho ezimbili okufanele ukhethe kuzo, okokuqala, kwimisebenzi ebekiwe. Kodwa-ke, ezimweni eziningi, inketho yokuqala iqinisekisa isilinganiso esivikelekile sokuvikela, futhi ukuvimba ukwabiwa kwesinye isikhathi kuyindlela yokuqapha engadingekile.
