Kupanga zolakwika, Zakale, ndi Zapadera Numeri ku Excel

01 a 04

Kupanga Numeri mu Excel Phunziro

Chidziwitso pa mafomu angapo angapezeke pamasamba otsatirawa:

Tsamba 1: Nambala zolakwika (m'munsimu);
Tsamba 2: Onetsani nambala ya decimal ngati magawo;
Tsamba 3: Nambala yapadera - zip zip ndi ma foni formatting;
Tsamba 4: Kupanga manambala ambiri - monga manambala a ngongole - monga malemba.

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, kugwiritsa ntchito ndalama, peresenti, kapena chiwerengero cha nambala ku deta kumangowonekera mu selo kumene chiwerengero chiri. Kusindikiza pa seloyo kudzawonetsa chiwerengero chosawerengedwera mu barolo lazenera pamwamba pa tsamba.

General Default

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.

Mapangidwe a chiwerengero angagwiritsidwe ntchito pa selo limodzi, mazenera onse kapena mizera, maselo osiyanasiyana , kapena tsamba lonse.

Kusintha kwa Nambala Yosayera

Mwachindunji, nambala zolakwika zimadziwika pogwiritsa ntchito chizindikiro cholakwika kapena dash (-) kumanzere kwa chiwerengerocho. Excel ili ndi njira zina zingapo zomwe mungasankhe kuti muwonetse nambala zolakwika zomwe zili mu bokosi la mauthenga . Izi zikuphatikizapo:

• zofiira
• mabwalo oyandikana
• mabwalo oyandikana ndi malemba ofiira

Kuwonetsa manambala ofiira mofiira kungakhale kosavuta kuwapeza - makamaka ngati ndi zotsatira za malemba omwe angakhale ovuta kuwatsatira mu tsamba lalikulu.

Mipata imagwiritsidwa ntchito kupanga nambala zosavuta zosavuta kupeza deta yomwe iyenera kusindikizidwa mu zakuda ndi zoyera.

Kusintha Nambala Yosasinthika Kujambula mu Bokosi la Majambulidwe a Ma cell

1. Onetsani deta kuti ikhale yojambulidwa
2. Dinani pa tabu la Home la riboni
3. Dinani pazomwe likulumikiza bokosi la bokosilo - chotsitsa chaching'ono chakugwera pansi pazanja lamanja la Number icon gulu pa riboni kuti mutsegule Mawonekedwe a Ma CD
4. Dinani pa Namba pansi pa Gawo la gawo la bokosi
5. Sankhani njira yosonyeza nambala zolakwika - zofiira, mabaki, kapena zofiira ndi mabakiteriya
6. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito
7. Malingaliro olakwika mu deta yosankhidwa ayenera tsopano kupangidwa ndi zosankhidwa zosankhidwa

02 a 04

Kupanga Numeri monga Zagawo ku Excel

Onetsani Numeri Yamtundu ngati Zagawo

Gwiritsani ntchito mawonekedwe a Fraction kuti muwonetse manambala monga magawo enieni, m'malo mochepa. Monga momwe tawerengedwera pansi pa ndondomeko ya kufotokozera mu chithunzi pamwambapa, zomwe mungapeze pazigawozi zikuphatikizapo:

• kuwonetsera ziwalo monga gawo limodzi, ziwiri, kapena zitatu mu gawo la chiwerengero cha nambala;
• kuwonetsa zizindikiro monga magawo omwe amagwiritsidwa ntchito kawirikawiri - monga theka limodzi ndi theka.

Fomu Yoyamba, Chachiwiri Chachidule

Kawirikawiri, ndi bwino kugwiritsira ntchito mawonekedwe a magawo a maselo musanalowetse deta kuti mupewe zotsatira zosadziwika.

Mwachitsanzo, ngati magawo omwe ali ndi chiwerengero pakati pa 1 ndi 12 - monga 1/2 kapena 12/64 - alowa mu maselo ndi Zowonetsera Zambiri , manambala adzasinthidwa kukhala ma dates monga:

• 1/2 adzabwezedwa monga 2-Jan
• 12/64 adzabwezedwa monga Jan-64 (January, 1964)

Komanso, tizigawo ting'onoting'ono ta owerengeka oposa 12 tidzasinthidwa, ndipo zingayambitse mavuto powerengera.

Mawerengedwe a Mawerengedwe monga Zagawo Zake mu Bokosi la Ma Dilo la Mauthenga

1. Sungani maselo kuti apangidwe monga magawo
2. Dinani pa tabu la Home la riboni
3. Dinani pazomwe likulumikiza bokosi la bokosilo - chotsitsa chaching'ono chakugwera pansi pazanja lamanja la Number icon gulu pa riboni kuti mutsegule Mawonekedwe a Ma CD
4. Dinani pa Fraction pansi pa Gawo la Gawo la bokosi kuti muwonetse mndandanda wa mawonekedwe a tizigawo ting'onoting'ono kudzanja lamanja la bokosi
5. Sankhani maonekedwe kuti muwonetse nambala za decimal monga tizigawo ting'onoting'ono
6. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito
7. Nambala zapamwamba zolowera muzithunzi zoyenera ziyenera kuwonetsedwa ngati magawo

03 a 04

Kupanga Mawerengedwe Owerengeka ku Excel

Zowonongeka ndi Kuwerengeka kwa Nambala

Ngati mumagwiritsa ntchito Excel kusunga manambala ozindikiritsa - monga ma zip code kapena manambala a foni - mungapeze kuti nambalayo isinthidwa kapena kuwonetsedwa ndi zotsatira zosayembekezereka.

Mwachindunji, maselo onse a pa Excel akamawunikira amagwiritsa ntchito Zopangidwe Zachikhalidwe , ndipo maonekedwe a mawonekedwe awa ndi awa:

• kutsogolera zeros mu manambala achotsedwa,
• Manambala okhala ndi manambala oposa 11 atembenuzidwa kuti aziwunika sayansi (kapena exponential).

Mofananamo, Chiwerengero cha chiwerengero ndi chochepa powonetsera manambala a maambala 15 m'litali. Mawonekedwe aliwonse opitirira malire awa amatsitsidwa mpaka zeros

Kuti mupewe mavuto ndi nambala yapadera, zosankha ziwiri zingagwiritsidwe ntchito malinga ndi chiwerengero cha chiwerengero chomwe chikusungidwa pa tsamba:

• gulu lapadera la mtundu wa bokosi la bokosi la maonekedwe (onani m'munsimu);
• nambala yosindikiza monga malemba (tsamba lotsatira).

Kuonetsetsa kuti nambala yapadera imasonyezedwa molondola pamene yalowa, yesani selo kapena maselo pogwiritsa ntchito chimodzi mwa mafomu awiriwa pansi musanalowe nambala.

Mtundu wapadera wa mtundu

Gulu lapadera la bokosi la bokosi la Mafilimu limagwiritsira ntchito maumboni apadera kwa manambala monga:

• manambala a foni - amalowetsa ma nambala atatu oyambirira a nambala 10 ya chiwerengero mu maina awo ndipo amasiyanitsa maulendo asanu ndi awiri otsala omwe amakhala osiyana ndi magulu awiri. Mwachitsanzo: (800) 555-1212
• Nambala Zosungira Zachikhalidwe - kulekanitsa manambala asanu ndi anayi kukhala magulu a atatu, awiri, ndi anayi osiyana ndi anthu. Mwachitsanzo: 555-00-9999

• Zipangizo za zip - zimakhala ndi zeros zotsatila - zomwe zimachotsedwa ndi machitidwe owerengeka. Mwachitsanzo: 00987

• zip code + 4 : amalekanitsa nambala zisanu ndi zinayi zamitundu kukhala magulu a maulendo asanu ndi anayi opatulidwa ndi chithunzi. Komanso imakhala ndi zeros zotsogolera. Chitsanzo: 00987-5555

Malo Osokonezeka

Mndandanda wotsika pansi pa Malowa umapereka njira zomwe mungasankhe kuti mupange manambala apadera oyenerera kumayiko ena. Mwachitsanzo, ngati Malowa asinthidwa kukhala Chingerezi (Canada) zomwe mungapeze ndi Nambala ya foni ndi Nambala ya Inshuwalansi ya Anthu - yomwe nthawi zambiri imagwiritsidwa ntchito nambala yapadera ya dzikoli.

Kugwiritsa Ntchito Kukonzekera Kwapadera kwa Numeri mu Bokosi la Mauthenga a Ma CD

1. Sungani maselo kuti apangidwe monga magawo
2. Dinani pa tabu la Home la riboni
3. Dinani pazomwe likulumikiza bokosi la bokosilo - chotsitsa chaching'ono chakugwera pansi pazanja lamanja la Number icon gulu pa riboni kuti mutsegule Mawonekedwe a Ma CD
4. Dinani pa Zapadera pansi pa Gawoli la gawo la bokosilo kuti muwone mndandanda wa mawonekedwe apadera omwe alipo kumanja kwa bokosi
5. Ngati ndi kotheka, dinani pa Malo omwe mungapeze kuti musinthe malo
6. Sankhani chimodzi mwazomwe mungasankhe kuti muwonetse nambala yapadera kuchokera mndandanda
7. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito
8. Nambala zoyenerera zimalowa muzithunzi zoyenerera ziyenera kuwonetsedwa monga ndi mtundu wosankhidwa wapadera

04 a 04

Kupanga Mawerengedwe Monga Ndemanga mu Excel

Zowonongeka ndi Kuwerengeka kwa Nambala

Kuonetsetsa kuti manambala aatali - monga makadi a ngongole 16 ndi makadi a banki - amasonyezedwa molondola pamene adalowa, kupanga mawonekedwe kapena selo pogwiritsa ntchito malemba - makamaka asanalowetse deta.

Mwachindunji, maselo onse a pa Excel akamawunikira amagwiritsa ntchito Zopangidwe Zowonongeka , ndipo chimodzi mwa zizindikiro za mtundu uwu ndi kuti manambala omwe ali ndi chiwerengero choposa 11 adatembenuzidwa kuti aziwunika sayansi (kapena exponential) - monga momwe akusonyezera mu selo A2 mu chithunzi pamwambapa.

Mofananamo, Chiwerengero cha chiwerengero ndi chochepa powonetsera manambala a maambala 15 m'litali. Mawonekedwe aliwonse opitirira malire awa amatsitsidwa mpaka zeros.

Mu selo A3 pamwambapa, nambala 1234567891234567 yasinthidwa kukhala 123456789123450 pamene selo yikonzedwa kuti ipangidwe nambala.

Kugwiritsira ntchito Deta Zachidule mu Mafomu ndi Ntchito

Mofanana ndi zimenezi, sewero la A4 pamwambapa - nambala yomweyo imawonetsa molondola, ndipo popeza chiwerengero cha khalidwe pa selo la maonekedwewo ndi 1,024, mwina ndi nambala chabe zopanda nzeru monga Pi (Π) ndi Phi (Φ) zomwe sizingatheke kuwonetsedwa kwathunthu.

Kuwonjezera pa kusunga chiwerengero chofanana ndi momwe chinalowedwera, mawerengedwe amawongosoledwa ngati malembo angagwiritsidwebe ntchito m'mafomu pogwiritsira ntchito masamu akuluakulu - monga kuwonjezera ndi kuchotsa monga momwe akusonyezera mu selo A8 pamwambapa.

Iwo sangakhoze kuzigwiritsa ntchito izo powerengera ndi zina za ntchito za Excel - monga SUM ndi MAVERA , monga maselo omwe ali ndi data akuwoneka opanda kanthu ndikubwezera:

• zotsatira za zero kwa SUM - selo A9
• malingaliro amtengo wapatali # DIV / 0! kwa AVERAGE - selo A10

Zosintha Zomwe Mungapangire Cell Kulemba

Mofanana ndi maonekedwe ena, ndikofunika kupanga foni ya sewero la deta musanalowe nambala - mwinamwake, zidzakhudzidwa ndi mawonekedwe a maselo omwe alipo tsopano.

1. Dinani mu selo kapena sankhani maselo osiyanasiyana omwe mukufuna kutembenuza ku malemba
2. Dinani pa tabu la Home la riboni
3. Dinani pansi pavivi pansi pa Number Format bokosi - amawonetsera General mwachindunji - kutsegula menyu pansi masamba zosankha
4. Pendani pansi pa menyu ndipo dinani pazolembazo - palibe njira zina zowonjezera malemba

Lembani kumanzere, Numeri kumanja

Chinthu chowonekera chothandizira kudziwa mtundu wa selo ndikuyang'ana kulumikizidwa kwa deta.

Mwachindunji mu Excel, deta yamtundu yatsatiridwa kumanzere mu selo ndi nambala ya nambala kumanja. Ngati kusinthika kosasinthika kwa maonekedwe osiyanasiyana monga malemba sikunasinthidwe, manambala angalowe mmalo amenewa ayenera kuwonetsedwa kumanzere kwa maselo monga momwe amasonyezera mu selo C5 mu chithunzi pamwambapa.

Kuonjezera apo, monga momwe zikusonyezedwera m'maselo A4 mpaka A7, manambala omwe amawongosoledwa ngati malemba adzasonyezanso katatu kakang'ono kobiriwira pamwamba pa ngodya yapamwamba ya selo yomwe ikusonyeza kuti detayo ingapangidwe molakwika.