Rashin lambar lamba shine daidaitaccen aikin lissafi. Ana amfani dashi a cikin lissafin daban-daban, duka don dalilai na horo da kuma aiki. Shirin Excel Shallan yana da kayan aikin ginawa don kirga wannan darajar. Bari mu ga yadda ake amfani da su a daban daban.
Darasi: Yadda za a sanya alamar digiri a Microsoft Word
Gina lambobi
Areo Excel, akwai hanyoyi da yawa a lokaci guda don gina lamba. Ana iya yin wannan tare da taimakon daidaitaccen alama, aiki, ko amfani da wasu, zaɓin da ba su da yawa, zaɓuɓɓukan aiki.Hanyar 1: gini ta amfani da alama
Mafi mashahuri da sanannun sanannun hanyar gina lamba mai kyau shine amfani da daidaitaccen alama "^" don waɗannan dalilai. JALIN TATTAUNAWA DON CIKIN SAUKI CIKIN SAUKI:
= x ^ n
A cikin wannan dabara, X shine lambar da aka gina, n shine digiri na gina.
- Misali, don gina lamba 5 zuwa digiri na huɗu. Mu a kowane sel na takardar ko a cikin kirjin dabara muna samar da wadannan shiga:
= 5 ^ 4
- Don yin lissafin kuma nuna sakamakon sa akan allon kwamfuta, danna maɓallin Shigar a kan maɓallin keyboard. Kamar yadda muke gani, a cikin yanayinmu, sakamakon zai yi daidai da 625.
Idan ginin wani muhimmin bangare ne na ƙarin lissafi, ana yin wannan a ƙarƙashin dokokin janar na lissafi. Wato, alal misali, a cikin misali 5 + 4 ^ 3, nan da nan yana yin wargauta lambar 4, sannan kuma Bugu da kari.
Bugu da kari, ta amfani da mai aiki "^" zaka iya gina lambobi na al'ada, amma kuma bayanan da ke ƙunshe da takamaiman kewayon zanen gado.
An gina shi a cikin digiri na shida na tantanin halitta A2.
- A kowane wuri kyauta a kan takardar, rubuta magana:
= A2 ^ 6
- Latsa maɓallin Shigar. Kamar yadda muke gani, an yi lissafin daidai. Tunda a cikin tantanin halitta a2 akwai lamba 7, sakamakon lissafin ya kasance 117649.
- Idan muna son gina nau'ikan lambobi zuwa daidai wannan digiri, to, ba lallai ba ne don yin rikodin tsari ga kowane darajar. Kawai ƙone shi don layin farko na tebur. Sannan kawai kuna buƙatar kawo siginan kwamfuta zuwa ƙananan kusurwar dama ta tantanin halitta tare da dabara. Cika alamar alama zata bayyana. Latsa maɓallin linzamin kwamfuta na hagu da shimfiɗa shi zuwa ƙarshen tebur.
Kamar yadda kake gani, duk dabi'un tazarar da ake so an gina shi cikin takamaiman matakin.
Wannan hanyar ta fi dacewa da dacewa, sabili da haka ya shahara tare da masu amfani. Yana da wanda ake amfani da shi a yawancin adadin ƙididdigar.
Darasi: Aiki tare da tsari a fice
Darasi: Yadda ake yin Autocomplete a Excel
Hanyar 2: aikin aikace-aikacen
Excel ma yana da fasalin musamman don wannan lissafin. Ana kiranta - digiri. Syntax ta yi kama da wannan:
= Digiri (lamba; digiri)
Yi la'akari da aikace-aikacensa akan takamaiman misali.
- Danna kan tantanin, inda muke shirin nuna sakamakon lissafin. Danna kan "Manna Active".
- Wizard ya buɗe. A cikin jerin abubuwa suna neman bayanan "digiri". Bayan kun sami, muna haskaka shi kuma danna maɓallin "Ok".
- Tagan taga yana buɗe. Wannan ma'aikaci yana da hujja guda biyu - lamba da digiri. Haka kuma, a matsayin farkon hujja, zai iya aiki azaman kalmomi da sel. Wato, analogy ne da aka yi ta hanyar kwatanci tare da hanyar farko. Idan an saita adireshin wayar a matsayin mahawara ta farko, ya isa ya sanya siginar linzamin kwamfuta a cikin "lambar", sannan danna maɓallin da ake so na takardar. Bayan haka, ƙimar adadi da aka adana a ciki zai bayyana a cikin filin. Hakanan za'a iya amfani da adireshin tantanin halitta a filin "digiri" a matsayin gardama, amma a aikace da wuya zartar da shi. Bayan an shigar da duk bayanan don yin lissafi, danna maɓallin "Ok".
Biyo wannan, sakamakon lissafin wannan aikin yana nunawa a wurin, wanda aka sanya shi a farkon matakin ayyukan da aka bayyana.
Bugu da kari, ana iya kiran taga muhawara ta hanyar juya zuwa shafin "tsari". A kan tef, danna maɓallin "lissafi", wanda ke cikin "ɗakin karatun aiki" wanda yake "kayan aiki. A cikin jerin abubuwan da suke akwai, kuna buƙatar zaɓar "digiri". Bayan haka, taga muhawara zata fara.
Masu amfani waɗanda suke da takamaiman kwarewa na iya haifar da maye na ayyuka, amma kawai shigar da tsari a cikin tantanin halitta bayan da kalmar sa, a cewar syntax.
Wannan hanyar ta fi rikitarwa fiye da wanda ya gabata. Amfani da shi zai iya barata idan an sanya lissafin a cikin iyakokin aikin hadaddun wanda ya kunshi ma'aikata da yawa.
Darasi: Ayyukan Wizard a Excel
Hanyar 3: Kafa ta hanyar tushe
Tabbas, wannan hanyar ba ta saba ba, amma ana iya sake guje idan idan kuna buƙatar gina adadin 0.5. Za mu bincika wannan yanayin ta wani takamaiman misali.
Muna buƙatar gina 9 zuwa cikin digiri na 0.5 ko daban - ½.
- Selectel a cikin abin da za'a nuna sakamakon. Danna kan "Manna Active".
- A cikin taga aiki na Wizard Ayyukan, neman sigogin tushen. Muna haskaka shi kuma latsa maɓallin "Ok".
- Tagan taga yana buɗe. Abinda kawai gardamar aikin shine lambar. Aikin da kanta tana yin hakar tushen murabba'i daga lambar da aka gabatar. Amma, tunda tushen murabba'i ɗaya ne ga motsa jiki zuwa ga digiri na to, sannan wannan zaɓi ya dace da mu. A filin "Number", mun shigar da lambar 9 kuma danna maɓallin "Ok".
- Bayan haka, ana lissafta sakamako a cikin tantanin halitta. A wannan yanayin, daidai yake daidai da wannan lambar da ita ce sakamakon gina 9 zuwa mataki na 0.5.
Amma, hakika, wannan hanyar keɓaɓɓun wuraren shakatawa da wuya, ta amfani da zaɓuɓɓukan da aka sani da yawa don ƙididdigewa.
Darasi: Yadda za a lissafta tushen a cikin exale
Hanyar 4: Yin rikodin lamba tare da digiri a cikin sel
Wannan hanyar bata samar da don aiwatar da kwamfuta ba. Ana amfani dashi kawai lokacin da kawai kuna buƙatar rubuta lamba tare da digiri a cikin sel.
- Mun tsara tantanin halitta wanda za'a yi shigarwa a tsarin rubutu. Muna haskaka shi. Kasancewa a cikin em tab "gida" a kintinkiri a cikin kayan aiki, danna jerin zaɓuka na zaɓin tsari. Muna danna kan "rubutu".
- A cikin sel guda, rubuta lamba da digiri. Misali, idan muna bukatar mu rubuta uku zuwa mataki na biyu, to rubuta "32".
- Mun sanya siginan kwamfuta zuwa tantanin halitta kuma muka ware lambar ta biyu.
- Ta latsa hadewar Ctrl + 1, kira taga tsarawa. Sanya kaska kusa da "azanci" siga. Latsa maɓallin "Ok".
- Bayan waɗannan magidano, lambar da aka ƙayyade ana nuna akan allon.
Hankali! Duk da cewa lambar cewa lambar zuwa digiri a cikin sel za a nuna a cikin sel, fi kusa da ta a matsayin rubutu na yau da kullun, kuma ba wani bayanin da yawa ba. Saboda haka, don ƙididdigewa, ba za a iya amfani da wannan zaɓi ba. Don waɗannan dalilai, ana amfani da daidaitaccen rikodin digiri a cikin wannan shirin - "^".
Darasi: Yadda ake canza tsarin tantanin halitta a Excel
Kamar yadda kake gani, a cikin shirin Excel akwai hanyoyi da yawa don ƙetare lamba. Don zaɓar takamaiman zaɓi, da farko, kuna buƙatar yanke shawara dalilin da yasa kuke buƙatar magana. Idan kana buƙatar gina magana don rubuta magana a cikin tsari ko kawai don yin lissafin darajar, to ya dace da rikodin ta "^" alama. A wasu halaye, zaku iya amfani da aikin digiri. Idan kana buƙatar gina adadin 0.5, to, zai yiwu a yi amfani da aikin tushen. Idan mai amfani yana so ya hango wani yanki mai amfani da wuta ba tare da ayyukan ƙididdiga ba, sannan tsarawa zai zo ga ceto.