Shirya Ƙananan Kullun, Dogon, da Lambobi na Musamman a Excel

01 na 04

Lissafin Ƙididdiga a cikin Excel Overview

Bayani game da takamaiman lambobin lissafi ana samuwa a shafuka masu zuwa:

Page 1: Lambobi masu mahimmanci (ƙasa);
Page 2: Nuna lambobin ƙayyadaddun abubuwa kamar ɓangarori;
Page 3: Lambobi na musamman - zip lambobi da tsarin tsarawar waya;
Page 4: Tsarin lambobi mai tsawo - kamar lambobin katin bashi - azaman rubutu.

Ana tsara fasalin lambobi a Excel don canza bayyanar lamba ko darajar a cikin tantanin halitta a cikin takardun aiki.

Tsarin lambobi yana haɗe zuwa tantanin halitta kuma ba ga darajar cikin tantanin halitta ba. A takaice dai, tsarawar lambobi bazai canza ainihin lambar a cikin tantanin halitta ba, amma kawai hanyar da ta bayyana.

Alal misali, yin amfani da kudi, kashi, ko tsarawar lambobi zuwa bayanai yana samuwa kawai a cikin tantanin halitta inda aka samo lambar. Danna kan tantanin salula zai nuna layi, lambar da ba a ƙidayar ba a cikin maɓallin tsari a sama da takardun aiki.

Janar Default

Tsarin tsoho don kwayoyin da ke dauke da duk bayanai shi ne Janar ɗin . Wannan salon ba shi da wani takamammen tsari kuma, ta hanyar tsoho, nuna lambobin ba tare da alamun dollar ko alamu ba da lambobi - lambobin da ke dauke da ɓangaren sashi - ba'a iyakance ga wani adadin adadin wurare mara kyau ba.

Za'a iya amfani da matakan lambobi zuwa tantanin tantanin halitta guda ɗaya, duk ginshiƙai ko layuka, wani zaɓi na zaɓin sel, ko dukan takardun aiki .

Matakan Nama Marasa

Ta hanyar tsoho, an gano lambobi masu maƙasta ta amfani da alamar kuskure ko dash (-) zuwa hagu na lambar. Excel yana da wasu nau'ukan zabin tsarin don nuna lambobin da ba su da kyau wanda ke cikin akwatin maganganu na Siffofin . Wadannan sun haɗa da:

• ja rubutu
• zagaye ta tsakiya
• zagaye zane da rubutu ja

Nuna lambobi mara kyau a cikin ja zai iya sauƙaƙe don samo su - musamman ma idan sune sakamakon dabarar da zai iya da wuya a biye a babban ɗimbin rubutu.

Ana amfani da takalma don yin lambobin ƙananan sauki don gano bayanan da za'a buga a baki da fari.

Canza Canjin Maɓallin Magance a cikin Siffar Magana Tsarin Siffar

1. Ƙaddamar da bayanan da za a tsara
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin maganganun maganganu - ƙananan arrow a cikin ƙananan kusurwar kusurwar Ƙungiyar Lambar lambar ta kan rubutun don buɗe akwatin maganganun Siffofin Siffar
4. Danna Lamba a ƙarƙashin sashin Sashen na akwatin maganganu
5. Zaɓi wani zaɓi don nuna lambobin maɓallin - ja, madogara, ko ja da ƙuƙwalwa
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki
7. Ya kamata a tsara tsarin kirki a cikin zaɓaɓɓun bayanan tare da zaɓuɓɓukan zaɓuɓɓuka

02 na 04

Lissafin Lissafi a matsayin Fractions a Excel

Nuna Lissafin Ƙididdiga kamar Fractions

Yi amfani da samfurin Fraction don nuna lambobi a matsayin rassa na ainihi, maimakon ƙaddarar ƙira. Kamar yadda aka jera a ƙarƙashin Maɓallin bayanin a cikin hoton da ke sama, zaɓuɓɓuka masu samuwa don raunuka sun haɗa da:

• nuna nau'i-ƙayyadaddun kashi ɗaya, biyu, ko uku a cikin ɓangaren lamba na lamba;
• nuna nau'i-nau'i kamar yadda aka saba amfani dashi - kamar rabin da rabi.

Tsarin farko, Bayani Na Biyu

Yawancin lokaci, ya fi dacewa don yin amfani da ƙwayar juzu'i zuwa kwayoyin halitta kafin shigar da bayanai don kauce wa sakamakon da ba a yi ba.

Alal misali, idan ɓangarori tare da ƙididdiga tsakanin daya da 12 - kamar 1/2 ko 12/64 - an shigar da su cikin sel tare da Tsarin Janar , za a canza lambobin zuwa kwanakin kamar:

• 1/2 za a mayar da su kamar 2-Jan
• 12/64 za a dawo a matsayin Jan-64 (Janairu, 1964)

Bugu da ƙari, ƙananan rassa da ƙididdiga fiye da 12 za a juya zuwa rubutu, kuma zai iya haifar da matsaloli idan aka yi amfani da su a cikin lissafi.

Ƙara Lissafi a matsayin Fractions a cikin Siffar Siffar Siffofin Siffar

1. Ganyo hanyoyi don tsara su a matsayin ɓangarori
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin maganganun maganganu - ƙananan arrow a cikin ƙananan kusurwar kusurwar Ƙungiyar Lambar lambar ta kan rubutun don buɗe akwatin maganganun Siffofin Siffar
4. Latsa Fraction a ƙarƙashin Sashin sashin layi na akwatin maganganu don nuna jerin samfurori na ɓangaren samuwa a gefen dama na akwatin zance
5. Zaɓi tsari don nuna lambar ƙayyadaddun abubuwa kamar ɓangarori daga lissafin
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki
7. Lambobin ƙayyadadden shigarwa a cikin zangon tsarawa ya kamata a nuna azaman ɓangarori

03 na 04

Shirya Lissafi Na Musamman a Excel

Janar da Lambar Tsarin Gida

Idan kayi amfani da Excel don adana lambobin tantancewa - kamar lambobin waya ko lambobin waya - zaka iya ganin lambar da aka canja ko nunawa tare da sakamakon da ba a yi ba.

Ta hanyar tsoho, dukkanin sel a cikin takardar aikin Excel suna amfani da Tsarin Tsarin, kuma halaye na wannan tsari sun haɗa da:

• Ana cire masu ɓarna a cikin lambobi,
• lambobi tare da lambobi fiye da 11 sun tuba zuwa ilimin kimiyya (ko ƙaddara).

Hakazalika, Tsarin Lambar yana iyakance ga nuna lambobin lambobi 15 a tsawon. Duk wasu lambobi fiye da iyakokin suna iyakance har zuwa baƙi

Don kaucewa matsalolin lambobi na musamman, za a iya amfani da zaɓuɓɓuka guda biyu dangane da irin nau'in lambar da aka adana a cikin takardun aiki:

• nau'in tsari na musamman a cikin akwatin Siffofin Siffa (duba a kasa);
• Tsarin lambobi a matsayin rubutu (shafi na gaba).

Don tabbatar da cewa lambobi na musamman an nuna daidai lokacin da aka shiga, tsara tantanin halitta ko sassan ta amfani da daya daga cikin siffofin biyu a ƙasa kafin shigar da lambar.

Musamman Format Category

Aikin musamman a cikin akwatin Siffofin Siffofin ta atomatik shafi ta musamman don tsarawa zuwa lambobi kamar:

• Lambobin waya - sun ƙunshi lambobi uku na lambar lamba guda 10 a cikin iyayengiji kuma ya raba sauran lambobi bakwai zuwa ƙungiyoyi biyu da suka rabu da su. Alal misali: (800) 555-1212
• Lambobin tsaro - raba lambobi tara a cikin rukuni na uku, biyu, da hudu waɗanda suka haɗu. Alal misali: 555-00-9999

• zip code - retains manyan zeros a cikin lambobi - wanda aka cire tare da tsarin lambobi na yau da kullum. Alal misali: 00987

• lambar zip + 4 : raba lambobi tara a cikin rukuni na biyar da hudu waɗanda suka raba ta. Har ila yau, yana riƙe duk wani nau'i mai mahimmanci. Misali: 00987-5555

Yanayin Siffar

Jerin da aka sauke a ƙarƙashin yankin yana ba da damar zaɓin lambobin da aka dace don ƙasashen da suka dace. Alal misali, idan an canza yankin zuwa Ingilishi (Kanada) zaɓuɓɓukan da ake samuwa su ne Lambar waya da Lambar Asusun Harkokin Kiwon Lafiya - wanda ake amfani dasu na musamman don wannan ƙasar.

Amfani da Musamman Tattaunawa don Lissafi a cikin Siffar Magana Tsarin Siffar

1. Ganyo hanyoyi don tsara su a matsayin ɓangarori
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin maganganun maganganu - ƙananan arrow a cikin ƙananan kusurwar kusurwar Ƙungiyar Lambar lambar ta kan rubutun don buɗe akwatin maganganun Siffofin Siffar
4. Danna kan Musamman a ƙarƙashin sashin Sashen na akwatin maganganu don nuna jerin jerin samfurori na musamman a gefen dama na akwatin maganganu
5. Idan ya cancanta, danna kan Zaɓin Yanayin don canja wurare
6. Zaɓi daya daga cikin zaɓuɓɓukan tsarin don nuna lambobin musamman daga lissafin
7. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki
8. Lambobi masu dacewa da aka shigar a cikin zangon tsarawa ya kamata a nuna su tare da tsari na musamman

04 04

Lissafin Magana kamar Rubutu a Excel

Janar da Lambar Tsarin Gida

Don tabbatar da cewa dogon lambobi - kamar katin katin bashi 16 da katin lambobin banki - an nuna su daidai lokacin da aka shiga, tsara tantanin halitta ko sassan ta amfani da Tsarin rubutu - zai fi dacewa kafin shigar da bayanai.

Ta hanyar tsoho, dukkanin sel a cikin takarda na Excel sunyi amfani da Tsarin Tsarin, kuma ɗaya daga cikin halaye na wannan tsari shine lambobin da lambobi fiye da 11 suka canza zuwa ilimin kimiyya (ko mahimmanci) - kamar yadda aka nuna a cell A2 a cikin hoto a sama.

Hakazalika, Tsarin Lambar yana iyakance ga nuna lambobin lambobi 15 a tsawon. Duk wasu lambobi fiye da iyakokin suna iyakance har zuwa baƙi.

A cikin salula A3 a sama, lambar ta 1234567891234567 an canza zuwa 123456789123450 lokacin da aka saita tantanin halitta don tsarawar lambobi.

Amfani da Bayanan Rubutun cikin Formulas da Ayyuka

Hakanan, idan aka yi amfani da tsarin rubutu - cell A4 a sama - daidai wannan adadi daidai, kuma, tun da halin haɓakar kowane tantanin halitta don tsarin rubutun shine 1,024, yana yiwuwa kawai lambobi marasa amfani kamar Pi (Π) da Phi (%) wanda ba za a iya bayyana a cikin su ba.

Bugu da ƙari ga adana lambar daidai da yadda aka shigar da shi, lambobin da aka tsara a matsayin rubutu za su iya amfani da su ta hanyar amfani da ma'anar lissafin ilmin lissafi - kamar ƙara da kuma cirewa kamar yadda aka nuna a cell A8 a sama.

Ba za su iya amfani da su ba, amma suna yin amfani da shi a lissafi tare da wasu ayyuka na Excel - irin su SUM da AVERAGE , yayin da kwayoyin da ke dauke da bayanai suna bi da komai kuma sun dawo:

• sakamakon sakamakon zero ga SUM - cell A9
• Ƙimar kuskure # DIV / 0! don BINKAR - cell A10

Matakai na Tsarin Sanya don Rubutu

Kamar yadda yake tare da wasu samfurori, yana da muhimmanci a tsara tantanin tantanin halitta don bayanan rubutu kafin shigar da lambar - in ba haka ba, tsarin halin yanzu zai shafi shi.

1. Danna kan tantanin halitta ko zaɓi wani yanki na sel wanda kake son juyawa zuwa tsarin rubutu
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin ƙusa kusa da akwatin Lambar Hakan - nuni Janar ta tsoho - don buɗe jerin menu na zabin menu
4. Gungura zuwa kasan menu kuma danna maɓallin Rubutun - babu ƙarin zaɓuɓɓuka don tsarin rubutu

Rubutu zuwa Hagu, Lissafi zuwa Dama

Abubuwan da ke gani don taimaka maka ƙayyadadden tsarin tantanin halitta shi ne ya dubi daidaitaccen bayanan.

By tsoho a Excel, an haɗa bayanan rubutu a gefen hagu a cikin tantanin halitta da lambar lamba a dama. Idan daidaiton tsoho don tsayayyar kewayon azaman rubutu ba a canza ba, lambobin da aka shiga cikin wannan ɗakin ya kamata a nuna su a gefen hagu na sel kamar yadda aka nuna a cikin C5 a cikin hoton da ke sama.

Bugu da ƙari, kamar yadda aka nuna a cikin kwayoyin A4 zuwa A7, lambobin da aka tsara a matsayin rubutu zasu nuna wani karamin tabarun kore a cikin hagu na hagu na tantanin halitta wanda yake nuna cewa ana iya tsara bayanai ba daidai ba.