Ibha yeFomula (ibha yefx) kwiSpredishithi

Yintoni i-Formula okanye i-Fx Ibha kwi-Excel kwaye Ndingayisebenzisela ntoni?

Ibha yefomula - ebizwa ngokuba yi- fx bar ngenxa yesithonjana sefx esisecaleni kwayo - ibar ye-multi-purpose located above the headings in Excel kunye ne-Google Spreadsheets.

Ngokuqhelekileyo, ukusetyenziswa kwayo kubandakanya ukubonisa, ukuhlela, nokufaka idatha ekhoyo kwiiseli zomsebenzi okanye kwiitshathi.

Ukubonisa iDatha

Ngokukodwa, ibha yefomula iya kubonisa:

Ekubeni ibha yefomula ibonisa iifomula ezikhoyo kwiiseli kunokuba iziphumo zefomula, kulula ukufumana ukuba yeyiphi iiseli ziqulethe iifomula nje ngokuchofoza kuzo.

Ibha yefomula ibonisa kwakhona inani elipheleleyo leenombolo ezifomathiweyo ukubonisa indawo ezimbalwa zeeselingi kwiseli.

UkuHlela amaFomula, iiKharati kunye neDatha

Ibha yefomula ingasetyenziselwa ukuhlela iifomula okanye enye idatha ekhoyo kwiseli esebenzayo nje ngokuchofoza kwidatha kwibha yefomula kunye ne-mouse pointer.

Ingasetyenziselwa ukuhlela iindidi zechungechunge lomntu ngamnye olukhethwe kwi-chart ye-Excel.

Kananjalo kunokwenzeka ukungena kwedatha kwiseli esebenzayo, kwakhona ngokuchofoza kunye ne-pointer ye mouse ukufaka inqaku lokufaka.

Ukwandisa i-Excel Bar yeFomula

Ngokufakela kwedatha ende okanye iifomula eziyinkimbinkimbi, ibha yefomula kwi-Excel inokwandiswa kwaye ifomula okanye idatha ifakwe emigqeni emininzi njengoko kuboniswe kumfanekiso ongentla. Ibha yefomula ayikwazi ukwandiswa kwi-Google Spreadsheets.

Ukwandisa ibha yefomula kunye nemouse:

  1. Ukuhambisa i-pointer ye mouse eduze kwezantsi kwibhar yomfomula ize iguqule kwi-vertical, i-arrow-headed-headed - njengokuba kuboniswe kumfanekiso;
  2. Kulo nqaku, cinezela kwaye ubambe iqhosha lasekhohlo le mouse kwaye udibanise ukwandisa ibha yefomula.

Ukwandisa ibha yefomula kunye nezitshixo zokufutshane:

Inqamulelo yebhobhodi yokwandisa ibha yefomula yile:

Ctrl + Shift + U

Ezi zitshixo zingacinwa kwaye zikhutshwe zonke ngexesha elinye okanye, iifayile zeCtrl kunye neShift zingagcinwa phantsi kunye nekhowudi u-U icinezele kwaye ikhululwe yodwa.

Ukubuyisela ubungakanani obungapheliyo kwibha yefomula, cinezela iifayile ezifanayo okwesibini.

Ukufomula amaFomula okanye iDatha kwiMitha emininzi kwiBhodi yeFomula

Emva kokuba ibhanki yefom ye-Excel isandisiwe, isinyathelo esilandelayo kukugubungula amafomula amade okanye idatha kwimigca emide, njengoko kuboniswe kumfanekiso ongentla,

Kwibha yefomula:

  1. Cofa kwiseli kwiphepha lokusebenzela eliqukethe ifom okanye idatha;
  2. Cofa kunye ne-pointer ye mouse ukuze ufake indawo yokufaka kwi-break point kwifom;
  3. Cinezela i- Alt + Faka izitshixo kwikhibhodi.

Ifomula okanye idatha ukusuka kwindawo yokuphumula iya kufakwa kumgca olandelayo kwibha yefomula. Phinda kwakhona amanyathelo angentla apha ukwengeza ikhefu elongezelelweyo.

Bonisa / Fihla iBra Formula

Kukho iindlela ezimbini ezikhoyo zokufihla / ukubonisa ibha yefomula kwi-Excel:

Indlela esheshayo-kuboniswe kumfanekiso ongentla:

  1. Cofa kwi-Tbon ye-Ribboni;
  2. Hlola / ungayikhethi inketho yeBrawu ye- Formula ekhompyutheni ye- Ribbon .

Indlela ende:

  1. Cofa kwifayile yefayile yebhebhoni ukuvula imenyu ehlayo;
  2. Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye - Excel ;
  3. Cofa kwi- Advanced kwiphepha lekhohlo lebhokisi yencoko;
  4. Kwisiqendu sokubonisa kwikholam yolungileyo, khangela / ungakhange ukhethise inketho yeBhodi yeFomula ;
  5. Cofa u-OK usebenzise iinguqu kwaye uvale ibhokisi yencoko.

I-Google Spreadsheets:

  1. Cofa kwi Imenyu yokujonga ukuvula uluhlu lwezinto ezikhethiweyo;
  2. Cofa kwi- bar yefomula yokukhetha ukujonga (ukujonga) okanye ukuyihlolisa (ukufihla).

Ukuthintela iifomula ezivela kwi-Excel Bar yeFomula

Ukukhuselwa komsebenzi we-Excel kuquka inketho ekhusela iifomula kwiiseli ezikhiweyo ukuba ziboniswe kwibha yefomula.

Ukufihla amafomula, njengokuvala iiseli, yinkqubo yezinyathelo ezimbini.

  1. Iiseli ezinemifomula zifihliwe;
  2. Ukukhuselwa kwephepha lokusebenzela kusetyenziswa.

Kude isinyathelo sesibini senziwa, iifomula ziya kuhlala zibonakala kubha yefomula.

Inyathelo 1:

  1. Khetha uluhlu lweeseli ezinemifomula efihliweyo;
  2. Kwiphepha laseKhaya lebhebhoni, nqakraza kwifom yefomathi ukuvula imenyu ehlayo;
  3. Ku menu, nqakraza kwiifomathi zefomathi ukuvula ibhokisi yencoko yebhokisi yefomathi;
  4. Kwibhokisi yencoko, nqakraza kwiTebhu yoKhuselo ;
  5. Kule ithebhu, khetha ibhokisi lokuhlola elifihliweyo ;
  6. Cofa u-OK ukufaka utshintsho kwaye uvale ibhokisi yencoko.

Inyathelo 2:

  1. Kwiphepha laseKhaya lebhebhoni, nqakraza kwifom yefomathi ukuvula imenyu ehlayo;
  2. Cofa kwiKhowudi yokuKhusela i-Protect ephantsi kweluhlu ukuvula ibhokisi yencoko ye- Protect Sheets ;
  3. Hlola okanye ungayicokiselanga okukhethwa kukho
  4. Cofa u-OK usebenzise iinguqu kwaye uvale ibhokisi yencoko.

Kule nqanaba, iifomula ezikhethiweyo mazifihliwe kwimbono kwibhar yomfom.

✘, ✔ kunye neefx icons kwi Excel

I-✗, ✔ kunye neefx icons ezikufutshane ne-bar bar kwifom ye-Excel zingasetyenziselwa:

Idibhodi elinganayo kule mizobo, ngokulandelanayo, yiyo:

Ukulungiswa kwiBra Formula kunye neeNqamlezo zeNqamlezo kwi-Excel

Ukhiye wekhamera yekhamera yokuhlela idatha okanye amafomula yiF2 kuzo zombini i-Excel kunye ne-Google Spreadsheets. Ngokungagqibekanga, oku kuvumela ukuhlelwa kwiseli esebenzayo - inqaku lokufaka likhoyo kwiseli xa iF2 icinezelwa.

Kwi-Excel, kunokwenzeka ukuhlela ifomula kunye nedatha kwifom yefomula kunokuba iseli. Ukwenza njalo:

  1. Cofa kwifayile yefayile yebhebhoni ukuvula imenyu ehlayo;
  2. Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye- Excel ;
  3. Cofa kwi- Advanced kwiphepha lekhohlo lebhokisi yencoko;
  4. Kwiqhosha lokukhethwa kwe-Editing kwikhompyutha elungileyo, cima i- Vumela ukuhlela ngokuthe ngqo kwikhetho ;
  5. Cofa u-OK ukufaka utshintsho kwaye uvale ibhokisi yencoko.

I-Google Spreadsheets ayivumeli ukuhlela ngokuthe ngqo kwibha yefomula usebenzisa iF2.