Cov kev xaiv yog qhov txheej txheem ntawm kev tsim cov khoom hauv ib qho kev sib lawv liag lossis kev txiav txim raws li cov cai.
Hauv kev tshaj tawm cov ntawv tshaj tawm xws li Excel thiab Google Spreadsheets, muaj ntau ntau yam kev txiav txim siab txawv txav nyob ntawm seb cov hom ntaub ntawv raug xa tawm.
Tshaj tawm thiab tshem tawm Tsi Txiav Txim
Rau cov ntawv nyeem lossis cov zauv muaj nuj nqis , qhov kev xaiv ob txoj kev xaiv yog nce thiab nqis .
Nyob ntawm seb hom ntawm cov ntaub ntawv nyob hauv cov kev xaiv ntau, cov kev xaj xaiv no yuav txheeb cov ntaub ntawv raws li hauv qab no:
Rau ascending xaiv:
- Tsi A rau Z - rau cov ntaub ntawv qhia
- Tsi Tshaj Tawm rau Tsawg tshaj plaws - rau cov ntaub ntawv xov tooj
- Tsi qub tshaj plaws rau Newest - rau cov ntaub ntawv hnub tim lossis sijhawm
Rau nqis nqis:
- Tsi A rau Z - rau cov ntaub ntawv qhia
- Tsi ntau tshaj plaws rau Smallest - rau cov ntaub ntawv xov tooj
- Tsi Newest rau Qub - rau cov ntaub ntawv hnub tim lossis sijhawm
Cov kab zauv thiab txhua kab thiab qhov sib txawv
Cov kab zauv thiab txhua kab ntawm cov ntaub ntawv tsis tau tsiv tawm thaum faib, vim li ntawd lawv yuav tsum tau ua tsis tau ua ntej qhov khoob qhov chaw.
Piv txwv, yog hais tias kab 7 yog muab zais, thiab nws yog ib feem ntawm cov ntaub ntawv uas tau muab txheeb tseg, nws yuav nyob twj ywm raws li kab 7 es tsis tau tsiv mus rau nws qhov chaw nyob qhov tseeb ntawm qhov sib txawv.
Tib yam mus rau txhua kab lus. Xaiv qhov ntawm kab yog qhov rov qab ntawm txhua cov ntaub ntawv, tab sis yog tias Kem B yog muab zais ua ntej qhov kev sib txawv, nws yuav nyob raws li Kem B thiab tsis raug kho dua nrog rau txhua kab hauv qhov kev sib txawv sorted.
Xaiv los ntawm Xim thiab Txiav Orders
Ntxiv rau qhov kev faib tawm los ntawm qhov tseem ceeb, xws li cov ntawv nyeem lossis cov zauv, Excel muaj kev cai xaiv cov kev xaiv uas tso kev cais los ntawm cov xim rau:
- ntawv lossis xim xim;
- cell xim ;
- conditional formatting icons .
Txij li thaum tsis muaj ib qho nqi lossis nce txog xim, tus neeg siv lub npe ntawm cov xim xaiv nyob rau hauv lub Thawv xaiv khij .
Tsi Tshaj Tawm Tseg
Source: Ntaus cim txiav txim
Feem ntau cov kev tshaj tawm hauv khoos phis tawj tau siv cov kev txiav txim raws li nram qab no rau ntau hom ntaub ntawv.
Cov Kab Xev Plaub Hlis : Hauv ob qho tibsi ascending thiab descending order xaj, cov hlwb dawb yeej ib txwm muab tso rau yav tas los.
Numbers : Cov naj npawb tsis zoo yog xam qhov tseem ceeb tshaj plaws, yog li qhov loj tshaj plaws tus naj npawb yeej tuaj yeem ua ntej nyob rau hauv qhov kev txiav txim ascending tseev thiab kawg nyob hauv kev txo nqis, xws li:
Haum Xaj Txiav: -3, -2, -1,0,1,2,3
Txiav Txiav: 3,2,1,0, -1, -2, -3
Cov Hnub : Lub hnub nyoog tshaj plaws yog xav tias tsawg dua tus nqi qis dua lossis tsawg tshaj hnub kawg los yog hnub tim tshiab.
Txiav Txiav (qhov tshaj tawm rau yav dhau los): 1/5/2000, 2/5/2000, 1/5/2010, 1/5/2012
Txiav Txim Tsis Tau Tshaj (qhov tsis ntev los no dhau los): 1/5/2012, 1/5/2010, 2/5/2000, 1/5/2000
Alphanumeric Data : Ib tug ua ke ntawm cov tsiaj ntawv thiab cov zauv, cov ntaub ntawv alphanumeric yog kho raws li cov ntaub ntawv qhia thiab txhua tus cwj pwm yog txheeb los ntawm sab laug mus rau sab xis ntawm tus ua cim los ntawm tus cwj pwm.
Rau cov ntaub ntawv alphanumeric, cov zauv pom tau tias yog tsawg dua tus nqi ntawv.
Rau cov ntaub ntawv li hauv qab no, 123A, A12, 12AW, thiab AW12 qhov kev txiav txim siab ascending:
123A 12AW A12 AW12Txiav txim raws li kev txiav txim yog:
AW12 A12 12AW 123ANyob rau hauv tsab xov xwm Yuav ua li cas txheeb xyuas cov ntaub ntawv nyob hauv Excel , nyob hauv lub website Microsoft.com, qhov kev txiav txim nram qab no yog muab rau cov cim nyob hauv cov ntaub ntawv alphanumeric:
0 1 2 3 4 5 6 7 8 9 (qhov chaw)! "# $% & () *,. /:; @ [\] ^ _" {|} ~ + <=> ABCDEFGHIJKLMNOPQRSTU VWXYZLogical lossis Boolean Cov Ntaub Ntawv : Qhov tseeb lossis qhov tseeb yog qhov tseem ceeb, thiab CAUM yog pom tias tsawg dua hauv qhov tseeb dua TRUE.
Rau cov ntaub ntawv nram qab no, TRUE, CEEB TOOM, TXOJ CAI, thiab CUIM qhov ua raws li kev txiav txim siab yog:
CUAV TXAWV TSEEM CEEB TRUETxiav txim raws li kev txiav txim yog:
TRUE
TSEEM CEEB CEEV CIA