Contents
Ƙayyade yawan adadin aiki ne gama gari wanda mai amfani da Ecxel wanda ke aiki da lambobi zai fuskanta. Irin waɗannan ƙididdiga suna da mahimmanci don yin ayyuka da yawa: ƙayyade girman rangwame, alamar, haraji, da sauransu. A yau za mu koyi dalla-dalla abin da za mu yi don ninka lamba da kashi ɗaya.
Yadda ake ninka lamba da kashi a cikin Excel
Menene kashi? Wannan juzu'i ne na 100. Saboda haka, ana iya fassara alamar kashi cikin sauƙi zuwa ƙimar juzu'i. Misali, kashi 10 cikin dari yayi daidai da lamba 0,1. Saboda haka, idan muka ninka 20 ta 10% da 0,1, za mu ƙare tare da lamba ɗaya - 2, tun da yake daidai da goma na lambar 20. Akwai hanyoyi da yawa don ƙididdige kashi a cikin maƙunsar bayanai.
Yadda ake lissafin kashi da hannu a cikin tantanin halitta ɗaya
Wannan hanya ita ce mafi sauƙi. Ya isa kawai a ƙayyade adadin takamaiman lamba ta amfani da daidaitaccen tsari. Zaɓi kowane tantanin halitta, kuma rubuta dabarar: lambar uXNUMXd * adadin kashi. Wannan dabara ce ta duniya. Yadda yake kallon a aikace yana da sauƙin gani a wannan hoton.
Mun ga cewa mun yi amfani da dabara =20*10%. Wato, ana rubuta tsarin lissafin a cikin ma'auni daidai da yadda na'urar lissafi ta al'ada. Shi ya sa wannan hanya tana da sauƙin koya. Bayan mun shigar da dabarar da hannu, zai rage don danna maɓallin shigar, kuma sakamakon zai bayyana a cikin tantanin halitta inda muka rubuta shi.
Kar a manta cewa an rubuta kashi biyu tare da alamar % kuma azaman juzu'i na goma. Babu wani babban bambanci tsakanin waɗannan hanyoyin yin rikodi, tunda wannan ƙimar ɗaya ce.
Ƙara lamba a cikin tantanin halitta ɗaya da kashi ɗaya cikin wani tantanin halitta
Hanyar da ta gabata tana da sauƙin koya, amma tana da koma baya ɗaya - ba ma amfani da ƙimar daga tantanin halitta azaman lambar. Don haka, bari mu ga yadda zaku iya samun bayanan kashi daga tantanin halitta. Makanikai gabaɗaya iri ɗaya ne, amma ƙarin aiki ɗaya yana buƙatar ƙarawa. Don yin wannan, bi matakan da aka bayyana a cikin wannan jagorar:
- A ce muna buƙatar gano girman girman alawus ɗin kuma mu nuna shi a shafi na E. Don yin wannan, zaɓi tantanin halitta na farko kuma rubuta wannan dabarar a ciki kamar yadda yake a cikin fom ɗin da ta gabata, amma maimakon lambobi, saka adiresoshin cell. Hakanan zaka iya yin aiki a cikin jeri mai zuwa: da farko ka rubuta alamar shigarwar dabara =, sannan danna kan tantanin halitta ta farko wacce muke son samun bayanai daga gare ta, sannan ka rubuta alamar multiplication * sannan ka danna tantanin halitta na biyu. Bayan shigar, tabbatar da dabarun ta latsa maɓallin "ENTER".
- A cikin tantanin halitta da ake buƙata, muna ganin jimlar ƙimar.
Don yin lissafin atomatik na duk wasu ƙididdiga, kuna buƙatar amfani da alamar cikawa ta atomatik.
Don yin wannan, matsar da siginan kwamfuta zuwa ƙananan kusurwar hagu kuma ja zuwa ƙarshen ginshiƙin tebur. Za a yi amfani da bayanan da ake buƙata ta atomatik.
Wataƙila akwai wani yanayi. Misali, muna buƙatar sanin adadin kashi ɗaya bisa huɗu na ƙimar da ke cikin wani shafi zai kasance. Sannan kuna buƙatar yin daidai daidai da misalin da ya gabata, kawai rubuta 25% azaman ƙimar ta biyu maimakon adireshin tantanin halitta mai ɗauke da wannan juzu'in lambar. To, ko raba ta 4. Makanikai na ayyuka iri ɗaya ne a wannan yanayin. Bayan danna maɓallin Shigar, muna samun sakamako na ƙarshe.
Wannan misalin ya nuna yadda muka tantance adadin lahani bisa ga gaskiyar cewa kusan kashi ɗaya bisa huɗu na duk kekunan da ake samarwa suna da lahani. Akwai wata hanya kuma yadda yake ƙididdige ƙima a matsayin kashi. Don nunawa, bari mu nuna matsala mai zuwa: akwai shafi C. Lambobi suna cikinsa. Wani muhimmin bayani - ana nuna kashi a cikin F2 kawai. Saboda haka, lokacin canja wurin dabarar, bai kamata ya canza ba. Me za a yi a wannan yanayin?
Gabaɗaya, kuna buƙatar bin jerin ayyuka iri ɗaya kamar na al'amuran da suka gabata. Da farko kana buƙatar zaɓar D2, sanya alamar = kuma rubuta dabarar ninka tantanin halitta C2 ta F2. Amma tunda muna da ƙimar kashi ɗaya kawai, muna buƙatar gyara ta. Don wannan, ana amfani da cikakken nau'in adireshin. Ba ya canzawa lokacin yin kwafin tantanin halitta daga wuri ɗaya zuwa wani.
Don canza nau'in adireshin zuwa cikakke, kuna buƙatar danna ƙimar F2 a cikin layin shigar da dabara kuma danna maɓallin F4. Bayan haka, za a ƙara alamar $ zuwa harafin da lamba, wanda ke nufin cewa adireshin ya canza daga dangi zuwa cikakke. Tsarin ƙarshe zai yi kama da haka: $F$2 (maimakon latsa F4, zaku iya ƙara alamar $ zuwa adireshin da kanku).
Bayan haka, kuna buƙatar tabbatar da canje-canje ta latsa maɓallin "ENTER". Bayan haka, sakamakon zai bayyana a cikin tantanin halitta na farko na ginshiƙi wanda ke kwatanta adadin aure.
Yanzu an canza dabarar zuwa duk sauran sel, amma cikakken bayanin ya kasance baya canzawa.
Zaɓin yadda ake nuna kashi a cikin tantanin halitta
An tattauna a baya cewa kashi yana zuwa cikin nau'i na asali guda biyu: azaman juzu'in juzu'i ko a cikin sigar % na al'ada. Excel yana ba ku damar zaɓar wanda kuke so mafi kyau a cikin wani yanayi. Don yin wannan, kuna buƙatar danna-dama akan tantanin halitta mai ƙunshe da juzu'in lambar, sannan canza tsarin tantanin halitta ta zaɓi abin da ya dace a cikin menu na mahallin.
Na gaba, taga zai bayyana tare da shafuka da yawa. Muna sha'awar farkon wanda aka sanya hannu a matsayin "Lambar". A can kuna buƙatar nemo tsarin kaso a jeri na hagu. Ana nuna mai amfani a gaba yadda tantanin halitta zai kasance bayan an shafa shi. A cikin filin da ke hannun dama, Hakanan zaka iya zaɓar adadin wuraren goma da aka ba da izini lokacin nuna wannan lambar.
Idan kana son nuna juzu'in lamba a matsayin juzu'i na goma, dole ne ka zaɓi tsarin lamba. Za a raba kashi ta atomatik da 100 don yin juzu'i. Misali, tantanin halitta mai ƙunshe da ƙimar 15% za a canza ta kai tsaye zuwa 0,15.
A kowane hali, don tabbatar da ayyukanku bayan shigar da bayanai a cikin taga, kuna buƙatar danna maɓallin Ok. Mun ga cewa babu wani abu mai rikitarwa wajen ninka lamba da kashi daya. Sa'a.