Page 48 - Play v1.0 gujarati class 7
P. 48

III.  ‚k[k {kxu ‘T’ y™u ¾kuxk {kxu ‘F’ ÷¾ku.

                        1.  Ëhuf ‚qºk yuf r[öÚke þY ÚkkÞ Au                                                  .....................
                        2.  ‚tÞwõŒ huVhuL‚ ‚u÷ huVhuL‚™ku yuf «fkh Au,                                       .....................
                        3.   LEN( ) Vtõþ™ xuõMx™e ÷tƒkE yk…u Au.                                             .....................

                        4.   TODAY( ) Vtõþ™ ðŒo{k™ Œkhe¾ yk…u Au                                             .....................

                  IV.  «&™kuLkk xqtf{kt sðkçk ÷¾ku.
                        1.  ‚u÷ huVhuL‚ þwt Au?
                            ..........................................................................................................................................................................................

                        2.  CONCATENATE( ) Vtõþ™™ku W…Þku„ þwt Au?
                            ..........................................................................................................................................................................................

                        3.   Œkhe¾ y™u ‚{Þ™kt Vtõþ™ yux÷u þwt ? fkuE…ý ƒu Œkhe¾ y™u ‚{Þ™k Vtõþ™ ™k ™k{ ÷¾ku
                            ..........................................................................................................................................................................................
                  V.    «&™kuLkk rðMík]ík sðkçk ÷¾ku.

                        1.  LEN Vtõþ™™ku W…Þku„ þwt Au? WËknhý ‚kÚku ‚{òðku.
                        2.  Vtfþ™ Ëk¾÷ fhðk™k r™Þ{ku þwt Au?

                        3.  ‚qºk y™u Vtõþ™ ðå[u þwt ŒVkðŒ Au? WËknhýku yk…ku.

                                                                                                    I nter- D is cip l ina ry
                                                                ÷uçk {kt


                     MS Excel {kt ‚{k™ INVOICE ƒ™kðku.














                         •  …kt[ ðMŒwyku, Œu{™e {kºkk y™u yuf{™k ¼kðku™e rð„Œku ¼hku.
                         •  PRODUCT Vtõþ™™ku W…Þku„ fhe™u, Ëhuf ðMŒw {kxu hf{™e „ýŒhe fhku.
                         •  SUM Vtõþ™™ku W…Þku„ fhe™u, fw÷ hf{™e „ýŒhe fhku.
                         •  ‚qºk™ku W…Þku„ fhe™u, yk…u÷ Ëh {wsƒ GST ™e „ýŒhe fhku.

                         •  [qfððk…kºk INVOICE ™k hf{™e „ýŒhe fhku.







                    1. MS Excel îkhk rðãkÚkeoyku™u …qhk …kzðk{kt ykðu÷k rðrðÄ «fkh™k Vtõþ™ ‚{òðku.
                    2. yk «fhý{kt ykðhe ÷uðkÞu÷k Œ{k{ {wÆk rðþu ‚{òðku




                  46      M od ul ar ( V er  1 . 0 ) - V I I
                                      .
   43   44   45   46   47   48   49   50   51   52   53