Kupanga Numeri mu Excel Kugwiritsa Ntchito Zowonjezera Zake

Zopangidwe ndizosintha zomwe zimapangidwira ku ma Excel pamasamba kuti apititse patsogolo maonekedwe awo / kapena kuti ayang'ane pazomwe zili mu tsambalo.

Kukonza kusintha kumawonekera maonekedwe a deta, koma sikusintha deta lenileni mu selo, zomwe zingakhale zofunikira ngati deta ikugwiritsidwa ntchito kuwerengera. Mwachitsanzo, nambala zojambulidwa kuti ziwonetse malo awiri okha omwe safupikitsa kapena zowonongeka ndi malo oposa awiri.

Kuti musinthe nambalayi mwa njirayi, deta iyenera kuyendetsedwa pogwiritsira ntchito limodzi la ntchito zozungulira.

01 a 04

Kupanga Numeri mu Excel

Mapangidwe a chiwerengero mu Excel amagwiritsidwa ntchito kusintha mawonekedwe a nambala kapena mtengo mu selo mu tsamba la ntchito.

Kusintha kwa chiwerengero kumaphatikizidwa ku selo osati kufunika mu selo. Mwa kuyankhula kwina, kusintha kwa chiwerengero sikusintha nambala yeniyeni mu selo, koma momwe ikuwonekera.

Mwachitsanzo, sankhani selo limene lakonzedwa kuti likhale loipa, lapadera, kapena nambala yaitali ndipo chiwerengero chapala kusiyana ndi chiwerengero choyikidwacho chikuwonetsedwa muzenera yapamwamba pamwamba pa tsamba.

Njira zosinthira kusintha mawerengero ndi awa:

• makina osinthana pa keyboard;
• kupanga mafano pamakina ;
• Maofesi a Mawonekedwe a Mafomu .

Mapangidwe a chiwerengero angagwiritsidwe ntchito pa selo limodzi, mazenera onse kapena mizere, maselo angapo osankhidwa, kapena tsamba lonse.

Mpangidwe wosasinthika wa maselo okhala ndi deta zonse ndizojambulazo. Ndondomekoyi ilibe mawonekedwe enieni ndipo, mwachisawawa, imawonetsa nambala popanda zizindikiro za dollar kapena makasitomala ndi manambala osakanikirana - manambala omwe ali ndi gawo lochepa - silimangoperekedwa ku chiwerengero chokha cha malo apamwamba.

02 a 04

Kugwiritsa Ntchito Kukonza Nambala

Mgwirizano wambiri womwe ungagwiritsidwe ntchito kugwiritsa ntchito nambala yolemba ku data ndi:

Ctrl + Shift + ! (mawu okweza)

Zopangidwe zogwiritsidwa ntchito ku deta yachisankhidwa pogwiritsa ntchito makina osatsekera ndi awa:

• malo awiri omaliza
• comma ngati wolekanitsa zikwi (,)

Kugwiritsa ntchito chiwerengero cha chiwerengero ku deta pogwiritsa ntchito makiyi afupikitsira:

1. Sungani maselo omwe ali ndi deta kuti apangidwe
2. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi
3. Sakanizani ndi kumasula fayilo yachinsinsi (!) - yomwe ili pamwamba pa nambala 1 - pa kibodiboli popanda kumasula makiyi a Ctrl ndi Shift
4. Tulutsani makiyi a Ctrl ndi Shift
5. Kumene kuli koyenera, manambala mu maselo osankhidwa adzapangidwira kuti asonyeze mawonekedwe omwe tatchulidwa pamwambapa
6. Kusindikiza pa maselo alionse akuwonetsa chiwerengero choyambirira chosasinthika mu barolo lazenera pamwamba pa tsamba

Zindikirani: pakuti manambala ali ndi malo oposa awiri okha malo oyambirira a decimal amasonyezedwa, ena onse satulutsidwa ndipo adzaligwiritsiridwa ntchito kuwerengera zomwe zimayendera.

Ikani Kujambula kwa Namba Pogwiritsa Ntchito Zosakanikirana

Ngakhale angapo mawonekedwe amodzi omwe amagwiritsidwa ntchito nthawi zambiri amakhalapo ngati zithunzi pa pepala la Home la Ribbon, monga momwe tawonetsera pa chithunzi pamwambapa, mawonekedwe ambiri ali mu mndandanda wotsika pansi pa Nambala - zomwe zimasonyeza Zonse monga mawonekedwe osasintha a maselo Kuti mugwiritse ntchito mndandanda wazinthu:

1. Sungani maselo a deta kuti apangidwe
2. Dinani pansi pavivi pansi pa Number Format bokosi kuti mutsegule mndandanda wotsika
3. Dinani pa Nambala yotsatila mndandanda kuti mugwiritse ntchito njirayi ku maselo osankhidwa a deta

Nambala zimapangidwira kumalo awiri osungirako monga ndi njira yachinsinsi pamwamba, koma chogawanitsa chojambulidwa sichinagwiritsidwe ntchito ndi njira iyi.

Lembani Kujambula kwa Nambala mu Bokosi la Mauthenga Wowonjezera

Zosankha zowerengera zonse zilipo kudzera m'bokosi la dialogs .

Pali njira ziwiri zothetsera bokosilo:

1. Dinani pazomwe likukambilana ndi bokosi la bokosilo - chotsitsa chaching'ono chakugwera pansi pazanja lamanja la Number icon gulu pa riboni
2. Onetsani Ctrl + 1 pa makiyi

Zomwe Mungapangire Mafoni mu bokosi la bokosi ziphatikizidwa palimodzi pamatuku omwe ali ndi ziwerengero za chiwerengero chomwe chili pansi pa tsamba la Namba .

Pa tabu ili, mawonekedwe omwe alipo ali ogawidwa m'magulu muwindo lamanzere. Dinani pazomwe mungasankhe pawindo ndi zikhumbo ndi chitsanzo cha njirayi yomwe ikuwonetsedwa kumanja.

Kusindikiza Namba muwindo lamanzere kumasonyeza makhalidwe omwe angasinthe

• Chiwerengero cha malo apamwamba omwe asonyezedwa
• kugwiritsidwa ntchito kwa wogawanikana wotsalira kwa zikwi
• kusonyeza zosankha za nambala zolakwika

03 a 04

Ikani Kukonzekera kwa Ndalama

Kugwiritsa Ntchito Kupanga Ndalama Kugwiritsa Ntchito Zowonjezera Zowonjezera

Mgwirizano waukulu womwe ungagwiritsidwe ntchito kugwiritsa ntchito ndalama kupanga ma data ndi:

• Ctrl + Shift + $ (chizindikiro cha dola)

Maofesi osakayika a ndalama omwe amagwiritsidwa ntchito ku data yosankhidwa pogwiritsa ntchito makina oyendetsa ndi awa:

• chizindikiro cha dola
• malo awiri omaliza
• chiwerengero ngati olekanitsa zikwi (,)

Zomwe Mungagwiritse Ntchito Kupanga Zomwe Mukugwiritsa Ntchito Pogwiritsa Ntchito Zowonjezera Zowonjezera

Kuti mugwiritse ntchito kupanga mafashoni ku deta pogwiritsa ntchito makiyi osinthana:

1. Sungani maselo omwe ali ndi deta kuti apangidwe
2. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi
3. Dinani ndi kumasula kiyi ya chizindikiro cha dola ($) - yomwe ili pamwamba pa nambala 4 - pakhibodi popanda kumasula makiyi a Ctrl ndi Shift
4. Tulutsani makiyi a Ctrl ndi Shift
5. Maselo osankhidwa adzasankhidwa ndalama ndipo, ngati kuli koyenera, onetsani mafomu omwe tatchulidwa pamwambapa
6. Kusindikiza pa maselo alionse akuwonetsa chiwerengero choyambirira chosasinthika mu barolo lazenera pamwamba pa tsamba.

Ikani Kukonzekera kwa Ndalama Kugwiritsa Ntchito Zosakanikirana

Mitengo ya ndalama ingagwiritsidwe ntchito pa deta mwa kusankha Mtengo wosankhidwa kuchokera mundandanda wa zolemba za Nambala .

Chizindikiro cha dola ( $) chomwe chili mu Gulu la Nambala pa Tsambali la Home la Ribbon, si la Mpangidwe wa Ndalama koma kwa fomu ya Kuwerengera monga momwe tawonetsera pa chithunzi pamwambapa.

Kusiyanitsa kwakukulu pakati pa ziwirizi ndikuti kuwerengera kwa chiwerengero kumayimira chizindikiro cha dola kumbali ya kumanzere kwa selo pamene akugwirizanitsa deta yomwe ili kumanja.

Lembani Kukonzekera kwa Ndalama mu Bokosi la Ma Dilo la Mauthenga

Mndandanda wa ndalama mu bokosi la bokosi la Mafomu ndi ofanana ndi chiwerengero cha chiwerengero, kupatulapo mwayi wosankha chizindikiro chosiyana cha ndalama kuchokera ku chizindikiro cha dollar chosasinthika.

Bokosi la bokosi la mawonekedwe lingathe kutsegulidwa mwa njira ziwiri:

1. Dinani pazomwe likukambilana ndi bokosi la bokosilo - chotsitsa chaching'ono chakugwera pansi pazanja lamanja la Number icon gulu pa riboni
2. Onetsani Ctrl + 1 pa makiyi

Mu bokosi la bokosi, dinani Ndalama mu gululo mndandanda ku dzanja lamanzere kuti muwone kapena kusintha masinthidwe omwe alipo.

04 a 04

Ikani mawonekedwe a Peresenti

Onetsetsani kuti deta yomwe ikuwonetsedwa muzithunzi zaperesenti imalowa mu fomu ya decimal - monga 0.33 - yomwe, ikapangidwira peresenti, iwonetsere bwino ngati 33%.

Kupatula chiwerengero cha 1, nambala - zopanda malire - sizinapangidwe kawirikawiri peresenti momwe ziwonetsero zowonetsera zikuwonjezeka ndi chinthu cha 100.

Mwachitsanzo, mukamapangidwe peresenti:

• nambala 1 idzawonetsedwa ngati 100%;
• nambala 33 idzawonetsedwa ngati 3300%.

Ikani Mafomu Mafomu Pogwiritsa Ntchito Zowonjezera Makatani

Mgwirizano wambiri womwe ungagwiritsidwe ntchito kugwiritsa ntchito nambala yolemba ku data ndi:

Ctrl + Shift + % (chizindikiro cha peresenti)

Zopangidwe zogwiritsidwa ntchito ku deta yachisankhidwa pogwiritsa ntchito makina osatsekera ndi awa:

• 0 malo amtundu
• chizindikiro cha peresenti chikuwonjezeredwa

Zomwe Mungagwiritse Ntchito Kupanga Mafelemu Pogwiritsira Ntchito Zowonjezera Keyi

Kugwiritsa ntchito peresenti yopanga deta pogwiritsa ntchito makiyi afupikitsira:

1. Sungani maselo omwe ali ndi deta kuti apangidwe
2. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi
3. Sakanizani ndi kumasula phokoso lamatsenga (%) - ili pamwamba pa nambala 5 - pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift
4. Tulutsani makiyi a Ctrl ndi Shift
5. Nambala mu maselo osankhidwa adzapangidwira kuti asonyeze chizindikiro cha peresenti
6. Kuyang'anitsitsa pa maselo alionse opangidwa amawonetsa chiwerengero choyambirira chosasinthidwa mu barolo lazenera pamwamba pa tsamba

Ikani Mafomu Mafomu Pogwiritsa Ntchito Zosakanizidwa

Mafelemu angagwiritsidwe ntchito pa deta pogwiritsira ntchito chiwonetsero chomwe chili mu Gulu la Nambala pa Tsambali la Home la Ribbon, monga momwe tawonetsera pa chithunzi pamwambapa, kapena posankha Peresenti kuchokera mundandanda wotsika pansi.

Kusiyana kokha pakati pa ziwiri ndikuti chithunzi chojambulidwa, monga njira yachitsulo pamwamba, ikuwonetsera malo osungira pamene mndandanda wazitsulo ungasankhe malo awiri. Mwachitsanzo, monga momwe tawonetsera pa chithunzi pamwambapa, chiwerengero cha 0.3256 chikuwonetsedwa monga:

• 33% potsatizidwa pogwiritsa ntchito chithunzi chojambula
• 32.56% potsatizidwa pogwiritsa ntchito ndondomeko yosiyidwa

Nambala zimapangidwira kumalo awiri osungirako monga ndi njira yachinsinsi pamwamba, koma chogawanitsa chojambulidwa sichinagwiritsidwe ntchito ndi njira iyi.

Lembani Peresenti Pogwiritsa Ntchito Bokosi la Majambulo A Mafoni

Poganizira chiwerengero cha masitepe omwe angapangidwe kuti mupeze mawonekedwe a mawonekedwe a mawonekedwe a ma CD , pali nthawi zochepa pamene chisankhochi chiyenera kugwiritsidwa ntchito mmalo mwa njira imodzi yomwe tatchula pamwambapa.

Chifukwa chokha chosankhira kugwiritsa ntchito njirayi chikanasintha chiwerengero cha malo osungirako omwe akuwonetsedwa ndi manambala omwe amawongolera peresenti - mu bokosi la chiwerengero chiwerengero cha malo osinthidwa chiwonetsedwe chikhoza kukhazikitsidwa kuchoka ku zero kufikira 30.

Bokosi la bokosi la mawonekedwe lingathe kutsegulidwa mwa njira ziwiri:

1. Dinani pazomwe likukambilana ndi bokosi la bokosilo - chotsitsa chaching'ono chakugwera pansi pazanja lamanja la Number icon gulu pa riboni
2. Onetsani Ctrl + 1 pa makiyi