Page 17 - Math_Genius_1 2

2 ,Dlsy dh mUur fo'ks"krk,¡

(Advanced Features of Excel)

vkidk y{;

fuEu osQ fo"k; esa tkuuk %
lkWfV±x MsVk fiQYVfjax MsVk

oaQfM'kuy iQkWesZ¯Vx ooZQ'khV fçaV djuk

vkius ,Dlsy ooZQ'khV dks iQkWeZsV djuk lh• fy;k gSA eku yhft, fd vkidks mu lsy (Cells) dks gkbykbV djuk

gS ftuesa fdlh fo'ks"k eku ls vf/d eku gSa vFkok vkjksgh@vojksgh Øe esa MsVk lkWVZ djuk gSA
,Dlsy vkidks ooZQ'khV ij bl çdkj dh iQkWeZsfVax djus osQ fy, vklku fodYi çnku djrk gSA

lkWfV±x MsVk (Sorting Data)
,Dlsy p;fur MsVk dks vkjksgh ;k vojksgh Øe esa Js.khc¼ ;k O;ofLFkr dj ldrk gSA bls MsVk
lkWfV±x (Sorting) dgk tkrk gSA MsVk lkWVZ djus osQ fy,] bu LVsIl dk ikyu djsa%

LVsi 1 lkWVZ fd, tkus okys MsVk dk p;u djsaA voxhZÑr MsVk
(Unsorted data)
LVsi 2 MªkWi&Mkmu lwph •ksyus osQ fy, gkse (Home) VSc osQ varxZr laiknu (Editing) lewg ls
lkWVZ vkSj fiQYVj (Sort & Filter) dekaM ij fDyd djsaA

lkWVZ vkSj fiQYVj dekaM dk mi;ksx djuk (Using Sort & Filter command)
LVsi 3 MsVk dks vkjksgh Øe esa Øec¼ djus osQ fy, A ls Z (VsDLV osQ fy,) vkSj lcls
NksVs ls lcls cM+s (la[;kvksa osQ fy,) dks Øec¼ djsa ij fDyd djsaA p;fur MsVk

dks vkjksgh Øe esa O;ofLFkr fd;k tkrk gSA Øec¼ MsVk
(Sorted data)
dLVe lkWVZ (Custom Sort)
;fn ,d ls vf/d dkWye dks bl çdkj dLVe lkWVZ fd;k tkuk gS fd igyk dkWye vkjksgh Øe (Ascending
Order) esa gS vkSj ;fn oqQN MsVk ,d ls vf/d jks”k (Rows) osQ fy, leku gSa] rks ,slh jks”k osQ nwljs dkWye dks
vojksgh Øe esa dLVe lkWVZ fd;k tkrk gSA vki bls dLVe lkWVZ dk mi;ksx djosQ ,Dlsy esa dj ldrs gSaA
dLVe lkWVZ dk mi;ksx djus osQ fy,] bu LVsIl dk ikyu djsa%

LVsi 1 lkWVZ fd, tkus okys dkWye dh Js.kh dk p;u djsaA
LVsi 2 ,d Mkmu lwph •ksyus osQ fy, gkse VSc osQ varxZr laiknu lewg ls lkWVZ vkSj fiQYVj dekaM ij fDyd
djsaA

,Dlsy dh mUur fo'ks"krk,¡ 15