Yin haɓaka lamba zuwa iko shi ne aiki na ilmin lissafi daidai. An yi amfani da shi a wasu ƙididdiga, duka don dalilai na ilimi da kuma aiki. Excel ya gina kayan aiki don ƙididdige wannan darajar. Bari mu ga yadda za mu yi amfani da su a wasu lokuta.
Darasi: Yadda za a sanya alamar digiri a cikin Microsoft Word
Haɓaka lambobi
A cikin Excel, akwai hanyoyi da dama don tada lamba zuwa iko a lokaci guda. Ana iya yin haka tareda taimakon alamar misali, aiki ko ta amfani da wasu, ba mawuyaci ba, zažužžukan.
Hanyar 1: erection ta amfani da alama
Hanyar da ya fi sanannun kuma sanannun hanyar yin amfani da shi a cikin Excel shi ne amfani da alamar misali. "^" don wadannan dalilai. Ma'anar samfurin tsari ga ginawa kamar haka:
= x ^ n
A wannan tsari x - wannan lamari ne mai ginawa n - mataki na erection.
- Alal misali, don tada lambar 5 zuwa ƙarfin na huɗu, muna yin shigarwa ta gaba a kowace tantanin halitta ko a cikin tsari:
=5^4 - Domin yin lissafi da nuna sakamakonsa akan allon kwamfuta, danna kan maballin. Shigar a kan keyboard. Kamar yadda muka gani, a cikin yanayinmu na musamman, sakamakon zai zama daidai da 625.
Idan aikin ya kasance wani ɓangare na lissafi mafi mahimmanci, to ana yin hanya bisa ga ka'idodi na lissafi. Wato, misali, a misali 5+4^3 Nan da nan Excel ya yi bayani akan ikon lambar 4, sannan kuma bugu.
Bugu da ƙari, ta amfani da mai aiki "^" Yana yiwuwa a gina ba kawai lambobi na kowa ba, amma har da bayanai da ke kunshe a wani kewayon takarda.
Gyara abinda ke ciki na cell A2 don digiri shida.
- A cikin kowane sarari a kan takardar rubuta rubutu:
= A2 ^ 6 - Muna danna maɓallin Shigar. Kamar yadda kake gani, an yi lissafi daidai. Tun lokacin da lambar ta 7 ta kasance a cell A2, sakamakon lissafi ya 117649.
- Idan muna so mu gina a cikin wannan digiri a cikin dukkanin lambobi, to lallai ba wajibi ne a rubuta wani tsari don kowane darajar ba. Ya isa ya rubuta shi don jeri na farko na tebur. Sa'an nan kuma kawai kuna buƙatar motsa siginan kwamfuta zuwa kusurwar dama na tantanin halitta tare da tsari. Alamar cika alama ta bayyana. Kunna maɓallin linzamin hagu kuma ja shi zuwa kasa sosai na teburin.
Kamar yadda kake gani, duk martabobin da ake bukata da aka ɗaga su zuwa ikon da aka ƙayyade.
Wannan hanya ta zama mai sauƙi kuma mai dacewa sosai, sabili da haka yana da kyau sosai tare da masu amfani. Wannan ana amfani dashi a mafi yawan lokuta ƙididdiga.
Darasi: Aiki tare da samfurori a Excel
Darasi: Yadda za a yi ba da kyauta a Excel
Hanyar 2: amfani da aikin
A cikin Excel akwai aikin na musamman don aiwatar da wannan lissafi. An kira shi - DEGREE. Sakamakonsa kamar haka:
= GARATARWA (lambar digiri)
Ka yi la'akari da amfani da shi a wani misali.
- Mun danna kan tantanin halitta inda muke shirin nuna sakamakon sakamakon lissafi. Muna danna maɓallin "Saka aiki".
- Yana buɗe Wizard aikin. A cikin jerin abubuwa muna neman rikodin. "ƘARARWA". Bayan mun sami, zaɓi shi kuma danna maballin "Ok".
- Maganin gardama ya buɗe. Mai bada sabis yana da ƙwararra biyu - lambar da digiri. Kuma kamar yadda gardama na farko zata iya aiki, duka nauyin lamba, da tantanin halitta. Wato, ana gudanar da ayyuka ta hanyar kwatanta da hanyar farko. Idan hujja ta farko ita ce adireshin tantanin salula, to kawai a saka siginan kwamfuta a filin "Lambar", sa'an nan kuma danna kan yankin da ake buƙata na takardar. Bayan haka, ana adana nauyin lambar da ake adana a cikin filin. Aiki a filin "Degree" Adireshin tantancewa na iya amfani dashi azaman gardama, amma a aikace wannan yana da wuya a dace. Bayan an shigar da bayanai, don yin lissafi, danna kan maballin "Ok".
Bayan haka, sakamakon sakamakon lissafin wannan aikin an nuna shi a wurin da aka sanya shi a mataki na farko na ayyukan da aka bayyana.
Bugu da ƙari, za a iya kiran maɓallin muhawara ta zuwa shafin "Formulas". A tef, danna maballin "Ilmin lissafi"wanda ke cikin akwatin kayan aiki "Gidan Kayan aiki". A cikin jerin abubuwan da kake buƙatar zaɓar "ƘARARWA". Bayan haka, maɓallin muhawarar wannan aikin zai fara.
Masu amfani da ke da kwarewa bazai kira ba Wizard aikin, kuma kawai shigar da samfurin a tantanin halitta bayan alamar "="bisa ga fassararsa.
Wannan hanya ta fi rikitarwa fiye da baya. Amfani da shi zai iya barata idan ana bukatar lissafi a cikin iyakokin aikin aiki wanda ya ƙunshi masu aiki da yawa.
Darasi: Wizard Function Wizard
Hanyar 3: bayyanar ta hanyar tushen
Hakika, wannan hanya ba al'ada bane, amma zaka iya samun damar yin hakan idan kana buƙatar gina lamba zuwa ikon 0.5. Bari mu bincika wannan shari'ar tare da misali misali.
Muna buƙatar tada 9 zuwa ikon 0.5 ko, in ba haka ba, zuwa ½.
- Zaɓi tantanin halitta wanda za'a nuna sakamakon. Danna maballin "Saka aiki".
- A cikin taga wanda ya buɗe Ma'aikata masu aiki neman abu ROOT. Zaɓi shi kuma danna maballin. "Ok".
- Maganin gardama ya buɗe. Ƙwararren aiki ɗaya ROOT yana da lamba. Ayyukan da kanta kanta suna yin haɓakar murfin tushen shigarwa. Amma, tun da tushen ginin yana da mahimmanci idan aka tashe shi da ikon ½, to wannan zabin yana da kyau a gare mu. A cikin filin "Lambar" shigar da lamba 9 kuma danna maballin "Ok".
- Bayan haka, ana lissafta sakamakon a cikin tantanin halitta. A wannan yanayin, ya daidaita da 3. Wannan lambar ce ita ce sakamakon kiwon 9 zuwa iko 0.5.
Amma, ba shakka, sun yi amfani da wannan hanyar lissafin sosai, ta hanyar amfani da ƙididdigar sanannun ƙididdigar sanannun ƙwarewa da fahimta.
Darasi: Yadda za a tantance tushen a cikin Excel
Hanyar 4: Rubuta Lamba tare da Degree a cikin Cell
Wannan hanya ba ta samar da lissafin akan gina ba. Ba daidai ba ne kawai lokacin da kake buƙatar rubuta lamba tare da digiri a cikin tantanin halitta.
- Shirya tantanin halitta da za a rubuta a cikin tsarin rubutu. Zaɓi shi. Kasancewa a cikin shafin "Home" a kan tef a cikin asalin kayan aiki "Lambar", danna kan jerin jerin sauƙi na zaɓi. Danna kan abu "Rubutu".
- A cikin tantanin daya, rubuta lambar da digiri. Alal misali, idan muna buƙatar rubuta uku zuwa digiri na biyu, to, sai mu rubuta "32".
- Sanya siginan kwamfuta a cikin tantanin salula kuma zaɓi kawai lambar na biyu.
- Keystroke Ctrl + 1 kira hanyar tsarawa. Saita alamar kusa da saiti "Tarihin". Muna danna maɓallin "Ok".
- Bayan wadannan manipulations, lambar da aka ƙayyade da digiri za a nuna a allon.
Hankali! Kodayake lambobin za a nuna su a cikin tantanin halitta zuwa digiri, Excel ta yi amfani da shi a matsayin rubutu mai rubutu, ba maɓallin lambobi ba. Saboda haka, ba za a iya amfani da wannan zaɓin don lissafi ba. Don waɗannan dalilai, ana amfani da rikodin digiri na musamman a wannan shirin - "^".
Darasi: Yadda za a canza tsarin salula a Excel
Kamar yadda ka gani, a cikin Excel akwai hanyoyi da yawa don tada lamba zuwa ikon. Domin zaɓar wani zaɓi na musamman, da farko, kana buƙatar yanke shawarar abin da kake buƙatar bayani don. Idan kana buƙatar yin aikin gina rubutu a cikin wani tsari ko kawai don lissafa darajar, to, ya fi dacewa ya rubuta ta wurin alamar "^". A wasu lokuta, zaka iya amfani da aikin DEGREE. Idan kana buƙatar tada lambar zuwa ikon 0.5, to akwai yiwuwar amfani da aikin ROOT. Idan mai amfani yana so ya yi nuni don nuna alamar wutar lantarki ba tare da aikinsu ba, to amma tsarawa zai zo wurin ceto.
