{"id":37369,"date":"2020-03-06T15:10:14","date_gmt":"2020-03-06T09:40:14","guid":{"rendered":"https:\/\/www.joshtalks.com\/joshkosh\/?p=37369"},"modified":"2020-03-06T15:13:51","modified_gmt":"2020-03-06T09:43:51","slug":"%e0%a4%8f%e0%a4%ae%e0%a4%8f%e0%a4%b8-%e0%a4%8f%e0%a4%95%e0%a5%8d%e0%a4%b8%e0%a4%b2-%e0%a4%95%e0%a5%8b%e0%a4%b0%e0%a5%8d%e0%a4%b8-%e0%a4%ad%e0%a4%be%e0%a4%97-2-sort-filter-find-replace","status":"publish","type":"post","link":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/%e0%a4%95%e0%a4%b0%e0%a4%bf%e0%a4%af%e0%a4%b0\/%e0%a4%8f%e0%a4%ae%e0%a4%8f%e0%a4%b8-%e0%a4%8f%e0%a4%95%e0%a5%8d%e0%a4%b8%e0%a4%b2-%e0%a4%95%e0%a5%8b%e0%a4%b0%e0%a5%8d%e0%a4%b8-%e0%a4%ad%e0%a4%be%e0%a4%97-2-sort-filter-find-replace\/","title":{"rendered":"\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 2 &#8211; Sort, Filter, Find &#038; Replace"},"content":{"rendered":"\n<h2>Sort \u0914\u0930 \u092b\u093f\u0932\u094d\u091f\u0930 \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 + Find \u0914\u0930 replace \u0915\u094d\u092f\u093e \u0939\u0948 \u0938\u0940\u0916\u0947\u0902 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925\u0964<\/h2>\n\n\n\n<p class=\"has-regular-font-size\">\u092f\u0939 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0939\u092e\u093e\u0930\u0947 \u092b\u094d\u0930\u0940 \u090f\u0915\u094d\u0938\u0932 \u0915\u094b\u0930\u094d\u0938 \u0915\u0947 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u093e \u0926\u0942\u0938\u0930\u093e \u092a\u093e\u0930\u094d\u091f \u0939\u0948\u0964<\/p>\n\n\n\n<p>\u0907\u0938 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092e\u0947\u0902 \u0939\u092e \u0906\u092a\u0915\u094b sort \u090f\u0902\u0921 filter \u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 \u0915\u0948\u0938\u0947 \u0932\u0917\u0924\u0947 \u0939\u0948 \u0914\u0930 find \u090f\u0902\u0921 replace \u0915\u094d\u092f\u093e \u0939\u0948 \u0938\u093f\u0916\u093e\u090f\u0902\u0917\u0947 \u090f\u0915 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925\u0964 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0940 \u0936\u0940\u091f \u0906\u092a \u092b\u094d\u0930\u0940 \u092e\u0947\u0902 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0914\u0930 \u0905\u092a\u0928\u0947 \u0915\u0902\u092a\u094d\u092f\u0942\u091f\u0930 \u092e\u0947\u0902 \u0938\u093e\u0925-\u0938\u093e\u0925 \u092a\u094d\u0930\u0948\u0915\u094d\u091f\u093f\u0938 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\n\n\n\n<p>\u091a\u0932\u093f\u092f\u0947 \u0938\u0940\u0916\u0924\u0947 \u0939\u0948 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 \u0907\u0938 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947\u0964<\/p>\n\n\n\n<p><strong>\u092f\u0939 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092c\u093e\u0915\u0940 \u090f\u0915\u094d\u0938\u0932 \u0915\u094b\u0930\u094d\u0938 \u0938\u0947 \u092c\u0947\u0939\u0924\u0930 \u0939\u0948 \u0915\u094d\u092f\u094b\u0902\u0915\u093f:<\/strong><\/p>\n\n\n\n<ul><li>\u092f\u0939 \u0915\u094b\u0930\u094d\u0938 \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 \u0939\u0948 \u0914\u0930 100% \u092e\u0941\u092b\u094d\u0924 \u0939\u0948\u0964<\/li><li> \u0907\u0938 \u0915\u094b\u0930\u094d\u0938 \u092e\u0947\u0902 \u0939\u092e\u0928\u0947 \u0906\u092a\u0915\u094b \u0938\u0930\u0932 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925 \u0938\u092e\u091d\u093e\u092f\u093e \u0939\u0948\u0964 <\/li><li> \u092f\u0939 \u0915\u094b\u0930\u094d\u0938 \u0936\u0941\u0930\u0941\u0906\u0924\u0940 \u0938\u094d\u0924\u0930 \u0938\u0947 \u0932\u0947\u0915\u0930 \u090f\u0921\u0935\u093e\u0902\u0938 \u0932\u0947\u0935\u0932 \u0924\u0915 \u0939\u0948\u0964<\/li><\/ul>\n\n\n\n<p><strong>\u0906\u092a\u0915\u094b \u092c\u093f\u0917\u093f\u0928\u0930 \u0915\u094b\u0930\u094d\u0938 \u092a\u093e\u0930\u094d\u091f 2 \u0915\u0940 \u091c\u0930\u0942\u0930\u0924 \u0939\u0948 \u0905\u0917\u0930: <\/strong><\/p>\n\n\n\n<ul><li>\u0906\u092a\u0915\u094b \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u092c\u0947\u0938\u093f\u0915 \u0925\u094b\u095c\u0947 \u092c\u0939\u0941\u0924 \u0906\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0906\u092a \u0921\u093e\u091f\u093e \u0915\u094b \u090f\u0928\u093e\u0932\u093e\u0907\u091c \u0915\u0930\u0928\u093e \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902 \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902\u0964<\/li><li>\u0906\u092a \u092b\u094d\u0930\u0947\u0936\u0930 \u0939\u0948 \u0914\u0930 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u095b\u094d\u092f\u093e\u0926\u093e \u092a\u0924\u093e \u0928 \u0939\u094b\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u0940 \u0928\u094c\u0915\u0930\u0940 \u0928\u0939\u0940\u0902 \u0932\u0917 \u0930\u0939\u0940 \u0939\u0948 \u092f\u093e \u0928\u094c\u0915\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u090f\u0915\u094d\u0938\u0947\u0932 \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p>\u092f\u0939 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u094b\u0930\u094d\u0938 \u0915\u0947 \u091f\u0941\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u093e \u0926\u0942\u0938\u0930\u093e \u092d\u093e\u0917 \u0939\u0948\u0964 \u0907\u0938\u0915\u094b \u092a\u0942\u0930\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u092c\u093e\u0915\u093f 3 \u091f\u0941\u091f\u094b\u0930\u093f\u092f\u0932 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0928\u0940\u091a\u0947 \u0926\u093f\u090f \u0917\u090f \u0932\u093f\u0902\u0915\u094d\u0938 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u0906\u092a \u0909\u0928 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u094b \u092a\u095d \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/hi\/%e0%a4%95%e0%a5%8c%e0%a4%b6%e0%a4%b2-%e0%a4%b5%e0%a4%bf%e0%a4%95%e0%a4%be%e0%a4%b8\/%e0%a4%8f%e0%a4%ae%e0%a4%8f%e0%a4%b8-%e0%a4%8f%e0%a4%95%e0%a5%8d%e0%a4%b8%e0%a4%b2-%e0%a4%ad%e0%a4%be%e0%a4%97-1\/\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 1 \u0939\u093f\u0928\u094d\u0926\u0940 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 &#8211; \u0905\u0917\u0930 \u090f\u0915\u094d\u0938\u0932 \u092c\u093f\u0932\u0915\u0941\u0932 \u0939\u0940 \u0928\u0939\u0940\u0902 \u0906\u0924\u0940<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-advanced-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 - \u090f\u0921\u0935\u093e\u0902\u0938 \u090f\u0915\u094d\u0938\u0932 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092a\u093e\u0930\u094d\u091f 1 (opens in a new tab)\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 &#8211; \u090f\u0921\u0935\u093e\u0902\u0938 \u090f\u0915\u094d\u0938\u0932 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092a\u093e\u0930\u094d\u091f 1<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-advanced-tutorial-in-hindi-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 - \u090f\u0921\u0935\u093e\u0902\u0938 \u090f\u0915\u094d\u0938\u0932 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092a\u093e\u0930\u094d\u091f 2 (opens in a new tab)\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 &#8211; \u090f\u0921\u0935\u093e\u0902\u0938 \u090f\u0915\u094d\u0938\u0932 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092a\u093e\u0930\u094d\u091f 2<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p>\u091a\u0932\u093f\u090f \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 \u0915\u093f \u0906\u092a \u0907\u0938 \u092c\u093f\u0917\u093f\u0928\u0930 \u092a\u093e\u0930\u094d\u091f 2 \u092e\u0947\u0902 \u0915\u094d\u092f\u093e \u0938\u0940\u0916\u0947\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<h3><strong>\u092c\u093f\u0917\u093f\u0928\u0930 \u092a\u093e\u0930\u094d\u091f 2 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u091f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092e\u0947\u0902 \u0939\u092e \u0938\u0940\u0916\u0947\u0902\u0917\u0947 <\/strong><\/h3>\n\n\n\n<p><a href=\"#sort-kaise-karte-hain\">Sort \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948<\/a><\/p>\n\n\n\n<p><a href=\"#excel_mein_filter_kaise_lagate_hain\">\u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 filter \u0915\u0948\u0938\u0947 \u0932\u0917\u093e\u0924\u0947 \u0939\u0948<\/a><\/p>\n\n\n\n<p><a href=\"#find-aur-replace-ka-kya-use-hai\">Find \u090f\u0902\u0921 replace \u0915\u094d\u092f\u093e \u0939\u0948<\/a><\/p>\n\n\n\n<p>\u0907\u0928\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0939\u092e \u090f\u0915 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u091c\u0930\u093f\u092f\u0947 \u0938\u092e\u091d\u093e\u090f\u0901\u0917\u0947<\/p>\n\n\n\n<p>\u092a\u0939\u0932\u0947 \u0939\u092e  \u0926\u0947\u0916\u0924\u0947 \u0939\u0948 \u0915\u093f \u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 Sort, Filter, Find \u0914\u0930 Replace \u0911\u092a\u094d\u0936\u0928 \u0939\u094b\u0924\u0947 \u0915\u094d\u092f\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<h3><strong>SORT \u090f\u0902\u0921 FILTER<\/strong><\/h3>\n\n\n\n<h4><strong>Sort<\/strong><\/h4>\n\n\n\n<p class=\"sort\">Sort \u0921\u093e\u091f\u093e \u0915\u093e \u0911\u092a\u094d\u0936\u0928 Home Tab \u092e\u0947\u0902 \u0938\u092c\u0938\u0947 \u0930\u093e\u0907\u091f \u0938\u093e\u0907\u0921 \u092e\u0947\u0902 \u0939\u094b\u0924\u093e \u0939\u0948, \u092f\u0947 \u0939\u092e\u0928\u0947 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0947 \u092a\u093f\u091b\u0932\u0947 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u092c\u0924\u093e\u092f\u093e \u0925\u093e\u0964 sort \u0915\u0947 \u092b\u0940\u091a\u0930 \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094b text, numbers \u092f\u093e colors \u0915\u0947 \u092c\u0947\u0938\u093f\u0938 \u092a\u0930 sort \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0915\u094b sort \u0915\u0930\u0915\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092a\u0924\u093e \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option.jpg\" alt=\"\" class=\"wp-image-16710\" width=\"1042\" height=\"987\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option.jpg 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-300x284.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-444x420.jpg 444w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"filter\" style=\"    margin-top: 0%;\"><strong>Filter<\/strong><\/h4>\n\n\n\n<p>\u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 \u0915\u093f\u0938\u0940 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u0938\u0947 \u0905\u092a\u0928\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0921\u093e\u091f\u093e \u0915\u094b \u090f\u0915\u094d\u0938\u091f\u094d\u0930\u0947\u0915\u094d\u091f \u092f\u093e \u0928\u093f\u0915\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Filter \u0915\u093e \u092f\u0942\u091c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u092f\u0947 \u0911\u092a\u094d\u0936\u0928 \u092c\u0939\u0941\u0924 \u092a\u093e\u0935\u0930\u092b\u0941\u0932 \u0911\u092a\u094d\u0936\u0928 \u0939\u0948\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter.jpg\" alt=\"\" class=\"wp-image-16704\" width=\"1059\" height=\"1003\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter.jpg 505w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter-300x285.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter-443x420.jpg 443w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/figure><\/div>\n\n\n\n<h3><br><strong>FIND \u0914\u0930 REPLACE \u0915\u094d\u092f\u093e \u0939\u0948<\/strong><\/h3>\n\n\n\n<h4><strong>Find<\/strong><\/h4>\n\n\n\n<p>\u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902<strong> Home tab<\/strong> \u092e\u0947\u0902 <strong>Find and Select <\/strong>\u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u092f\u0942\u091c \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u092f\u093e \u0928\u0902\u092c\u0930 \u0915\u094b \u0938\u0930\u094d\u091a \u0915\u0930\u0915\u0947 \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0924\u093e \u0939\u0948 \u0907\u0938\u0947 \u0921\u093e\u092f\u0930\u0947\u0915\u094d\u091f\u0932\u0940 \u0906\u092a <strong>Ctrl+F<\/strong> \u092a\u094d\u0930\u0947\u0938 \u0915\u0930\u0915\u0947 \u092d\u0940 \u0921\u093e\u092f\u0930\u0947\u0915\u094d\u091f\u0932\u0940 \u0913\u092a\u0928 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 <strong>Find and Select <\/strong>\u092c\u0939\u0941\u0924 \u092f\u0942\u091c\u092b\u0942\u0932 \u0915\u092e\u093e\u0902\u0921 \u0939\u0948\u0964<\/p>\n\n\n\n<h4><strong>Replace<\/strong><\/h4>\n\n\n\n<p>\u092f\u0947 \u0911\u092a\u094d\u0936\u0928 \u0906\u092a\u0915\u094b <strong>Home tab<\/strong> \u092e\u0947\u0902 <strong>Find and Select<\/strong> \u0915\u0947 \u0905\u0902\u0921\u0930 \u092e\u093f\u0932 \u091c\u093e\u092f\u0947\u0917\u093e \u092f\u093e \u0905\u0917\u0930 \u0906\u092a <strong>Ctrl+H<\/strong> \u092a\u094d\u0930\u0947\u0938 \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u092d\u0940 \u092f\u0947 \u0911\u092a\u094d\u0936\u0928 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u092a\u0930 \u0926\u093f\u0916 \u091c\u093e\u092f\u0947\u0917\u093e\u0964 \u0907\u0938 \u0911\u092a\u094d\u0936\u0928 \u0915\u093e \u092f\u0942\u091c \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u0939\u0932\u0947 \u0938\u0947 \u092a\u094d\u0930\u0947\u091c\u0947\u0902\u091f \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u0930\u093f\u092a\u0932\u0947\u0938 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option.jpg\" alt=\"\" class=\"wp-image-16710\" width=\"1042\" height=\"987\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option.jpg 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-300x284.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-444x420.jpg 444w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<p><br><strong><em>\u091a\u0932\u093f\u090f \u0905\u092c \u092f\u0947 \u0938\u092c \u091a\u0940\u095b\u0947\u0902 \u0935\u093f\u0938\u094d\u0924\u093e\u0930 \u092e\u0947\u0902 \u090f\u0915 \u0909\u0926\u093e\u0939\u0930\u0923 \u0932\u0947\u0915\u0930 \u0938\u092e\u091d\u0947\u0902 \u0915\u094d\u092f\u094b\u0902\u0915\u093f \u0909\u0926\u093e\u0939\u0930\u0923 \u0938\u0947 \u0938\u092c\u0938\u0947 \u0905\u091a\u094d\u091b\u0940 \u0924\u0930\u0939 \u0906\u092a\u0915\u094b \u0938\u093e\u0930\u0947 \u092b\u0940\u091a\u0930\u094d\u0938 \u0938\u092e\u091d \u0906\u090f\u0902\u0917\u0947\u0964<\/em><\/strong><\/p>\n\n\n\n<h3><strong>\u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 sort \u0914\u0930 filter \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925 \u0938\u0940\u0916\u0947\u0902<\/strong><\/h3>\n\n\n\n<p>\u092e\u0948\u0902 \u0909\u0926\u093e\u0939\u0930\u0923 \u0932\u0947 \u0930\u0939\u093e \u0939\u0942\u0901 \u0915\u0915\u094d\u0937\u093e 10\u0935\u0940\u0902 \u0915\u0947 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u0947 \u092e\u093e\u0930\u094d\u0915\u094d\u0938 \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0915\u093e \u091c\u093f\u0938\u0947 \u0939\u092e\u0928\u0947 \u0915\u0941\u091b \u0910\u0938\u0947 \u090f\u0902\u091f\u0930 \u0915\u093f\u092f\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-Raw.xlsx\"> \u092f\u0939\u093e\u0902 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0947\u0902 \u092c\u093f\u0917\u093f\u0928\u0930 \u092a\u093e\u0930\u094d\u091f 2 RAW \u0921\u093e\u091f\u093e \u0936\u0940\u091f <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-Raw.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1.jpg\" alt=\"\" class=\"wp-image-16757\" width=\"1043\" height=\"840\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1-300x242.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1-521x420.jpg 521w\" sizes=\"(max-width: 1043px) 100vw, 1043px\" \/><\/figure><\/div>\n\n\n\n<h4><strong>\u0907\u0938 \u0921\u093e\u091f\u093e \u0938\u0947 \u0939\u092e \u0915\u0908 \u091a\u0940\u091c\u0947\u0902 \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0947\u0902\u0917\u0947 \u091c\u0948\u0938\u0947- <\/strong><\/h4>\n\n\n\n<ul><li>Merge and Center \u0915\u0948\u0938\u0947 \u0915\u0930\u0947\u0902 \u2013 Merge and Center option<\/li><li> Alphabetically \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094b \u0915\u0948\u0938\u0947 \u0935\u094d\u092f\u0935\u0938\u094d\u0925\u093f\u0924 \u0915\u0930\u0947\u0902 &#8211; Sort option<\/li><li> Total \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u093e\u0932\u0947\u0902 -SUM fn<\/li><li> Percentage \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u093e\u0932\u0947 &#8211; Multiplication operator<\/li><li> Grading aur pass\/fail \u0915\u0948\u0938\u0947 \u092a\u0924\u093e \u0915\u0930\u0947\u0902 \u2013 IF and IFS function use<\/li><li> \u0915\u0948\u0938\u0947 \u0938\u093f\u0930\u094d\u092b \u092e\u0939\u093f\u0932\u093e \u092f\u093e \u092a\u0941\u0930\u0941\u0937 \u0915\u093e \u0921\u093e\u091f\u093e \u0928\u093f\u0915\u093e\u0932\u0947\u0902  &#8211; Filter option<\/li><li> \u0915\u0948\u0938\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f \u0915\u093e \u0921\u093e\u091f\u093e \u0922\u0942\u0902\u0922\u0947\u0902 \u2013 Find option<\/li><li> \u0915\u0948\u0938\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f \u0915\u0947 \u0917\u0932\u0924 \u0921\u093e\u091f\u093e \u0915\u094b \u0938\u0939\u0940 \u0915\u0930\u0947\u0902 &#8211; Replace option<\/li><\/ul>\n\n\n\n<p>\u091a\u0932\u093f\u092f\u0947 \u0926\u0947\u0916\u0947\u0902 \u092a\u0939\u0932\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 &#8211;<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Merge \u0914\u0930 Center \u0915\u0948\u0938\u0947 \u0915\u0930\u0947\u0902 \u2013 Merge \u0914\u0930 Center option<\/strong><\/p>\n\n\n\n<p>\u0939\u092e \u0907\u0938\u092e\u0947\u0902 <strong>Merge and Center <\/strong>\u0915\u093e \u092f\u0942\u091c \u0915\u0930\u0915\u0947 \u0915\u0941\u091b cells \u0915\u094b \u092e\u0930\u094d\u091c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u091c\u0948\u0938\u0947 \u0915\u093f \u092e\u0948\u0902\u0928\u0947 \u0915\u093f\u092f\u093e <strong><em>Subject Marks<\/em><\/strong> \u0915\u094b \u0915\u094d\u092f\u094b\u0902\u0915\u093f \u0938\u093e\u0930\u0947 \u0938\u092c\u094d\u091c\u0947\u0915\u094d\u091f\u094d\u0938 \u092e\u093e\u0930\u094d\u0915\u094d\u0938 <strong>Subject Marks <\/strong>\u0915\u0947 \u0905\u0902\u0921\u0930 \u0939\u0940 \u0906\u090f\u0902\u0917\u0947. \u0926\u0947\u0916\u093f\u092f\u0947 \u0910\u0938\u0947- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1.jpg\" alt=\"\" class=\"wp-image-16763\" width=\"1054\" height=\"824\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1-300x235.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1-537x420.jpg 537w\" sizes=\"(max-width: 1054px) 100vw, 1054px\" \/><\/figure><\/div>\n\n\n\n<p>\u0910\u0938\u0947 \u0939\u0940 \u0906\u092a \u092f\u0947 S. no. \u0914\u0930 name \u0915\u0947 \u0932\u093f\u090f \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\n\n\n\n<p>\u092f\u0939 \u092b\u093f\u0930 \u0915\u0941\u091b \u0910\u0938\u093e \u0932\u0917\u0947\u0917\u093e &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1.jpg\" alt=\"\" class=\"wp-image-16775\" width=\"1036\" height=\"860\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1-300x249.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1-506x420.jpg 506w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><strong>\u091a\u0932\u093f\u090f \u0905\u092c \u0926\u0947\u0916\u0947\u0902 \u0915\u0948\u0938\u0947 \u0939\u092e \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094d\u0932\u0940\u0928\u093f\u0902\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/strong><\/p>\n\n\n\n<h3><strong> <a name=\"sort-kaise-karte-hain\">Sort \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948<\/a><\/strong><\/h3>\n\n\n\n<p>\u0905\u0917\u0930 \u0906\u092a\u0915\u094b \u092a\u0924\u093e \u0928\u0939\u0940\u0902 \u0939\u0948 \u0915\u093f sort \u0915\u094d\u092f\u093e \u0939\u094b\u0924\u093e \u0939\u0948 \u0924\u094b \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Alphabetically \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094b \u0915\u0948\u0938\u0947 \u0935\u094d\u092f\u0935\u0938\u094d\u0925\u093f\u0924 \u0915\u0930\u0947\u0902 &#8211; Sort option<\/strong><\/p>\n\n\n\n<p>\u0905\u0917\u0930 \u0906\u092a \u0938\u092c \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u093e \u0921\u093e\u091f\u093e \u0909\u0928\u0915\u0947 \u0928\u093e\u092e \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 alphabetically \u0935\u094d\u092f\u0935\u0938\u094d\u0925\u093f\u0924 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u092a\u0939\u0932\u0947 \u091c\u093f\u0938 \u0921\u093e\u091f\u093e \u0915\u094b sort \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0935\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902, \u092f\u0947 \u0938\u093f\u0932\u0947\u0915\u094d\u0936\u0928 \u0906\u092a\u0915\u094b \u0927\u094d\u092f\u093e\u0928 \u0938\u0947 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 \u092e\u0948\u0902\u0928\u0947 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u0947 \u0928\u093e\u092e (excluding the heading Name) \u0914\u0930 \u0909\u0928\u0915\u0947 \u0915\u0930\u0947\u0938\u094d\u092a\u094b\u0902\u0921\u093f\u0902\u0917 \u092e\u093e\u0930\u094d\u0915\u094d\u0938 \u0915\u0947 cells (excluding name of subject) \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u093f\u092f\u093e \u0939\u0948 \u0915\u0941\u091b \u0910\u0938\u0947- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1.jpg\" alt=\"\" class=\"wp-image-16781\" width=\"1036\" height=\"770\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-300x224.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-80x60.jpg 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-160x120.jpg 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-265x198.jpg 265w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-485x360.jpg 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-564x420.jpg 564w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/figure><\/div>\n\n\n\n<p>\u0905\u092c \u0938\u093f\u0932\u0947\u0915\u094d\u0936\u0928 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u091c\u093e\u090f\u0901 Home tab &gt; Sort and Filter &gt; Sort A to Z.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-2-1.jpg\" alt=\"\" class=\"wp-image-16787\" width=\"1052\" height=\"505\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-2-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-2-1-300x144.jpg 300w\" sizes=\"(max-width: 1052px) 100vw, 1052px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u092f\u0947 \u0915\u0941\u091b \u0910\u0938\u093e \u0926\u093f\u0916\u0947\u0917\u093e &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3.jpg\" alt=\"\" class=\"wp-image-16793\" width=\"1042\" height=\"953\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3-300x275.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3-459x420.jpg 459w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<p style=\"font-size:18px\"><strong>Total \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u093e\u0932\u0947\u0902 &#8211; SUM function<\/strong><\/p>\n\n\n\n<p>\u0906\u092a \u0907\u0928 \u0938\u093e\u0930\u0947 \u092e\u093e\u0930\u094d\u0915\u094d\u0938 \u0915\u093e \u091f\u094b\u091f\u0932 \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948 SUM function \u0915\u093e \u092f\u0942\u091c \u0915\u0930\u0915\u0947\u0964<\/p>\n\n\n\n<p>SUM \u092b\u0902\u0915\u094d\u0936\u0928 \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u091c\u093f\u0938 cell \u092e\u0947\u0902 \u091f\u094b\u091f\u0932 \u092e\u093e\u0930\u094d\u0915\u094d\u0938 \u091a\u093e\u0939\u093f\u090f \u0909\u0938 \u0938\u0947\u0932 \u092e\u0947\u0902 \u092f\u0947 \u091f\u093e\u0907\u092a \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e &#8211;<\/p>\n\n\n\n<p><strong>&nbsp;=SUM(C10:G10)&nbsp; <\/strong><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function.jpg\" alt=\"\" class=\"wp-image-16799\" width=\"1030\" height=\"792\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function-300x231.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function-545x420.jpg 545w\" sizes=\"(max-width: 1030px) 100vw, 1030px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u0928\u094b\u091f<\/strong>: \u092e\u0947\u0930\u0947 cells \u091c\u093f\u0928\u092e\u0947\u0902 \u0938\u092c\u094d\u091c\u0947\u0915\u094d\u091f \u092e\u093e\u0930\u094d\u0915\u094d\u0938 \u0939\u0948\u0902 \u0909\u0928\u0915\u0940 \u0930\u0947\u0902\u091c C10 \u0938\u0947 G10 \u0939\u0948 \u0907\u0938\u0932\u093f\u090f \u090a\u092a\u0930 \u092e\u0947\u0930\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u092e\u0947\u0902 C10:G10 \u0939\u0948\u0902\u0964 \u0906\u092a\u0915\u0947 cells \u0915\u0940 \u0930\u0947\u0902\u091c \u0905\u0932\u0917 \u092d\u0940 \u0939\u094b \u0938\u0915\u0924\u0940 \u0939\u0948\u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0938\u092c\u0938\u0947 \u092c\u0947\u0938\u094d\u091f \u0939\u0948 \u0915\u093f \u0906\u092a =SUM(  \u0932\u093f\u0916\u0915\u0930 \u091c\u093f\u0938 \u0930\u0947\u0902\u091c \u0915\u093e SUM \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0909\u0938\u0947 \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930 \u0932\u0947\u0902 \u0907\u0938\u0938\u0947 \u0906\u092a\u0915\u0940 \u0930\u093f\u0915\u094d\u0935\u093e\u092f\u0930\u094d\u0921 \u0930\u0947\u0902\u091c \u0905\u092a\u0928\u0947 \u0906\u092a \u092b\u0902\u0915\u094d\u0936\u0928 \u092e\u0947\u0902 \u0926\u093f\u0916\u0928\u0947 \u0932\u0917\u0947\u0917\u0940, \u091c\u0948\u0938\u0947 \u092e\u0947\u0930\u0940 \u0939\u0941\u0908 &#8211;<\/p>\n\n\n\n<p>&nbsp;<strong>=SUM(C10:G10<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-1.jpg\" alt=\"\" class=\"wp-image-16805\" width=\"1008\" height=\"573\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-1-300x170.jpg 300w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2.jpg\" alt=\"\" class=\"wp-image-16811\" width=\"1001\" height=\"937\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2-300x281.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2-449x420.jpg 449w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u092e\u0947\u0902 \u092c\u094d\u0930\u0948\u0915\u0947\u091f \u092c\u0902\u0926 \u0915\u0940\u091c\u093f\u092f\u0947 \u0910\u0938\u0947 &#8211;<\/p>\n\n\n\n<p><strong>=SUM(C10:G10)<\/strong><\/p>\n\n\n\n<p>\u0905\u092c Enter \u0926\u092c\u093e\u0907\u090f\u0964 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u093e \u091f\u094b\u091f\u0932 \u092e\u093f\u0932 \u091c\u093e\u090f\u0917\u093e\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3.jpg\" alt=\"\" class=\"wp-image-16818\" width=\"1002\" height=\"797\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3-300x239.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3-528x420.jpg 528w\" sizes=\"(max-width: 1002px) 100vw, 1002px\" \/><\/figure><\/div>\n\n\n\n<p>\u092f\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0938\u093e\u0930\u0947 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u0947 \u0932\u093f\u090f \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092a\u0939\u0932\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 \u091f\u094b\u091f\u0932 \u0915\u093f\u092f\u0947 \u0939\u0941\u090f \u0938\u0947\u0932 \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0914\u0930 \u092b\u093f\u0930 \u0909\u0938\u0947 \u0928\u0940\u091a\u0947 \u091c\u0939\u093e\u0901 \u0924\u0915 \u090f\u0915 \u091c\u0948\u0938\u093e \u092b\u093e\u0930\u094d\u092e\u0942\u0932\u093e \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u093e \u0939\u0948 \u0921\u094d\u0930\u0948\u0917 \u0915\u0930\u0947\u0902 \u092f\u0947 \u091a\u0940\u095b Fill \u092b\u0940\u091a\u0930 \u0915\u0940 \u0935\u091c\u0939 \u0938\u0947 \u0939\u094b\u0924\u0940 \u0939\u0948\u0964 \u0906\u092a \u0928\u0940\u091a\u0947 \u091c\u0939\u093e\u0901 \u0924\u0915 \u0921\u094d\u0930\u0948\u0917 \u0915\u0930\u0947\u0902\u0917\u0947 \u0935\u0939\u093e\u0901 \u0924\u0915 \u0911\u091f\u094b\u092e\u0947\u091f\u093f\u0915\u0932\u0940 \u092f\u0947 \u092b\u093e\u0930\u094d\u092e\u0942\u0932\u093e Fill \u092b\u0940\u091a\u0930 \u0938\u0947 \u092c\u093e\u0915\u0940 \u0938\u0947\u0932\u094d\u0938 \u092e\u0947\u0902 \u0905\u092a\u094d\u0932\u093e\u0908 \u0939\u094b \u091c\u093e\u092f\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Percentage \u0915\u0948\u0938\u0947 \u0928\u093f\u0915\u093e\u0932\u0947\u0902 &#8211; Multiplication operator<\/strong><\/p>\n\n\n\n<p>Percentage \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u092e\u0948\u0902 \u090f\u0915 \u0915\u0949\u0932\u092e \u0905\u0927\u093f\u0915\u0924\u092e \u092e\u093e\u0930\u094d\u0915\u094d\u0938 \u0915\u093e \u091c\u094b\u095c\u0915\u0930 \u0930\u0939\u093e \u0939\u0942\u0901 \u0910\u0938\u0947 &#8211;<\/p>\n\n\n\n<p>Percentage \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u092f\u0947 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u092f\u0942\u091c \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e &#8211;<\/p>\n\n\n\n<p class=\"has-text-align-left\"><strong>% of total marks scored = (Total marks scored\/MAx. Marks)&nbsp;* 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;       &nbsp;&nbsp;             <\/strong><\/p>\n\n\n\n<p>\u0907\u0938\u0938\u0947 \u090f\u0915\u094d\u0938\u0947\u0932 \u092e\u0947\u0902 \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u092a\u0939\u0932\u0947 \u091c\u093f\u0938 \u0938\u0947\u0932 \u092e\u0947\u0902 \u0906\u092a\u0915\u094b \u092a\u0930\u0938\u0947\u0902\u091f\u0947\u091c \u0928\u093f\u0915\u093e\u0932\u0928\u0940 \u0939\u0948 \u0909\u0938\u092e\u0947\u0902 \u0911\u092a\u0930\u0947\u091f\u0930\u094d\u0938 \u0915\u093e \u0909\u0938\u0947 \u0915\u0930\u0915\u0947 \u092b\u093e\u0930\u094d\u092e\u0942\u0932\u093e \u0932\u093f\u0916\u0947\u0902 \u091c\u0948\u0938\u0947 \u092e\u0948\u0902\u0928\u0947 \u0915\u093f\u092f\u093e- <\/p>\n\n\n\n<p><strong>=(H10\/I10)*100<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    <br> &nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1.jpg\" alt=\"\" class=\"wp-image-16824\" width=\"987\" height=\"830\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1-300x253.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1-498x420.jpg 498w\" sizes=\"(max-width: 987px) 100vw, 987px\" \/><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 entar \u0926\u092c\u093e\u090f\u0901 \u0914\u0930 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0940 percentage \u092e\u093f\u0932 \u091c\u093e\u090f\u0917\u0940\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2.jpg\" alt=\"\" class=\"wp-image-16832\" width=\"977\" height=\"912\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2-300x281.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2-449x420.jpg 449w\" sizes=\"(max-width: 977px) 100vw, 977px\" \/><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3.jpg\" alt=\"\" class=\"wp-image-16838\" width=\"999\" height=\"974\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3-300x293.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3-430x420.jpg 430w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4.jpg\" alt=\"\" class=\"wp-image-16845\" width=\"1042\" height=\"1026\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4-300x296.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4-426x420.jpg 426w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u0947 \u0938\u092c \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u0947 \u0932\u093f\u090f \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u091c\u093f\u0938 cell \u092e\u0947\u0902 \u0905\u092d\u0940 \u0906\u092a\u0928\u0947 \u092a\u0930\u0938\u0947\u0902\u091f\u0947\u091c \u0915\u093e \u092b\u093e\u0930\u094d\u092e\u0942\u0932\u093e \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u093e \u0909\u0938\u0947 \u0928\u0940\u091a\u0947 \u0921\u094d\u0930\u0948\u0917 \u0915\u0930 \u0926\u0947\u0902 \u091c\u0939\u093e\u0901 \u0924\u0915 \u0906\u092a\u0915\u094b \u092f\u0947 \u092b\u093e\u0930\u094d\u092e\u0942\u0932\u093e \u0909\u0938\u0940 \u0924\u0930\u0939 \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Grading \u0914\u0930 pass\/fail \u0915\u0948\u0938\u0947 \u092a\u0924\u093e \u0915\u0930\u0947\u0902 \u2013 IF \u0914\u0930 IFS function \u0915\u093e \u092f\u0942\u091c<\/strong><\/p>\n\n\n\n<p><strong>GRADING<\/strong><\/p>\n\n\n\n<p>Grading \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b IFS \u0915\u093e \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u092f\u0942\u091c \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964<\/p>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0901 \u0905\u092a\u0928\u093e \u0917\u094d\u0930\u0947\u0921\u093f\u0902\u0917 \u0938\u093f\u0938\u094d\u091f\u092e \u092f\u0947 \u0932\u093f\u092f\u093e \u0939\u0948 &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Grading-criteria.jpg\" alt=\"\" class=\"wp-image-16881\" width=\"1064\" height=\"101\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Grading-criteria.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Grading-criteria-300x29.jpg 300w\" sizes=\"(max-width: 1064px) 100vw, 1064px\" \/><\/figure><\/div>\n\n\n\n<p>\u0905\u092c \u091a\u0932\u093f\u092f\u0947 \u0926\u0947\u0916\u0924\u0947 \u0939\u0948 \u0915\u093f \u0915\u0948\u0938\u0947 IFS \u092b\u0902\u0915\u094d\u0936\u0928 \u0917\u094d\u0930\u0947\u0921\u093f\u0902\u0917 \u0915\u0947 \u0932\u093f\u090f \u0905\u092a\u094d\u0932\u093e\u0908 \u0939\u094b\u0924\u093e \u0939\u0948 &#8211;<\/p>\n\n\n\n<p>\u0907\u0938 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u094b \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u091c\u093f\u0938 \u0915\u0949\u0932\u092e \u092e\u0947\u0902 grades \u091a\u093e\u0939\u093f\u090f \u0909\u0938\u092e\u0947\u0902 \u0905\u092c\u0942\u0935 \u0915\u094d\u0930\u093e\u0907\u091f\u0947\u0930\u093f\u092f\u093e \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u092f\u0947 \u0938\u094d\u091f\u0947\u091f\u092e\u0947\u0902\u091f \u0932\u093f\u0916\u0928\u0940 \u0939\u094b\u0917\u0940 &#8211; <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-1-1.jpg\" alt=\"\" class=\"wp-image-16887\" width=\"1064\" height=\"535\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-1-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-1-1-300x151.jpg 300w\" sizes=\"(max-width: 1064px) 100vw, 1064px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-3-1.jpg\" alt=\"\" class=\"wp-image-16893\" width=\"1047\" height=\"54\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-3-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-3-1-300x16.jpg 300w\" sizes=\"(max-width: 1047px) 100vw, 1047px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u0928\u094b\u091f: <\/strong>\u092f\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u0932\u0947\u091f\u0947\u0938\u094d\u091f \u0935\u0930\u094d\u0936\u0928 \u092e\u0947\u0902 \u0939\u0940 \u0939\u0948\u0964 \u0906\u092a \u0905\u092a\u0928\u0940 \u0915\u0949\u0932\u092e \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u092f\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0932\u0917\u093e\u090f\u0902 \u091c\u0948\u0938\u0947 \u092e\u0947\u0930\u0940 \u092a\u0930\u0938\u0947\u0902\u091f\u0947\u091c J10 \u092e\u0947\u0902 \u0925\u0940 \u091c\u093f\u0938\u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u092e\u0948\u0902\u0928\u0947 IFS \u092b\u0902\u0915\u094d\u0936\u0928 \u092e\u0947\u0902 \u0939\u0930 \u091c\u0917\u0939 J10 \u0938\u0947\u0932 \u0915\u093e \u092f\u0942\u091c \u0915\u093f\u092f\u093e \u0939\u0948\u0964<\/p>\n\n\n\n<p>\u092f\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0932\u0917\u093e\u0928\u0947 \u092a\u0930 \u0906\u092a\u0915\u094b \u092f\u0947 \u092e\u093f\u0932\u0947\u0917\u093e &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1.jpg\" alt=\"\" class=\"wp-image-16900\" width=\"1047\" height=\"894\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1-300x256.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1-492x420.jpg 492w\" sizes=\"(max-width: 1047px) 100vw, 1047px\" \/><\/figure><\/div>\n\n\n\n<p>\u092f\u0939 \u0938\u092c \u092e\u0947\u0902 \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u0907\u0938 cell \u0915\u094b \u0928\u0940\u091a\u0947 \u0921\u094d\u0930\u0948\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0926\u0947\u0916\u093f\u092f\u0947 \u0910\u0938\u0947 &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1.jpg\" alt=\"\" class=\"wp-image-16912\" width=\"1075\" height=\"990\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1-300x277.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1-456x420.jpg 456w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><strong><br>PASS\/FAIL<\/strong><\/p>\n\n\n\n<p>\u0917\u094d\u0930\u0947\u0921\u093f\u0902\u0917 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u0947 \u0932\u093f\u090f pass\/fail \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u092c\u0939\u0941\u0924 \u0938\u0930\u0932 \u0939\u094b\u0917\u093e\u0964 \u092f\u0947 \u0906\u092a IF \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u093e \u092f\u0942\u091c \u0915\u0930\u0915\u0947 \u092c\u0939\u0941\u0924 \u0938\u0930\u0932\u0924\u093e \u0938\u0947 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p>\u0928\u094b\u091f: \u092e\u0948\u0902\u0928\u0947 \u092f\u0939\u093e\u0901 \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094b \u0925\u094b\u095c\u093e \u0939\u0947\u0930\u092b\u0947\u0930 \u0915\u093f\u092f\u093e \u0939\u0948 \u0924\u093e\u0915\u093f \u0906\u092a\u0915\u094b pass\/fail \u095b\u094d\u092f\u093e\u0926\u093e \u0905\u091a\u094d\u091b\u0940 \u0924\u0930\u0939 \u0938\u0947 \u092a\u0924\u093e \u091a\u0932\u0947 \u0915\u094d\u092f\u094b\u0902\u0915\u093f \u0939\u092e\u093e\u0930\u0947 \u092a\u0939\u0932\u0947 \u0915\u0947 \u0921\u093e\u091f\u093e \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0938\u092c \u092a\u093e\u0938 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p>\u092e\u0948\u0902\u0928\u0947 pass\/fail \u0915\u094d\u0930\u093e\u0907\u091f\u0947\u0930\u093f\u092f\u093e \u092f\u0947 \u0932\u093f\u092f\u093e \u0939\u0948 &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-crieteria-1.jpg\" alt=\"\" class=\"wp-image-16924\" width=\"1048\" height=\"686\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-crieteria-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-crieteria-1-300x197.jpg 300w\" sizes=\"(max-width: 1048px) 100vw, 1048px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u0915\u094b \u0905\u092a\u094d\u0932\u093e\u0908 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092a\u0939\u0932\u0947 \u0906\u092a \u0909\u0938 cell \u092a\u0930 \u091c\u093e\u0908\u092f\u0947 \u091c\u0939\u093e\u0901 \u0906\u092a\u0915\u094b \u092f\u0947 \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0939\u0948 \u0914\u0930 \u0935\u0939\u093e\u0902 \u092f\u0947 \u092b\u093e\u0930\u094d\u092e\u0942\u0932\u093e \u0932\u093f\u0916 \u0926\u0940\u091c\u093f\u092f\u0947 &#8211; <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function.jpg\" alt=\"\" class=\"wp-image-16930\" width=\"1080\" height=\"242\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-300x67.jpg 300w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/figure><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-1.1.jpg\" alt=\"\" class=\"wp-image-16936\" width=\"1058\" height=\"211\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-1.1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-1.1-300x60.jpg 300w\" sizes=\"(max-width: 1058px) 100vw, 1058px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Press <strong>Enter<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4.jpg\" alt=\"\" class=\"wp-image-16958\" width=\"1042\" height=\"787\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-300x227.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-80x60.jpg 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-160x120.jpg 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-556x420.jpg 556w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u0915\u094b \u0906\u092a \u0928\u0940\u091a\u0947 \u0921\u094d\u0930\u0948\u0917 \u0915\u0930\u0915\u0947 \u0938\u093e\u0930\u0947 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u0947 \u0932\u093f\u090f \u092d\u0940 \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2.jpg\" alt=\"\" class=\"wp-image-16942\" width=\"1043\" height=\"826\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2-300x238.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2-531x420.jpg 531w\" sizes=\"(max-width: 1043px) 100vw, 1043px\" \/><\/figure><\/figure><\/div>\n\n\n\n<h3 id=\"-excel_mein_filter_kaise_lagate_hain\"><strong><a name=\"filter-kaise-lagate-hain\">Filter \u0915\u0948\u0938\u0947 \u0932\u0917\u093e\u0924\u0947 \u0939\u0948<\/a><\/strong><\/h3>\n\n\n\n<p style=\"font-size:18px\"><strong>\u0915\u0948\u0938\u0947 \u0938\u093f\u0930\u094d\u092b males \u092f\u093e females \u0915\u093e \u0921\u093e\u091f\u093e \u0928\u093f\u0915\u093e\u0932\u0947\u0902 &#8211; Filter option<\/strong><\/p>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u092a\u0939\u0932\u0947 \u0906\u092a \u0907\u0938\u092e\u0947\u0902 \u090f\u0915 blank \u0915\u0949\u0932\u092e Insert \u0915\u0930 \u0932\u0947\u0902\u0964 GENDER \u0915\u0947 \u0932\u093f\u090f \u0910\u0938\u0947 &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row.jpg\" alt=\"\" class=\"wp-image-16973\" width=\"1024\" height=\"1074\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row-286x300.jpg 286w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row-401x420.jpg 401w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2.jpg\" alt=\"\" class=\"wp-image-16980\" width=\"1028\" height=\"1215\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2-254x300.jpg 254w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2-355x420.jpg 355w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0905\u092c Insert \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u0907\u0938\u092e\u0947\u0902 \u091c\u0947\u0902\u0921\u0930 \u0930\u093f\u0932\u0947\u091f\u0947\u0921 \u0921\u093e\u091f\u093e \u091f\u093e\u0907\u092a \u0915\u0930 \u0926\u0947\u0902\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column.jpg\" alt=\"\" class=\"wp-image-16986\" width=\"1013\" height=\"1034\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column-294x300.jpg 294w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column-356x364.jpg 356w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column-412x420.jpg 412w\" sizes=\"(max-width: 1013px) 100vw, 1013px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Males\/Females\/Other \u0915\u093e \u0921\u093e\u091f\u093e Filter \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094b \u0938\u0939\u0940 \u0938\u0947 \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947\u0902 \u0910\u0938\u0947 &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-1-Select.jpg\" alt=\"\" class=\"wp-image-16992\" width=\"1061\" height=\"446\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-1-Select.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-1-Select-300x127.jpg 300w\" sizes=\"(max-width: 1061px) 100vw, 1061px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u092f\u0947 \u0915\u0930\u0947\u0902 &#8211; <strong>Home tab &gt; Sort and Filter &gt; Filter. <\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-2.jpg\" alt=\"\" class=\"wp-image-16998\" width=\"1070\" height=\"545\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-2-300x153.jpg 300w\" sizes=\"(max-width: 1070px) 100vw, 1070px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u093f \u0906\u092a\u0915\u0940 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u092a\u0930 \u0939\u0947\u0921\u093f\u0902\u0917\u094d\u0938 \u0915\u0947 \u092a\u093e\u0938 small scroll buttons \u0926\u093f\u0916 \u0930\u0939\u0947 \u0939\u094b\u0902\u0917\u0947 \u0910\u0938\u0947- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-3.jpg\" alt=\"\" class=\"wp-image-17004\" width=\"1066\" height=\"487\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-3-300x137.jpg 300w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u092f\u0947 \u0938\u094d\u0915\u094d\u0930\u0949\u0932 \u092c\u091f\u0928 Filter options \u0939\u0948\u0902\u0964 \u0905\u092c \u091c\u0948\u0938\u0947 \u092e\u0941\u091d\u0947 \u0938\u093f\u0930\u094d\u092b \u092e\u0939\u093f\u0932\u093e\u0913\u0902 \u0915\u093e \u0921\u093e\u091f\u093e \u091a\u093e\u0939\u093f\u090f \u092f\u093e \u092e\u0939\u093f\u0932\u093e\u0913\u0902 \u0915\u093e \u0921\u093e\u091f\u093e filter \u0915\u0930\u0928\u093e \u0939\u0948 \u0924\u094b \u0906\u092a <strong>gender <\/strong>\u0915\u0947 \u0938\u093e\u0907\u0921 \u0915\u0947 \u0938\u094d\u0915\u094d\u0930\u0949\u0932 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u0938\u093f\u0930\u094d\u092b &#8216;female&#8217; \u092a\u0930 \u091f\u093f\u0915 \u0915\u0930 \u0926\u0947\u0902 \u0914\u0930 \u0907\u0938\u0938\u0947 \u0906\u092a\u0915\u094b \u0938\u093f\u0930\u094d\u092b \u092e\u0939\u093f\u0932\u093e\u0913\u0902 \u0915\u093e \u0921\u093e\u091f\u093e \u092e\u093f\u0932 \u091c\u093e\u092f\u0947\u0917\u093e \u0910\u0938\u0947 &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4.jpg\" alt=\"\" class=\"wp-image-17010\" width=\"952\" height=\"952\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4-150x150.jpg 150w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4-300x300.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4-420x420.jpg 420w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5.jpg\" alt=\"\" class=\"wp-image-17017\" width=\"955\" height=\"930\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5-300x292.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5-432x420.jpg 432w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Female \u0915\u093e \u095e\u093f\u0932\u094d\u091f\u0930 \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u092a\u0930 \u092c\u0938 females \u0915\u093e \u0921\u093e\u091f\u093e \u0939\u0940 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-6.jpg\" alt=\"\" class=\"wp-image-17032\" width=\"1043\" height=\"353\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-6.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-6-300x102.jpg 300w\" sizes=\"(max-width: 1043px) 100vw, 1043px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0910\u0938\u0947 \u0939\u0940 \u0906\u092a \u095e\u0947\u0932 \u0939\u0941\u090f \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f\u094d\u0938 \u0915\u0947 \u0932\u093f\u090f filter \u0932\u0917\u093e \u0938\u0915\u0924\u0947 \u0939\u0948, \u092f\u0947 \u0906\u092a PASS\/FAIL \u0915\u0947 \u0938\u094d\u0915\u094d\u0930\u0949\u0932 \u092e\u0947\u0902 \u091c\u093e\u0915\u0930 \u0938\u0932\u0947\u0915\u094d\u091f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0910\u0938\u0947- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-7.jpg\" alt=\"\" class=\"wp-image-17039\" width=\"1072\" height=\"258\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-7.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-7-300x73.jpg 300w\" sizes=\"(max-width: 1072px) 100vw, 1072px\" \/><\/figure><\/figure><\/div>\n\n\n\n<h3><strong><a name=\"find-aur-replace-ka-kya-use-hai\">Find \u0914\u0930 Replace \u0915\u093e \u0915\u094d\u092f\u093e \u092f\u0942\u091c \u0939\u0948<\/a><\/strong><a name=\"find-aur-replace-ka-kya-use-hai\"><strong><\/strong><\/a><\/h3>\n\n\n\n<p style=\"font-size:19px\"><strong>\u0915\u0948\u0938\u0947 \u0915\u093f\u0938\u0940 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f \u0915\u093e \u0921\u093e\u091f\u093e Find \u0915\u0930\u0947\u0902 &#8211; Find option<\/strong><\/p>\n\n\n\n<p>\u091a\u0932\u093f\u090f \u0905\u092c \u091c\u093e\u0928\u0924\u0947 \u0939\u0948 \u0915\u093f \u0915\u0948\u0938\u0947 \u0939\u092e \u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f \u0915\u093e \u0921\u093e\u091f\u093e \u0909\u0938\u0915\u0947 \u0928\u093e\u092e \u0915\u0947 \u091c\u0930\u093f\u092f\u0947 \u095e\u093f\u0932\u094d\u091f\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 \u092f\u0939 \u092b\u0940\u091a\u0930 \u0938\u092c\u0938\u0947 \u095b\u094d\u092f\u093e\u0926\u093e \u0909\u092a\u092f\u094b\u0917\u0940 \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u092c \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 \u092c\u0939\u0941\u0924 \u0938\u093e\u0930\u093e \u0921\u093e\u091f\u093e \u0939\u094b \u0914\u0930 \u0906\u092a \u0916\u0941\u0926 \u0938\u093e\u0930\u0947 \u0921\u093e\u091f\u093e \u092e\u0947\u0902 \u0938\u0947 \u0910\u0938\u0947 \u0939\u0940 \u0926\u0947\u0916\u0915\u0930 \u0915\u093f\u0938\u0940 \u0938\u094d\u092a\u0947\u0938\u093f\u092b\u093f\u0915 \u091a\u0940\u095b \u0909\u0938\u0915\u094b find \u0928 \u0915\u0930 \u0938\u0915\u0947\u0902\u0964<\/p>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u092a\u0939\u0932\u0947 \u0906\u092a \u091c\u093e\u090f\u0902 <strong>Home tab > Find and Select > Find<\/strong> \u092f\u093e \u0905\u0917\u0930 \u0906\u092a \u0907\u0938\u0915\u0947 \u0932\u093f\u090f <strong>Ctrl+F<\/strong> \u0936\u0949\u0930\u094d\u091f\u0915\u091f \u0915\u0947 \u0915\u093e \u092f\u0942\u091c \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u092d\u0940 find \u0911\u092a\u094d\u0936\u0928 \u0915\u0940 \u0935\u093f\u0902\u0921\u094b \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u092a\u0930 \u0926\u093f\u0916 \u091c\u093e\u092f\u0947\u0917\u0940\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1.jpg\" alt=\"\" class=\"wp-image-17047\" width=\"1038\" height=\"1092\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1-285x300.jpg 285w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1-399x420.jpg 399w\" sizes=\"(max-width: 1038px) 100vw, 1038px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Find \u0911\u092a\u094d\u0936\u0928 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u0947 \u0938\u093e\u092e\u0928\u0947 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u092a\u0930 \u092f\u0939 \u0935\u093f\u0902\u0921\u094b \u0926\u093f\u0916\u0928\u0947 \u0932\u0917\u0947\u0917\u0940-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-2.jpg\" alt=\"\" class=\"wp-image-17053\" width=\"1080\" height=\"404\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-2-300x112.jpg 300w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u2018Find what\u2019 \u0915\u0947 \u0915\u0930\u0947\u0938\u094d\u092a\u094b\u0902\u0921\u093f\u0902\u0917 \u0906\u092a \u0935\u094b \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u091f\u093e\u0907\u092a \u0915\u0930\u093f\u092f\u0947 \u091c\u093f\u0938\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0906\u092a\u0915\u094b \u091c\u093e\u0928\u0928\u093e \u0939\u0948\u0964 \u092e\u0948\u0902\u0928\u0947 \u092f\u0939\u093e\u0901 \u201cKrish\u201d \u091f\u093e\u0907\u092a \u0915\u093f\u092f\u093e \u0939\u0948\u0964 \u201cKrish\u201d \u091f\u093e\u0907\u092a \u0915\u0930\u0924\u0947 \u0939\u0940 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u093f \u0906\u092a\u0915\u0940 cell \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0921\u093e\u092f\u0930\u0947\u0915\u094d\u091f\u0932\u0940 \u0909\u0938 \u0938\u0947\u0932 \u092a\u0930 \u091c\u093f\u0938\u092e\u0947\u0902 \u201cKrish\u201d \u0932\u093f\u0916\u093e \u0939\u0948 \u0909\u0938 \u092a\u0930 \u091a\u0932\u093e \u091c\u093e\u090f\u0917\u093e \u0910\u0938\u0947- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-3-Krish.jpg\" alt=\"\" class=\"wp-image-17059\" width=\"1055\" height=\"538\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-3-Krish.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-3-Krish-300x153.jpg 300w\" sizes=\"(max-width: 1055px) 100vw, 1055px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0905\u092c \u091c\u092c \u0906\u092a\u0915\u094b &#8220;Krish&#8221; \u0915\u0947 cell \u0915\u0940 \u092a\u094b\u091c\u0940\u0936\u0928 \u092e\u093f\u0932 \u0917\u092f\u0940 \u0939\u0948 \u0924\u094b \u0909\u0938\u0938\u0947 \u091c\u0941\u095c\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\n\n\n\n<p>\u0907\u0938 \u0911\u092a\u094d\u0936\u0928 \u0938\u0947 \u0905\u0917\u0930 \u0906\u092a\u0928\u0947 \u0915\u093f\u0938\u0940 \u0915\u093e \u0921\u093e\u091f\u093e \u0917\u0932\u0924 \u0921\u093e\u0932\u093e \u0939\u0948 \u0924\u094b \u0909\u0938\u0915\u0947 \u0928\u093e\u092e \u0915\u094b find \u0915\u0930\u0915\u0947 \u0914\u0930 \u092b\u093f\u0930 \u0909\u0938\u0915\u0940 \u0921\u093f\u091f\u0947\u0932\u094d\u0938 \u090f\u0921\u093f\u091f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>\u0915\u0948\u0938\u0947 \u0915\u093f\u0938\u0940 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f \u0915\u0947 \u0917\u0932\u0924 \u0921\u093e\u0932\u0947 \u0917\u090f \u0921\u093e\u091f\u093e \u0915\u094b \u0938\u0939\u0940 \u0915\u0930\u0947\u0902 &#8211; Replace option<\/strong><\/p>\n\n\n\n<p>\u091a\u0932\u093f\u092f\u0947 \u0905\u092c \u0926\u0947\u0916\u0924\u0947 \u0939\u0948 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0915\u093e \u0906\u0916\u093f\u0930\u0940 \u091f\u0949\u092a\u093f\u0915\u0964<\/p>\n\n\n\n<p>\u0915\u0932\u094d\u092a\u0928\u093e \u0915\u0940\u091c\u0940\u092f \u0915\u093f \u0906\u092a\u0928\u0947 \u0917\u0932\u0924\u0940 \u0938\u0947 \u0915\u093f\u0938\u0940 \u0938\u094d\u091f\u0942\u0921\u0947\u0902\u091f \u0915\u093e \u0928\u093e\u092e \u0917\u0932\u0924 \u0932\u093f\u0916 \u0926\u093f\u092f\u093e \u0939\u0948 \u0914\u0930 \u0906\u092a\u0915\u094b \u0909\u0938\u0947 \u092c\u0926\u0932\u0928\u093e \u0939\u0948 \u0924\u094b \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a Replace \u0911\u092a\u094d\u0936\u0928 \u092f\u0942\u091c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p>\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u092e\u0948\u0902\u0928\u0947 \u201cKrishna\u201d \u0915\u093e \u0928\u093e\u092e \u0917\u0932\u0924\u0940 \u0938\u0947 Krish \u090f\u0902\u091f\u0930 \u0915\u0930 \u0926\u093f\u092f\u093e \u0924\u094b \u092e\u0948\u0902 \u0907\u0938\u0947 Replace \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u091c\u093e\u0909\u0902\u0917\u0940 <strong>Home tab > Find and Select > Replace. <\/strong>\u092f\u093e \u0906\u092a \u0907\u0938 \u0911\u092a\u094d\u0936\u0928 \u0915\u0947 \u0932\u093f\u090f Ctrl+f \u0936\u0949\u0930\u094d\u091f\u0915\u091f key \u0915\u093e \u092d\u0940 \u092f\u0942\u091c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1.jpg\" alt=\"\" class=\"wp-image-17067\" width=\"1030\" height=\"974\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1-300x284.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1-444x420.jpg 444w\" sizes=\"(max-width: 1030px) 100vw, 1030px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Replace \u0911\u092a\u094d\u0936\u0928 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u090f\u0915 \u091b\u094b\u091f\u093e \u0935\u093f\u0902\u0921\u094b \u0926\u093f\u0916\u0947\u0917\u093e-<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img width=\"600\" height=\"222\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option2.jpg\" alt=\"\" class=\"wp-image-17073\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option2-300x111.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>\u0905\u092c \u0907\u0938\u092e\u0947\u0902 <strong>\u2018Find what\u2019<\/strong> \u0915\u0947 \u0915\u0930\u0947\u0938\u094d\u092a\u094b\u0902\u0921\u093f\u0902\u0917 \u0935\u094b \u091f\u093e\u0907\u092a \u0915\u0930\u0947\u0902 \u091c\u093f\u0938\u0947 \u0906\u092a <strong>Replace <\/strong>\u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0964 <strong>\u2018Replace with\u2019 <\/strong>\u092e\u0947\u0902 \u0935\u094b \u091f\u093e\u0907\u092a \u0915\u0930\u0947\u0902 \u091c\u094b \u0938\u0939\u0940 \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0939\u0948 \u092f\u093e \u091c\u093f\u0938 \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0938\u0947 \u0906\u092a \u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0947 \u0915\u094b Replace \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902\u0964 \u092f\u0939\u093e\u0901 \u092e\u0948\u0902 \u201cKrish\u201d \u0915\u0940 \u091c\u0917\u0939 \u201cKrishna\u201d Replace \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0940 \u0939\u0942\u0901\u0964 \u092f\u0947 \u0911\u092a\u094d\u0936\u0928 \u0938\u092c\u0938\u0947 \u095b\u094d\u092f\u093e\u0926\u093e \u0909\u092a\u092f\u094b\u0917\u0940 \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u092c \u0939\u092e\u0928\u0947 \u090f\u0915 \u0939\u0940 \u0938\u094d\u092a\u0947\u0932\u093f\u0902\u0917 \u092e\u093f\u0938\u094d\u091f\u0947\u0915 \u0915\u0908 \u091c\u0917\u0939 \u0915\u0940 \u0939\u094b \u0909\u0938\u0947<strong> \u2018Replace all\u2019 <\/strong>\u0915\u0930\u0915\u0947 \u0906\u092a \u090f\u0915 \u0938\u093e\u0925 \u091a\u0947\u0902\u091c \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-4-Krishna.jpg\" alt=\"\" class=\"wp-image-17079\" width=\"1087\" height=\"570\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-4-Krishna.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-4-Krishna-300x158.jpg 300w\" sizes=\"(max-width: 1087px) 100vw, 1087px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902 <strong>Replace<\/strong> \u092a\u0930<\/p>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u093f &#8220;Krish&#8221; \u091a\u0947\u0902\u0917 \u0939\u094b \u091c\u093e\u090f\u0917\u093e &#8220;Krishna&#8221; \u092e\u0947\u0902\u0964<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-5-changed-Krishna.jpg\" alt=\"\" class=\"wp-image-17085\" width=\"1059\" height=\"611\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-5-changed-Krishna.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-5-changed-Krishna-300x173.jpg 300w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/figure><\/div>\n\n\n\n<p>\u0910\u0938\u0947 \u0939\u0940 \u0906\u092a \u0914\u0930 \u092d\u0940 \u0909\u0926\u093e\u0939\u0930\u0923 \u0932\u0947\u0915\u0930 \u0905\u092a\u0928\u0947 \u0921\u093e\u091f\u093e \u0915\u094b sort \u0914\u0930 Filter \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0921\u093e\u091f\u093e \u0915\u094b \u0915\u094d\u0932\u0940\u0928 \u0914\u0930 \u0909\u092a\u092f\u094b\u0917\u0940 \u0924\u0930\u0940\u0915\u0947 \u0938\u0947 \u0938\u094d\u091f\u094b\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p>\u0905\u0917\u0930 \u0906\u092a \u091a\u093e\u0939\u0947\u0902 \u0924\u094b \u092f\u0947 RAW \u0921\u093e\u091f\u093e \u0914\u0930 \u092b\u093e\u0907\u0928\u0932 \u090f\u0915\u094d\u0938\u0947\u0932 \u0921\u093e\u091f\u093e \u0936\u0940\u091f \u092e\u0947\u0902 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u091a\u0947\u0915 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0905\u092a\u0928\u0947 \u0909\u0924\u094d\u0924\u0930\u0964<\/p>\n\n\n\n<p>\u0936\u0940\u091f \u0915\u093e \u0932\u093f\u0902\u0915 \u0928\u0940\u091a\u0947 \u0926\u093f\u092f\u093e \u0939\u0941\u0906 \u0939\u0948\u0964<\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-Raw.xlsx\">\u092f\u0939\u093e\u0902 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0947\u0902 \u092c\u093f\u0917\u093f\u0928\u0930 \u092a\u093e\u0930\u094d\u091f 2 RAW \u0921\u093e\u091f\u093e \u0936\u0940\u091f<\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-Raw.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/BEG-PART-2-Final.xlsx\">\u092f\u0939\u093e\u0902 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0947\u0902 \u092c\u093f\u0917\u093f\u0928\u0930 \u092a\u093e\u0930\u094d\u091f 2 \u0915\u093e \u095e\u093e\u0907\u0928\u0932 \u0921\u093e\u091f\u093e \u0936\u0940\u091f<\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/BEG-PART-2-Final.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<p class=\"has-text-align-center has-regular-font-size\"><em>\u0924\u094b \u0939\u092e \u0905\u092a\u0928\u093e \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092f\u0939\u0940\u0902 \u0938\u092e\u093e\u092a\u094d\u0924 \u0915\u0930\u0924\u0947 \u0939\u0948 \u0914\u0930 \u0906\u0936\u093e \u0915\u0930\u0924\u0947 \u0939\u0948 \u0915\u093f \u092f\u0947 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0906\u092a\u0915\u094b \u092e\u0926\u0926\u0917\u093e\u0930 \u0932\u0917\u093e \u0939\u094b\u0917\u093e \u0914\u0930 \u0907\u0938\u0947 \u092a\u095d\u0915\u0930 \u0906\u092a\u0915\u094b \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u0915\u0941\u091b \u090f\u0921\u0935\u093e\u0902\u0938 \u092c\u0947\u0938\u093f\u0915\u094d\u0938 \u0938\u092e\u091d \u0906 \u0917\u092f\u0947 \u0939\u094b\u0902\u0917\u0947\u0964 \u0914\u0930 \u0905\u0917\u0930 \u0906\u092a\u0915\u094b \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092f\u093e \u090f\u0915\u094d\u0938\u0932 \u0938\u0947 \u091c\u0941\u095c\u0940 \u0915\u094b\u0908 \u092d\u0940 \u0915\u094d\u0935\u0947\u0930\u0940 \u092f\u093e \u0921\u093e\u0909\u091f \u0939\u0948 \u0924\u094b \u0906\u092a \u0928\u0940\u091a\u0947 \u0915\u092e\u0947\u0902\u091f \u0938\u0947\u0915\u094d\u0936\u0928 \u092e\u0947\u0902 \u0915\u092e\u0947\u0902\u091f \u0915\u0930\u0915\u0947 \u092a\u0942\u091b \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 <\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p><strong>\u092f\u0939 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0939\u093f\u0928\u094d\u0926\u0940 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u092b\u0941\u0932 \u0915\u094b\u0930\u094d\u0938 \u0907\u0928 \u0939\u093f\u0928\u094d\u0926\u0940 \u0915\u093e \u0926\u0942\u0938\u0930\u093e \u092d\u093e\u0917 \u0925\u093e\u0964 \u0907\u0938\u0915\u094b \u092a\u0942\u0930\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u092c\u093e\u0915\u0940 3 \u092d\u093e\u0917 \u092a\u095d \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 <\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/hi\/%e0%a4%95%e0%a5%8c%e0%a4%b6%e0%a4%b2-%e0%a4%b5%e0%a4%bf%e0%a4%95%e0%a4%be%e0%a4%b8\/%e0%a4%8f%e0%a4%ae%e0%a4%8f%e0%a4%b8-%e0%a4%8f%e0%a4%95%e0%a5%8d%e0%a4%b8%e0%a4%b2-%e0%a4%ad%e0%a4%be%e0%a4%97-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Beginner course part 1 - Agar excel bilkul nahi aati (opens in a new tab)\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 1 \u0939\u093f\u0928\u094d\u0926\u0940 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932\n<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-advanced-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u090f\u0921\u0935\u093e\u0902\u0938 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 1 - \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u092c\u0947\u0938\u093f\u0915 \u0932\u0947\u0935\u0932 \u0915\u0947 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e (opens in a new tab)\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u090f\u0921\u0935\u093e\u0902\u0938 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 1 &#8211; \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u092c\u0947\u0938\u093f\u0915 \u0932\u0947\u0935\u0932 \u0915\u0947 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-advanced-tutorial-in-hindi-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u090f\u0921\u0935\u093e\u0902\u0938 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 2 - \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u090f\u0921\u0935\u093e\u0902\u0938 \u0932\u0947\u0935\u0932 \u0915\u0947 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e (opens in a new tab)\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u090f\u0921\u0935\u093e\u0902\u0938 \u0915\u094b\u0930\u094d\u0938 \u092d\u093e\u0917 2 &#8211; \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0932 \u0915\u0947 \u090f\u0921\u0935\u093e\u0902\u0938 \u0932\u0947\u0935\u0932 \u0915\u0947 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Sort \u0914\u0930 \u092b\u093f\u0932\u094d\u091f\u0930 \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947\u0902 + Find \u0914\u0930 replace \u0915\u094d\u092f\u093e \u0939\u0948 \u0938\u0940\u0916\u0947\u0902 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925\u0964 \u092f\u0939 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0939\u092e\u093e\u0930\u0947 \u092b\u094d\u0930\u0940 \u090f\u0915\u094d\u0938\u0932 \u0915\u094b\u0930\u094d\u0938 \u0915\u0947 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u0915\u093e \u0926\u0942\u0938\u0930\u093e \u092a\u093e\u0930\u094d\u091f \u0939\u0948\u0964 \u0907\u0938 \u091f\u094d\u092f\u0942\u091f\u094b\u0930\u093f\u092f\u0932 \u092e\u0947\u0902 \u0939\u092e \u0906\u092a\u0915\u094b sort \u090f\u0902\u0921 filter \u090f\u0915\u094d\u0938\u0932 \u092e\u0947\u0902 \u0915\u0948\u0938\u0947 \u0932\u0917\u0924\u0947 \u0939\u0948 \u0914\u0930 find \u090f\u0902\u0921 replace \u0915\u094d\u092f\u093e \u0939\u0948 \u0938\u093f\u0916\u093e\u090f\u0902\u0917\u0947 \u090f\u0915 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925\u0964 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0940 \u0936\u0940\u091f \u0906\u092a [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":23232,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":""},"categories":[],"tags":[],"yst_prominent_words":[9879,10542,5310,2504,9865,6575,3946,10555,2724,4854,2902,10549,643,10554,10556,9891,384,10557,4862,652],"_links":{"self":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts\/37369"}],"collection":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/comments?post=37369"}],"version-history":[{"count":81,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts\/37369\/revisions"}],"predecessor-version":[{"id":37638,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts\/37369\/revisions\/37638"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/media\/23232"}],"wp:attachment":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/media?parent=37369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/categories?post=37369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/tags?post=37369"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/yst_prominent_words?post=37369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}