Zamkatimu
Mu phunziro laling'onoli mupeza zambiri zothandiza mtundu wamaperesenti mu Excel. Muphunzira momwe mungasinthire mawonekedwe a data yomwe ilipo Peresenti, momwe mungakhazikitsire chiwonetsero cha maperesenti mu cell, komanso momwe mungasinthire manambala kukhala maperesenti mukalowa pamanja.
Mu Microsoft Excel, kuwonetsa mitengo ngati maperesenti ndikosavuta. Kuti muchite izi, sankhani selo limodzi kapena angapo ndikudina batani Percent Style (maperesenti amtundu) mu gawoli Number (Nambala) tabu Kunyumba (Kunyumba):
Mutha kuchita izi mwachangu kwambiri podina njira yachidule ya kiyibodi Ctrl+Shift+%. Excel imakukumbutsani zophatikizirazi nthawi iliyonse mukadumphira pa batani. Percent Style (chiwerengero cha mtundu).
Inde, Percent Format mu Excel ikhoza kukhazikitsidwa ndikudina kamodzi. Koma zotsatira zake zidzakhala zosiyana kwambiri kutengera ngati mukugwiritsa ntchito masanjidwe kuzinthu zomwe zilipo kapena ma cell opanda kanthu.
Sinthani zikhalidwe zomwe zilipo ngati maperesenti
Mukafunsira Percent Format Kwa ma cell omwe ali ndi manambala kale, Excel imachulukitsa ziwerengerozo ndi 100 ndikuwonjezera chizindikiro (%) kumapeto. Kuchokera pakuwona kwa Excel, izi ndizolondola, popeza 1% kwenikweni ndi zana limodzi.
Komabe, nthawi zina izi zimabweretsa zotsatira zosayembekezereka. Mwachitsanzo, ngati selo A1 ili ndi nambala 20 ndipo mumayika pa selo iyi Percent Format, ndiye zotsatira zake mudzapeza 2000%, osati 20% monga momwe mumafunira.
Momwe mungapewere cholakwikacho:
- Ngati selo lomwe lili patebulo lanu lili ndi manambala amtundu wanthawi zonse, ndipo muyenera kuwasandutsa Peresenti, choyamba gawani manambalawa ndi 100. Mwachitsanzo, ngati deta yanu yoyambirira yalembedwa mugawo A, mukhoza kulemba fomula mu selo B2. =A2/100 ndi kukopera ku maselo onse ofunikira a gawo B. Kenako, sankhani ndime yonse B ndikuyikapo Percent Format. Chotsatiracho chiyenera kukhala chonchi:
Mutha kusinthanso ma fomu omwe ali mugawo B ndi zikhalidwe, kenako ndikuzikopera ku gawo A ndikuchotsa gawo B ngati simukufunanso. - Ngati mungofunika kusintha zina mwazinthu kukhala mawonekedwe amtundu, mutha kuziyika pamanja pogawa nambala ndi 100 ndikulemba ngati decimal. Mwachitsanzo, kuti mupeze mtengo wa 28% mu cell A2 (onani chithunzi pamwambapa), lowetsani nambala 0.28, kenako gwiritsani ntchito Percent Format.
Mutha kusinthanso ma fomu omwe ali mugawo B ndi zikhalidwe, kenako ndikuzikopera ku gawo A ndikuchotsa gawo B ngati simukufunanso.Ikani mawonekedwe amtundu pama cell opanda kanthu
Tawona momwe kuwonetsera kwa data yomwe ilipo kale mu Microsoft Excel spreadsheet imasintha mukasintha manambala osavuta kukhala Peresenti. Koma chimachitika ndi chiyani ngati mutayamba kugwiritsa ntchito selo Percent Format, ndikulowetsamo nambala pamanja? Apa ndipamene Excel imatha kuchita mosiyana.
- Nambala iliyonse yofanana kapena yoposa 1 idzangolembedwa ndi % chizindikiro. Mwachitsanzo, nambala 2 idzalembedwa ngati 2%; 20 - ngati 20%; 2,1 - ngati 2,1% ndi zina zotero.
- Manambala ochepera pa 1 olembedwa popanda 0 kumanzere kwa desimali adzachulukitsa ndi 100. Mwachitsanzo, ngati mulemba ,2 mu cell yokhala ndi masanjidwe amtundu, mudzawona mtengo wa 20% chifukwa chake. Komabe, ngati mulemba pa kiyibodi 0,2 mu selo lomwelo, mtengowo udzalembedwa ngati 0,2%.
Onetsani manambala monga maperesenti nthawi yomweyo mukamalemba
Ngati mulowetsa nambala 20% (ndi chizindikiro cha peresenti) mu selo, Excel idzamvetsetsa kuti mukufuna kulemba mtengowo ngati peresenti ndikusintha mawonekedwe a selo.
Chidziwitso chofunikira!
Mukamagwiritsa ntchito masanjidwe amtundu mu Excel, chonde kumbukirani kuti ichi sichake koma chifaniziro cha masamu enieni osungidwa mu cell. M'malo mwake, mtengo wamtengo wapatali nthawi zonse umasungidwa ngati decimal.
Mwanjira ina, 20% imasungidwa ngati 0,2; 2% imasungidwa ngati 0,02 ndi zina zotero. Ziwerengero zosiyanasiyana zikapangidwa, Excel imagwiritsa ntchito ziwerengerozi, mwachitsanzo, zigawo za decimal. Kumbukirani izi popanga ma formula omwe amalozera ku maselo okhala ndi maperesenti.
Kuti muwone mtengo weniweni womwe uli mu cell yomwe ili nayo Percent Format:
- Dinani kumanja pa izo ndipo sankhani kuchokera ku menyu yankhaniyo Sakani Maselo kapena dinani kuphatikiza Ctrl + 1.
- Mu bokosi la zokambirana lomwe likuwoneka Sakani Maselo (Cell Format) yang'anani derali nyemba (Zitsanzo) tabu Number (Nambala) mu gulu General (General).
Malangizo powonetsa maperesenti mu Excel
Zikuwoneka kuti kuwerengera ndi kuwonetsa deta ngati peresenti ndi imodzi mwa ntchito zosavuta zomwe timachita ndi Excel. Koma ogwiritsa ntchito odziwa bwino amadziwa kuti ntchitoyi si yosavuta nthawi zonse.
1. Khazikitsani zowonetsera ku nambala yomwe mukufuna yamalo a decimal
Liti Percent Format Zogwiritsidwa ntchito ku manambala, Excel 2010 ndi 2013 amawonetsa mtengo wawo mozungulira nambala yonse, ndipo nthawi zina izi zitha kusokeretsa. Mwachitsanzo, ikani mtundu wamtundu ku cell yopanda kanthu ndikulowetsa mtengo wa 0,2% mu cell. Chinachitika ndi chiyani? Ndikuwona 0% patebulo langa, ngakhale ndikudziwa motsimikiza kuti iyenera kukhala 0,2%.
Kuti muwone mtengo weniweni osati mtengo wozungulira, muyenera kuwonjezera kuchuluka kwa malo omwe Excel iyenera kuwonetsa. Za ichi:
- Tsegulani bokosi la zokambirana Sakani Maselo (Maselo a Format) pogwiritsa ntchito menyu yankhani, kapena kanikizani makiyiwo Ctrl + 1.
- Sankhani gulu Peresenti (Percentage) ndikukhazikitsa kuchuluka kwa malo omwe akuwonetsedwa mu cell momwe mungafunire.
- Zonse zikakonzeka, dinani OKchifukwa kusinthaku kumachitika.
2. Onetsani Makhalidwe Oipa ndi Mapangidwe
Ngati mukufuna kuti zinthu zoipa ziziwonetsedwa mosiyana, monga font yofiyira, mutha kukhazikitsa mtundu wa manambala. Tsegulaninso zokambirana Sakani Maselo (Maselo a Format) ndikupita ku tabu Number (Nambala). Sankhani gulu mwambo (Onse Formats) ndi kulowa m'munda mtundu umodzi mwa mizere iyi:
- 00%; [Red] -0.00% or 00%;[Chofiira]-0,00% - onetsani maperesenti olakwika ofiira ndikuwonetsa malo awiri a decimal.
- 0%;[Chofiira]-0% or 0% pa; [Krakugona]-0% - wonetsani maperesenti olakwika ofiira ndipo osawonetsa mayendedwe pambuyo pa decimal.
Mutha kuphunzira zambiri za njira yofooketsa iyi muzofotokozera za Microsoft, pamutu wowonetsa manambala mumtundu wa maperesenti.
3. Sinthani Maperesenti Olakwika mu Excel okhala ndi Mapangidwe Okhazikika
Poyerekeza ndi njira yapitayi, masanjidwe okhazikika mu Excel ndi njira yosinthika yomwe imakulolani kuti muyike mtundu uliwonse wa selo lomwe lili ndi mtengo wolakwika.
Njira yosavuta yopangira lamulo lokhazikika ndikupita ku menyu Kukonzekera mwatsatanetsatane > Onetsani malamulo a maselo > Ochepera (Mapangidwe Okhazikika> Malamulo Osankhira Ma cell> Ochepera…) ndikulowetsa 0 m'mundamo Pangani ma cell omwe ali Ocheperapo (Maselo amtundu wa LESS)
Kenako, pamndandanda wotsitsa, mutha kusankha imodzi mwazosankha zomwe mwasankha kapena dinani Mtundu Wakapangidwe (Mawonekedwe Amakonda) kumapeto kwa mndandandawu ndikusintha makonda onse amtundu wa cell momwe mukufunira.
Nazi zina zomwe mungachite kuti mugwiritse ntchito Maperesenti mawonekedwe data imatsegula Excel. Ndikukhulupirira kuti chidziwitso chomwe mwapeza kuchokera ku phunziroli chidzakupulumutsani kumutu wosafunikira m'tsogolomu. M'nkhani zotsatirazi, tilowa mozama pamutu wa magawo mu Excel. Muphunzira njira zomwe mungagwiritse ntchito kuti muwerengere chidwi mu Excel, phunzirani mafomu owerengera kusintha kwa peresenti, peresenti ya kuchuluka, chidwi chophatikizika, ndi zina zambiri.
Khalani tcheru ndi kuwerenga mosangalala!