Excel, ta amfani da kayan aiki kamar tsari, yana baka damar gudanar da ayyuka daban-daban ilmin lissafi tsakanin bayanai a sel. Har ila yau, ragewa ya shafi irin waɗannan ayyukan. Bari muyi zurfin bincike kan hanyoyin da za'a iya yin wannan lissafin a cikin Excel.
Aikace-aikacen Rage
Za a iya amfani da raguwa a cikin Excel a duka takamaiman lambobi da adreshin sel waɗanda bayanan ke ciki. Ana yin wannan aikin godiya ga tsari na musamman. Kamar yadda yake cikin sauran ƙididdigar lissafin lissafi a cikin wannan shirin, kafin ƙaramin nassin, kuna buƙatar saita alamar daidai (=). Sannan a cikin jerin ana ragewa (a cikin lamba ko adireshin salula), alamar debewa (-), na farko wanda aka cire (a cikin lamba ko adireshin), kuma a wasu halaye masu biyo baya.
Bari mu bincika takamaiman misalai na yadda aka aiwatar da wannan aikin ilimin lissafi a cikin Excel.
Hanyar 1: Maimaita lambobi
Misali mafi sauki shine ragewar lambobi. A wannan yanayin, ana aiwatar da dukkan ayyuka tsakanin takamaiman lambobi, kamar yadda a cikin ƙididdigar al'ada, kuma ba tsakanin sel ba.
- Zaɓi kowane tantanin halitta ko sanya siginan kwamfuta a cikin masarar dabara. Mun sanya alama daidai. Muna buga aikin ilmin lissafi tare da raguwa, kamar dai yadda muke yi akan takarda. Misali, rubuta wannan dabarar:
=895-45-69 - Don aiwatar da lissafin aikin, danna maballin Shigar a kan keyboard.
Bayan an aiwatar da waɗannan ayyuka, ana nuna sakamakon a cikin tantanin da aka zaɓa. A cikin batunmu, wannan shine 781. Idan kun yi amfani da wasu bayanan don ƙididdigewa, to, daidai da haka, zaku sami sakamako na daban.
Hanyar 2: cire lambobi daga sel
Amma, kamar yadda ka sani, Excel shine, da farko, shiri don aiki tare da tebur. Sabili da haka, aiki tare da sel suna da mahimmanci a ciki. Musamman, za'a iya amfani dasu don raguwa.
- Zaɓi tantanin da keɓaɓɓe ƙa'idar tsari zai kasance. Mun sanya alama "=". Danna wayar da ke dauke da bayanan. Kamar yadda kake gani, bayan wannan matakin, an shigar da adireshin sa a cikin masarar dabara kuma an ƙara shi bayan alamar daidai. Mun buga lambar da za'a rage.
- Kamar yadda ya gabata, domin samun sakamakon lissafin, danna maɓallin Shigar.
Hanyar 3: cire wani sel daga sel
Kuna iya yin ayyukan cirewa ba tare da wani lamuni ba kwata-kwata, tana amfani da adreshin sel kawai. Ka'idar aiki iri daya ce.
- Muna zaɓar tantanin don nuna sakamakon ƙididdigar kuma sanya alama a ciki daidai. Danna wayar da ke dauke da ragewa. Mun sanya alama "-". Danna wayar da ke dauke da rage. Idan ana buƙatar aiwatar da aikin tare da wasu kudade masu yawa, to muma mun sanya alama debewa kuma aiwatar da ayyukan a daidai wannan hanyar.
- Bayan an shigar da dukkan bayanan, don nuna sakamakon, danna maɓallin Shigar.
Darasi: Aiki tare da dabaru a Excel
Hanyar 4: taro don sarrafa rage aiki
Sau da yawa sau ɗaya, lokacin aiki tare da Excel, yana faruwa cewa kuna buƙatar yin lissafin ƙirar ƙananan sassan sel zuwa wani shafi sel. Tabbas, zaku iya rubuta sabon tsari ga kowane mataki da hannu, amma wannan zai dauki lokaci mai mahimmanci. An yi sa'a, aikin aikace-aikacen yana da ikon yin aiki da irin wannan ƙididdigar sosai, godiya ga aikin aikin kammala aikin.
Misali, muna kirga ribar kamfanin a bangarori daban-daban, da sanin jimlar kudaden shiga da farashin samarwa. Don yin wannan, daga kudaden shiga kana buƙatar ɗaukar farashi.
- Zaɓi babban sel don ƙididdigar riba. Mun sanya alama "=". Danna wayar da ke dauke da girman kudaden shiga a jere guda. Mun sanya alama "-". Zaɓi tantanin tare da farashin.
- Domin nuna sakamakon ribar wannan layin akan allo, danna maballin Shigar.
- Yanzu muna buƙatar kwafa wannan dabara zuwa ƙananan kewayon don yin lissafin da yakamata a wurin. Don yin wannan, sanya siginan kwamfuta a cikin ƙananan gefen dama na tantanin da ke ɗauke da tsari. Alamar cike take bayyana. Mun danna maɓallin linzamin kwamfuta na hagu kuma a cikin madaukai mun ja siginar ƙasa zuwa ƙarshen teburin.
- Kamar yadda kake gani, bayan waɗannan ayyuka, an kwafa dabarar zuwa duka zangon da ke ƙasa. A lokaci guda, saboda irin wannan dukiya kamar adireshin aiki, wannan kwafin ya faru tare da naƙasa, wanda ya sanya ya yiwu ƙididdige ƙididdigewa a cikin sel kusa.
Darasi: Yadda ake yin autocomplete a Excel
Hanyar 5: raguwar bayanai na sel guda daga kewayon
Amma wani lokacin kuna buƙatar yin kawai akasin haka, wato, don adireshin bai canza ba yayin kwafa, amma ya kasance koyaushe, yana nufin takamaiman sel. Yaya ake yin wannan?
- Mun shiga cikin sel na farko don nuna sakamakon ƙididdigar kewayon. Mun sanya alama daidai. Mun danna kan tantanin da ke ciki raguwa. Saita alamar debewa. Mun danna danna kan sel mai cirewa, adireshin wanda bai kamata a canza shi ba.
- Yanzu kuma mun juya zuwa mafi mahimmancin ra'ayi tsakanin wannan hanyar da wacce ta gabata. Mataki ne na gaba wanda zai baka damar canza hanyar haɗi daga dangi zuwa cikakke. Mun sanya alamar dollar a gaban daidaitawa da a kwance na tantanin halitta wanda adireshin sa bai kamata ya canza ba.
- Mun danna kan maballin keyboard Shigar, wanda zai baka damar nuna lissafin wannan layin akan allo.
- Don yin ƙididdigar lissafi akan sauran layin, daidai kamar yadda a cikin misalin da ya gabata, kira alamar alamar sai a ja ƙasa.
- Kamar yadda kake gani, an zartar da tsarin ragewar kamar yadda muke bukata. Wato, lokacin hawa ƙasa, adiresoshin bayanan da aka rage sun canza, amma an rage raguwa ba.
Misalin da ke sama shine kawai yanayi na musamman. Haka zalika, ana iya yinshi ta wata hanyar don haka mai cirewa ya kasance kullun kuma ana cirewa shine dangi da canje-canje.
Darasi: Cikakkar kuma haɗin dangi a cikin Excel
Kamar yadda kake gani, babu wani abu mai rikitarwa ga kwarewar rage ragamar cikin Excel. Ana yin shi gwargwadon dokoki guda kamar sauran lissafin ilimin lissafi a cikin wannan aikace-aikacen. Sanin wasu abubuwa masu ban sha'awa zasu bawa mai amfani damar aiwatar da bayanai masu yawa ta hanyar wannan ilimin lissafi, wanda zai iya adana lokacinsa.
