Ifihla amafomula ku-Excel

Lapho usebenza namaspredishithi e-Excel, ngokuqinisekile, abasebenzisi abaningi bangase baqaphele ukuthi uma iseli liqukethe ifomula, bese kuba kubha yefomula ekhethekile (ngakwesokudla kwenkinobho. "Fx") sizoyibona.

Isikhathi esiningi kuba nesidingo sokufihla amafomula ephepheni lokusebenza. Lokhu kungase kube ngenxa yokuthi umsebenzisi, isibonelo, akafuni ukuwabonisa abantu abangagunyaziwe. Ake sibone ukuthi lokhu kungenziwa kanjani ku-Excel.

Indlela 1. Vula ukuvikelwa kweshidi

Umphumela wokusetshenziswa kwale ndlela ukufihla okuqukethwe kwamaseli kubha yefomula futhi uvimbele ukuhlelwa kwawo, okuhambisana ngokugcwele nomsebenzi.

1. Okokuqala sidinga ukukhetha amaseli esifuna ukukufihla okuqukethwe kwawo. Bese uchofoza kwesokudla ebangeni elikhethiwe kanye nemenyu yokuqukethwe evulekayo, ima emugqeni "Ifomethi Yeseli". Futhi, esikhundleni sokusebenzisa imenyu, ungacindezela inhlanganisela yokhiye Ctrl + 1 (ngemuva kokuthi indawo efunwayo yamaseli isikhethiwe).
2. Shintshela kuthebhu "Ukuvikela" efasiteleni lefomethi elivulekayo. Lapha, khetha ibhokisi eliseduze kwenketho “Fihla Amafomula”. Uma umgomo wethu ungekona ukuvikela amaseli ezinguqukweni, ibhokisi lokuhlola elihambisanayo lingasuswa ukuthikhiwe. Kodwa-ke, ezimweni eziningi, lo msebenzi ubaluleke kakhulu kunokufihla amafomula, ngakho-ke kithi, sizokushiya futhi. Chofoza uma usulungile OK.
3. Manje efasiteleni lohlelo olukhulu, shintshela kuthebhu "Buyekeza", lapho eqenjini lamathuluzi "Ukuvikela" khetha umsebenzi “Vikela Ishidi”.
4. Ewindini elivelayo, shiya izilungiselelo ezijwayelekile, faka iphasiwedi (kuzodingeka kamuva ukususa ukuvikelwa kweshidi) bese uchofoza. OK.
5. Ewindini lokuqinisekisa elivela ngokulandelayo, faka iphasiwedi emiswe ngaphambilini futhi bese uchofoza OK.
6. Ngenxa yalokho, sakwazi ukufihla amafomula. Manje, uma ukhetha amaseli avikelwe, ibha yefomula izobe ingenalutho.

Qaphela: Ngemva kokuvula ukuvikelwa kweshidi, lapho uzama ukwenza noma yiziphi izinguquko kumaseli avikelwe, uhlelo luzokhipha umlayezo wolwazi ofanele.

Ngasikhathi sinye, uma sifuna ukushiya ithuba lokuhlela amanye amaseli (kanye nokukhetha - kwendlela 2, okuzoxoxwa ngayo ngezansi), ukuwamaka futhi uye efasiteleni lokufometha, ungahloli. “Iseli elivikelwe”.

Isibonelo, esimweni sethu, singafihla ifomula, kodwa ngesikhathi esifanayo sishiye ikhono lokushintsha ubuningi bento ngayinye nezindleko zayo. Ngemuva kokuthi sisebenzise ukuvikela kweshidi, okuqukethwe kulawa maseli kusengalungiswa.

Indlela 2. Khubaza ukukhetha kweseli

Le ndlela ayivamile ukusetshenziswa uma iqhathaniswa naleyo okukhulunywe ngayo ngenhla. Kanye nokufihla ulwazi kubha yefomula nokwenqabela ukuhlelwa kwamaseli avikelwe, kuphinde kusho ukuvinjelwa ekukhethweni kwawo.

1. Sikhetha ububanzi obudingekayo bamaseli ngokuhlobene nesifuna ukwenza izenzo ezihleliwe.
2. Siya efasiteleni lokufometha nakuthebhu "Ukuvikela" hlola ukuthi inketho ihloliwe “Iseli elivikelwe” (kufanele inikwe amandla ngokuzenzakalela). Uma kungenjalo, yibeke bese uchofoza OK.
3. Ithebhu "Buyekeza" chofoza inkinobho “Vikela Ishidi”.
4. Iwindi elijwayelekile lizovuleka ukuze ukhethe izinketho zokuphepha nokufaka iphasiwedi. Susa ukumaka ibhokisi eduze kwenketho "gqamisa amaseli avinjiwe", setha iphasiwedi bese uchofoza OK.
5. Qinisekisa iphasiwedi ngokuyibhala futhi, bese uchofoza OK.
6. Njengomphumela wezenzo ezithathiwe, ngeke sisakwazi ukubuka kuphela okuqukethwe kwamaseli kubha yefomula, kodwa futhi siwakhethe.

Isiphetho

Ngakho, kunezindlela ezimbili zokufihla amafomula kusipredishithi se-Excel. Esokuqala sibandakanya ukuvikela amaseli ngamafomula ekuhleleni nasekufihleni okuqukethwe kwawo kubha yefomula. Owesibili uqine kakhulu, ngaphezu komphumela otholwe kusetshenziswa indlela yokuqala, ubeka ukuvinjelwa, ikakhulukazi, ekukhethweni kwamaseli avikelwe.