Kugadzirisa Nhamba, Yekare, uye Nhamba Dzakasiyana muExcel

01 ye 04

Kugadzira Numeri muExpcel Overview

Mashoko pamusoro pehuwandu hwehuwandu hunogona kuwanikwa pamapeji anotevera:

Peji 1: Nhamba dzisina kunaka (pasi);
Peji 2: Ratidza nhamba dzemazana sezvikamu;
Peji 3: Nhamba dzinokosha - zip zip uye nhamba yefomiti yekufambisa;
Peji 4: Kugadzirisa nhamba yakareba - yakadai semakadhi emakadhi echikwereti - semashoko.

Nhamba yehuwandu hwekufambisa muExcel inoshandiswa kuchinja kuonekwa kwechiverengero kana kukosha mune imwe sero mubasa rekushanda.

Nhamba yehuwandu inosanganiswa nesero uye kwete kukosha mumusero. Mune mamwe mazwi, kuumbwa kwenhamba hakushandisi nhamba chaiyo muchitokisi, asi nenzira iyo inooneka.

Semuenzaniso, kushandiswa kwemari, mapeji, kana kuverenga mafaira kune data zvinongowanikwa muchitokisi umo nhamba iripo. Kushandura pane iyo sero kucharatidza fani, nhamba isina kufananidzwa mubhadha yepamusoro pane pepa pepaji.

General Default

Izvo zvisina kumira maitiro emaseli ane data yose ndeyeGaraiyo maitiro. Iyi maitiro haana mhando yakarongeka uye, nekutadza, inoratidza nhamba dzisina dhora zviratidzo kana mazai uye nhamba yakavhenganiswa - nhamba dzine chine chikamu chiduku-hachirevi kune imwe nhamba yedzimba dzepamusoro.

Nhamba yemaitiro inogona kushandiswa kune imwe sero, mazamu ese kana mitsetse, sarudzo yakasarudzwa yemasero, kana kuti bheji rose rebasa .

Nhamba Nhamba Isingafadzi

Nokusingaperi, nhamba dzisingazivikanwi dzinoshandiswa uchishandisa chiratidzo chisina kunaka kana dash (-) kuruboshwe rwechiwandu. Excel ine dzimwe nzira dzakasiyana-siyana dzokusarudza pakuratidza nhamba dzisina kunaka dziri mu Format Cells dialog box . Izvi zvinosanganisira:

• mutsvuku
• round brackets
• mabheji akapoteredza uye zvinyorwa zvitsvuku

Kuratidza nhamba dzisina kunaka muhomwe kunogona kuita kuti zvive nyore kuzviwana - kunyanya kana zviri mhedzisiro yezvinyorwa zvingave zvakaoma kutarisa mune pepa guru rephizha.

Mabheti anowanzoshandiswa kuita kuti nhamba dzisina kunaka dzive nyore kuziva kuti deta inofanira kudhindwa mumasikati nemachena.

Kuchinja Nhamba Isingafadzi Kugadziridza muImajeri Maselo eDhiyabhorosi Dialog

1. Simbisa deta kuti igoverwe
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya pabhokisi rebhokisi rebhokisi - mutsara muduku wekunyorera pasi mukona wezasi weNhamba yekiyo yeboka pane ribhoni kuti uzarure maBeri eDaviki maBhokisi ebhokisi
4. Dzvanya paNhamba pasi peChikamu chikamu chebhokisi rebhokisi
5. Sarudza chisarudzo chekuonesa nhamba dzisina kunaka - dzvuku, mabheji, kana dzvuku uye mabheji
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
7. Nhamba dzisina kunaka mumasarudzo akasarudzwa dzinofanira kuenzanisirwa nemasarudzo akasarudzwa

02 of 04

Kugadzirisa Numeri sezvikamu zveExcel

Ratidza Nhamba Dzakakwirira Sezvikamu Zviduku

Shandisa Fraction format kuti uratidze nhamba sezvikamu zvepachokwadi, panzvimbo yezvimedu. Sezvakanyorwa pasi peKurondedzero chinyorwa mumufananidzo uri pamusoro apa, zviwanikwa zviripo zvezvikamu zvinosanganisira:

• kuratidza zviduku semumwe, maviri, kana zvitatu zvikamu zviduku muine denominator chikamu chenhamba;
• kuratidza kumira semashandi anowanzoshandiswa - zvakadai sehafu neyendima.

Format First, Data Second

Kazhinji, zvakanakisisa kushandisa chikamu chemukati masero kumasero vasati vapinda munharaunda kuti vadzivise migumisiro isingatarisirwi.

Semuenzaniso, kana zvikamu zviduku zvine ma numerator pakati pekutanga ne12 - zvakadai se 1/2 kana 12/64 - zvakapinda mumasero neGeneral format, nhamba dzichashandurwa dzive dzakadai se:

• 1/2 ichadzorerwa sa 2-Jan
• 12/64 ichadzorerwa saJan-64 (January, 1964)

Uyewo, zvikamu zviduku zvinodarika makumi gumi nezviviri zvinoshandurwa kuva zvinyorwa, uye zvinogona kukonzera zvinetso kana zvichishandiswa mukuverenga.

Fomora Numeri sezvikamu zviduku muIndaneti Maseja eBhokisi reDhiyabhorosi

1. Simbisai masero kuti aenzaniswe sezvikamu
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya pabhokisi rebhokisi rebhokisi - mutsara muduku wekunyorera pasi mukona wezasi weNhamba yekiyo yeboka pane ribhoni kuti uzarure maBeri eDaviki maBhokisi ebhokisi
4. Dzvanya paFraction pasi peChikamu chikamu chebhokisi rebhokisi kuti uratidze urongwa hwezvikamu zvezvikamu zvitsva zviri kuruoko rworudyi rwebhokisi rebhokisi.
5. Sarudza chimiro chekuratidza nhamba dzemadhora sezvikamu zvekutsvaga
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
7. Nhamba dzakatemwa dzakapinda mumutsetse wakarongeka dzinofanira kuratidzwa sezvikamu

03 of 04

Kugadzirisa Nhamba Dzakasiyana muExcel

Zvose uye Nhamba Yehuwandu Hwakakwana

Kana ukashandisa Excel kuti uchengetedze nhamba dzekuzivikanwa - dzakadai sedhizha dze zip kana nhamba dzefoni - ungawana nhamba ichichinjwa kana kuiswa nemigumisiro isingatarisirwi.

Nokusingaperi, masero ose eExpcel worksheet anoshandisa Izvo zvakagadziriswa, uye maitiro eiyo mafomu anosanganisira:

• kutungamirira zeros mu nhamba zvakabviswa,
• nhamba dzine nhamba dzinopfuura 11 dzinoshandurwa kusayenzi (kana exponential) notation.

Saizvozvowo, Nhamba yehuwandu inogumira pakuratidza nhamba dzemajeri gumi nemashanu pakureba. Nhamba ipi zvayo mairi kupfuura iyi muganhu yakakombererwa kusvika zeros

Kuti udzivise matambudziko nemhando dzakasarudzwa, zvingasarudzwa zviviri zvinogona kushandiswa zvichienderana nerudzi rwepi ruri kuchengetwa mune pepa rekushanda:

• iyo yakarongeka mutsara muIndaneti Cells dialog box (ona pasi apa);
• kuenzanisa nhamba semashoko (peji rinotevera).

Kuti uone kuti nhamba dzakasarudzwa dzinoratidzwa zvakanaka kana dzichipinda, dzoratidzira sero kana masero anoshandisa imwe yezvimiro zviviri pasi apa usati wapinda nhamba.

Special Format category

Chikamu Chinokosha muFomendi Cells dialog box rinoshandisa maitiro akasiyana-siyana kumatare akadai se:

• foni nhamba - inoshandisa mazita matatu okutanga ehamba nhamba gumi nenhamba pakati pevabereki uye inoparadzanisa zvakasara zvinomwe majeri mumapoka maviri akaparadzaniswa nehana. Somuenzaniso: (800) 555-1212
• Nhamba dzekuchengeteka kwevanhu - inoparadzanisa mapfumbamwe emadhijita mumapoka evanhu vatatu, maviri, uye mana akaparadzaniswa nehana. Somuenzaniso: 555-00-9999

• zip code - retains inotungamirira zeros mu nhamba - izvo zvinobviswa nevakawandisa mafomu emhando. Somuenzaniso: 00987

• zip code + 4 : inoparadzanisa mapeji mapfumbamwe mumapoka ezvishanu uye mana akaparadzaniswa nehana. Uyezve inoramba iine zeros inotungamirira. Muenzaniso: 00987-5555

Locale Sensitive

Kudonha pasi pasi pe Locale kunopa maitiro ekugadzirisa nhamba dzakasiyana dzakakodzera kune dzimwe nyika. Somuenzaniso, kana nzvimbo yakashandurwa kuChirungu (Kanada) zvingasarudzwa ndeyeNhamba yeNhare uye Nhamba yeInishuwarenzi Yenharaunda - iyo inowanzoshandiswa nhamba dzinokosha dzenyika iyoyo.

Kushandisa Kugadzirisa Kukosha KweNhamba muBhokisi Remajeri Ekutengesa Mabhokisi

1. Simbisai masero kuti aenzaniswe sezvikamu
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya pabhokisi rebhokisi rebhokisi - mutsara muduku wekunyorera pasi mukona wezasi weNhamba yekiyo yeboka pane ribhoni kuti uzarure maBeri eDaviki maBhokisi ebhokisi
4. Dzvanya paZvamwe pasi peChikamu chikamu chebhokisi rebhokisi kuti uratidze urongwa hwezviwanikwa zvakakosha zvakagadzirirwa kuruoko rworudyi rwebhokisi rebhokisi
5. Kana zvichidikanwa, chengetedza paIndale sarudzo kuti uchinje nzvimbo
6. Sarudza chimwe chemafaira maitiro ekuratidzira nhamba dzakasiyana kubva pakurongwa
7. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
8. Nhamba dzakakodzera dzakapinda mumusangano wakarongeka dzinofanira kuratidzirwa saiyo yakasarudzwa yakarongeka

04 we 04

Kugadzira Numeri seMagwaro muExcel

Zvose uye Nhamba Yehuwandu Hwakakwana

Kuchengetedza kuti nhamba dzenguva refu - dzakadai se-16 chidimbu chekadhi rechikwereti uye nhamba dzekadhi rebhangi - dzinonyatsoratidzwa kana dzichipinda, dzakaita sero kana masero anoshandisa iyo Format format - kunyanya asati apinda data.

Nokusingaperi, masero ose eExpcel worksheet anoshandisa Izvo zvakasarudzika, uye imwe yenhengo dzeiyo mafomati ndeyokuti nhamba dzine nhamba dzinopfuura 11 dzinoshandurwa kusayenzi (kana kuti exponential) notation - sezvinoratidzwa muchikamu cheA2 mumufananidzo uri pamusoro.

Saizvozvowo, Nhamba yehuwandu inogumira pakuratidza nhamba dzemajeri gumi nemashanu pakureba. Nhamba ipi zvayo mairi kupfuura iyi muganhu yakakombererwa kusvika zeros.

Muchikamu cheA3 pamusoro, nhamba 1234567891234567 inoshandurwa kusvika 123456789123450 apo sero rinotarirwa kuwandisa nhamba.

Kushandisa Text Data muMafomu neMabasa

Zvimwe, kana magwaro ekugadzirisa kushandiswa anoshandiswa - sero A4 kumusoro - nhamba imwe chete inoratidza zvakanaka, uye, sezvo chiyero chemhando pamasero emafomati maitiro ari 1,024, zvinenge zvichida nhamba dzisinganzwisisiki dzakadai saPi (Π) naFi (Φ) izvo zvisingagoni kuratidzirwa zvachose.

Mukuwedzera pakuchengeta nhamba yakafanana nenzira iyo yakapinda nayo, nhamba dzakarongwa semagwaro zvinogona kushandiswa mumashonga kushandisa masvomhu ekuita mabasa - sekuwedzera nekudzinga sezvinoratidzwa muchikamu cheA8 pamusoro.

Havakwanise, asi, kuti vashandise pakuverenga nemamwe mabasa eExpcel - akadai seSUM neAVERAGE , sezvo masero ane data aya anobatwa asina chinhu uye anodzoka:

• chikonzero che zero yeSUM - seki A9
• iko kukanganisa kunokosha # DIV / 0! yeAVERAGE - cell A10

Matanho ekufambisa Cell kuti Tinyora

Sezvimwe nemamwe maitiro, zvakakosha kuenzanisa sero yevaraidzo deta usati wapinda nhamba - zvisinei, ichasvibiswa neiyo sekusimbwa kwema cell.

1. Dzvanya pane sero kana sarudza hutanda hwemasero ayo waunoda kutendeuka kuti unyore mafaira
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya pamusorosoro pasi pedyo neNhamba yeFomiti yebhokisi - maonerwo Gara nekusingaperi -kuzarura mhando yezvinyorwa zvemafaira ekusarudza
4. Bhura kusvika pasi pe menu uye chengeta paMutsetse sarudzo - hapana zvimwe zvingasarudzwa zvemashoko mavara

Nyora kune Kuruboshwe, Numeri kuruboshwe

Chiratidzo chekuona kuti chikubatsire kuziva kuti seni yakarongeka ndechipi kutarisa kuenzaniswa kwe data.

Nokusara muExpcel, deta yedhesi yakabatana nechokuruboshwe mune imwe sero uye nhamba ye data pane kurudyi. Kana kuenzaniswa kusina kushandiswa kwemazera akaenzaniswa semagwaro kusina kuchinjwa, nhamba dzakapinda muzera iroro dzinofanira kuratidzwa kuruboshwe rwemajeri sezvinoratidzwa muchitokisi C5 mumufananidzo uri pamusoro.

Mukuwedzera, sezvakaratidzwa mumasero A4 kusvika kuA7, nhamba dzakarongerwa semashoko dzicharatidzawo katatu katsvuku mumucheto wepamusoro wekona wesero inoratidza kuti data inogona kuenzaniswa zvisina kururama.