Ngokuqhelekileyo, iiseli ezinamafomula kwi-Excel kunye ne-Google AmaSpredishithi zibonisa iimpendulo kuwo onke amafomula nemisebenzi esekweni lokusebenzela .
Kwimashishini amakhulu, ucofa ngeenxa zonke kunye ne-pointer ye mouse ukuze ufumane iiseli eziqulethe iifomula okanye imisebenzi zingabetha okanye zilahleke ukusebenza.
Bonisa iifomula kwi-Excel kunye ne-Google AmaSpredishithi usebenzisa iiNqamlezo ezifutshane
Susa uqikelelo xa ufumanisa iifomula ngokusebenzisa inhlanganisela yeqhosha elifutshane ukuze ubonise zonke iifomula kwi-Excel kunye ne-Google AmaSpredishithi:
Ctrl + `
Kwiinkalobho ezininzi eziqhelekileyo, ukhiye we-accent key ufumaneka ecaleni kwinombolo ye-1 kwikota yangasese ekhohlo yebhodibhodi. Kubonakala ngathi i-apostrophe yangemva.
Inhlanganisela ebalulekileyo isebenza njengekhibhokisi yokutshintsha, oko kuthetha ukuba ucinezela ukudibanisa ukhiye ofanayo kwakhona ukufihla iifomula xa ugqibile ukuyijonga.
Amanyathelo okubonisa onke amafomula
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cinezela kwaye ukhulule ikhibhozo yengxolo engundoqo kwikhibhodi ngaphandle kokukhulula ikhiye ye Ctrl.
- Ukukhulula ikhiye ye Ctrl .
Iphepha lokusebenzela kufuneka libonise zonke iifomula kwiiseli zabo zesebenzi kunokuba ziphumo zefomula.
Ukuhlaziya kwakhona iiFomula
Ukubonisa kwakhona iziphumo endaweni yefomula, cindezela iCtrl + ` ukhiye kwakhona.
Malunga neeFomula
- Bonisa amafomula ayitshintshi okuqukethwe kwiphepha lomsebenzi, kuphela indlela ababoniswa ngayo.
- Bonisa amafomula yenza kube lula ukufumana iiseli ezinemifomula.
- Ikuvumela ukuba ufunde ngokukhawuleza kuzo zonke iifomula ukujonga iimpazamo.
- Isixhobo sinokuphinda sisebenze ngokukhetha:
- Iifomula > Bonisa iifomula kwi- Ribbon e-Excel
- Jonga > Zonke iinketho zefomula kumamenyu kwi-Google AmaSpredishithi
- Ukushicilela iifomathi zokusebenzela kunye ne-Show Formslas vula kungenza kube lula ukukhangela nzima ukufumana iziphoso.
Bonisa Iifomula Zomsebenzi ngamnye
Esikhundleni sokubukela zonke iifomula, kunokwenzeka ukujonga iifomula enye ngexesha nje ngoku:
- Ukuchofoza kabini kwiseli equle ifom ne mouse.
- Ukuchofoza kanye kwiseli equlethe ifomu kunye ne mouse kwaye ucinezela iqhosha leF2 kwibhodibhodi.
Zomibini zezi zenzo zibeka inkqubo-ingaba i-Excel okanye i-Google -Spysheetshi-ibe yimodi yokuhlela, ebonisa ifomu kwifom kwaye icacisa ngombala iiferensi zesetyenzisiweyo ezisetyenziswe kwifom. Oku kwenza kube lula ukulandelela imithombo yedatha esetyenziswa kwifom.
Fihla iifomula kwi-Excel usebenzisa i-Protect Sheet
Enye indlela yokufihla iifomula kwi-Excel kukuba isebenzise ukhuseleko lomsebenzi , olubandakanya ukhetho lokuthintela iifomula kwiiseli ezikhiweyo ukuba ziboniswe kule ndawo:
- Kwiseli apho zifumaneka khona
- Kwibha yefomula xa iseli equle ifom iqhosha
- Xa iifomula zivuliwe okanye usebenzisa i-shortcut yebhobhodi okanye ngokusebenzisa idibhoni.
Ukufihla amafomula, njengokuvala iiseli, inyathelo elibini elibandakanya ukuchonga uluhlu lweeseli ofuna ukulifihla uze ulisebenzise ukukhuselwa kwephepha lokusebenzela.
Khetha i-Cell Range ukufihla
- Khetha uluhlu lweeseli ezinemifomula efihliweyo.
- Kwiphepha laseKhaya lebhebhoni, cofa kwiqhosha lokuFometha ukuvula imenyu ehlayo.
- Ku menu, nqakraza kwiifomathi zefomathi ukuvula ibhokisi yencoko yebhokisi yefomathi.
- Kwibhokisi yencoko, nqakraza kwiTebhu yokukhusela .
- Kule ithebhu, khetha ibhokisi yokukhangela elifihliweyo .
- Cofa u- OK ukufaka utshintsho kwaye uvale ibhokisi yencoko.
Faka isicelo seKhuseleko lokuSebenza
- Kwiphepha lekhaya lasebhoni, nqakraza kwifom yefomathi ukuvula imenyu yokuhla.
- Cofa kwiKhowudi yokuKhusela i-Protect phantsi kweloluhlu ukuvula ibhokisi yencoko ye-Protect Sheets.
- Hlola okanye ungayicokiselanga okukhethwa kukho.
- Cofa u- OK usebenzise iinguqu kwaye uvale ibhokisi yencoko.
Kule nqanaba, iifomula ezikhethiweyo mazifihliwe kwimbono kwibhar yomfom. Kuze kube isinyathelo sesibini senziwa, iifomula zihlala zibonakala kwiseli yomsebenzi kunye nebha bar.