Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 20 - Math_Genius_1 2
P. 20

    MsVk dh  Ük`a•yk esa iQkWesZ¯Vx ykxw djus osQ fy,] bu LVsIl dk ikyu djsa%
                      LVsi 1  ml MsVk dk p;u djsa ftl ij iQkWesZ¯Vx ykxw fd;k tkuk gSA

                      LVsi 2  MªkWi&Mkmu lwph •ksyus osQ fy, gkse VSc osQ varxZr LVkbYl lewg ls oaQfM'kuy iQkWesZ¯Vx (Conditional
                              Formatting) vkns'k ij fDyd djsaA ;g lwph fofHkUu ekunaM (Criteria) fn•krh gS tSls%
                               •   gkbykbV lsy fu;e (Highlight Cells Rules) & ;g fodYi rc pquk tkrk gS tc vki fdlh nh xbZ
                                  'krZ dks iwjk djus okys lHkh lsy dks gkbykbV djuk pkgrs gSaA tc vki bl fodYi ij ekml ?kqekrs gSa] rks
                                  ;g ,d mi&lwph •ksyrk gS tks ØkbVsfj;k fn•krk gS tSls xzsVj Fkku] ySl nSu] bDoy Vw] fcVohu] vkfnA
                               •   VkWi@ckWVe #Yl (Top/Bottom Rules)& ;g fodYi rc pquk tkrk gS] tc vki fdlh MsVk  Ük`a•yk
                                  esa oqQN 'kh"kZ ;k fupys vkbVe dks gkbykbV djuk pkgrs gSaA tc vki bl fodYi ij ekml ?kqekrs
                                  gSa] rks ;g ,d mi&lwph •ksyrk gS ftlesa 'kh"kZ 10 vkbVe] 'kh"kZ 10»] uhps 10 vkbVe] uhps 10»]
                                  vkfn tSls ØkbVsfj;k fn•kbZ nsrs gSaA
                               •   MsVk cklZ (Data Bars)& ;g fodYi rc pquk tkrk gS tc vki la[;kRed MsVk okys lsy esa MsVk
                                  ckj tksM+uk pkgrs gSaA tc vki bl fodYi ij ekml ?kqekrs gSa] rks ;g ,d mi&lwph •ksyrk gS ftlesa
                                  fofHkUu çdkj vkSj jaxksa osQ ckj fn•k, tkrs gSa ftUgsa lsyksa esa tksM+k tk ldrk gSA
                               •   dyj LosQy (Colour Scales)& ;g fodYi rc pquk tkrk gS] tc vki lHkh p;fur lsyksa esa jax
                                  ;kstukvksa dks tksM+uk pkgrs gSa tks /hjs&/hjs Åij ls uhps dh oLrqvksa esa fHkUu gksrs gSaA tc vki bl
                                  fodYi ij ekml ?kqekrs gSa] rks ;g ,d mi&lwph •ksyrk gS ftlesa fofHkUu jax fHkUurk,¡ fn•kbZ nsrh
                                  gSa] ftUgsa lsyksa esa tksM+k tk ldrk gSA
                               •   vkbdu lsV (Icon Sets)& ;g fodYi rc pquk tkrk gS] tc vki ;g fn•kus osQ fy, vkbdu lsV
                                  tksM+uk pkgrs gSa fd dkSu ls lsy Lohdk;Z gSa] dkSu ls eè;e gSa vkSj ftu ij è;ku nsus dh vko';drk
                                  gSA tksM+s tk ldus okys fofHkUu çdkj osQ vkbdu lsV mi&lwph esa fn•k, tkrs gSa] tks bl fodYi
                                  ij ekml dks ?kqekus ij •qyrs gSaA

                                                  oaQMh'kuy iQkWesZ¯Vx dk mi;ksx djuk (Using Conditional Formatting)
                      p;fur oaQMh'kuy iQkWesZ¯Vx p;fur lsy Js.kh ij ykxw gksrk gSA vki oaQfM'kuy
                      iQkWesZ¯Vx MªkWi&Mkmu lwph ls u;k fu;e fodYi pqudj d{kksa dks gkbykbV

                      djus osQ fy, viuk Lo;a dk fu;e Hkh ifjHkkf"kr dj ldrs gSaA
                      MsVk Js.kh ij ykxw oaQMh'kuy iQkWesZ¯Vx lqfo/kvksa dks oaQMh'kuy iQkWesZ¯Vx MªkWi&Mkmu
                      lwph ls fDy;j :y fodYi dk p;u djosQ fDy;j fd;k tk ldrk gSA

                                                                                                     l'krZ Lo:i.k ykxw
                          oZd'khV fçaV djuk  (Printing a Worksheet)             oaQI;wVj        (Conditional Formatting applied)
                      ooZQ'khV fçaV djus osQ fy,] bu LVsIl dk ikyu djsa%
                      LVsi 1  ml MsVk dh Js.kh dk p;u djsa] ftls vki fçaV djuk

                              pkgrs gSa vkSj fiQj fDod ,Dlsl Vwyckj MªkWi&Mkmu                    fçaV Mk;ykWx ckWDl •ksyus
                              lwph ls fçaV izhO;w vkSj fçaV vkbdu ij fDyd djsaA        Kku        osQ fy, Ctrl $ P dht
                                                ;k
                                                                                                  nck,¡A

                         18  Play (Ver. 1.0)-VIII

| 15 16 17 18 19 20 21 22 23 24 25 |