Yadda ake saka decimals a cikin Excel? A cikin wannan koyawa za mu bar muku duk matakai da sauran bayanai.
Tabbas, a yanzu dole ne ku sani cewa Excel yana ɗaya daga cikin kayan aikin da suka fi nasara a duniya don tsarawa, rarrabawa da ƙirƙirar maƙunsar bayanai, ba wai kawai saboda yana da ayyuka masu ban mamaki ba. Amma saboda a ciki, za mu iya aiwatar da kowane nau'i na aiki da ayyuka, ba tare da buƙatar zama ƙwararrun ƙwararrun ƙwararru ba.
Har ila yau, ya kamata ku sani cewa a cikin wannan shirin za mu iya yin ayyuka na decimal, wanda ke da matukar amfani ga fannin lissafin kudi da gudanarwa, ko na aiki, kasuwanci ko kuma kawai a matsayin aikin jami'a. A cikin Excel za mu iya sanya decimals, Ba tare da ƙoƙari sosai ba.
Yanzu, idan kawai kun sami kanku kun san da kuma koyo game da fa'idodin ban mamaki na Excel, ban da duk ayyukan da ke cikinsa, to za mu sauƙaƙe muku aikin. koya muku yadda ake saka decimals a cikin Excel, kamar kai kwararre ne.
Hanyoyi don sanya decimals a cikin Excel
A cikin wannan dole ne mu gaya muku, cewa akwai hanyoyi daban-daban, waɗanda za mu iya ƙara lambobi goma zuwa takardar Excel, waɗannan hanyoyin guda ɗaya, muna dalla-dalla da su tare da mataki-mataki. Wadanda su ne kamar haka:
Shigar da dabarar a cikin ginshiƙi mai dacewa
Wannan ita ce hanya ta farko, wadda za mu koya muku yadda za ku iya shigar da decimals a cikin takardar Excel, Domin wannan dole ne ku bi umarnin da muka bar muku a yanzu. Ga su kamar haka:
- A matsayin mataki na farko, kuna buƙatar buɗe maƙunsar bayanai na Excel.
- Sannan dole ne ka shigar da ƙimar lambobi masu zagaye, kowanne ɗaya a cikin tantanin halitta ɗaya. A matsayin shawarwarin, yana da kyau a shigar da lambobi, duk a cikin ginshiƙi ɗaya, wanda zai sauƙaƙa hanyar aiwatarwa.
- A cikin ginshiƙi na biyu, dole ne ka ƙara dabara mai zuwa "= zagaye (A1,N)". A lokacin, dole ne ka maye gurbin "N" a cikin dabara tare da lambar decimal, wanda kake son ƙarawa.
- Don ginshiƙai masu zuwa, ba zai zama dole a sake rubuta dabarar ba, tunda kuna iya ja da jefa ta cikin sel masu zuwa, har zuwa na ƙarshe da kuke son amfani da su. Hakanan zaka iya amfani da zaɓin kwafi da liƙa, lokacin da suke cikin shafi ɗaya.
- Misali: "= Zagaye (A1,8)"
Shi ke nan! Ta haka za ku koya Hanyar farko don sanya ƙima a cikin excel.
Sanya ƙima a cikin Excel ba tare da dabara ba
Wannan shi ne Wata hanyar da aka sani shigar da decimals a cikin Excel, a gefe guda, wannan baya buƙatar ƙididdiga don samun damar yin aiki kuma don wannan, mun kuma bar muku cikakken jerin matakai, wanda shine kamar haka:
- Da farko shigar da ƙimar lamba goma da kuke so, a kowace tantanin halitta.
- Sannan dole ne ku zaɓi ɗaya ko duka.
- Na gaba dole ne ku nemo kanku a cikin shafin "farawa".
- Sannan, dole ne ka yi amfani da maɓallan don "rage ko ƙara" adadin da aka zaɓa ta lambobi ɗaya. Ta haka zai kasance a shirye.
Hakanan, kuna iya samun sanya adadi a cikin Excel ba tare da amfani da dabara ba.
Sanya decimals a cikin Excel ta amfani da aikin Truncate, don ƙima ba tare da zagaye ba
Dole ne mu furta cewa hanyoyin da suka gabata sun dogara ne akan tsarin gaba ɗaya kawai, wanda ke ba mu damar ƙarawa ko rage adadin, dangane da ko decimal ɗinsa yana sama ko ƙasa da 5.
A cikin wannan hanyar, sauran lambobin ƙima za a cire su ta atomatik, ba tare da la'akari da zagaye na simmetric ba, don wannan muna da matakai masu zuwa:
- A cikin tantanin halitta mara komai, dole ne mu rubuta dabara mai zuwa: “= TRUNCAR(A1; N)” muna zaton akwatin A! shine inda lambar decimal take kuma "N" shine adadin lambobi da muke son gani a cikin maƙunsar bayanai.
- Sai kawai mu danna maɓallin "enter" sannan mu gama.
Shi ke nan, sai muka samu wani yadda ake saka decimals a cikin Excel.
Zagaye decimals a cikin Excel. (Mahimman abubuwan da za a yi la'akari da su)
Ya kamata ku sani cewa sanya decimals a cikin Excel, Ba ya zama aiki mai wahala ko wahala, yanzu don zagaye waɗannan ƙididdiga, zaku iya amfani da duk hanyoyin da muka bar muku a baya. Irin waɗannan za ku iya amfani da su, idan ƙarancin ƙima ba shi da matsala a gare ku.
Har ila yau, ya kamata ku sani cewa ayyuka zuwa zagaye na decimal a cikin Excel galibi suna ƙarƙashin wata ƙa'ida ce, inda aka gaya mana cewa idan lambobi na ƙarshe na lambar decimal ya fi 5, lambar tana ƙaruwa. a 1. A daya hannun. hannu, idan wannan lamba ta ƙare a cikin adadi mai ƙima da ƙimar ƙasa da 5, to, lambar tushe ta kasance, tare da ƙimarta na yanzu.
Sauran aikace-aikacen da ke ba mu damar yin ayyuka tare da ƙima
A cikin yanayin ban mamaki cewa Wataƙila Excel ba shine shirin da kuke nema da gaske ba don aiwatar da ayyukan lissafin ku tare da ƙima, Mun bar muku wasu hanyoyin, waɗanda zaku iya amfani da su a halin yanzu, don samun damar sanya ƙima. Wadannan su ne:
1. Alama
Wannan kalkuleta ce ta kan layi, inda zamu iya aiwatar da kowane nau'in ayyukan algebra, daga mafi sauƙi zuwa mafi rikitarwa.
Ana iya amfani da wannan kalkuleta lokacin shiga dandalin yanar gizon sa https://es.symbolab.com/solver/decimals-calculator, Yana da gaba ɗaya kyauta kuma zaka iya samun abubuwa masu ban mamaki da yawa.
Baya ga kasancewa mai fa'ida sosai, lokacin yin kowane ƙari, ragi, ninkawa ko rarrabuwar ƙima, ba tare da buƙatar rubutawa ko adana bayanai ba, don wani abu na ɗan lokaci.
2. DivPad: Mataki na Lissafi
Wannan, a nasa bangaren, manhaja ce da ake da ita na manhajar Android, inda za ka iya aiwatar da kowane nau’in ayyukan lissafi, ciki har da ayyukan decimal, cikin mintuna kadan.
Idan kuna son yin lissafi ko samun asusu, daidai da sauri, wannan aikace-aikacen hannu shine wanda yakamata kuyi amfani da shi.
3. Ƙididdigar rarraba (tare da saura ko ƙima)
Wannan kuma, a gefe guda, aikace-aikace ne na tsarin aiki na Android, wanda ke da cikakken kyauta kuma yana da mu'amala, tare da keɓantacce kawai wanda ya fi mayar da hankali a fili kan warware ayyuka tare da ƙima.
Don haka idan koyaushe kuna lissafta ta amfani da ƙididdiga, wannan aikace-aikacen shine wanda yakamata ku zaɓa.