Divorala Divory Excele: 6 Zaɓuɓɓuka masu sauƙi

A cikin Microsoft Excel, ana iya yin rarrabuwa da taimakon dabaru da amfani da ayyuka. Dalili da Musulmi suna aikata lambobin da adireshin sel.

Hanyar 1: Lambar rarrabuwa don lambar

Za'a iya amfani da takardar FIEP a matsayin wani nau'in kalkuleta, kawai raba lamba daya zuwa wani. Alamar rarrabuwar kawuna ta lalace (layin juyawa) - "/".

1. Mun zama cikin kowane sel na kyauta na takardar ko a cikin nau'in tsari. Mun sanya alamar "daidai" (=). Mun dauki lambar da aka raba daga maballin. Sanya alamar rarrabuwa (/). Muna daukar ma'aikata daga mabuɗin. A wasu halaye, masu rarrabewa sun fi ɗaya. To, a gabãnin kõ, Mun sanya slash, haƙĩƙa, Mun sanya slash (().



2. Don yin lissafin da kuma fitarwa ta a kan mai saka idanu, muna sanya latsa a maɓallin Shigar.

Bayan haka, da Excel zai lissafa dabara da kuma ƙayyadaddun sel da aka ƙayyade za su fito da sakamakon ƙididdigewa.

Idan an yi lissafin tare da haruffa da yawa, to, tsari na kisan an yi shi ne ta hanyar dokokin lissafi. Wato, da farko an yi shi, da ƙari ana yi, kuma a kan ragewa.

Kamar yadda aka sani, rarrabuwa akan 0 shine ba daidai ba. Sabili da haka, tare da irin wannan yunƙurin yin irin wannan lissafi a cikin ERCELE A cikin sel, sakamakon "#!" Zai bayyana.

Darasi: Aiki tare da tsari a fice

Hanyar 2: Rarraba abubuwan da ke cikin sel

Hakanan a Excel, zaku iya raba bayanan a cikin sel.

1. Mun ware a cikin tantanin halitta a cikin abin da za a nuna sakamakon lissafin. Mun sanya alamar "=". Bugu da ari, danna wurin da Delimi yake. Wannan adireshin ya bayyana a cikin tsarin dabara bayan alamar "daidai." Bayan haka, ka saita alamar "/" daga mabuɗin. Danna kan tantanin hannu wanda ya rabu. Idan masu kashe kansu suke, kamar yadda ta dace, muna ƙayyade su duka, da kafin adiresoshinsu sun sanya alamar rarrabuwa.



2. Don yin aiki (rarrabuwa), danna maɓallin "Shigar".

Hakanan zaka iya haɗuwa, a matsayin rabawa ko sama ta amfani da adiresoshin tantanin halitta da lambobi.

Hanyar 3: Rarraba Rarrabawa akan shafi

Lissafi a cikin tebur, ƙimar ɗayan shafi ɗaya ana buƙatar raba bayanan shafi na biyu. Tabbas, zaku iya raba darajar kowane sel a hanyar da aka nuna a sama, amma kuna iya yin wannan hanyar da sauri.

1. Select da kwayar farko a cikin shafi inda yakamata a nuna sakamakon. Mun sanya alamar "=". Danna kan sel rarrabawa. Muna daukar alamar "/". Danna kan sinaddar Surahu.



2. Danna maɓallin Shigar don yin lissafin sakamako.



3. Don haka, ana lissafta sakamako, amma don jere ɗaya. Domin lissafta a cikin sauran layin, kuna buƙatar aiwatar da matakan da ke sama ga kowannensu. Amma zaka iya adana lokacinku ta hanyar kawai ta hanyar yin amfani da ɗaya. Saita siginan kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta tare da dabara. Kamar yadda kake gani, gunki ya bayyana a cikin hanyar gicciye. Ana kiranta mai alamar alama. Danna maɓallin linzamin kwamfuta na hagu kuma cire alamar alamar ƙasa zuwa ƙarshen tebur.

Kamar yadda muke gani, bayan wannan matakin, hanya don rarraba shafi guda daya a karo na biyu za a cire cikakken tsari, kuma an cire sakamakon a cikin wani shafi daban. Gaskiyar ita ce ta hanyar cika alamar alama, an kwafa dabara zuwa ƙananan sel. Amma, yin la'akari da gaskiyar cewa ta hanyar tsoho, duk nassoshi yana da dangi, to, a cikin dabara, da ke motsa ƙasa, adiresoshin sel an canza dangi ne da na farko. Wato, wannan wajibi ne gare mu ga wani yanayi.

Darasi: Yadda ake yin Autocomplete a Excel

Hanyar 4: shafi yanke shawara akan akai

Akwai lokuta lokacin da ya zama dole don raba shafi a lokaci ɗaya - akai, kuma cire adadin rarrabuwa a cikin wani shafi daban.

1. Mun sanya alamar "daidai" a cikin tantanin farko na jimlar shafi. Danna kan sel mai rarrabuwa na wannan zaren. Sanya alamar rarrabuwa. Sannan da hannu tare da keyboard sanya lambar da ake so.



2. Latsa maɓallin Shigar. Sakamakon lissafin don kirtani na farko yana nuna akan mai saka idanu.



3. Don yin lissafin ƙimar dabi'u, kamar yadda a zamanin da ya gabata, kira alamar cika. A daidai wannan hanyar, shimfiɗa shi.

Kamar yadda muke gani, wannan lokacin rarrabuwa ma daidai ne. A wannan yanayin, lokacin kwafa bayanai, alamar maimaitawa yana sake zama dangi. Adireshin rabon na kowane layi ya canza ta atomatik. Amma mai rabawa yana cikin wannan yanayin wani lamba mai daidaitawa, wanda ke nufin cewa dukiyar da ba ta amfani da shi ba. Don haka, mun rarraba abubuwan da abinda ke cikin sel na shafi zuwa akai.

Hanyar 5: yanke shawara yanke shawara akan tantanin halitta

Amma abin da za a yi idan kuna buƙatar raba shafi akan abin da ke cikin sel ɗaya. Bayan duk, bisa ga ka'idar dangantakar da nassoshi, masu daidaitawa kuma za a canza su. Muna buƙatar yin adireshin tantanin halitta tare da wanda ya fifita.

1. Shigar da siginan kwamfuta zuwa mafi girman fayil ɗin don nuna sakamakon. Mun sanya alamar "=". Latsa wurin raba, wanda akwai ƙima mai canzawa. Mun sanya slash (/). Latsa wani tantanin halitta wanda aka sanya wanda ya cancanci dindindin.



2. Don yin tunani game da cikakken mai girma, wato akai, sanya alamar dala ($) a cikin tsari a gaban daidaitawar wannan sel a tsaye da kwance. Yanzu wannan adireshin zai ci gaba da kasancewa lokacin da kwafa alamar cika.



3. Mun danna maballin shigar da don nuna sakamakon lissafin a layin farko akan allon.



4. Yin amfani da mai cika alamar, kwafe dabaru cikin sauran sel na shafi tare da sakamako na gaba daya.

Bayan haka, sakamakon ya shirya don duka shafi. Kamar yadda muke gani, a wannan yanayin, an rarraba shafi a cikin tantanin halitta tare da tsayayyen adireshin.

Darasi: Cikakken da dangantakar dangantakar dangi zuwa Excel

Hanyar 6: Aiki mai zaman kansa

Ana iya yin isarwa a excele a excele ta amfani da aikin musamman da ake kira mai zaman kansa. A peculiarity wannan fasalin shi ne cewa ya rabu, amma ba tare da ragowar ba. Wato, lokacin amfani da wannan hanyar rarraba sakamakon, a koyaushe zai zama lamba. A lokaci guda, ba a yi zagaye na zagaye ba bisa ga ka'idodin ilmin lissafi ba ga dangantakar lissafi mafi kusa, amma ga ƙaramin yanki. Wato, lambar 5.8 aiki zagaye ba har zuwa 6 ba, da 5.

Bari mu ga aikace-aikacen wannan fasalin akan misali.

1. Danna kan sel, inda sakamakon lissafin za a nuna. Latsa maɓallin "Saka Aikin" zuwa hagu na ƙirar formula.



2. Wizard ya buɗe. A cikin jerin ayyukan da zai samar mana, muna neman kashi "masu zaman kansu". Muna haskaka shi kuma latsa maɓallin "Ok".



3. An bude hujja taga. Wannan fasalin yana da hujja guda biyu: maimaitawa da denominator. An gabatar da su cikin filayen tare da sunaye masu dacewa. A cikin "mai ba da kudin baƙi" filin da muke shiga Delimi. A filin "hadari" - mai rarrabawa. Zaka iya shigar da takamaiman lambobi da adiresoshin sel wanda ake samun bayanan. Bayan an shigar da dabi'un da aka shigar, danna maɓallin "Ok".

Bayan waɗannan ayyukan, fasalin sirri yana sanya sarrafa bayanai kuma yana ba da amsa ga tantanin halitta, wanda aka nuna a farkon matakin wannan hanyar.

Hakanan za'a iya shigar da wannan fasalin da hannu ba tare da amfani da maye ba. Syntax ta yi kama da wannan:

= Masu zaman kansu (lambobi; denominator)

Darasi: Ayyukan Wizard a Excel

Kamar yadda muke gani, babbar hanyar rarraba a cikin shirin ofishin Microsoft shine amfani da dabaru. Alamar raguwa a cikinsu shine slash - "/". A lokaci guda, don wasu dalilai, yana yiwuwa a yi amfani da wani aiki na sirri a cikin rabo. Amma, ya zama dole don yin la'akari da cewa lokacin da ake lissafta ta wannan hanyar, ana samun bambanci ba tare da ragowar ba, lamba. A lokaci guda, ba a yi zagaye na gaba ɗaya ta hanyar daidaitattun ka'idodi, amma zuwa ƙaramin module a cikin lamba.