Ungawafihla kanjani amafomula ku-Excel. Izindlela ezi-2 zokufihla amafomula ku-Excel

Ngokuzenzakalelayo, kudokhumenti ye-Excel, lapho uchofoza iseli kubha yefomula, ifomula esetshenziswa kuseli elishiwo ivela ngokuzenzakalelayo. Ngezinye izikhathi kungase kudingeke ukuba ufihle ifomula esetshenzisiwe emehlweni okubuka. Ukusebenza kwe-Excel kwenza kube lula ukwenza lokhu.

Ukusetha ukuboniswa kwamafomula kuthebula le-Excel

Ukuze kube lula ukusebenza ngamatafula nokuhlela okuqukethwe kwamafomula, uma uchofoza kuseli, kuvela umbono ogcwele wefomula ekhonjiswe kuyo. Iboniswa emugqeni ophezulu eduze kohlamvu oluthi “F”. Uma ingekho ifomula, khona-ke okuqukethwe kweseli kumane kuyimpinda. Lokhu kwenza kube lula ukuhlela ithebula, kodwa akudingekile ngaso sonke isikhathi ukuthi abanye abasebenzisi bakwazi ukubona amafomula asetshenzisiwe noma bakwazi ukufinyelela kumaseli athile. Izici ze-Excel zikuvumela ukuthi umane ufihle ukuboniswa kwamafomula, futhi zenze kungenzeki nhlobo ukusebenzisana namaseli acacisiwe. Ake sicabangele zombili izinketho.

Engeza ukuvikelwa kweshidi

Uma le nketho inikwe amandla okuqukethwe kweseli kubha yefomula ukuyeka ukubonisa. Nokho, noma yikuphi ukusebenzisana namafomula kulesi simo nakho kuzovinjelwa, ngakho-ke ukuze wenze izinguquko, uzodinga ukuvala ukuvikela kweshidi. Ukuvikelwa kweshidi kunikwe amandla ngale ndlela:

  1. Khetha amaseli ofuna ukuwafihla amafomula awo.
  2. Chofoza kwesokudla endaweni egqanyisiwe. Kumenyu yokuqukethwe, yiya entweni ethi “Fometha Amaseli”. Kunalokho, ungasebenzisa isinqamuleli sekhibhodi “Ctrl+1”.
Ungawafihla kanjani amafomula ku-Excel. Izindlela ezi-2 zokufihla amafomula ku-Excel
Ukushayela imenyu yokuqukethwe ngezilungiselelo zeseli
  1. Iwindi elinezilungiselelo zefomethi yeseli lizovuleka. Shintshela kuthebhu "Ukuvikela".
  2. Maka ibhokisi eliseduze kokuthi Fihla Amafomula. Uma futhi udinga ukwenqabela ukuhlela okuqukethwe kwamaseli, bese uthikha ibhokisi eliseduze kokuthi “Iseli elivikelwe”. Chofoza okuthi “KULUNGILE” ukuze usebenzise izilungiselelo bese uvala iwindi lokushintsha ifomethi yeseli.
Ungawafihla kanjani amafomula ku-Excel. Izindlela ezi-2 zokufihla amafomula ku-Excel
Vikela futhi ufihle amafomula eseli
  1. Ungayeki ukukhetha amaseli. Shintshela kuthebhu ethi "Buyekeza", etholakala kumenyu ephezulu.
  2. Eqenjini lamathuluzi elithi “Vikela”, chofoza okuthi “Vikela Ishidi”.
  3. Iwindi lezilungiselelo zokuvikela amashidi lizovuleka. Cabanga ngephasiwedi bese uyifaka endaweni efanele. Chofoza "KULUNGILE" ukuze usebenzise iphasiwedi.
Ungawafihla kanjani amafomula ku-Excel. Izindlela ezi-2 zokufihla amafomula ku-Excel
Ukusetha iphasiwedi ukuvikela ishidi
  1. Iwindi lokuqinisekisa iphasiwedi lizovela. Yifake lapho futhi bese uchofoza okuthi KULUNGILE.
  2. Ngenxa yalokho, amafomula azofihlwa ngempumelelo. Uma ukhetha imigqa evikelwe, ibha yokufaka yefomula izoba ayinalutho.

Qaphela! Ukuze wenze izinguquko kumaseli avikelwe, uzodinga ukungalivikeli ishidi lokusebenza usebenzisa iphasiwedi oyinikezile.

Uma ufuna ukuthi amanye amaseli akwazi ukuguqula amanani futhi acatshangelwe ngokuzenzakalelayo kumafomula afihliwe, yenza lokhu okulandelayo:

  1. Khetha amaseli adingekayo.
  2. Chofoza kwesokudla kokukhethiwe bese uya kokuthi Fometha Amaseli.
  3. Shintshela kuthebhu ethi “Ukuvikela” bese ususa ukumaka into ethi “Ukuvikelwa kweseli”. Chofoza okuthi “KULUNGILE” ukuze ufake isicelo.
  4. Manje ungashintsha amanani kumaseli akhethiwe. Idatha entsha izoshintshwa ngokuzenzakalelayo kumafomula afihliwe.

Vimbela ukukhethwa kweseli

Lolu khetho lusetshenziswa uma ungadingi nje ukuvimbela ukusebenza namaseli futhi ufihle ifomula, kodwa futhi ukwenza kungenzeki ukuwakhetha. Kulokhu, ngeke kusebenze ngisho nokushintsha umklamo.

  1. Khetha ububanzi obufunekayo bamaseli. Chofoza kwesokudla endaweni egqanyisiwe.
  2. Shintshela kuthebhu "Ukuvikela". Hlola uma kukhona umaki eduze kokuthi “Iseli elivikelwe”. Uma kungenjalo, yifake.
  3. Chofoza okuthi “KULUNGILE” ukuze ufake isicelo.
  4. Shintshela kuthebhu yokubuyekeza. Lapho, khetha ithuluzi elithi Vikela Ishidi.
  5. Iwindi lezilungiselelo zokuvikela lizovuleka. Susa ukumaka ibhokisi eliseduze kokuthi “Gqamisa amaseli akhiyiwe” bese uchofoza okuthi “KULUNGILE” ukuze usebenzise izilungiselelo.
Ungawafihla kanjani amafomula ku-Excel. Izindlela ezi-2 zokufihla amafomula ku-Excel
Ikhubaza ukugqamisa
  1. Qinisekisa iphasiwedi ngokuyibhala futhi efasiteleni elivelayo.
  2. Manje awukwazi ukusebenzisana namaseli ashiwo nhlobo. Lokhu kulula kakhulu uma uthumela idokhumenti kothile futhi ungafuni umamukeli alimaza okuthile kuyo.

Kubalulekile! Le nketho ayinconywa uma uthumela idokhumenti komunye umsebenzisi okungenzeka adinge ukwenza izinguquko kuyo. Iqiniso liwukuthi kumadokhumenti lapho amaseli axhumeke ngokuqinile, umamukeli angase angakwazi nhlobo ukwenza izinguquko kuwo.

Isiphetho

Lapho ufihla amafomula kumaseli ku-Excel, lungiselela imikhawulo yokuhlela okuqukethwe. Kwinketho yokuqala, zingadlulwa kancane ngokuthatha izinyathelo ezengeziwe. Inketho yesibili isho ukungenzeki kokwenza izinguquko kumaseli onquma ukuwafihla amafomula awo.

shiya impendulo