Amfani da Takaddun Yanki a cikin Shafukan Lissafi na Excel

Tsarin shi ne tsari na shirya abubuwa a cikin wani jerin ko tsara tsari bisa ga dokoki.

A cikin shirye-shiryen sassauki irin su Excel da Google Spreadsheets, akwai wasu nau'o'in nau'i daban-daban na samuwa dangane da irin bayanan da aka tsara.

Ƙaddamar da Ƙa'idar Tsara ta Musamman

Domin rubutun ko lambobi, lambobin biyun suna hawa da sauka .

Dangane da irin bayanai a cikin zaɓin da aka zaɓa, waɗannan umarni irin wannan za su raba bayanai da hanyoyi masu zuwa:

Don hawan nauyin:

Don saukowa:

Hannun da aka boye da ginshiƙai da rarrabawa

An ba da sahun zane da ginshiƙan bayanai ba a yayin da ake rarraba ba, don haka suna buƙatar zama marasa lafiya kafin irin wannan ya faru.

Alal misali, idan jere 7 yana ɓoye, kuma yana cikin ɓangaren bayanai da aka tsara, zai kasance a matsayin jere 7 maimakon komawa zuwa wurin da yake daidai saboda sakamakon.

Haka yake don ginshikan bayanai. Kashewa ta hanyar layuka ya haɗa da canza ginshiƙan bayanai, amma idan Shafin B yana ɓoye kafin wannan, zai kasance a matsayin Column B kuma ba za a sake komawa tare da sauran ginshiƙai a cikin jeri ba.

Ƙaddara ta Ƙawwalwa da Ƙaddara

Bugu da ƙari da rarraba ta dabi'u, kamar rubutu ko lambobi, Excel yana da al'ada al'ada da zaɓuɓɓukan da za su yarda izuwa ta launi don:

Tun da babu wani hawan hawa ko saukowa don launuka, mai amfani yana bayyana tsari irin launi a cikin akwatin maganganu .

Tsara Faɗakar Taɓa

Source: Tsohon tsari

Yawancin shirye-shiryen bayanan rubutu sunyi amfani da umarnin irin wannan tsoho don daban-daban na bayanai.

Cells Blank : A cikin haɗuwa da saukowa irin tsari, an saka Kwayoyin tsararru a karshe.

Lissafi : Lambobi marasa mahimmanci ana la'akari da ƙananan dabi'un, saboda haka yawancin lambar ƙira ya zo da farko a cikin tsari mai girma da kuma ƙarshe a cikin tsari mai sauƙi, kamar:
Dokar Tsara: -3, -2, -1,0,1,2,3
Order mai zuwa: 3,2,1,0, -1, -2, -3

Dates : Mafi yawan kwanan wata an dauke su da ƙananan darajar ko ƙananan fiye da kwanan nan ko kwanan wata.
Lissafin Hawan (mafi tsufa zuwa kwanan nan): 1/5/2000, 2/5/2000, 1/5/2010, 1/5/2012
Dokar Tafiya (mafi yawan kwanan nan zuwa mafi tsufa): 1/5/2012, 1/5/2010, 2/5/2000, 1/5/2000

Alphanumeric Data : Haɗuwa da haruffa da lambobi, bayanai masu alphanumeric ana bi da su azaman bayanan rubutu kuma kowane hali yana ana jerawa daga hagu zuwa dama a kan hali ta hanyar halayyar mutum.

Don alphanumeric data, lambobi suna dauke su kasance na ƙarami daraja fiye da characters haruffa.

Don wadannan bayanan, 123A, A12, 12AW, da AW12 tsari mai girma shine:

123A 12AW A12 AW12

Sakamakon wannan tsari shine:

AW12 A12 12AW 123A

A cikin labarin Yayinda za a samar da cikakkun bayanai na alphanumeric a Excel , wanda ke kan shafin yanar gizon Microsoft.com, ana ba da wannan tsari na musamman don haruffan da aka samu a cikin alphanumeric data:

0 1 2 3 4 5 6 7 8 9 (sarari)! "# $% & () *, / /;; @ [\] ^ _` {|} ~ + <=> ABCDEFGHIJKLMNOPQRSTU VWXYZ

Faɗakarwa ko Boolean Data : TRUE ko FALSE kawai, kuma FALSE aka la'akari da ƙarami a darajar fiye da TRUE.

Don wadannan bayanan, TRUE, FALSE, TRUE, da FALSE irin tsari mai girma shine:

FALSE FALSE TRUE TRUE

Sakamakon wannan tsari shine:

Gaskiya

FALSE FALSE