Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 17 - Math_Genius_1 2
P. 17

    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

| 12 13 14 15 16 17 18 19 20 21 22 |