Ibha yefomula (i-fx bar) kumaSpredishithi

Iyini i-Formula noma i-Fx Ibha ku-Excel futhi Ngingayisebenzisa Kanjani?

Ibha yefomula - ebizwa nangokuthi ibha ye-fx ngenxa yesithonjana sefx esiseduze nayo - ibha yezinhloso eziningi ezitholakala ngaphezulu kwezingqikithi zekholomu ku-Excel nama-Google Spreadsheets.

Ngokuvamile, ukusetshenziswa kwalo kufaka phakathi ukubonisa, ukuhlela, nokufaka idatha ekhona kumaseli omsebenzi noma kumashadi.

Ukubonisa Idatha

Ngokuqondile, ibha yefomula izobonisa:

• idatha noma inombolo yedatha ekhona esitokisini samanje noma esebenzayo;
• amafomula atholakala esitokisini esisebenzayo kunokuba impendulo yefomula;
• ububanzi bamaseli abamele uchungechunge lwedatha olukhethiwe eshadini le-Excel.

Njengoba ibha yefomula ibonisa amafomula asetsheni kunemiphumela yefomula, kulula ukuthola ukuthi yimaphi amangqamuzana aqukethe amafomula nje ngokuchofoza kuwo.

Ibha yefomula iphinda yembule inani eligcwele lezinombolo ezifomathiwe ukubonisa izindawo ezimbalwa zesimali esesitokisini.

Ukuhlela Amafomula, Amashadi, NeDatha

Ibha yefomula ingasetshenziselwa ukuhlela amafomula noma enye idatha esesitokisini esisebenzayo ngokuchofoza idatha ku-bar yefomula ne-pointer yegundane.

Ingasetshenziselwa ukuhlela izigaba zohlu chungechunge lomuntu ngamunye olukhethiwe eshadini se-Excel.

Kungenzeka futhi ukufaka idatha esitokisini esisebenzayo, futhi ngokuchofoza inkinobho yegundane ukungena iphuzu lokufaka.

Ukwandisa i-Excel Bar yefomula

Ngokufaka okufakiwe kwedatha ende noma amafomula adidayo, ibha yefomula ku-Excel ingandiswa futhi ifomula noma idatha ifakwe emigqeni eminingi njengoba kuboniswe esithombeni ngenhla. I-bar yefomula ayikwazi ukunwetshwa kuma-Google Spreadsheets.

Ukwandisa ibha yefomula negundane:

1. Hover i-pointer yegundane eduze kwe-bar yefomula kuze kube yilapho ishintshela emgqeni, umcibisholo onamahloko amabili - njengoba kuboniswe esithombeni;
2. Kuleli phuzu, cindezela bese ubamba inkinobho yesinxele yesinxele bese ususa phansi ukwandisa ibha yefomula.

Ukwandisa ibha yefomula ngezinkinobho zokunqamulela:

Isinqamuleli sekhibhodi sokwandisa ibha yefomula ngu:

Ctrl + Shift + U

Lezi zihluthulelo zingacindezelwa futhi zikhishwe konke ngesikhathi esifanayo noma, izinkinobho ze- Ctrl ne- Shift zingagcinwa phansi bese ukhiye we-U ucindezela futhi ukhululekile uqobo.

Ukuze ubuyisele usayizi ozenzakalelayo webha yefomula, cindezela okhiye abafanayo okwesibili.

Ukufomula Amafomula noma Idatha kwimigqa eminingi e-Bar Formula

Uma ibha ye-Excel yefomula isandisiwe, isinyathelo esilandelayo ukugoqa amafomula amade noma idatha emigqeni eminingi, njengoba kuboniswe esithombeni ngenhla,

Ku-bar yefomula:

1. Chofoza kuseli kufomu lokusebenzela eliqukethe ifomula noma idatha;
2. Chofoza nge-pointer yegundane ukubeka iphuzu lokufaka endaweni yokuphumula kwifomula;
3. Cindezela okhiye be- Alt + Enter ekhibhodi.

Ifomula noma idatha kusuka iphuzu lokuphumula kuya phambili lizofakwa emgqeni olandelayo kwibha yefomula. Phinda izinyathelo ezingenhla ukuze wengeze amaphuzu engeziwe.

Bonisa / Fihla ibha yefomula

Kunezindlela ezimbili ezikhona zokufihla / ukubonisa ibha yefomula ku-Excel:

Indlela esheshayo - kuboniswe esithombeni ngenhla:

1. Chofoza kuthebhu Buka yebhebhoni;
2. Hlola / unqamule inketho ye- Formula Bar ekhoneni lokubonisa lebhebhoni .

Indlela ende:

1. Chofoza kuthebhu yefayela yebhebhoni ukuvula imenyu ehlayo;
2. Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye- Excel ;
3. Chofoza ku- Okuthuthukile ngakwesokunxele kwesibhokisi sebhokisi;
4. Esigabeni sokubonisa sesilawuli sokunene, hlola / ungasikhethi inketho ye- Formula Bar ;
5. Chofoza OK ukufaka izinguquko bese uvala ibhokisi lengxoxo.

I-Google Spreadsheets:

1. Chofoza kwimenyu yokubuka ukuze uvule uhlu lokudonsa phansi lwezinketho;
2. Chofoza ku-option yebha yefomu ye - Formula ukuhlola (ukubuka) noma ukungahloli (fihla).

Vimbela amafomula ekuboniseni kwi-Excel Bar yefomula

Ukuvikeleka kwephepha lokusebenza kwe-Excel kufaka phakathi inketho evimbela amafomula kumaseli avaliwe ukusuka ekubonisweni kubha yefomula.

Ukufihla amafomula, njengokuvala amangqamuzana, inqubo yezinyathelo ezimbili.

1. Amaseli aqukethe amafomula afihlekile;
2. Ukuvikelwa kwephepha lokusebenza kusetshenzisiwe.

Kuze kube yilapho isinyathelo sesibili senziwa, amafomula azohlala ebonakala ebhasini lefomula.

Isinyathelo 1:

1. Khetha ububanzi bamaseli aqukethe amafomula afihliwe;
2. Ethempelini laseKhaya lebhebhoni, chofoza inketho Yefomathi ukuvula imenyu ehlayo;
3. Ku imenyu, chofoza kumafomathi efomathi ukuze uvule ibhokisi lezingxoxo zefomathi yefomathi;
4. Ebhokisini lengxoxo, chofoza kuthebhu yokuvikela ;
5. Kule ithebhu, khetha ibhokisi lokuhlola elifihlekile;
6. Chofoza OK ukuze usebenzise ushintsho bese uvale ibhokisi lengxoxo.

Isinyathelo 2:

1. Ethempelini laseKhaya lebhebhoni, chofoza inketho Yefomathi ukuvula imenyu ehlayo;
2. Chofoza ku- Ukuvikela Ishidi leShidi ngezansi kuhlu ukuze uvule ibhokisi lokukhulisa leSikhwama sokuvikela;
3. Hlola noma ungacubungula izinketho oyifunayo
4. Chofoza OK ukufaka izinguquko bese uvala ibhokisi lengxoxo.

Kuleli qophelo, amafomula akhethiwe kufanele afihliwe ekubukeni kubha yamatomu.

✘, ✔ ne-fx Ama-icons ku-Excel

I-✗, i-✔ ne-fx icons eseduze ne-formula bar ku-Excel ingasetshenziselwa:

• ✘ - ukukhansela ukuhlela noma ukungena kwedatha okuyingxenye esitokisini esisebenzayo;
• ✔ - ukuqedela ukungena noma ukuhlela kwedatha esitokisini esisebenzayo - ayishukumisi ukugqamisa kweselula okusebenzayo kwesinye iseli;
• fx - inikeza isinqamuleli sokufaka imisebenzi esitokisini esisebenzayo ngokuvula ibhokisi lengxoxo ye- Insert uma uchofoza.

Ukulingana kwekhibhodi kulezi zithombe, ngokulandelana, yilokhu:

• Isihluthulelo se- Esc - amakheli ahlela noma ukungena kwedatha ngokwengxenye;
• ukhiye we- Enter - uqedela ukungena noma ukuhlela kwedatha esitokisini esisebenzayo - ushukumisela ukugqamisa kweselula okusebenzayo kwesinye iseli;
• I-Shift + F3 - ivula ibhokisi lokufaka le- Insert ;

Ukuhlela ku-Bar yefomula nge-Kegin Short Keys ku-Excel

Ukhiye wokunqamulela wekhibhodi wokuhlela idatha noma amafomula yi-F2 kokubili i-Excel ne-Google Spreadsheets. Ngokuzenzakalelayo, lokhu kuvumela ukuhlelwa kuseli elisebenzayo - iphuzu lokufaka likhona esitokisini uma iF2 icindezelwe.

Ku-Excel, kungenzeka ukuhlela amafomula nedatha kubha yefomula kunokuba iseli. Ukwenza kanjalo:

1. Chofoza kuthebhu yefayela yebhebhoni ukuvula imenyu ehlayo;
2. Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye- Excel ;
3. Chofoza ku- Okuthuthukile ngakwesokunxele kwesibhokisi sebhokisi;
4. Esigabeni sokukhethwa kokuhlela kwesilawuli sokunene, hlola ukuhlela kwe- Vumela ngokuqondile kukhetho lweseli ;
5. Chofoza OK ukuze usebenzise ushintsho bese uvale ibhokisi lengxoxo.

I-Google Spreadsheets ayivumeli ukuhlela okuqondile ebhafini lefomula usebenzisa i-F2.