Mene ne Formula ko Fx Bar a Excel kuma Menene Zan Yi amfani da shi Domin?
Gurbin dabarun - wanda ake kira fx bar saboda fx icon dake kusa da shi - shi ne maɓallin maɓalli wanda yake a sama da rubutun shafi a cikin Excel da Google Lissafi.
Kullum magana, amfani da shi ya hada da nunawa, gyarawa, da shigar da bayanan da aka samo a cikin Kayan aiki ko kuma a cikin sigogi.
Bayyana Bayanai
Fiye da haka, ɗakin dabarar za ta nuna:
- da rubutu ko lambar da aka samo a cikin halin yanzu ko tantanin halitta;
- dabarar da aka samo a tantanin halitta mai aiki maimakon da amsar tambaya;
- da kewayon Kwayoyin suna wakiltar jerin bayanan da aka zaɓa a cikin wani fasali na Excel.
Tun da maɓallin tsari ya nuna dabarun da ke cikin sel maimakon ƙidodin tsari, yana da sauki a gano wanda kwayoyin sun ƙunshi siffofi kawai ta latsa su.
Gurbin tsari yana nuna cikakken darajar lambobin da aka tsara don nuna ƙananan wurare na ƙadi a cikin tantanin halitta.
Ana gyara Formulas, Charts, da Data
Za a iya amfani da ma'aunin daftarin don gyara dabara ko wasu bayanan dake cikin tantanin halitta ta hanyar danna bayanan da aka yi a cikin ma'auni tare da maɓallin linzamin kwamfuta.
Ana iya amfani da shi don daidaita jeri na kowane jerin bayanai waɗanda aka zaba a cikin wani tashar Excel.
Haka ma za a iya shigar da bayanai cikin tantanin halitta, kuma ta danna tare da maɓallin linzamin kwamfuta don shigar da maɓallin sakawa.
Ƙara Fadar Ƙirar Magana ta Ƙara
Don dogon shigarwar bayanai ko tsari mai mahimmanci, za'a iya fadada irin wannan tsari a Excel da kuma dabarun ko bayanai da aka nannade akan layi da yawa kamar yadda aka nuna a cikin hoto a sama. Ba'a iya fadada shafuka ba a cikin shafukan Google.
Don fadada tsarin dabarun tare da linzamin kwamfuta:
- Sauke maɓallin linzamin kwamfuta a kusa da tushe na takarda har sai ya canza zuwa wani gefe-tsaye, arrow biyu-kamar yadda aka nuna a hoton;
- A wannan lokaci, latsa ka riƙe maɓallin linzamin hagu na dama kuma kaɗa don fadada maɓallin tsari.
Don fadada maɓallin dabarun tare da maɓallan gajeren hanya:
Hanyar maɓallin keyboard don fadada maƙallin ƙirar ita ce:
Ctrl + Shift + U
Wadannan maɓallan za a iya gugawa kuma a saki dukansu a lokaci ɗaya ko, ana iya riƙe Ctrl da Canft Shift kuma saukar maɓallin U key kuma an sake shi a kansa.
Don sake mayar da girman girman irin wannan tsari, latsa maɓallan maɓallin a karo na biyu.
Sauya takardu ko Bayanai a kan Ƙananan Lines a cikin Barikin Formula
Da zarar an shimfiɗa fasalin fasali na Excel, mataki na gaba shine a kunsa dogayen samfurori ko bayanai akan layi da yawa, kamar yadda aka gani a cikin hoto a sama,
A cikin wannan tsari:
- Danna kan tantanin halitta a cikin takardun aiki wanda ke dauke da tsari ko bayanai;
- Danna tare da maɓallin linzamin kwamfuta don sanya wurin sakawa a lokacin hutu a cikin tsari;
- Latsa maɓallin Alt shigarwa a kan keyboard.
Dabarar ko bayanai daga maɓallin hutu zuwa gaba za a sanya shi a layi na gaba a cikin ma'auni. Maimaita matakan da ke sama don ƙara ƙarin hutu.
Nuna / Ɓoye Barikin Ƙira
Akwai hanyoyi guda biyu don ɓoyewa / nuna alamar tsari a Excel:
Hanyar mai sauri - aka nuna a hoton da ke sama:
- Danna kan shafin shafin View na kintinkiri;
- Bincika / cire tsarin zaɓi na Formula Bar a cikin Show na rukuni.
Hanya mai tsawo:
- Danna kan fayil na rubutun don bude jerin menu na saukewa;
- Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Options ;
- Danna Ci gaba a cikin hagu na hagu na akwatin maganganu;
- A cikin Nuni Nuni na aikin haƙiƙa, duba / cire maɓallin zaɓi na Formula Bar ;
- Danna Ya yi don amfani da canje-canje kuma rufe akwatin maganganu.
Ga Shafukan Lissafin Google:
- Danna maɓallin Duba don bude jerin jerin zaɓuɓɓuka;
- Danna maɓallin zaɓi na Formula bar don bincika (duba) ko rufe (boye) shi.
Tsaida Formulas daga Nuna a cikin Ƙarin Saiti na Excel
Kuskuren takardar aiki na Excel ya ƙunshi wani zaɓi wanda ya hana ƙayyadaddun abubuwa a cikin kulle kulle daga nunawa a cikin tsari.
Hiding siffofin, kamar kulle kwayoyin, shi ne mataki na biyu-mataki.
- Kwayoyin da ke dauke da dabara suna ɓoye;
- Ana amfani da kariya ta aiki.
Har zuwa lokacin da aka aiwatar da mataki na biyu, za a kasance da siffofin a cikin wannan tsari.
Mataki na 1:
- Zaži kewayon Kwayoyin da ke dauke da takaddun da za a boye;
- A kan shafin shafin rubutun, danna kan Zaɓin Zabin don buɗe menu na saukewa;
- A cikin menu, danna kan Siffofin Siffofin don buɗe akwatin maganganun Siffofin Siffofin;
- A cikin akwatin maganganu, danna kan Kariya shafin;
- A kan wannan shafin, zaɓi akwatin akwatin boye ;
- Danna Ya yi don amfani da canji kuma rufe akwatin maganganu.
Mataki na 2:
- A kan shafin shafin rubutun, danna kan Zaɓin Zabin don buɗe menu na saukewa;
- Danna Maɓallin Tsare Shafin a kasa na jerin don buɗe akwatin maganganun Tsare-tsare ;
- Bincika ko cire abubuwan da ake so
- Danna Ya yi don amfani da canje-canje kuma rufe akwatin maganganu.
A wannan lokaci, za a ɓoye siffofin da aka zaɓa daga ra'ayi a cikin tsari.
✘, ✔ da fx Icons a Excel
✗, ✔ da fx gumakan da ke kusa da wannan tsari a Excel za a iya amfani dasu:
- ✘ - soke sharuɗɗa ko shigarwa na shiga cikin tantanin halitta mai aiki;
- ✔ - kammala shigarwa ko gyare-gyaren bayanai a cikin tantanin halitta mai aiki - ba ya motsa rayayyun tantanin halitta zuwa wani cell;
- fx - samar da gajeren hanya don saka ayyuka a cikin salula mai aiki ta hanyar bude akwatin maganganun Saka saiti yayin da aka latsa.
Abubuwan da ke maɓallin rubutu daidai don waɗannan gumaka, bi da bi, sune:
- maɓallin Esc - cancantar gyare-gyare ko shigarwa shiga shiga;
- maɓallin Shigar - kammala aikin shigarwa ko gyare-gyaren bayanai a cikin tantanin halitta mai aiki - motsa jiki mai haske zuwa wani cell;
- Shift + F3 - ya buɗe Siffar maganganu;
Ana gyarawa a cikin Barikin Ƙararra tare da Jagorar Gajerun Aiki a Excel
Maɓallin gajerar maɓallin kewayawa don gyara bayanai ko tsari shine F2 ga duka Excel da Fassara na Google. Ta hanyar tsoho, wannan yana bada izinin gyarawa a cikin tantanin halitta mai aiki - wurin sanyawa wuri ne a cikin tantanin halitta lokacin da aka kunna F2.
A cikin Excel, yana yiwuwa a shirya ƙayyadaddun bayanai da mahimman bayanai a cikin maɓallin tsari maimakon cell. Don yin haka:
- Danna kan fayil na rubutun don bude jerin menu na saukewa;
- Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Options ;
- Danna Ci gaba a cikin hagu na hagu na akwatin maganganu;
- A cikin zaɓin zaɓuɓɓukan Zaɓuɓɓuka na aikin dama, cire maɓallin Izinin kai tsaye a cikin zaɓi na cell ;
- Danna Ya yi don amfani da canji kuma rufe akwatin maganganu.
Shafukan Lissafi na Google ba su bada izinin gyara kai tsaye a cikin tsari ta hanyar amfani da F2 ba.