{"id":2912,"date":"2021-09-14T02:33:38","date_gmt":"2021-09-14T02:33:38","guid":{"rendered":"https:\/\/seekhomujhse.in\/data-entry-in-excel-worksheet-in-hindi\/"},"modified":"2025-12-11T17:10:24","modified_gmt":"2025-12-11T17:10:24","slug":"data-entry-in-excel-worksheet-in-hindi","status":"publish","type":"post","link":"https:\/\/seekhomujhse.in\/en\/data-entry-in-excel-worksheet-in-hindi\/","title":{"rendered":"MS EXCEL WORKSHEET \u092e\u0947\u0902 DATA ENTRY  \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 ? (DATA ENTRY IN EXCEL WORKSHEET IN HINDI)"},"content":{"rendered":"<p><br>\u0906\u092a\u0928\u0947 \u092e\u0947\u0930\u0947 \u092a\u0939\u0932\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 MS EXCEL \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u092a\u0922\u093c\u093e \u0939\u094b\u0917\u093e\u0964 \u0905\u0917\u0930 \u0928\u0939\u0940\u0902 \u092a\u0922\u093c\u093e \u0939\u0948 \u0924\u094b <strong><a href=\"https:\/\/seekhomujhse.in\/en\/inroduction-to-msexcel-in-hindi\/\">MS EXCEL \u0915\u094d\u092f\u093e \u0939\u0948 ?<\/a><\/strong> \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u092a\u0922\u093c \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p> \u092a\u0939\u0932\u0947 \u092a\u094b\u0938\u094d\u091f \u0938\u0947 \u0906\u092a MS EXCEL \u0938\u0947 \u092a\u0930\u093f\u091a\u093f\u0924 \u0939\u0941\u090f \u0939\u094b\u0902\u0917\u0947\u0964 \u0906\u091c \u0915\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902  \u0906\u092a MS EXCEL \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0925\u094b\u0921\u093c\u093e \u0914\u0930 \u0905\u0927\u094d\u092f\u092f\u0928 \u0915\u0930\u0947\u0902\u0917\u0947\u0964 \u0906\u091c \u0915\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 \u0939\u092e MS EXCEL WORKSHEET \u092e\u0947\u0902 DATA ENTERY  \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0938\u0940\u0916\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<p>\u091a\u093e\u0939\u0947 \u0906\u092a \u0915\u093f\u0938\u0940 \u092d\u0940 \u0915\u094d\u0937\u0947\u0924\u094d\u0930 \u092e\u0947\u0902 \u0915\u093e\u092e \u0915\u0930\u0924\u0947 \u0939\u094b\u0902 \u0935\u0939\u093e\u0901  \u092a\u0930 DATA ENTRY  \u092e\u0939\u0924\u094d\u0935\u092a\u0942\u0930\u094d\u0923 \u0939\u094b\u0924\u093e \u0939\u0948\u0964 \u0939\u092e \u0906\u091c \u0915\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0938\u093e\u0927\u093e\u0930\u0923 \u0909\u0926\u093e\u0939\u0930\u0923 \u0938\u0947 \u0936\u0941\u0930\u0941\u0906\u0924 \u0915\u0930\u0947\u0902\u0917\u0947 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u0928\u0947 \u0935\u093e\u0932\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 \u0939\u092e \u0915\u0920\u093f\u0928 \u0909\u0926\u093e\u0939\u0930\u0923\u094b\u0902 \u0915\u094b \u092d\u0940 \u0932\u0947\u0902\u0917\u0947 \u0938\u093e\u0925 \u0939\u0940 MIS \u092d\u0940 \u092c\u0928\u093e\u0928\u093e \u0938\u0940\u0916\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<p>\u0924\u094b \u091a\u0932\u093f\u090f \u0936\u0941\u0930\u0942 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 :-<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/SA-1.jpg\" alt=\"\" class=\"wp-image-2011\" width=\"645\" height=\"525\"\/><figcaption>DATA ENTRY IN EXCEL WORKSHEET<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET  \u092e\u0947\u0902 DATA ENTRY  \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948 ? \u0938\u0940\u0916\u0947\u0902\u0964<\/strong><\/h2>\n\n\n\n<p>\u0905\u092c \u0906\u092a Row \u0924\u0925\u093e Column \u0938\u0947 \u092a\u0930\u093f\u091a\u093f\u0924 \u0939\u094b \u091a\u0941\u0915\u0947 \u0939\u0948\u0902\u0964 Row \u0924\u0925\u093e column \u0915\u0940 \u0935\u093f\u0938\u094d\u0924\u0943\u0924 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092e\u0948\u0902\u0928\u0947 \u0905\u092a\u0928\u0947 \u092a\u0939\u0932\u0947 \u092a\u094b\u0938\u094d\u091f<a href=\"https:\/\/seekhomujhse.in\/en\/\"> <strong>\u090f\u0915 \u092a\u0930\u093f\u091a\u092f : MS EXCEL \u0938\u0947<\/strong><\/a> \u092e\u0947\u0902 \u0926\u0940 \u0939\u0948\u0964<\/p>\n\n\n\n<p> MS EXCEL \u0936\u0940\u091f \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u092a\u0941\u091f \u0915\u094b \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u090f\u0915 \u0938\u093e\u0927\u093e\u0930\u0923 \u0909\u0926\u093e\u0939\u0930\u0923 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p> \u090f\u0915 \u0935\u093f\u0926\u094d\u092f\u093e\u0932\u092f XYZ \u0939\u0948 , \u0907\u0938 \u0935\u093f\u0926\u094d\u092f\u093e\u0932\u092f \u0915\u0947 \u0928\u0935\u092e\u0940 \u0915\u0947 \u091b\u093e\u0924\u094d\u0930\u094b\u0902 \u0915\u093e \u0930\u093f\u091c\u0932\u094d\u091f \u0906\u092f\u093e \u0939\u0948 \u0914\u0930 \u0939\u092e\u0947 DATA ENTRY  \u0915\u0930\u0928\u093e \u0939\u0948 \u0915\u093f  \u0915\u093f\u0924\u0928\u0947 \u091b\u093e\u0924\u094d\u0930 \u092a\u093e\u0938 \u0939\u0941\u090f \u0939\u0948,\u0915\u093f\u0924\u0928\u0947 \u092b\u0947\u0932 \u0939\u0941\u090f \u0939\u0948\u0902 ,\u0909\u0928\u0915\u093e \u0917\u094d\u0930\u0947\u0921 \u0915\u094d\u092f\u093e \u0939\u0948 ? <\/p>\n\n\n\n<p>\u0924\u094b \u091a\u0932\u093f\u090f \u0939\u092e \u0926\u0947\u0916\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0939\u092e \u0907\u0938\u0947 \u0915\u0948\u0938\u0947 \u0924\u0948\u092f\u093e\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 MS EXCEL WORKSHEET  \u0915\u0947 ROW \u092e\u0947\u0902 \u0939\u092e \u0938\u093e\u0930\u0947 \u091b\u093e\u0924\u094d\u0930\u094b\u0902 \u0915\u093e \u0928\u093e\u092e \u0932\u093f\u0916\u0947\u0902\u0917\u0947 , \u0915\u0949\u0932\u092e \u092e\u0947\u0902 \u0935\u093f\u0937\u092f\u094b\u0902 \u0915\u094b \u0930\u0916\u0947\u0902\u0917\u0947 , \u0935\u093f\u0937\u092f\u094b\u0902 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e \u090f\u0915 \u0915\u0949\u0932\u092e \u091f\u094b\u091f\u0932 \u0915\u093e ,\u090f\u0915 \u0930\u093f\u091c\u0932\u094d\u091f \u0915\u093e \u0924\u0925\u093e \u090f\u0915 \u0917\u094d\u0930\u0947\u0921 \u0915\u093e \u092c\u0928\u093e\u090f\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<p> \u091a\u093f\u0924\u094d\u0930  \u0926\u0947\u0916\u0947\u0902  &#8211;<\/p>\n\n\n\n<p>\u0938\u092d\u0940 \u091b\u093e\u0924\u094d\u0930\u094b\u0902 \u0915\u093e \u0928\u093e\u092e \u0932\u093f\u0916\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0905\u0902\u0924\u093f\u092e ROW \u092e\u0947\u0902 \u0939\u092e \u091f\u094b\u091f\u0932 \u0932\u093f\u0916\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<p>\u092a\u0941\u0930\u0947  MS EXCEL \u0936\u0940\u091f \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY Ctrl+A \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0947\u0902 \u0964<\/p>\n\n\n\n<p> \u092b\u093f\u0930 \u0938\u092d\u0940 Row \u0924\u0925\u093e \u0915\u0949\u0932\u092e \u092e\u0947\u0902 \u092c\u0949\u0930\u094d\u0921\u0930 \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0936\u0949\u0930\u094d\u091f\u0915\u091f key Alt H B A  \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0947\u0902<\/p>\n\n\n\n<p>\u0914\u0930 \u0938\u092d\u0940 CELL \u0915\u094b \u090f\u0921\u091c\u0938\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY Alt H O I \u0915\u093e \u092a\u094d\u0930\u092f\u094b\u0917 \u0915\u0930\u0947\u0902\u0964  <\/p>\n\n\n\n<p>( <span class=\"has-inline-color has-vivid-cyan-blue-color\"><strong>\u0928\u094b\u091f \u0915\u0930\u0947\u0902<\/strong> :- \u0905\u0917\u0930 \u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY \u092c\u0924\u093e\u0928\u0947 \u092e\u0947\u0902 ( + ) \u091a\u093f\u0928\u094d\u0939 \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u093f\u092f\u093e \u091c\u093e \u0930\u0939\u093e \u0939\u0948 \u0924\u094b  \u0907\u0938\u0915\u093e \u092e\u0924\u0932\u092c \u0939\u0948 \u0915\u093f  \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u0947 \u0917\u090f KEY  \u0915\u094b \u0938\u093e\u0925 \u092e\u0947\u0902 \u0926\u092c\u093e\u0928\u093e \u0939\u0948\u0964 <\/span><\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-cyan-blue-color\">\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0940 \u0924\u094c\u0930 \u092a\u0930 Ctrl + A \u0915\u093e \u0905\u0930\u094d\u0925 \u0939\u0948 \u0915\u093f Ctrl \u0914\u0930 A \u0915\u094b \u0938\u093e\u0925 \u092e\u0947\u0902 \u0926\u092c\u093e\u090f\u0902\u0964 <\/span><\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-cyan-blue-color\">\u0905\u0917\u0930 \u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY  \u092c\u0924\u093e\u0928\u0947 \u092e\u0947\u0902 ( + ) \u091a\u093f\u0928\u094d\u0939 \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u091c\u093e \u0930\u0939\u093e \u0939\u0948 \u0924\u094b \u0907\u0938\u0915\u093e \u092e\u0924\u0932\u092c \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u0947 \u0917\u090f KEY \u0915\u094b \u090f\u0915 \u090f\u0915 \u0915\u0930 \u0926\u092c\u093e\u0928\u093e \u0939\u0948\u0964<\/span><\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-cyan-blue-color\"> \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0924\u094c\u0930  \u092a\u0930 Alt H O I \u0915\u093e \u092e\u0924\u0932\u092c \u0939\u0948 \u092a\u0939\u0932\u0947 Alt \u0926\u092c\u093e\u090f\u0902 ,\u092b\u093f\u0930  H \u0926\u092c\u093e\u092f\u0947\u0902<\/span><\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-cyan-blue-color\"> ,\u092b\u093f\u0930 O \u0926\u092c\u093e\u092f\u0947\u0902 \u0914\u0930 \u0905\u0902\u0924 \u092e\u0947\u0902 I \u0926\u092c\u093e\u092f\u0947\u0902\u0964<\/span>  )  <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">DATA ENTRY <\/h3>\n\n\n\n<p>\u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY \u0915\u093e \u092e\u0939\u0924\u094d\u0935 \u092e\u0948\u0902\u0928\u0947 \u0905\u092a\u0928\u0947 \u092a\u0939\u0932\u0947 \u092a\u094b\u0938\u094d\u091f <strong>\u090f\u0915 \u092a\u0930\u093f\u091a\u092f : MS EXCEL \u0938\u0947 <\/strong>\u092e\u0947\u0902 \u092c\u0924\u093e\u092f\u093e \u0939\u0941\u0906 \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0938\u092d\u0940 \u091b\u093e\u0924\u094d\u0930\u094b\u0902 \u0924\u0925\u093e \u0935\u093f\u0937\u092f\u094b\u0902 \u0915\u094b \u0932\u093f\u0916\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0905\u092c \u0939\u092e \u0909\u0928 \u091b\u093e\u0924\u094d\u0930\u094b\u0902 \u0926\u094d\u0935\u093e\u0930\u093e \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u093f\u092f\u0947 \u0917\u090f \u0905\u0902\u0915\u094b \u0915\u094b \u0932\u093f\u0916\u0947\u0902\u0917\u0947\u0964 \u0905\u0902\u0915\u094b \u0915\u094b \u0932\u093f\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u0938\u0947\u0932 B2 \u0938\u0947 \u0932\u0947\u0915\u0930 CELL F11 \u0924\u0915 \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930 \u0932\u0947\u0902 <\/p>\n\n\n\n<p>\u0914\u0930 \u092b\u093f\u0930 \u0905\u0902\u0915\u094b \u0915\u094b \u092a\u094d\u0930\u0935\u093f\u0937\u094d\u091f \u0915\u0930\u0947\u0902 \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u092a\u0930 \u0906\u092a\u0915\u094b \u092c\u093e\u0930 \u092c\u093e\u0930 ARROW \u092c\u091f\u0928 \u0926\u092c\u093e\u0928\u0947 \u0915\u0940 \u091c\u0930\u0941\u0930\u0924 \u0928\u0939\u0940\u0902 \u092a\u0921\u093c\u0947\u0917\u0940\u0964 <\/p>\n\n\n\n<p>\u090f\u0915 \u092c\u093e\u0930 \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u093c\u0947\u0902\u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/GM.jpg\" alt=\"\" class=\"wp-image-2013\"\/><figcaption><strong>DATA ENTRY IN EXCEL WORKSHEET<\/strong><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET  \u092e\u0947\u0902 \u0915\u0948\u0938\u0947 \u091c\u094b\u0921\u093c\u0924\u0947  \u0939\u0948\u0902  ? \u0938\u0940\u0916\u0947\u0902\u0964<\/strong><\/h3>\n\n\n\n<p>\u0915\u094d\u092f\u093e \u0906\u092a\u0915\u094b \u092a\u0924\u093e \u0939\u0948 \u0915\u093f MS EXCEL \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f\u0930 \u0915\u0947 \u0924\u0930\u0939 \u092d\u0940 \u0915\u093e\u092e \u0915\u0930\u0924\u093e \u0939\u0948\u0964 \u091a\u0932\u093f\u090f \u091c\u093e\u0928\u0924\u0947 \u0939\u0948 \u0915\u0948\u0938\u0947 ? <\/p>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 cell \u092e\u0947\u0902 (=) \u0915\u093e \u091a\u093f\u0928\u094d\u0939 \u0932\u0917\u093e\u0915\u0930 \u0906\u092a \u091c\u094b\u0921\u093c , \u0918\u091f\u093e\u0935 , \u0917\u0941\u0923\u093e , \u092d\u093e\u0917 \u0907\u0924\u094d\u092f\u093e\u0926\u093f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p>\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0924\u094c\u0930 \u092a\u0930 \u090a\u092a\u0930 \u0926\u0930\u094d\u0936\u093e\u092f\u0947 \u0917\u090f \u091a\u093f\u0924\u094d\u0930 \u0938\u0902\u0916\u094d\u092f\u093e 2 \u092e\u0947\u0902 \u0905\u0917\u0930 \u0906\u092a cell  B12 \u092e\u0947\u0902 \u0905\u0917\u0930 \u0939\u093f\u0902\u0926\u0940 \u0915\u093e \u0915\u0941\u0932 \u0905\u0902\u0915 \u091c\u094b\u0921\u093c\u0928\u093e \u091a\u093e\u0939\u0947\u0902 <\/p>\n\n\n\n<p>\u0924\u094b CELL B12 \u092e\u0947\u0902 =45+76+80+91+92+87+56+78+98+56 \u0932\u093f\u0916\u0915\u0930 ENTER \u0926\u092c\u093e\u090f\u0902 \u0964<\/p>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u0915\u0941\u0932 \u092f\u094b\u0917 \u092e\u093f\u0932 \u091c\u093e\u092f\u0947\u0917\u093e\u0964 \u090f\u0915 \u092c\u093e\u0930 \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902\u0964<\/p>\n\n\n\n<p> \u0909\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0906\u092a \u0907\u0902\u0917\u094d\u0932\u093f\u0936 ,\u0917\u0923\u093f\u0924 ,\u0938\u093e\u092e\u093e\u091c\u093f\u0915 \u0935\u093f\u091c\u094d\u091e\u093e\u0928 \u0924\u0925\u093e \u0935\u093f\u091c\u094d\u091e\u093e\u0928 \u0915\u093e \u0915\u0941\u0932 \u092f\u094b\u0917 \u0915\u094d\u0930\u092e\u0936\u0903 C12 ,D12 ,E12 \u0924\u0925\u093e F12 \u092e\u0947\u0902 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p> \u091a\u093f\u0924\u094d\u0930  \u092e\u0947\u0902 \u0926\u0930\u094d\u0936\u093e\u092f\u093e \u0917\u092f\u093e \u0921\u093e\u091f\u093e \u092c\u0939\u0941\u0924 \u0939\u0940 \u091b\u094b\u091f\u093e \u0939\u0948 \u0907\u0938\u0932\u093f\u092f\u0947 \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u091c\u094b\u0921\u093c\u0928\u093e \u0938\u0902\u092d\u0935 \u0939\u094b \u092a\u093e\u092f\u093e \u092a\u0930\u0928\u094d\u0924\u0941 \u092c\u0921\u093c\u0947 \u0921\u093e\u091f\u093e \u0915\u0947 \u0932\u093f\u090f \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u091c\u094b\u0921\u093c\u0928\u093e \u0938\u0902\u092d\u0935 \u0928\u0939\u0940\u0902 \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0924\u094b \u0939\u092e \u0915\u094d\u092f\u093e \u0915\u0930\u0947\u0902 \u0915\u093f \u092c\u0921\u093c\u0947 \u0921\u093e\u091f\u093e \u0915\u093e \u092d\u0940 \u0915\u0941\u0932 \u092f\u094b\u0917 \u0939\u092e\u0947\u0902  \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 MS EXCEL\u092e\u0947\u0902 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0964 <\/p>\n\n\n\n<p>MS EXCEL \u092e\u0947\u0902 \u091c\u094b\u0921\u093c\u0928\u0947 \u0915\u0947 \u0915\u0908 \u0906\u0938\u093e\u0928 \u0924\u0930\u0940\u0915\u0947 \u0939\u0948 \u091c\u093f\u0938\u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0939\u092e \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u092c\u0921\u093c\u0947 \u0938\u0947 \u092c\u0921\u093c\u093e \u091c\u094b\u0921\u093c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p>\u091a\u0932\u093f\u090f \u090f\u0915 \u090f\u0915 \u0915\u0930 \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 :-<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET \u092e\u0947\u0902\u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u094b\u0921\u093c\u0928\u093e <\/strong><\/h3>\n\n\n\n<p> \u0906\u092a B12 cell \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0914\u0930( Alt + =) <span class=\"has-inline-color has-vivid-red-color\">[\u090a\u092a\u0930 \u0932\u093f\u0916\u0947 \u0928\u094b\u091f \u0915\u094b \u092a\u0922\u093c\u0947\u0902]<\/span> \u0926\u092c\u093e\u090f\u0902 \u0905\u092c Enter \u0926\u092c\u093e\u090f\u0902 \u0906\u092a\u0915\u094b B2 \u0938\u0947 B11 \u0924\u0915 \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<p> \u0905\u092c G2  \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0914\u0930 Alt + = \u0926\u092c\u093e\u090f\u0902 \u0905\u092c Enter \u0926\u092c\u093e\u090f\u0902 \u0906\u092a\u0915\u094b  B2, C2, D2, E2, F2 \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<p>\u092a\u0941\u0928\u0903 B12 \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0914\u0930 Ctrl + c \u0926\u092c\u093e\u0915\u0930 \u0915\u0949\u092a\u0940 \u0915\u0930 \u0932\u0947\u0902 \u0914\u0930 C12 \u092e\u0947\u0902 Ctrl + V \u0926\u092c\u093e\u0915\u0930  \u092a\u0947\u0938\u094d\u091f  \u0915\u0930 \u0926\u0947\u0902 \u0906\u092a\u0915\u094b C2 \u0938\u0947 C12 \u0924\u0915 \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 \u092f\u0939\u0940 \u092a\u094d\u0930\u0915\u094d\u0930\u093f\u092f\u093e D , E \u0924\u0925\u093e F COLUMN \u092e\u0947\u0902 \u092d\u0940 \u0926\u094b\u0939\u0930\u093e\u090f\u0902 \u0906\u092a\u0915\u094b \u0938\u092d\u0940 COLUMN \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<p> \u0907\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 G2 CELL \u0915\u094b \u0915\u0949\u092a\u0940 \u0915\u0930\u0915\u0947 G3 ,G4 &#8230;&#8230;&#8230; G11, G12 \u092e\u0947\u0902 \u092a\u0947\u0938\u094d\u091f \u0915\u0930 \u0926\u0947\u0902\u0964 \u0906\u092a\u0915\u094b \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">FILL HANDLE<\/h3>\n\n\n\n<p>\u0905\u0917\u0930 \u0906\u092a \u0915\u0949\u092a\u0940 \u092a\u0947\u0938\u094d\u091f \u0928 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0947\u0902 \u0924\u094b B12 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0964<\/p>\n\n\n\n<p> \u092e\u093e\u0909\u0938 \u0915\u0930\u094d\u0938\u0930 \u0915\u094b CELL \u0915\u0947 \u0915\u094b\u0928\u0947 \u092e\u0947\u0902 \u0932\u0947 \u091c\u093e\u090f\u0902 \u0906\u092a\u0915\u094b + \u091a\u093f\u0928\u094d\u0939 \u0926\u093f\u0916\u0947\u0917\u093e \u0907\u0938\u0947 FILL HANDLE (\u091a\u093f\u0924\u094d\u0930  \u0926\u0947\u0916\u0947\u0902 ) \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948 ,<\/p>\n\n\n\n<p>\u0905\u092c \u092e\u093e\u0909\u0938 \u092e\u0947\u0902 \u0932\u0947\u092b\u094d\u091f  \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 F12 \u0924\u0915 \u0916\u0940\u091a\u0947\u0902\u0964 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u093f \u0938\u092d\u0940 COLUMN \u0915\u093e \u091c\u094b\u0921\u093c \u0906\u092a\u0915\u094b \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u0917\u092f\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<p> \u0907\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 G2 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0915\u0947 \u092e\u093e\u0909\u0938 \u0915\u0930\u094d\u0938\u0930 \u0915\u094b CELL \u0915\u0947 \u0915\u094b\u0928\u0947  \u0932\u0947 \u091c\u093e\u092f\u0947 FILL HANDLE \u0926\u093f\u0916\u0928\u0947 \u092a\u0930 \u092e\u093e\u0909\u0938 \u092e\u0947\u0902 \u0932\u0947\u092b\u094d\u091f  \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u0928\u0940\u091a\u0947 G12 \u0924\u0915 \u0916\u0940\u091a\u0947\u0902\u0964 <\/p>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 \u0907\u0938 \u092a\u0942\u0930\u0940 \u092a\u094d\u0930\u0915\u094d\u0930\u093f\u092f\u093e \u0915\u094b \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902 \u0924\u092d\u0940 \u092a\u0942\u0930\u094d\u0923 \u0930\u0942\u092a \u0938\u0947 \u0938\u092e\u091d \u092a\u093e\u090f\u0902\u0917\u0947\u0964  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/MJ.jpg\" alt=\"\" class=\"wp-image-2014\" width=\"620\" height=\"505\"\/><figcaption><strong>FILL HANDLE<\/strong><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET \u092e\u0947\u0902 SUM FORMULA \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u094b\u0921\u093c\u0928\u093e<\/strong><\/h3>\n\n\n\n<p>\u0926\u0942\u0938\u0930\u0947 \u0924\u0930\u0940\u0915\u0947 \u092e\u0947\u0902 \u0939\u092e CELL B12 \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 \u0909\u0938\u092e\u0947 =SUM( \u0932\u093f\u0916\u0915\u0930 B2 CELL \u092e\u0947\u0902 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 FILL HANDLE \u0926\u094d\u0935\u093e\u0930\u093e  B11 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902\u0917\u0947 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 ENTER \u0926\u092c\u093e \u0926\u0947\u0902\u0917\u0947 \u0939\u092e\u0947\u0902 B2 \u0938\u0947 B11 \u0924\u0915 \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<p> \u0905 \u092e\u0947\u0902 \u0935\u0930\u094d\u0923\u0928 \u0915\u093f\u092f\u0947 \u0917\u090f \u0905\u0928\u0941\u0938\u093e\u0930 FILL HANDLE \u0915\u094b F12 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902\u0917\u0947 \u0938\u092d\u0940 COLUMN \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 \u091a\u093f\u0924\u094d\u0930  \u0915\u094b \u0926\u0947\u0916\u0947\u0902\u0964 <\/p>\n\n\n\n<p>\u0905\u092cG2 \u092e\u0947\u0902  =SUM( \u0932\u093f\u0916\u0915\u0930 B2 \u092e\u0947\u0902 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 F2 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902\u0917\u0947 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/QQ.jpg\" alt=\"\" class=\"wp-image-2015\"\/><figcaption><strong>SUM FORMULA<\/strong><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/RR-1.jpg\" alt=\"\" class=\"wp-image-2016\" width=\"591\" height=\"438\"\/><figcaption><strong>SUM FORMULA<\/strong><\/figcaption><\/figure>\n\n\n\n<p> ENTER \u0926\u092c\u093e \u0926\u0947\u0902\u0917\u0947 \u0939\u092e\u0947\u0902 B2 \u0938\u0947 F2 \u0924\u0915 \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964  <\/p>\n\n\n\n<p>\u0905 \u092e\u0947\u0902 \u0935\u0930\u094d\u0923\u0928 \u0915\u093f\u092f\u0947 \u0917\u090f \u0905\u0928\u0941\u0938\u093e\u0930 FILL HANDLE \u0915\u094b G12 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902\u0917\u0947 \u0938\u092d\u0940 ROW  \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964\u091a\u093f\u0924\u094d\u0930  \u0926\u0947\u0916\u0947\u0902\u0964 <\/p>\n\n\n\n<p>\u0907\u0938 \u092a\u0942\u0930\u0940 \u092a\u094d\u0930\u0915\u094d\u0930\u093f\u092f\u093e \u0915\u094b \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902 \u0924\u092d\u0940 \u092a\u0942\u0930\u094d\u0923 \u0930\u0942\u092a \u0938\u0947 \u0938\u092e\u091d \u092a\u093e\u090f\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET \u092e\u0947\u0902 AUTO SUM \u0915\u0947 \u0924\u0930\u0940\u0915\u0947 \u0938\u0947 \u091c\u094b\u0921\u093c\u0928\u093e<\/strong><\/h3>\n\n\n\n<p>\u0924\u0940\u0938\u0930\u0947 \u0924\u0930\u0940\u0915\u0947 \u092e\u0947\u0902 \u0939\u092e CELL B12 \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 \u092b\u093f\u0930 FORMULA TAB \u092e\u0947\u0902 \u091c\u093e\u0915\u0930 AUTOSUM \u0915\u094b \u0915\u094d\u0932\u093f\u0915 \u0915\u0930 \u0926\u0947\u0902\u0917\u0947 \u0939\u092e\u0947 \u0909\u0938 COLUMN \u0915\u093e \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 \u092b\u093f\u0930 FILL HANDLE \u0915\u094b \u0916\u0940\u0902\u091a \u0915\u0930 \u0938\u093e\u0930\u0947 COLUMN \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964  CELL B12 \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930 \u0936\u0949\u0930\u094d\u091f\u0915\u091f KEY Alt M U S [\u090a\u092a\u0930 \u0932\u093f\u0916\u0947 \u0928\u094b\u091f \u0915\u094b \u092a\u0922\u093c\u0947\u0902]  \u0926\u092c\u093e\u090f\u0902\u0964 \u0907\u0938 \u0924\u0930\u0940\u0915\u0947 \u0938\u0947 \u092d\u0940 \u0906\u092a\u0915\u094b \u091c\u094b\u0921\u093c \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964  <\/p>\n\n\n\n<p> ROW \u0924\u0925\u093e COLUMN \u092e\u0947\u0902 \u0915\u0941\u0932  \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b MS EXCEL WORKSHEET \u0928\u0940\u091a\u0947 \u0926\u0930\u094d\u0936\u093e\u092f\u0947 \u0917\u090f \u091a\u093f\u0924\u094d\u0930 \u0915\u0940 \u0924\u0930\u0939 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940\u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/TOTAL.jpg\" alt=\"\" class=\"wp-image-2017\" width=\"614\" height=\"435\"\/><figcaption><strong>TOTAL IN MS EXCEL WORKSHEET<\/strong><\/figcaption><\/figure>\n\n\n\n<p>\u0905\u092c \u0939\u092e LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u092a\u093e\u0938 ,\u092b\u0947\u0932 \u0924\u0925\u093e \u0917\u094d\u0930\u0947\u0921 \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0938\u0940\u0916\u0947\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET \u092e\u0947\u0902 LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0948\u0938\u0947 \u0915\u0930\u0947\u0902 \u0939\u0948 ?<\/strong><\/h3>\n\n\n\n<p>\u0905\u092c \u0939\u092e\u0947\u0902 \u0935\u093f\u0926\u094d\u092f\u093e\u0932\u092f XYZ \u092e\u0947\u0902 \u092f\u0939 \u092a\u0924\u093e \u0932\u0917\u093e\u0928\u093e \u0939\u0948 \u0915\u093f \u0928\u0935\u092e\u0940 \u0915\u0915\u094d\u0937\u093e \u092e\u0947\u0902 \u0915\u094c\u0928 \u0938\u093e \u091b\u093e\u0924\u094d\u0930 \u092a\u093e\u0938 \u0939\u0948 \u0915\u094c\u0928 \u0938\u093e \u092b\u0947\u0932 \u0939\u0948 \u0924\u0925\u093e \u0909\u0928\u0915\u093e \u0917\u094d\u0930\u0947\u0921 \u0915\u094d\u092f\u093e \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0924\u094b \u0939\u092e \u092e\u093e\u0928 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0915\u093f  \u092f\u0939\u093e\u0901 \u0932\u093f\u090f \u0917\u090f \u0909\u0926\u093e\u0939\u0930\u0923 \u092e\u0947\u0902 \u0938\u092d\u0940 \u0935\u093f\u0937\u092f\u094b\u0902 \u0915\u093e \u092a\u0942\u0930\u094d\u0923\u093e\u0902\u0915 100 \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0914\u0930 \u0915\u092e \u0938\u0947 \u0915\u093e\u092e 40 \u0905\u0902\u0915 \u0932\u093e\u0928\u0947 \u092a\u0930 \u091b\u093e\u0924\u094d\u0930 \u092a\u093e\u0938 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<p> \u0905\u0917\u0930 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0935\u093f\u0937\u092f \u092e\u0947\u0902 40 \u0938\u0947 \u0915\u093e\u092e \u0905\u0902\u0915 \u0906\u0924\u0947 \u0939\u0948 \u0924\u094b \u0935\u0939 \u091b\u093e\u0924\u094d\u0930 \u092b\u0947\u0932 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0924\u094b \u0905\u092c \u0939\u092e LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u091b\u093e\u0924\u094d\u0930 \u0915\u093e \u0930\u093f\u091c\u0932\u094d\u091f \u0928\u093f\u0915\u093e\u0932\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MS EXCEL WORKSHEET \u092e\u0947\u0902  IF AND \u0924\u0925\u093e IF OR LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0930\u093f\u091c\u0932\u094d\u091f \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u0932\u0924\u0947 \u0939\u0948\u0902 ?<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>IF AND LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0930\u093f\u091c\u0932\u094d\u091f \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u0932\u0924\u0947 \u0939\u0948\u0902 ?<\/strong><\/h4>\n\n\n\n<p> H2 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0905\u092c \u0909\u0938\u092e\u0947\u0902 \u0915\u0902\u0921\u0940\u0936\u0928 \u0932\u0917\u093e\u090f\u0902 ,\u0915\u0948\u0938\u0947 \u0906\u0917\u0947 \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 :-<\/p>\n\n\n\n<p>\u0939\u092e \u0915\u0902\u0921\u0940\u0936\u0928 \u0932\u0917\u093e\u0924\u0947 \u0939\u0948 \u0915\u093f \u0915\u093f\u0938\u0940 \u091b\u093e\u0924\u094d\u0930 \u0915\u093e \u0905\u0917\u0930 \u0938\u092d\u0940 \u0935\u093f\u0937\u092f\u094b\u0902 \u092e\u0947\u0902 40 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0905\u0902\u0915 \u0906\u092f\u0947 \u0924\u094b \u0935\u0939 \u092a\u093e\u0938 \u0939\u094b\u0917\u093e,\u0928\u0939\u0940\u0902 \u0924\u094b \u092b\u0947\u0932 \u0939\u094b\u0917\u093e \u0964<\/p>\n\n\n\n<p> \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a H2 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947 \u0909\u0938\u092e\u0947\u0902 <code><span class=\"has-inline-color has-luminous-vivid-orange-color\">=IF(AND(B2>=40,C2>=40,D2>=40,E2>=40,F2>=40),\"PASS\",\"FAIL\")<\/span> <\/code><\/p>\n\n\n\n<p>\u091f\u093e\u0907\u092a \u0915\u0930\u0947\u0902 \u0914\u0930 ENTER \u0926\u092c\u093e \u0926\u0947\u0902 \u0906\u092a\u0915\u094b \u0930\u093f\u091c\u0932\u094d\u091f \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<p>\u0905\u092c H2 CELL \u092e\u0947\u0902 FILL HANDLE \u0926\u094d\u0935\u093e\u0930\u093e \u0928\u0940\u091a\u0947 H11 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902 , \u0935\u0939\u0940 \u0915\u0902\u0921\u0940\u0936\u0928 \u0938\u092d\u0940 CELL \u092e\u0947\u0902 \u0932\u0917 \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/IF-AND-1024x476.jpg\" alt=\"\" class=\"wp-image-2018\" width=\"616\" height=\"286\"\/><figcaption><strong>IF AND LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932<\/strong><\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"> <strong>IF OR LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0930\u093f\u091c\u0932\u094d\u091f \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u0932\u0924\u0947 \u0939\u0948\u0902 ?<\/strong> :-<\/h4>\n\n\n\n<p> H2 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0905\u092c \u0909\u0938\u092e\u0947\u0902 \u0915\u0902\u0921\u0940\u0936\u0928 \u0932\u0917\u093e\u090f\u0902 ,\u0915\u0948\u0938\u0947 \u0906\u0917\u0947 \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 :-<\/p>\n\n\n\n<p>\u0939\u092e \u0915\u0902\u0921\u0940\u0936\u0928 \u0932\u0917\u093e\u0924\u0947 \u0939\u0948 \u0915\u093f \u0915\u093f\u0938\u0940 \u091b\u093e\u0924\u094d\u0930 \u0915\u093e \u0905\u0917\u0930 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0935\u093f\u0937\u092f \u092e\u0947\u0902 40 \u0938\u0947 \u0915\u092e \u0905\u0902\u0915 \u0906\u092f\u0947 \u0924\u094b \u0935\u0939 \u092b\u0947\u0932 \u0939\u094b\u0917\u093e ,\u0928\u0939\u0940\u0902 \u0924\u094b \u092a\u093e\u0938 \u0939\u094b\u0917\u093e \u0964 \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a H2 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0909\u0938\u092e\u0947\u0902 <\/p>\n\n\n\n<p> <span class=\"has-inline-color has-luminous-vivid-orange-color\">=IF(OR(B2<40,C2<40,D2<40,E2<40,F2<40),\"FAIL\",\"PASS\")<\/span> \u091f\u093e\u0907\u092a \u0915\u0930\u0947\u0902 \u0914\u0930 <\/p>\n\n\n\n<p>ENTER \u0926\u092c\u093e \u0926\u0947\u0902 \u0906\u092a\u0915\u094b \u0930\u093f\u091c\u0932\u094d\u091f \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<p> \u0905\u092c H2 CELL \u092e\u0947\u0902 FILL HANDLE \u0926\u094d\u0935\u093e\u0930\u093e \u0928\u0940\u091a\u0947 H11 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902 , \u0935\u0939\u0940 \u0915\u0902\u0921\u0940\u0936\u0928 \u0938\u092d\u0940 CELL \u092e\u0947\u0902 \u0932\u0917 \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/IF-OR-1024x533.jpg\" alt=\"\" class=\"wp-image-2019\" width=\"607\" height=\"315\"\/><figcaption><strong>IF OR LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932<\/strong> <\/figcaption><\/figure>\n\n\n\n<p>\u0906\u092a IF AND \u0914\u0930 IF OR LOGIC \u0915\u0947 \u0905\u0902\u0924\u0930 \u0915\u094b \u0938\u092e\u091d\u0947\u0902 , IF AND \u090f\u0915 COMPULSORY \u0915\u0902\u0921\u0940\u0936\u0928 \u0939\u0948\u0964<\/p>\n\n\n\n<p> \u091c\u092c\u0915\u093f  IF OR \u090f\u0915 OPTIONAL CONDITION \u0939\u0948\u0964 \u0926\u094b\u0928\u094b\u0902 \u0939\u0940 LOGIC \u092e\u0947\u0902 \u0930\u093f\u091c\u0932\u094d\u091f \u0938\u092e\u093e\u0928 \u0939\u0940 \u0906\u0924\u093e \u0939\u0948 \u0964<\/p>\n\n\n\n<p>\u092a\u0930 \u0907\u0938\u0915\u094b \u0932\u0917\u093e\u0928\u0947 \u0915\u093e \u0924\u0930\u0940\u0915\u093e \u0925\u094b\u0921\u093c\u093e \u0905\u0932\u0917 \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0906\u092a EXCEL WORKSHEET \u092e\u0947\u0902 \u092a\u094d\u0930\u0948\u0915\u094d\u091f\u093f\u0915\u0932 \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902 \u0924\u094b \u0906\u092a\u0915\u094b \u0914\u0930 \u092d\u0940 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947\u0902 \u0906 \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/PASS-FAIL.jpg\" alt=\"\" class=\"wp-image-2020\" width=\"615\" height=\"489\"\/><figcaption><strong>PASS FAIL RESULT<\/strong><\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>IF LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0917\u094d\u0930\u0947\u0921 \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u0932\u0924\u0947 \u0939\u0948\u0902 ?<\/strong><\/h4>\n\n\n\n<p>IF LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0939\u092e \u0917\u094d\u0930\u0947\u0921 \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0938\u0940\u0916\u0924\u0947 \u0939\u0948\u0902\u0964 \u0939\u092e \u092e\u093e\u0928\u0924\u0947 \u0939\u0948 \u0915\u093f 375 < A+, 300 < A , 250 < B , 200 < C , 200 > FAIL , \u0907\u0938 \u0915\u0902\u0921\u0940\u0936\u0928 \u0915\u094b \u0932\u0917\u093e\u0915\u0930 \u0939\u092e \u0917\u094d\u0930\u0947\u0921 \u0928\u093f\u0915\u093e\u0932\u0947\u0902\u0917\u0947\u0964 \u0906\u092a  I2 CELL \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0914\u0930 \u0909\u0938\u092e\u0947\u0902<span class=\"has-inline-color has-luminous-vivid-orange-color\"> =IF(H2=&#8221;FAIL&#8221;,&#8221;FAIL&#8221;,IF(G2>375,&#8221;A+&#8221;,IF(G2>300,&#8221;A&#8221;,IF(G2>250,&#8221;B&#8221;,IF(G2>200,&#8221;C&#8221;))))) <\/span><\/p>\n\n\n\n<p>\u091f\u093e\u0907\u092a \u0915\u0930\u0947\u0902 \u0906\u092a\u0915\u094b \u0917\u094d\u0930\u0947\u0921 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<p>I2 \u0915\u0947 FILL HANDLE \u0926\u094d\u0935\u093e\u0930\u093e I11 \u0924\u0915 \u0916\u0940\u0902\u091a \u0926\u0947\u0902 \u0906\u092a\u0915\u094b \u0938\u092d\u0940 \u091b\u093e\u0924\u094d\u0930\u094b\u0902 \u0915\u093e \u0917\u094d\u0930\u0947\u0921 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/seekhomujhse.in\/wp-content\/uploads\/2025\/12\/GRADE.jpg\" alt=\"\" class=\"wp-image-2021\" width=\"594\" height=\"412\"\/><figcaption><strong>GRADE<\/strong><\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u092a\u094d\u0930\u0936\u094d\u0928 :-<\/h4>\n\n\n\n<p>\u0907\u0938 \u092a\u094b\u0938\u094d\u091f \u0915\u094b \u092a\u0922\u093c\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u0928\u093f\u092e\u094d\u0928\u0932\u093f\u0916\u093f\u0924 \u092a\u094d\u0930\u0936\u094d\u0928\u094b \u0915\u093e \u0909\u0924\u094d\u0924\u0930 \u0926\u0947\u0928\u0947 \u092e\u0947\u0902 \u0938\u0915\u094d\u0937\u092e \u0939\u094b\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<p> \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u0938\u0939\u0940 \u0909\u0924\u094d\u0924\u0930 \u0915\u0947\u0932\u093f\u090f \u0905\u092a\u0928\u0947 \u0906\u092a \u0915\u094b 2 \u0905\u0902\u0915 \u0926\u0947\u0902\u0964 \u0905\u0917\u0930 \u0906\u092a 8 \u092f\u093e \u0907\u0938\u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0905\u0902\u0915 \u0932\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b <\/p>\n\n\n\n<p>\u0906\u092a \u0907\u0938 \u091f\u0949\u092a\u093f\u0915 \u0915\u094b \u0905\u091a\u094d\u091b\u0940 \u0924\u0930\u0939 \u0938\u092e\u091d \u0917\u090f \u0939\u0948\u0902 :-<\/p>\n\n\n\n<p>1 ) \u091c\u094b\u0921\u093c\u0928\u0947 \u0915\u0947 \u0905\u0932\u0917 \u0905\u0932\u0917 \u0924\u0930\u0940\u0915\u094b\u0902 \u0915\u093e \u0935\u0930\u094d\u0923\u0928 \u0915\u0930\u0947\u0902\u0964<\/p>\n\n\n\n<p>2 )IF AND LOGIC \u0915\u093e \u0935\u0930\u094d\u0923\u0928 \u0915\u0930\u0947\u0902\u0964<\/p>\n\n\n\n<p>3 ) IF OR LOGIC \u0915\u093e \u0935\u0930\u094d\u0923\u0928 \u0915\u0930\u0947\u0902\u0964<\/p>\n\n\n\n<p>4 ) FILL HANDLE \u0915\u093c\u094d\u092f\u093e \u0939\u094b\u0924\u093e \u0939\u0948 \u0924\u0925\u093e \u0907\u0938\u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 ?<\/p>\n\n\n\n<p>5 ) \u0917\u094d\u0930\u0947\u0921 \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u0947 \u0915\u093e \u0935\u0930\u094d\u0923\u0928 \u0915\u0930\u0947\u0902\u0964<\/p>\n\n\n\n<p>\u0908\u092e\u093e\u0928\u0926\u093e\u0930\u0940 \u0938\u0947 \u0907\u0928 \u092a\u094d\u0930\u0936\u094d\u0928\u094b \u0915\u093e \u0909\u0924\u094d\u0924\u0930 \u0926\u0947\u0902 \u0924\u0925\u093e \u0906\u092a\u0915\u094b \u0915\u093f\u0924\u0928\u0947 \u0905\u0902\u0915 \u0906\u092f\u0947 \u0915\u092e\u0947\u0902\u091f \u0915\u0930\u0915\u0947 \u0905\u0935\u0936\u094d\u092f \u092c\u0924\u093e\u092f\u0947\u0902\u0964<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u0938\u093e\u0930\u093e\u0902\u0936 :-<\/h4>\n\n\n\n<p>\u0907\u0938 \u092a\u0941\u0930\u0947 \u092a\u094b\u0938\u094d\u091f <strong>MS EXCEL WORKSHEET \u092e\u0947\u0902 DATA ENTRY  \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 ?(DATA ENTRY IN EXCEL WORKSHEET IN HINDI) <\/strong>\u092e\u0947\u0902 \u0939\u092e\u0928\u0947 \u0905\u0932\u0917 \u0905\u0932\u0917 \u0924\u0930\u0940\u0915\u0947 \u0938\u0947 \u091c\u094b\u0921\u093c\u0928\u093e , IF AND \u0924\u0925\u093e IF OR LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0930\u093f\u091c\u0932\u094d\u091f \u0928\u093f\u0915\u093e\u0932\u0928\u093e<\/p>\n\n\n\n<p> \u0924\u0925\u093e IF LOGIC \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0915\u0947 \u0917\u094d\u0930\u0947\u0921 \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0938\u0940\u0916\u093e\u0964<\/p>\n\n\n\n<p> \u0905\u0917\u0930 \u0906\u092a \u090a\u092a\u0930 \u092c\u0924\u093e\u0908 \u0917\u0908 \u0935\u093f\u0927\u093f\u092f\u094b\u0902 \u0915\u094b MS EXCEL WORKSHEET \u092e\u0947\u0902  \u092a\u094d\u0930\u0948\u0915\u094d\u091f\u093f\u0915\u0932 \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0924\u094b \u0906\u092a\u0915\u094b \u0914\u0930 \u092d\u0940 \u0905\u091a\u094d\u091b\u0940 \u0924\u0930\u0939 \u0938\u092e\u091d \u092e\u0947\u0902 \u0906\u090f\u0917\u093e\u0964 <\/p>\n\n\n\n<p>\u0905\u0924\u0903 \u092e\u0947\u0930\u0940 \u0938\u0932\u093e\u0939 \u0939\u0948 \u0915\u093f \u0906\u092a \u0907\u0938\u0947 \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902\u0964 \u0905\u0917\u0930 \u0906\u092a\u0915\u094b \u092f\u0939 \u092a\u094b\u0938\u094d\u091f \u092a\u0938\u0902\u0926 \u0906\u092f\u093e \u0924\u094b \u0907\u0938\u0947 \u0905\u092a\u0928\u0947 \u092a\u094d\u0930\u093f\u092f\u091c\u0928\u094b\u0902 \u0938\u0947 \u0905\u0935\u0936\u094d\u092f \u0936\u0947\u092f\u0930 \u0915\u0930\u0947\u0902\u0964<\/p>\n\n\n\n<p> \u0905\u0917\u0932\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 \u0939\u092e MS EXCEL WORKSHEET \u0915\u0940 \u0915\u0941\u091b \u0914\u0930 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930\u0947\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>\u0906\u092a\u0928\u0947 \u092e\u0947\u0930\u0947 \u092a\u0939\u0932\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 MS EXCEL \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u092a\u0922\u093c\u093e \u0939\u094b\u0917\u093e\u0964 \u0905\u0917\u0930 \u0928\u0939\u0940\u0902 \u092a\u0922\u093c\u093e \u0939\u0948 \u0924\u094b MS EXCEL \u0915\u094d\u092f\u093e \u0939\u0948 ? \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u092a\u0922\u093c \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u092a\u0939\u0932\u0947 \u092a\u094b\u0938\u094d\u091f \u0938\u0947 \u0906\u092a MS EXCEL \u0938\u0947 \u092a\u0930\u093f\u091a\u093f\u0924 \u0939\u0941\u090f \u0939\u094b\u0902\u0917\u0947\u0964 \u0906\u091c \u0915\u0947 \u092a\u094b\u0938\u094d\u091f \u092e\u0947\u0902 \u0906\u092a MS EXCEL \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0925\u094b\u0921\u093c\u093e \u0914\u0930 \u0905\u0927\u094d\u092f\u092f\u0928 \u0915\u0930\u0947\u0902\u0917\u0947\u0964 \u0906\u091c \u0915\u0947 \u092a\u094b\u0938\u094d\u091f [&hellip;]<\/p>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[35],"class_list":["post-2912","post","type-post","status-publish","format-standard","hentry","category-ms-excel","tag-data-entrydata-entry-in-excel"],"_links":{"self":[{"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/posts\/2912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/comments?post=2912"}],"version-history":[{"count":1,"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/posts\/2912\/revisions"}],"predecessor-version":[{"id":3132,"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/posts\/2912\/revisions\/3132"}],"wp:attachment":[{"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/media?parent=2912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/categories?post=2912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seekhomujhse.in\/en\/wp-json\/wp\/v2\/tags?post=2912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}