Nuna kashi a cikin Excel

A cikin wannan ƙaramin darasi za ku sami bayanai masu amfani da yawa game da su tsarin kashi a cikin Excel. Za ku koyi yadda ake canza tsarin bayanan data kasance zuwa kashi, yadda ake saita nunin kashi a cikin tantanin halitta, da kuma yadda ake canza lambobi kai tsaye zuwa kashi idan an shigar da su da hannu.

A cikin Microsoft Excel, nuna ƙima a matsayin kashi yana da sauƙi. Don yin wannan, zaɓi ɗaya ko fiye sel kuma danna maɓallin Salon Kashi (tsarin kashi) a cikin sashin Number (Lambar) shafuka Gida (Gida):

Kuna iya yin shi har ma da sauri ta latsa gajeriyar hanyar madannai Ctrl+Shift+%. Excel zai tunatar da ku wannan haɗin duk lokacin da kuka yi shawagi akan maɓallin. Salon Kashi (tsarin kashi).

Haka ne, Tsarin Kashi a cikin Excel ana iya saitawa a dannawa ɗaya. Amma sakamakon zai zama daban-daban dangane da ko kuna amfani da tsarawa zuwa ƙimar data kasance ko sel mara komai.

• Tsara ƙimar data kasance a matsayin kaso
• Aiwatar da tsarin kashi zuwa komai cikin sel
• Nuna lambobi azaman kashi nan da nan yayin da kuke bugawa
• Dabaru lokacin nuna kaso a cikin Excel

Tsara ƙimar data kasance a matsayin kaso

Lokacin da kake nema Tsarin Kashi Don sel waɗanda suka riga sun ƙunshi ƙimar lambobi, Excel yana ninka waɗannan ƙimar da 100 kuma yana ƙara alamar kashi (%) a ƙarshe. Daga ra'ayi na Excel, wannan daidai ne, tunda 1% shine ainihin ɗari.

Koyaya, wani lokacin wannan yana haifar da sakamakon da ba a zata ba. Misali, idan cell A1 ya ƙunshi lamba 20 kuma kun yi amfani da wannan tantanin halitta Tsarin Kashi, to a sakamakon haka za ku sami 2000%, kuma ba 20% kamar yadda kuke so ba.

Yadda ake hana kuskuren:

• Idan tantanin halitta a cikin tebur ɗinku ya ƙunshi lambobi a tsarin lamba, kuma kuna buƙatar juya su zuwa kashi, da farko raba waɗannan lambobin da 100. Misali, idan an rubuta bayanan farko a shafi na A, zaku iya shigar da dabarar a cikin cell B2 = A2/100 sannan a kwafe shi zuwa ga dukkan sel da ake bukata na shafi na B. Na gaba, zaži dukan shafi na B kuma yi amfani da shi Tsarin Kashi. Sakamakon yakamata ya kasance kamar haka:Sannan zaku iya maye gurbin dabarar a shafi na B tare da dabi'u, sannan ku kwafa su zuwa shafi A sannan ku share shafi na B idan baku buƙatarsa.
• Idan kawai kuna buƙatar canza wasu dabi'u zuwa tsarin kashi, zaku iya shigar da su da hannu ta hanyar raba lambar ta 100 kuma rubuta ta azaman ƙima. Misali, don samun darajar 28% a cikin tantanin halitta A2 (duba adadi na sama), shigar da lamba 0.28, sannan a shafa masa. Tsarin Kashi.

Aiwatar da tsarin kashi zuwa komai cikin sel

Mun ga yadda nunin bayanan da aka rigaya a cikin maƙunsar bayanan Microsoft Excel ke canzawa lokacin da kuka canza tsarin lamba mai sauƙi zuwa kashi. Amma me zai faru idan ka fara amfani da kwayar halitta Tsarin Kashi, sannan ka shigar da lamba a ciki da hannu? Wannan shine inda Excel zai iya zama daban.

• Duk wani lamba daidai ko sama da 1 za a rubuta shi da alamar % kawai. Misali, za a rubuta lamba 2 a matsayin 2%; 20 - kamar 20%; 2,1 - kamar 2,1% da sauransu.
• Lambobin da ba su wuce 1 da aka rubuta ba tare da 0 zuwa hagu na maki goma ba za a ninka su da 100. Misali, idan ka buga ,2 a cikin tantanin halitta tare da tsarin kashi, za ku ga darajar 20% a sakamakon haka. Duk da haka, idan ka buga a kan keyboard 0,2 a cikin tantanin halitta ɗaya, za a rubuta ƙimar a matsayin 0,2%.

Nuna lambobi azaman kashi nan da nan yayin da kuke bugawa

Idan ka shigar da lamba 20% (tare da alamar kashi) cikin tantanin halitta, Excel zai fahimci cewa kana son rubuta darajar a matsayin kashi kuma ta atomatik canza tsarin tantanin halitta.

Muhimmiyar sanarwa!

Lokacin amfani da tsarin kashi a cikin Excel, da fatan za a tuna cewa wannan ba kome ba ne illa wakilcin gani na ainihin ƙimar lissafin da aka adana a cikin tantanin halitta. A haƙiƙa, ƙimar kashi koyaushe ana adana shi azaman ƙima.

A wasu kalmomi, 20% an adana shi azaman 0,2; An adana 2% azaman 0,02 da sauransu. Lokacin da ake ƙididdige ƙididdiga daban-daban, Excel yana amfani da waɗannan ƙimar, watau juzu'i na goma. Rike wannan a zuciyarsa lokacin da za a ƙirƙira ƙididdiga waɗanda ke nufin sel tare da kaso.

Don ganin ainihin kimar da ke ƙunshe a cikin tantanin halitta mai Tsarin Kashi:

1. Danna-dama akan shi kuma daga menu na mahallin zaɓi Tsarin Sel ko danna hade Ctrl + 1.
2. A cikin akwatin maganganu da ya bayyana Tsarin Sel (Tsarin Cell) kalli wurin samfurin (Sample) tab Number (Lambar) a rukuni Janar (Gabaɗaya).

Dabaru lokacin nuna kaso a cikin Excel

Da alama ƙididdigewa da nuna bayanai a matsayin kashi ɗaya ne daga cikin ayyuka mafi sauƙi da muke yi tare da Excel. Amma ƙwararrun masu amfani sun san cewa wannan aikin ba koyaushe ba ne mai sauƙi.

1. Saita nuni zuwa adadin da ake so na wuraren goma

A lokacin da Tsarin Kashi An yi amfani da lambobi, Excel 2010 da 2013 suna nuna ƙimar su a zagaye gabaɗaya, kuma a wasu lokuta wannan na iya zama yaudara. Misali, saita tsarin kashi zuwa tantanin halitta mara komai kuma shigar da ƙimar 0,2% a cikin tantanin halitta. Me ya faru? Ina ganin 0% a cikin tebur na, kodayake na san tabbas ya kamata ya zama 0,2%.

Don ganin ƙimar gaske kuma ba ƙimar zagaye ba, kuna buƙatar ƙara adadin wuraren goma da ya kamata Excel ya nuna. Don wannan:

1. Bude akwatin maganganu Tsarin Sel (tsara Kwayoyin) ta amfani da menu na mahallin, ko danna haɗin maɓalli Ctrl + 1.
2. Zaži category kashi (Kashi Kashi) kuma saita adadin wuraren goma da aka nuna a cikin tantanin halitta yadda kuke so.
3. Lokacin da komai ya shirya, danna OKdon canje-canje don ɗaukar tasiri.

2. Haskaka Dabaru mara kyau tare da Tsara

Idan kuna son a nuna munanan dabi'u daban-daban, kamar a cikin jajayen rubutu, zaku iya saita tsarin lambar al'ada. Sake buɗe maganganun Tsarin Sel (tsara Kwayoyin) kuma je zuwa shafin Number (Lambar). Zaɓi nau'i Custom (Duk Formats) kuma shiga cikin filin type daya daga cikin wadannan layukan:

• 00%; [Red] -0.00% or 00%; [Ja] -0,00% - nuna ma'auni mara kyau a cikin ja kuma ya nuna wurare 2 na ƙima.
• 0%; [Ja] -0% or 0%; [Krabarci] -0% - nuna ma'auni mara kyau a cikin ja kuma kar a nuna ƙimar bayan ma'aunin ƙima.

Kuna iya ƙarin koyo game da wannan hanyar tsarawa a cikin ma'anar Microsoft, a cikin maudu'in nuna lambobi a tsarin kashi.

3. Tsara Ƙimar Kashi Mara Kyau a cikin Excel tare da Tsarin Yanayi

Idan aka kwatanta da hanyar da ta gabata, tsara yanayin yanayi a cikin Excel hanya ce mafi sassauƙa wacce ke ba ka damar saita kowane tsari don tantanin halitta mai ɗauke da ƙima mara kyau.

Hanya mafi sauƙi don ƙirƙirar ƙa'idar tsara sharadi shine zuwa menu Tsarin sharaɗi > Haskaka dokokin sel > Kasa da (Tsarin Yanayi> Dokokin Zaɓin salula> Kasa da…) kuma shigar da 0 a cikin filin. Tsara Kwayoyin da ba su da ƙasa (Hanyar sel waɗanda ba su da ƙasa)

Na gaba, a cikin jerin abubuwan da aka saukar, zaku iya zaɓar ɗaya daga cikin daidaitattun zaɓuɓɓukan da aka tsara ko danna Tsarin Al'ada (Tsarin Musamman) a ƙarshen wannan jeri kuma tsara duk bayanan tsarin tantanin halitta yadda kuke so.

Anan akwai wasu zaɓuɓɓuka don aiki da su Tsarin kashi data bude Excel. Ina fatan ilimin da aka samu daga wannan darasi zai cece ku daga ciwon kai mara amfani nan gaba. A cikin kasidu masu zuwa, za mu zurfafa zurfafa cikin batun kashi a cikin Excel. Za ku koyi hanyoyin da za ku iya amfani da su don ƙididdige sha'awa a cikin Excel, koyon dabarun ƙididdige canjin kashi, kashi na jimla, sha'awa mai yawa, da ƙari.

Kasance cikin saurare da farin ciki karatu!