Haɓaka iko zuwa iko shine daidaitaccen aikin lissafi. Ana amfani dashi a cikin lissafin iri daban-daban, don dalilai na ilimi da kuma a aikace. Excel yana da kayan aikin ginannun ƙididdigar wannan ƙimar. Bari mu ga yadda ake amfani da su a fannoni daban-daban.
Darasi: Yadda ake sanya alamar digiri a cikin Microsoft Word
Gyara lambobi
A cikin Excel, akwai hanyoyi da yawa don ɗaga ikon zuwa lamba a lokaci guda. Ana iya yin wannan ta amfani da daidaitaccen alama, aiki, ko ta amfani da wasu, ba ma talakawa ba.
Hanyar 1: ere ta amfani da alama
Hanyar da aka fi sani da sanannun hanyar haɓaka iko zuwa lamba a cikin Excel ita ce amfani da daidaitaccen halaye "^" saboda wadannan dalilai. Tsarin tsari na aikin shine kamar haka:
= x ^ n
A cikin wannan dabara x ana tayar da lambar, n - digiri na kaciya.
- Misali, don tayar da lamba 5 zuwa karfin na hudu, muna samar da shigarwa mai zuwa a cikin kowace sel na takardar ko a masarar dabara:
=5^4 - Domin yin lissafi da nuna sakamakon sa a allon kwamfuta, danna maballin Shigar a kan keyboard. Kamar yadda kake gani, a cikin yanayinmu na musamman, sakamakon zai kasance 625.
Idan ginin wani ɓangare ne na haɗaɗɗun lissafi mai rikitarwa, to, ana aiwatar da aikin gwargwadon ka'idodin lissafi ne. Wannan shine, misali, a cikin misali 5+4^3 Excel nan da nan ya hau zuwa ikon 4, sannan ƙari.
Bugu da kari, ta amfani da afareta "^" Zaku iya ginawa ba kawai lambobin talakawa ba, har ma da bayanan da suke cikin takaddar takarda.
Mun daukaka zuwa na shida ikon abubuwan da ke cikin sel A2.
- A kowane sarari kyauta akan takarda, rubuta kalmar:
= A2 ^ 6 - Latsa maballin Shigar. Kamar yadda kake gani, an yi lissafin daidai. Tun da lambar 7 tana cikin sel A2, sakamakon ƙididdigar ya kasance 117649.
- Idan muna son tayar da jimlar lambobi zuwa matsayi guda, to ba lallai ba ne mu rubuta dabara akan kowane darajar. Ya isa a rubuta shi don layin farko na tebur. Don haka kawai kuna buƙatar motsa siginan kwamfuta zuwa ƙananan kusurwar dama na sel tare da dabara. Mai cike alamar zai bayyana. Riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi zuwa ƙasan tebur.
Kamar yadda kake gani, duk dabi'un da ake so tazara an tashe su zuwa daidai gwargwado.
Wannan hanyar tana da sauƙi kuma mai dacewa kamar yadda zai yiwu, sabili da haka ya shahara sosai tsakanin masu amfani. Yana da shi ana amfani dashi a mafi yawan lokuta na lissafin.
Darasi: Aiki tare da dabaru a Excel
Darasi: Yadda ake yin autocomplete a Excel
Hanyar 2: sanya aikin
Hakanan Excel yana da aiki na musamman don aiwatar da wannan ƙididdigar. Ana kiran shi cewa - DEGREE. Syntax kamar haka:
= DEGREE (lamba; digiri)
Bari muyi la’akari da aikace-aikacensa akan wani ingantaccen misali.
- Mun danna kan wayar inda muke shirin nuna sakamakon sakamakon lissafin. Latsa maballin "Saka aikin".
- Yana buɗewa Mayan fasalin. A cikin jerin abubuwan da muke nema don shigarwa "DEGREE". Bayan mun samo, zaɓi shi kuma danna maballin "Ok".
- Tattaunawa ta buɗe tana buɗewa. Wannan ma'aikacin yana da hujjoji guda biyu - lamba da iko. Haka kuma, duka lambobi da tantanin halitta zasu iya zama azaman farkon gardamar. Wannan shine, ana aiwatar da ayyuka ta hanyar kwatancen tare da hanyar farko. Idan adireshin kwayar yana aiki azaman farkon magana, to kawai sanya siginar linzamin kwamfuta a fagen "Lambar", sannan danna kan yankin da ake buƙata a takardar. Bayan wannan, ƙimar lambobi da aka adana a ciki za a nuna su a filin. Tunani a fagen "Digiri" Hakanan ana iya amfani da adreshin tantanin halitta azaman hujja, amma a aikace wannan ba shi yiwuwa. Bayan an shigar da dukkan bayanai, don aiwatar da lissafin, danna maballin "Ok".
Bayan wannan, sakamakon lissafin wannan aikin an nuna shi a wurin da aka kasafta a farkon matakin ayyukan da aka bayyana.
Bugu da kari, za a iya kiran taga muhawara ta hanyar zuwa shafin Tsarin tsari. Akan tef ɗin, danna "Ilmin lissafi"located a cikin toshe kayan aiki Laburaren Ma’aikata. A jerin samammen abubuwan da suke buɗe, zaɓi "DEGREE". Bayan haka, taga muhawara don wannan aikin zai fara.
Masu amfani waɗanda ke da ƙwarewa na iya yin kira Mayan fasalin, amma kawai shigar da dabara a cikin tantanin halitta bayan alamar "="gwargwadon yadda yake magana.
Wannan hanyar ta fi rikitarwa fiye da wacce ta gabata. Amfani da shi na iya zama barata idan ana buƙatar yin lissafin tsakanin iyakokin aikin babban aiki wanda ya ƙunshi masu aiki da yawa.
Darasi: Wizard ɗin Aiki a cikin Excel
Hanyar 3: exponentiation ta wurin tushen
Tabbas, wannan hanyar ba talakawa bace, amma zaka iya sake yin amfani da ita idan kana buƙatar ƙara lambar zuwa ikon 0,5. Mun bincika wannan yanayin tare da takamaiman misali.
Muna buƙatar ɗaukaka 9 zuwa ikon 0,5, ko kuma a wata hanya - ½.
- Zaɓi tantanin da za'a nuna sakamakon shi. Latsa maballin "Saka aikin".
- A cikin taga yana buɗewa Wizards na Aiki neman kashi TAFIYA. Zaɓi shi kuma danna maballin. "Ok".
- Tattaunawa ta buɗe tana buɗewa. Aiki hujja daya TAFIYA lamba ce. Aikin da kansa yana yin hakar daga cikin tushen murabba'in lamba na shigarwar lamba. Amma, tun da tushen murabba'i ɗaya daidai ne don haɓaka zuwa ƙarfin ½, wannan zaɓi shine daidai a gare mu. A fagen "Lambar" shigar da lamba 9 kuma danna maɓallin "Ok".
- Bayan haka, ana lissafta sakamakon a cikin tantanin halitta. A wannan yanayin, daidai yake da 3. Yana da wannan lambar wanda shine sakamakon haɓaka 9 zuwa ikon 0,5.
Amma, ba shakka, suna yin amfani da wannan hanyar ƙididdigar wahala ba wuya, ta yin amfani da ƙarin sanannun sanannun lissafin zaɓuɓɓuka
Darasi: Yadda ake lissafin tushen a Excel
Hanyar 4: rubuta lamba tare da digiri a cikin sel
Wannan hanyar ba ta samar da ƙididdigar gini ba. Yana da amfani kawai lokacin da kawai kuna buƙatar rubuta lamba tare da digiri a cikin sel.
- Mun tsara salon da za a yi rikodin, a tsarin rubutu. Zaba shi. Kasancewa a cikin shafin "Gidan" a kan tef a cikin akwatin kayan aiki "Lambar", danna kan jerin abubuwanda aka zaba. Danna kan kayan "Rubutu".
- A cikin sel ɗaya, rubuta lambar da kuma digiri. Misali, idan muna bukatar rubuta guda uku a digiri na biyu, to sai mu rubuta "32".
- Mun sanya siginan kwamfuta a cikin tantin kuma zaɓi lambobi na biyu kawai.
- Ta latsa mabuɗan rubutu Ctrl + 1 kira taga tsarawa. Duba akwatin kusa da sigogi "Karshe". Latsa maballin "Ok".
- Bayan waɗannan manipulation, allon zai nuna lambar saiti tare da iko.
Hankali! Duk da cewa za a nuna lamba a cikin tantanin halitta a digiri na biyu, Excel ya dauke shi a matsayin matani a fili, ba adadi ba ne. Sabili da haka, baza'a iya amfani da wannan zaɓi don lissafi ba. Don waɗannan dalilai, ana amfani da daidaitaccen shigarwar digiri a cikin wannan shirin - "^".
Darasi: Yadda za a canza tsarin tantanin halitta a Excel
Kamar yadda kake gani, a cikin Excel akwai hanyoyi da yawa don ɗaga wutar lantarki zuwa wuta. Don zaɓar takamaiman zaɓi, da farko, kuna buƙatar yanke shawarar abin da kuke buƙatar furcin don. Idan kuna buƙatar yin ginin don rubuta magana a cikin dabara ko don ƙididdige darajar, to, ya fi dacewa a rubuta ta hanyar alamar "^". A wasu yanayi, zaku iya amfani da aikin DEGREE. Idan kuna buƙatar haɓaka lamba zuwa ƙarfin 0.5, to, yana yiwuwa a yi amfani da aikin TAFIYA. Idan mai amfani yana so ya gani da ikon magana ba tare da aiwatar da ayyukan kwamfuta ba, to tsara zai zo ga cetonka.
