Ngokujwayelekile, amaseli aqukethe amafomula ku-Excel nama-Google AmaSpredishithi abonisa izimpendulo kuwo wonke amafomula nemisebenzi esekelwe emsebenzini.
Emakhasini amakhulu okusebenza, ngokuchofoza nxazonke nge-pointer yegundane ukuthola amaseli aqukethe lawa mafomula noma imisebenzi angabanjwa noma aphuthelwe umsebenzi.
Bonisa amafomula ku-Excel nama-Google AmaSpredishithi usebenzisa ama-keycut Keys
Susa ukuqagela lapho uthola amafomula ngokusebenzisa inhlanganisela yokhiye wezinqamuleli ukubonisa wonke amafomula ku-Excel nama-Google AmaSpredishithi:
I-Ctrl + `(ikhi lengqondo eligxile)
Kumakhibhodi amaningi ajwayelekile, ukhiye we-accent yamathuna utholakale eduze nenombolo ye-1 ekhoneni eliphezulu ngakwesokunxele lekhibhodi. Kubonakala sengathi i-apostrophe yangemuva.
Le nhlanganisela eyisihluthulelo isebenza njengokhiye wokuguqula, okusho ukuthi ucindezela inhlanganisela eyinhloko futhi ukufihla amafomula uma usuqedile ukubheka.
Izinyathelo Zokubonisa Zonke Amafomula
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula ukhiye we-accent ekhibhodi ngaphandle kokukhipha ukhiye we-Ctrl.
- Khipha ukhiye we- Ctrl .
Iphepha lokusebenzela kufanele libonise wonke amafomula kumasekhondi abo okusebenzela kunemiphumela yefomula.
Ukubuyisela kabusha amafomula
Ukuze ubonise imiphumela futhi esikhundleni samafomula, cindezela okhiye be- Ctrl + ` futhi.
Mayelana namafomu okubonisa
- Bonisa amafomula ashintshi okuqukethwe kokushicilela, kuphela indlela aboniswa ngayo.
- Bonisa amafomula yenza kube lula ukuthola amaseli aqukethe amafomula.
- Ikuvumela ukuba ufunde ngokushesha kuwo wonke amafomula ukuze uhlole amaphutha.
- Isici singasetshenziswa futhi ngokukhetha:
- Amafomula > Bonisa amafomula ku- Ribbon ku-Excel
- Buka > Zonke izinketho zefomula kumamenyu ku-Google AmaSpredishithi
- Ukushicilela amafomethi okusebenza nge-Show Formulas kuvuliwe kungenza kube lula ukucinga kanzima ukuthola amaphutha.
Bonisa Amafomula Okusebenza Omuntu Ngamanye
Esikhundleni sokubuka wonke amafomula, kungenzeka ukubuka amafomula esisodwa ngesikhathi nje:
- Ukuchofoza kabili kuseli eliqukethe ifomula negundane.
- Ukuchofoza kanye kwiseli eliqukethe ifomula negundane bese ucindezela ukhiye we- F2 ekhibhodi.
Zombili lezi zenzo zibeka uhlelo-kungaba i-Excel noma i-Google AmaSpredishithi-ibe yimodi yokuhlela, ebonisa ifomula esitokisini bese icacisa ngombala izingqikithi zeseli ezisetshenziselwa ifomula. Lokhu kwenza kube lula ukulandelela imithombo yedatha esetshenziswe kwifomula.
Fihla amafomula ku-Excel usebenzisa i-Protect Sheet
Enye indlela yokufihla amafomula ku-Excel ukusebenzisa ukuvikelwa komsebenzi, okufaka ukhetho lokuvimbela amafomula kumaseli avaliwe kusukela ekukhonjisweni kulezi zindawo:
- Esitokisini lapho zitholakala khona
- Ku-bar yefomula uma iseli equkethe ifomu lichofoziwe
- Lapho Amafomu Okubonisa evuliwe noma usebenzisa isinqamuleli sekhibhodi noma ngebhebhoni.
Ukufihla amafomula, njengokuvala amangqamuzana, inqubo ezinyathelo ezimbili ezihilela ukukhomba ububanzi bamaseli ofuna ukuwafihla bese usebenzisa ukuvikela ishidi lomsebenzi.
Khetha i-Cell Range ukufihla
- Khetha ububanzi bamaseli aqukethe amafomula afihliwe.
- Ethempelini laseKhaya lebhebhoni, chofoza inkinobho Yefomathi ukuvula imenyu ehlayo.
- Ku imenyu, chofoza kumafomethi okufometha ukuze uvule ibhokisi lengxoxo yefomathi yefomathi.
- Ebhokisini lengxoxo, chofoza kuthebhu yokuvikelwa .
- Kule ithebhu, khetha ibhokisi lokuhlola elifihliwe .
- Chofoza OK ukuze usebenzise ushintsho bese uvale ibhokisi lengxoxo.
Faka isicelo sokuvikelwa kohlelo lokusebenza
- Ethempelini laseKhaya lebhebhoni, chofoza inketho Yefomathi ukuvula imenyu yokudonsa.
- Chofoza ku- Ukuvikela Ishidi leShidi ngaphansi kwehlu ukuze uvule ibhokisi lengxoxo ye-Protect Sheet.
- Hlola noma ungacubungula izinketho oyifunayo.
- Chofoza OK ukufaka izinguquko bese uvala ibhokisi lengxoxo.
Kuleli qophelo, amafomula akhethiwe kufanele afihliwe ekubukeni kubha yamatomu. Kuze kube yilapho isinyathelo sesibili senziwa, amafomula ahlala ebonakala esitokisini sekhasi lokusebenzela futhi kubha yefomula.