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:
- isicatshulwa okanye idatha yedatha ekhoyo kwiseli ekhoyo okanye esebenzayo;
- iifomula ezifumaneka kwisisele esisebenzayo kunokuba impendulo yefomula;
- uluhlu lweeseli ezimele uchungechunge lwedatha olukhethiweyo kwi-chart ye-Excel.
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:
- Ukuhambisa i-pointer ye mouse eduze kwezantsi kwibhar yomfomula ize iguqule kwi-vertical, i-arrow-headed-headed - njengokuba kuboniswe kumfanekiso;
- 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:
- Cofa kwiseli kwiphepha lokusebenzela eliqukethe ifom okanye idatha;
- Cofa kunye ne-pointer ye mouse ukuze ufake indawo yokufaka kwi-break point kwifom;
- 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:
- Cofa kwi-Tbon ye-Ribboni;
- Hlola / ungayikhethi inketho yeBrawu ye- Formula ekhompyutheni ye- Ribbon .
Indlela ende:
- Cofa kwifayile yefayile yebhebhoni ukuvula imenyu ehlayo;
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye - Excel ;
- Cofa kwi- Advanced kwiphepha lekhohlo lebhokisi yencoko;
- Kwisiqendu sokubonisa kwikholam yolungileyo, khangela / ungakhange ukhethise inketho yeBhodi yeFomula ;
- Cofa u-OK usebenzise iinguqu kwaye uvale ibhokisi yencoko.
I-Google Spreadsheets:
- Cofa kwi Imenyu yokujonga ukuvula uluhlu lwezinto ezikhethiweyo;
- 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.
- Iiseli ezinemifomula zifihliwe;
- Ukukhuselwa kwephepha lokusebenzela kusetyenziswa.
Kude isinyathelo sesibini senziwa, iifomula ziya kuhlala zibonakala kubha yefomula.
Inyathelo 1:
- Khetha uluhlu lweeseli ezinemifomula efihliweyo;
- Kwiphepha laseKhaya lebhebhoni, nqakraza kwifom yefomathi ukuvula imenyu ehlayo;
- Ku menu, nqakraza kwiifomathi zefomathi ukuvula ibhokisi yencoko yebhokisi yefomathi;
- Kwibhokisi yencoko, nqakraza kwiTebhu yoKhuselo ;
- Kule ithebhu, khetha ibhokisi lokuhlola elifihliweyo ;
- Cofa u-OK ukufaka utshintsho kwaye uvale ibhokisi yencoko.
Inyathelo 2:
- Kwiphepha laseKhaya lebhebhoni, nqakraza kwifom yefomathi ukuvula imenyu ehlayo;
- Cofa kwiKhowudi yokuKhusela i-Protect ephantsi kweluhlu 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.
✘, ✔ kunye neefx icons kwi Excel
I-✗, ✔ kunye neefx icons ezikufutshane ne-bar bar kwifom ye-Excel zingasetyenziselwa:
- ✘ - ukukhansela ukulungiswa okanye ukungena kwedatha kwiseli esebenzayo;
- ✔ - ukugqiba ukungena okanye ukuhlela kwedatha kwiseli esebenzayo - ayishukumisi ukugqamisa kweeseli esebenzayo kwenye iseli;
- fx - ukubonelela ngeendlela ezinqamlekileyo zokufakela imisebenzi kwiseli esebenzayo ngokuvula ibhokisi yencoko yencoko yokufaka xa ucofa.
Idibhodi elinganayo kule mizobo, ngokulandelanayo, yiyo:
- Isitshixo se- Esc - iishilo ziguqula okanye ukungena kwedatha;
- Ukhiye wokungena - ugqibezela ukungena okanye ukuhlela kwedatha kwiseli esebenzayo - ishukumisela ukugqamisa kweselluli esisebenzayo kwenye iseli;
- Shift + F3 - ivula ibhokisi yencoko yokufaka;
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:
- Cofa kwifayile yefayile yebhebhoni ukuvula imenyu ehlayo;
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye- Excel ;
- Cofa kwi- Advanced kwiphepha lekhohlo lebhokisi yencoko;
- Kwiqhosha lokukhethwa kwe-Editing kwikhompyutha elungileyo, cima i- Vumela ukuhlela ngokuthe ngqo kwikhetho ;
- Cofa u-OK ukufaka utshintsho kwaye uvale ibhokisi yencoko.
I-Google Spreadsheets ayivumeli ukuhlela ngokuthe ngqo kwibha yefomula usebenzisa iF2.