{"id":5880,"date":"2025-04-12T14:17:28","date_gmt":"2025-04-12T10:47:28","guid":{"rendered":"https:\/\/www.softrah.ir\/?p=5880"},"modified":"2025-04-29T08:31:14","modified_gmt":"2025-04-29T05:01:14","slug":"90-%d8%b3%d9%88%d8%a7%d9%84-%d8%b9%d9%85%d9%84%db%8c-%d8%a7%da%a9%d8%b3%d9%84-2024","status":"publish","type":"post","link":"https:\/\/www.softrah.ir\/?p=5880","title":{"rendered":"90 \u0633\u0648\u0627\u0644 \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 2024"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 90 \u0633\u0648\u0627\u0644 \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 2024 (\u0648\u06cc\u0698\u0647 \u0622\u0632\u0645\u0648\u0646 \u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc) \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u0633\u062e \u0622\u0645\u062f\u0647 \u0627\u0633\u062a. \u0628\u06cc\u0646 \u0633\u0648\u0627\u0644\u0627\u062a \u0648 \u067e\u0627\u0633\u062e\u200c\u0647\u0627 \u0641\u0627\u0635\u0644\u0647 \u06af\u0630\u0627\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. \u0642\u0641\u0644 \u06a9\u0631\u062f\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u062f\u0631 \u06cc\u06a9 \u0634\u06cc\u062a<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: Review &gt; Protect Sheet &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u062c\u0627\u0632 \u0628\u0647 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0647\u0633\u062a\u0646\u062f<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0631\u0627\u06cc \u06cc\u0627\u0641\u062a\u0646 \u0642\u06cc\u0645\u062a \u0645\u062d\u0635\u0648\u0644<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: =VLOOKUP(A2,Sheet2!A:B,2,FALSE)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. \u062a\u0646\u0638\u06cc\u0645 \u0686\u0627\u067e \u0628\u0631\u0627\u06cc \u0642\u0631\u0627\u0631\u06af\u06cc\u0631\u06cc \u062c\u062f\u0648\u0644 \u062f\u0631 \u06cc\u06a9 \u0635\u0641\u062d\u0647<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: Page Layout &gt; Page Setup &gt; Fit to one page<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 COUNTIF \u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u0646\u0645\u0631\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 15<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: =COUNTIF(B2:B20,&#8221;&gt;15&#8243;)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5. \u0645\u062d\u0627\u0633\u0628\u0647 \u062f\u0631\u0635\u062f \u067e\u06cc\u0634\u0631\u0641\u062a \u0628\u0627 \u0641\u0631\u0645\u0648\u0644 (\u0645\u0642\u062f\u0627\u0631 \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \/ \u06a9\u0644) * 100<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: =(C2\/D2)*100<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6. \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0642\u0627\u0644\u0628 \u0634\u0631\u0637\u06cc \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0627\u0639\u062f\u0627\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: Conditional Formatting &gt; Highlight Cells Rules &gt; Duplicate Values<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7. \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u062e\u0648\u062f\u06a9\u0627\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Data Bars<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: Conditional Formatting &gt; Data Bars<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>8. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 IF \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0622\u06cc\u0627 \u0646\u0645\u0631\u0647 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 10 \u0627\u0633\u062a<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: =IF(A2&gt;10,&#8221;\u0642\u0628\u0648\u0644&#8221;,&#8221;\u0631\u062f&#8221;)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9. \u0627\u06cc\u062c\u0627\u062f \u0646\u0645\u0648\u062f\u0627\u0631 \u0633\u062a\u0648\u0646\u06cc \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0641\u0631\u0648\u0634 \u0645\u0627\u0647\u0627\u0646\u0647<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: \u0627\u0646\u062a\u062e\u0627\u0628 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 &gt; Insert &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0648\u062f\u0627\u0631 \u0633\u062a\u0648\u0646\u06cc<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10. \u0627\u06cc\u062c\u0627\u062f \u062e\u0644\u0627\u0635\u0647\u200c\u0627\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Pivot Table<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e: Insert &gt; Pivot Table &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 &gt; \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u062c\u062f\u06cc\u062f<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\u062d\u062a\u0645\u0627\u064b! \u0627\u0632 \u0627\u06cc\u0646\u062c\u0627 \u0628\u0647 \u0628\u0639\u062f \u0633\u0648\u0627\u0644\u0627\u062a \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0637\u0631\u0627\u062d\u06cc \u0645\u06cc\u200c\u06a9\u0646\u0645\u061b \u06cc\u0639\u0646\u06cc:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u062f\u0631 \u0635\u0648\u0631\u062a \u0633\u0624\u0627\u0644\u060c \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u0634\u0648\u062f (\u0645\u062b\u0644\u0627\u064b A2:A10 \u06cc\u0627 Sheet1!B2:D20)<\/li>\n\n\n\n<li>\u0633\u067e\u0633 \u067e\u0627\u0633\u062e \u062f\u0642\u06cc\u0642 \u0648 \u0634\u0641\u0627\u0641 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 10 \u0646\u0645\u0648\u0646\u0647 \u0627\u0648\u0644 \u0628\u0647 \u0627\u06cc\u0646 \u0633\u0628\u06a9 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647\u200c\u0627\u0646\u062f:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A2:A10 \u0627\u0633\u0627\u0645\u06cc \u062f\u0631\u062c \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u062f\u0631 \u0633\u0644\u0648\u0644 B2 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0622\u06cc\u0627 \u0647\u0631 \u0627\u0633\u0645 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 &#8220;Ali&#8221; \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631. \u0627\u0632 \u0686\u0647 \u0641\u0631\u0645\u0648\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(A2=\"Ali\",\"\u0628\u0644\u0647\",\"\u062e\u06cc\u0631\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. \u062f\u0631 Sheet1!B2:B20 \u0646\u0645\u0631\u0627\u062a \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0686\u0646\u062f \u0646\u0641\u0631 \u0646\u0645\u0631\u0647 \u0628\u0627\u0644\u0627\u06cc 15 \u06af\u0631\u0641\u062a\u0647\u200c\u0627\u0646\u062f\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIF(Sheet1!B2:B20,\"&gt;15\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. \u062f\u0631 Sheet1!A2:A10 \u0642\u06cc\u0645\u062a \u06a9\u0627\u0644\u0627\u0647\u0627 \u0648 \u062f\u0631 Sheet1!B2:B10 \u062a\u0639\u062f\u0627\u062f \u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0645\u062c\u0645\u0648\u0639 \u06a9\u0644 \u0641\u0631\u0648\u0634 \u0631\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 C2 \u062d\u0633\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUMPRODUCT(A2:A10,B2:B10)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4. \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc C2:C15 \u062a\u0627\u0631\u06cc\u062e \u062b\u0628\u062a \u0633\u0641\u0627\u0631\u0634\u200c\u0647\u0627 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0645\u06cc\u0644\u0627\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0686\u0637\u0648\u0631 \u0641\u0631\u0645\u062a \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0634\u0645\u0633\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0641\u0632\u0648\u0646\u0647 \u062a\u0627\u0631\u06cc\u062e \u0634\u0645\u0633\u06cc \u06cc\u0627 \u0641\u0631\u0645\u062a\u200c\u062f\u0647\u06cc \u0628\u0627 \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627\u06cc \u062c\u0627\u0646\u0628\u06cc \u0645\u0627\u0646\u0646\u062f PersianDate. \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0647\u200c\u062a\u0646\u0647\u0627\u06cc\u06cc \u0627\u0645\u06a9\u0627\u0646 \u062a\u0628\u062f\u06cc\u0644 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0646\u06cc\u0633\u062a \u0645\u06af\u0631 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc VBA.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5. \u062f\u0631 Sheet1!A1:D10 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u06cc\u06a9 Pivot Table \u0628\u0633\u0627\u0632\u06cc\u0645 \u062a\u0627 \u0645\u062c\u0645\u0648\u0639 \u0641\u0631\u0648\u0634 \u0647\u0631 \u0645\u062d\u0635\u0648\u0644 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>Insert &gt; Pivot Table &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u062d\u062f\u0648\u062f\u0647 A1:D10 &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u06cc\u0634 Pivot &gt; \u062f\u0631 \u067e\u0646\u062c\u0631\u0647 Pivot:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Product \u0631\u0627 \u062f\u0631 \u0628\u062e\u0634 Rows<\/li>\n\n\n\n<li>Amount \u0631\u0627 \u062f\u0631 \u0628\u062e\u0634 Values \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6. \u062f\u0631 \u0633\u0644\u0648\u0644 A1 \u0639\u062f\u062f 1200 \u0648 \u062f\u0631 A2 \u0639\u062f\u062f 800 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u062f\u0631\u0635\u062f \u06a9\u0627\u0647\u0634 \u0631\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 A3 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u062f.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=((A1-A2)\/A1)*100<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7. \u062f\u0631 Sheet1!A2:A50 \u0627\u0633\u0627\u0645\u06cc \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0648 \u062f\u0631 B2:B50 \u0634\u0645\u0627\u0631\u0647 \u0641\u0627\u06a9\u062a\u0648\u0631 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0686\u0637\u0648\u0631 \u062a\u0639\u062f\u0627\u062f \u0641\u0627\u06a9\u062a\u0648\u0631\u0647\u0627\u06cc \u06cc\u06a9\u062a\u0627 \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUM(1\/COUNTIF(B2:B50,B2:B50))<\/code><br><em>\u062f\u0631 \u062d\u0627\u0644\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u0627\u06cc\u06cc\u062f \u0628\u0627 Ctrl+Shift+Enter \u0628\u0631\u0627\u06cc \u0641\u0631\u0645\u0648\u0644 \u0622\u0631\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0627\u06a9\u0633\u0644<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u0627 \u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f:<br><code>=COUNTA(UNIQUE(B2:B50))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>8. \u062f\u0631 Sheet1!C2:C20 \u0644\u06cc\u0633\u062a \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc \u0648\u0631\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0686\u06af\u0648\u0646\u0647 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e \u0622\u0646\u200c\u0647\u0627 \u062f\u0631 \u0645\u0627\u0647 \u0641\u0631\u0648\u0631\u062f\u06cc\u0646 \u0647\u0633\u062a\u0646\u062f \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc \u0628\u0627 \u0641\u0631\u0645\u0648\u0644:<br><code>=TEXT(C2,\"mm\")<\/code><br>\u0633\u067e\u0633 \u0641\u06cc\u0644\u062a\u0631 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0642\u062f\u0627\u0631 &#8220;01&#8221;<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9. \u062f\u0631 Sheet1!A2:A20 \u0644\u06cc\u0633\u062a \u0627\u0639\u062f\u0627\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0686\u0637\u0648\u0631 \u0641\u0642\u0637 \u0627\u0639\u062f\u0627\u062f \u06cc\u06a9\u062a\u0627 \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u062f\u0631 \u0633\u0644\u0648\u0644 \u062f\u06cc\u06af\u0631 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f:<br><code>=UNIQUE(A2:A20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10. \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 B2:B100 \u0646\u0645\u0631\u0627\u062a \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0646\u0645\u0631\u0627\u062a \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 10 \u0631\u0627 \u062d\u0633\u0627\u0628 \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=AVERAGEIF(B2:B100,\"&gt;10\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u062f\u0627\u0645\u0647 \u06f9\u06f0 \u0633\u0648\u0627\u0644 \u0639\u0645\u0644\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0627\u06a9\u0633\u0644 2024 (\u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc) \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u0633\u062e\u060c \u0628\u0647 \u0647\u0645\u0627\u0646 \u0633\u0628\u06a9 \u0642\u0628\u0644\u06cc:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>11. \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A2:A15 \u0646\u0627\u0645 \u06a9\u0627\u0644\u0627\u0647\u0627 \u0648 \u062f\u0631 B2:B15 \u0642\u06cc\u0645\u062a \u0648\u0627\u062d\u062f \u0622\u0646\u200c\u0647\u0627 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u062f\u0631 C2:C15 \u062a\u0639\u062f\u0627\u062f \u0641\u0631\u0648\u0634 \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u062f\u0631 D2\u060c \u0645\u062c\u0645\u0648\u0639 \u0641\u0631\u0648\u0634 \u06a9\u0644 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u062f.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUMPRODUCT(B2:B15,C2:C15)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>12. \u062f\u0631 Sheet1!B2:B30 \u0646\u0645\u0631\u0627\u062a \u0627\u0645\u062a\u062d\u0627\u0646 \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0686\u0637\u0648\u0631 \u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=MAX(B2:B30)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>13. \u062f\u0631 Sheet1!C2:C40 \u062a\u0627\u0631\u06cc\u062e \u062a\u0648\u0644\u062f \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0686\u0637\u0648\u0631 \u0633\u0646 \u0647\u0631 \u0646\u0641\u0631 \u0631\u0627 \u0646\u0633\u0628\u062a \u0628\u0647 \u0627\u0645\u0631\u0648\u0632 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=DATEDIF(C2,TODAY(),\"Y\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>14. \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 D2:D100 \u0646\u0645\u0631\u0627\u062a \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0631\u0645\u062a\u200c\u062f\u0647\u06cc \u0634\u0631\u0637\u06cc\u060c \u0646\u0645\u0631\u0627\u062a \u06a9\u0645\u062a\u0631 \u0627\u0632 10 \u0631\u0627 \u0628\u0647 \u0631\u0646\u06af \u0642\u0631\u0645\u0632 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u06cc\u062f.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u062d\u062f\u0648\u062f\u0647 D2:D100 &gt; Conditional Formatting &gt; Highlight Cell Rules &gt; Less Than &gt; \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0639\u062f\u062f 10 \u0648 \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u0646\u06af \u0642\u0631\u0645\u0632<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>15. \u062f\u0631 A2:A20 \u0627\u0633\u0627\u0645\u06cc \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0648 \u062f\u0631 B2:B20 \u0634\u0645\u0627\u0631\u0647 \u067e\u0631\u0633\u0646\u0644\u06cc. \u062f\u0631 \u0633\u0644\u0648\u0644 C5 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0634\u0645\u0627\u0631\u0647 \u067e\u0631\u0633\u0646\u0644\u06cc\u060c \u0646\u0627\u0645 \u0641\u0631\u062f \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u06cc\u0645.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=VLOOKUP(C5,B2:B20,1,FALSE)<\/code><br><em>\u0627\u06af\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0634\u0627\u0645\u0644 \u062c\u062f\u0648\u0644 \u0646\u0627\u0645 \u0648 \u0634\u0645\u0627\u0631\u0647 \u0628\u0627\u0634\u062f\u060c \u062a\u0627\u0628\u0639 \u0628\u0627\u06cc\u062f \u062a\u063a\u06cc\u06cc\u0631 \u06a9\u0646\u062f. \u0627\u06af\u0631 \u062c\u062f\u0648\u0644 A2:B20 \u0628\u0627\u0634\u062f:<\/em><br><code>=VLOOKUP(C5,A2:B20,2,FALSE)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>16. \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u062a\u0627 A10 \u0627\u0639\u062f\u0627\u062f \u0645\u062e\u062a\u0644\u0641 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0686\u0647 \u062a\u0627\u0628\u0639\u06cc \u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u0641\u0642\u0637 \u0627\u0639\u062f\u0627\u062f \u0632\u0648\u062c \u0645\u0646\u0627\u0633\u0628 \u0627\u0633\u062a\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIFS(A1:A10,\"=0\",MOD(A1:A10,2))<\/code><br>\u06cc\u0627 \u0628\u0627 \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632:<br><code>=IF(MOD(A1,2)=0,1,0)<\/code> \u0648 \u0633\u067e\u0633 <code>=SUM<\/code> \u0628\u0631\u0627\u06cc \u062c\u0645\u0639<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>17. \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A2:A50 \u0634\u0645\u0627\u0631\u0647 \u0645\u0644\u06cc \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0686\u06af\u0648\u0646\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0647\u06cc\u0686\u200c\u06a9\u062f\u0627\u0645 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0646\u06cc\u0633\u062a\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639:<br><code>=COUNTIF(A2:A50,A2)&gt;1<\/code> \u062f\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc<br>\u06cc\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632:<br>Conditional Formatting &gt; Highlight Cells Rules &gt; Duplicate Values<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>18. \u062f\u0631 Sheet1!B2:B30 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u0631\u0648\u0634 \u0631\u0648\u0632\u0627\u0646\u0647 \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0645\u062c\u0645\u0648\u0639 \u0641\u0631\u0648\u0634 \u062f\u0631 \u0631\u0648\u0632\u0647\u0627\u06cc \u0641\u0631\u062f (\u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u0641\u0631\u062f) \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u062f.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUM(FILTER(B2:B30,ISEVEN(ROW(B2:B30))=FALSE))<\/code><br>\u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0627\u06a9\u0633\u0644<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>19. \u062f\u0631 A2:A20 \u0646\u0627\u0645\u200c\u0647\u0627 \u0648 \u062f\u0631 B2:B20 \u0634\u0645\u0627\u0631\u0647 \u062a\u0644\u0641\u0646\u200c\u0647\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0686\u0637\u0648\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u062d\u0631\u0648\u0641 \u0627\u0644\u0641\u0628\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 \u0646\u0627\u0645 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0627\u0646\u062a\u062e\u0627\u0628 A2:B20 &gt; Data &gt; Sort &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u062a\u0648\u0646 A &gt; A to Z<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>20. \u062f\u0631 Sheet1!A2:A20 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0686\u06af\u0648\u0646\u0647 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u06cc\u0645\u061f<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTBLANK(A2:A20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 70 \u0633\u0648\u0627\u0644 \u0628\u0627\u0642\u06cc\u200c\u0645\u0627\u0646\u062f\u0647 \u0627\u0632 \u062a\u0645\u0631\u06cc\u0646\u0627\u062a \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0633\u0628\u06a9 \u0622\u0632\u0645\u0648\u0646\u200c\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646 \u0641\u0646\u06cc\u200c\u0648\u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>21.<\/strong> \u062f\u0631 Sheet1!A2:A20 \u0627\u0633\u0627\u0645\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631\u062e\u0627\u0644\u06cc \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTA(A2:A20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>22.<\/strong> \u062f\u0631 Sheet1!B2:B20 \u0646\u0645\u0631\u0627\u062a \u062f\u0627\u0646\u0634\u062c\u0648\u06cc\u0627\u0646 \u062b\u0628\u062a \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0646\u0645\u0631\u0627\u062a \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=AVERAGE(B2:B20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>23.<\/strong> \u062f\u0631 Sheet1!C2:C20 \u062a\u0639\u062f\u0627\u062f\u06cc \u062a\u0627\u0631\u06cc\u062e \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u0648\u0644\u06cc\u0646 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=MIN(C2:C20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>24.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 D2:D20 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u0627\u0632 100 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUMIF(D2:D20,\"&gt;100\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>25.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 E2:E20 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc\u06cc \u062b\u0628\u062a \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0633\u0627\u0644 1402 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0634\u0645\u0627\u0631\u0634 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIFS(E2:E20,\"&gt;=1402\/01\/01\",E2:E20,\"&lt;=1402\/12\/29\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>26.<\/strong> \u062f\u0631 Sheet1!A2:A20 \u0627\u0633\u0627\u0645\u06cc \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0646\u0627\u0645 &#8220;\u0639\u0644\u06cc&#8221; \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u062f \u0648 \u0627\u06af\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u060c &#8220;\u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a&#8221; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(COUNTIF(A2:A20,\"\u0639\u0644\u06cc\")&gt;0,\"\u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a\",\"\u0645\u0648\u062c\u0648\u062f \u0646\u06cc\u0633\u062a\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>27.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 B2:B20 \u0646\u0645\u0631\u0627\u062a \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0646\u0645\u0631\u0627\u062a\u06cc \u06a9\u0647 \u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u06cc\u0627 \u0645\u0633\u0627\u0648\u06cc 10 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIF(B2:B20,\"&gt;=10\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>28.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 C2:C20 \u0642\u06cc\u0645\u062a \u06a9\u0627\u0644\u0627\u0647\u0627 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0642\u06cc\u0645\u062a\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u06a9\u0645\u062a\u0631 \u0627\u0632 50000 \u062a\u0648\u0645\u0627\u0646 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=AVERAGEIF(C2:C20,\"&lt;50000\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>29.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 D \u0646\u0627\u0645 \u0634\u0647\u0631\u0647\u0627 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0686\u0646\u062f \u0628\u0627\u0631 &#8220;\u062a\u0647\u0631\u0627\u0646&#8221; \u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIF(D2:D20,\"\u062a\u0647\u0631\u0627\u0646\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>30.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0633\u0644\u0648\u0644 A2 \u0631\u0627 \u0628\u0647 \u062d\u0631\u0648\u0641 \u0628\u0632\u0631\u06af \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=UPPER(A2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>31.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a \u06a9\u0627\u0645\u0644 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a (\u0645\u062b\u0644\u0627\u064b: \u0639\u0644\u06cc \u0631\u0636\u0627\u06cc\u06cc). \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0646\u0627\u0645 (\u06a9\u0644\u0645\u0647 \u0627\u0648\u0644) \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=LEFT(A2,FIND(\" \",A2)-1)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>32.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc (\u06a9\u0644\u0645\u0647 \u062f\u0648\u0645) \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=MID(A2,FIND(\" \",A2)+1,LEN(A2))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>33.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 B2:B20 \u062a\u0627\u0631\u06cc\u062e \u062a\u0648\u0644\u062f \u0627\u0641\u0631\u0627\u062f \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u0646 \u0627\u0641\u0631\u0627\u062f \u0631\u0627 \u062f\u0631 \u0633\u0627\u0644 1403 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=AVERAGE(1403-YEAR(B2:B20))<\/code> <em>(\u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0627\u06a9\u0633\u0644 \u06cc\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Ctrl+Shift+Enter \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0628\u0647 \u0641\u0631\u0645\u0648\u0644 \u0622\u0631\u0627\u06cc\u0647\u200c\u0627\u06cc)<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>34.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u06cc\u06a9 \u0639\u062f\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u062f \u0622\u06cc\u0627 \u0639\u062f\u062f \u0632\u0648\u062c \u0627\u0633\u062a \u06cc\u0627 \u0641\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(ISEVEN(A2),\"\u0632\u0648\u062c\",\"\u0641\u0631\u062f\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>35.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0642\u06cc\u0645\u062a\u200c\u0647\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0628\u0632\u0627\u0631 <em>Conditional Formatting<\/em>\u060c \u062e\u0627\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0642\u06cc\u0645\u062a \u0628\u0627\u0644\u0627\u06cc 100000 \u062f\u0627\u0631\u0646\u062f \u0631\u0627 \u0628\u0647 \u0631\u0646\u06af \u0642\u0631\u0645\u0632 \u062f\u0631\u0622\u0648\u0631\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u062a\u0648\u0646 C \u2192 \u0645\u0646\u0648\u06cc Home \u2192 Conditional Formatting \u2192 Highlight Cell Rules \u2192 Greater Than \u2192 \u0645\u0642\u062f\u0627\u0631 100000 \u2192 \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u0646\u06af \u0642\u0631\u0645\u0632<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0633\u0648\u0627\u0644\u0627\u062a 36 \u062a\u0627 90 \u0627\u0632 \u062a\u0645\u0631\u06cc\u0646\u0627\u062a \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 (2024) \u0628\u0647 \u0633\u0628\u06a9 \u0622\u0632\u0645\u0648\u0646\u200c\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646 \u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc\u060c \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u0633\u062e \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>36.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u06cc\u06a9 \u0639\u062f\u062f \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062d\u0627\u0635\u0644 \u0645\u0631\u0628\u0639 \u0622\u0646 \u0639\u062f\u062f \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=A2^2<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>37.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 B2:B10 \u0646\u0645\u0631\u0627\u062a \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=MAX(B2:B10)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>38.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 C2 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0631\u0648\u0632 \u0647\u0641\u062a\u0647 \u0622\u0646 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0641\u0627\u0631\u0633\u06cc \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u0631\u06a9\u06cc\u0628 \u062a\u0627\u0628\u0639 <code>TEXT<\/code> \u0628\u0627 \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u0633\u0641\u0627\u0631\u0634\u06cc \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0628\u0647 \u0641\u0627\u0631\u0633\u06cc \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0627\u0641\u0632\u0648\u062f\u0646 \u0627\u0641\u0632\u0648\u0646\u0647 \u06cc\u0627 VBA \u062f\u0627\u0631\u062f. \u062f\u0631 \u062d\u0627\u0644\u062a \u0633\u0627\u062f\u0647:<br><code>=TEXT(C2,\"dddd\")<\/code> <em>(\u0631\u0648\u0632 \u0647\u0641\u062a\u0647 \u0628\u0647 \u0627\u0646\u06af\u0644\u06cc\u0633\u06cc \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f)<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>39.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 D2 \u0645\u0642\u062f\u0627\u0631 \u0639\u062f\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0627\u06af\u0631 \u0639\u062f\u062f \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 100 \u0628\u0627\u0634\u062f \u0628\u0646\u0648\u06cc\u0633\u062f &#8220;\u0628\u0632\u0631\u06af&#8221;\u060c \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a &#8220;\u06a9\u0648\u0686\u06a9&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(D2&gt;100,\"\u0628\u0632\u0631\u06af\",\"\u06a9\u0648\u0686\u06a9\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>40.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 E \u062a\u0627\u0631\u06cc\u062e \u062a\u0648\u0644\u062f \u0627\u0641\u0631\u0627\u062f \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0633\u0646 \u0641\u0631\u062f \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u0627\u0644 \u062c\u0627\u0631\u06cc (1403) \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=1403-YEAR(E2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>41.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 A \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0646\u0627\u0645 \u067e\u0631\u0633\u0646\u0644 \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0628\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc\u060c \u0646\u0627\u0645 \u0641\u0631\u062f \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=VLOOKUP(\u06a9\u062f_\u0645\u0648\u0631\u062f\u0646\u0638\u0631,A2:B20,2,FALSE)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>42.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0645\u0642\u062f\u0627\u0631\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0633\u0644\u0648\u0644 \u062e\u0627\u0644\u06cc \u0628\u0627\u0634\u062f\u060c &#8220;\u0648\u0627\u0631\u062f \u0646\u0634\u062f\u0647&#8221; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f\u060c \u0648\u06af\u0631\u0646\u0647 \u0647\u0645\u0627\u0646 \u0645\u0642\u062f\u0627\u0631 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(A2=\"\",\"\u0648\u0627\u0631\u062f \u0646\u0634\u062f\u0647\",A2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>43.<\/strong> \u0645\u062d\u062f\u0648\u062f\u0647 A2:A10 \u0634\u0627\u0645\u0644 \u0627\u0639\u062f\u0627\u062f \u0645\u062e\u062a\u0644\u0641 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0627\u0639\u062f\u0627\u062f\u06cc \u06a9\u0647 \u0645\u0636\u0631\u0628 5 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0634\u0645\u0627\u0631\u0634 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUMPRODUCT(--(MOD(A2:A10,5)=0))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>44.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 B2 \u0646\u0627\u0645 \u0645\u0627\u0647 (\u0645\u062b\u0644\u0627\u064b &#8220;\u0641\u0631\u0648\u0631\u062f\u06cc\u0646&#8221;) \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0634\u0645\u0627\u0631\u0647 \u0622\u0646 \u0645\u0627\u0647 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SWITCH(B2,\"\u0641\u0631\u0648\u0631\u062f\u06cc\u0646\",1,\"\u0627\u0631\u062f\u06cc\u0628\u0647\u0634\u062a\",2,\"\u062e\u0631\u062f\u0627\u062f\",3,\"\u062a\u06cc\u0631\",4,\"\u0645\u0631\u062f\u0627\u062f\",5,\"\u0634\u0647\u0631\u06cc\u0648\u0631\",6,\"\u0645\u0647\u0631\",7,\"\u0622\u0628\u0627\u0646\",8,\"\u0622\u0630\u0631\",9,\"\u062f\u06cc\",10,\"\u0628\u0647\u0645\u0646\",11,\"\u0627\u0633\u0641\u0646\u062f\",12)\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>45.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 A \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0642\u06cc\u0645\u062a \u06a9\u0627\u0644\u0627 \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0642\u06cc\u0645\u062a \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u06a9\u062f\u0634\u0627\u0646 \u0628\u0627 &#8220;K&#8221; \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f \u0631\u0627 \u062d\u0633\u0627\u0628 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=AVERAGEIF(A2:A20,\"K*\",B2:B20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>46.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0646\u0627\u0645 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u067e\u0633\u0648\u0646\u062f \u0641\u0627\u06cc\u0644 (\u0645\u062b\u0644\u0627\u064b &#8220;.xlsx&#8221;) \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=RIGHT(C2,LEN(C2)-FIND(\".\",C2))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>47.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0646\u062a\u06cc\u062c\u0647\u200c\u06cc \u062a\u0627\u0628\u0639 IF \u0633\u0647\u200c\u0634\u0631\u0637\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u067e\u06cc\u0627\u062f\u0647 \u06a9\u0646\u062f:<br>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 &lt;10 \u0628\u0627\u0634\u062f &#8220;\u0636\u0639\u06cc\u0641&#8221;\u060c \u0627\u06af\u0631 \u0628\u06cc\u0646 10 \u062a\u0627 17 \u0628\u0627\u0634\u062f &#8220;\u0645\u062a\u0648\u0633\u0637&#8221;\u060c \u0627\u06af\u0631 \u0628\u0627\u0644\u0627\u062a\u0631 \u0628\u0627\u0634\u062f &#8220;\u062e\u0648\u0628&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(A2&lt;10,\"\u0636\u0639\u06cc\u0641\",IF(A2&lt;=17,\"\u0645\u062a\u0648\u0633\u0637\",\"\u062e\u0648\u0628\"))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>48.<\/strong> \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0628\u0632\u0627\u0631 Pivot Table\u060c \u0645\u062c\u0645\u0648\u0639 \u0641\u0631\u0648\u0634 \u0647\u0631 \u0641\u0631\u0648\u0634\u0646\u062f\u0647 \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 \u0641\u0631\u0648\u0634 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br>Insert \u2192 Pivot Table \u2192 \u062f\u0631 Row: \u0646\u0627\u0645 \u0641\u0631\u0648\u0634\u0646\u062f\u0647\u060c \u062f\u0631 Values: \u0645\u062c\u0645\u0648\u0639 \u0641\u0631\u0648\u0634<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>49.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 D \u062a\u0627\u0631\u06cc\u062e \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0645\u0627\u0647 \u0622\u0646 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0639\u062f\u062f\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=MONTH(D2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>50.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u06cc\u06a9 \u0639\u062f\u062f \u0627\u0639\u0634\u0627\u0631\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0628\u062e\u0634 \u0635\u062d\u06cc\u062d \u0639\u062f\u062f \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=INT(A2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>51.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 B2 \u06cc\u06a9 \u0639\u062f\u062f \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0639\u062f\u062f \u0631\u0627 \u0628\u0647 \u0646\u0632\u062f\u06cc\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0635\u062d\u06cc\u062d \u06af\u0631\u062f \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=ROUND(B2,0)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>52.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0642\u06cc\u0645\u062a\u200c\u0647\u0627 \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639 \u0642\u06cc\u0645\u062a\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u06a9\u0645\u062a\u0631 \u0627\u0632 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u06a9\u0644 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0628\u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUMIF(C2:C20,\"&lt;\"&amp;AVERAGE(C2:C20))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>53.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0686\u0646\u062f \u0631\u0648\u0632 \u062a\u0627 \u067e\u0627\u06cc\u0627\u0646 \u0633\u0627\u0644 \u0645\u0627\u0646\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=DATE(YEAR(A2),12,31)-A2<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>54.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0646\u0645\u0631\u0627\u062a \u062b\u0628\u062a \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0646\u0645\u0631\u0627\u062a \u0628\u06cc\u0646 10 \u062a\u0627 20 \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIFS(B2:B20,\"&gt;=10\",B2:B20,\"&lt;=20\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>55.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0639\u062f\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 CHOOSE\u060c \u0627\u06af\u0631 \u0639\u062f\u062f 1 \u0628\u0627\u0634\u062f &#8220;\u06a9\u0645&#8221;\u060c 2 \u0628\u0627\u0634\u062f &#8220;\u0645\u062a\u0648\u0633\u0637&#8221;\u060c 3 \u0628\u0627\u0634\u062f &#8220;\u0632\u06cc\u0627\u062f&#8221; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=CHOOSE(A2,\"\u06a9\u0645\",\"\u0645\u062a\u0648\u0633\u0637\",\"\u0632\u06cc\u0627\u062f\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>56.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0639\u062f\u062f \u0645\u0648\u062c\u0648\u062f \u062f\u0631 A2 \u0631\u0627 \u0628\u0647 \u0639\u062f\u062f\u06cc \u0628\u0627 \u0633\u0647 \u0631\u0642\u0645 \u0627\u0639\u0634\u0627\u0631 \u06af\u0631\u062f \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=ROUND(A2,3)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>57.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 D \u062a\u0627\u0631\u06cc\u062e \u062a\u0648\u0644\u062f\u0647\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0646\u0627\u0645 \u0645\u0627\u0647 \u0645\u06cc\u0644\u0627\u062f\u06cc \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=TEXT(D2,\"mmmm\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>58.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0639\u062f\u062f \u062f\u0631 \u0628\u0627\u0632\u0647 100 \u062a\u0627 200 \u0628\u0627\u0634\u062f &#8220;\u0645\u062c\u0627\u0632&#8221; \u0648 \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a &#8220;\u0646\u0627\u0645\u062c\u0627\u0632&#8221; \u0628\u0646\u0648\u06cc\u0633\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(AND(A2&gt;=100,A2&lt;=200),\"\u0645\u062c\u0627\u0632\",\"\u0646\u0627\u0645\u062c\u0627\u0632\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>59.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0634\u0645\u0627\u0631\u0647 \u0645\u0648\u0628\u0627\u06cc\u0644\u200c\u0647\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 4 \u0631\u0642\u0645 \u0622\u062e\u0631 \u0647\u0631 \u0634\u0645\u0627\u0631\u0647 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=RIGHT(C2,4)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>60.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0639\u062f\u062f\u06cc \u0628\u06cc\u0646 1 \u062a\u0627 7 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0631\u0648\u0632 \u0647\u0641\u062a\u0647 \u0645\u0639\u0627\u062f\u0644 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0641\u0627\u0631\u0633\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=CHOOSE(A2,\"\u0634\u0646\u0628\u0647\",\"\u06cc\u06a9\u0634\u0646\u0628\u0647\",\"\u062f\u0648\u0634\u0646\u0628\u0647\",\"\u0633\u0647\u200c\u0634\u0646\u0628\u0647\",\"\u0686\u0647\u0627\u0631\u0634\u0646\u0628\u0647\",\"\u067e\u0646\u062c\u0634\u0646\u0628\u0647\",\"\u062c\u0645\u0639\u0647\")\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0633\u0648\u0627\u0644\u0627\u062a <strong>61 \u062a\u0627 90<\/strong> \u062a\u0645\u0631\u06cc\u0646 \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 2024 \u0628\u0647 \u0633\u0628\u06a9 \u0622\u0632\u0645\u0648\u0646\u200c\u0647\u0627\u06cc <strong>\u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc<\/strong> \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u067e\u0627\u0633\u062e\u060c \u0628\u0627 \u0631\u0639\u0627\u06cc\u062a \u0641\u0627\u0635\u0644\u0647 \u0628\u06cc\u0646 \u0633\u0624\u0627\u0644 \u0648 \u062c\u0648\u0627\u0628 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06af\u0631\u062f\u062f:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>61.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0627\u0639\u062f\u0627\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639 \u0627\u0639\u062f\u0627\u062f \u0632\u0648\u062c \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=SUMIF(A2:A20,\"=0\",MOD(A2:A20,2)=0)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(\u0646\u0633\u062e\u0647 \u062f\u0642\u06cc\u0642\u200c\u062a\u0631:<br><code>=SUMPRODUCT(--(MOD(A2:A20,2)=0),A2:A20)<\/code>)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>62.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0627\u0633\u0627\u0645\u06cc \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0627\u0633\u0627\u0645\u06cc \u0634\u0627\u0645\u0644 \u062d\u0631\u0641 &#8220;\u0639&#8221; \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIF(B2:B20,\"*\u0639*\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>63.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 C2 \u0631\u0634\u062a\u0647\u200c\u0627\u06cc \u0634\u0627\u0645\u0644 \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a (\u0645\u062b\u0644\u0627\u064b &#8220;\u0639\u0644\u06cc \u0631\u0636\u0627\u06cc\u06cc&#8221;). \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0646\u0627\u0645 \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=LEFT(C2,FIND(\" \",C2)-1)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>64.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 D2 \u0647\u0645\u0627\u0646 \u0631\u0634\u062a\u0647 \u0628\u0627\u0644\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=RIGHT(D2,LEN(D2)-FIND(\" \",D2))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>65.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 E \u0627\u0639\u062f\u0627\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0641\u0642\u0637 \u0627\u0639\u062f\u0627\u062f \u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u0627\u0632 100 \u0631\u0627 \u062d\u0633\u0627\u0628 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=AVERAGEIF(E2:E20,\"&gt;100\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>66.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0639\u062f\u062f \u0645\u0648\u062c\u0648\u062f \u062f\u0631 A2 \u0631\u0627 \u0628\u0647 \u0646\u0632\u062f\u06cc\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0645\u0636\u0631\u0628 5 \u06af\u0631\u062f \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=MROUND(A2,5)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>67.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 B2 \u0633\u0627\u0639\u062a \u0648\u0631\u0648\u062f (\u0645\u062b\u0644\u0627\u064b 08:30) \u0648 \u062f\u0631 C2 \u0633\u0627\u0639\u062a \u062e\u0631\u0648\u062c \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0633\u0627\u0639\u0627\u062a \u06a9\u0627\u0631\u06cc \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=C2-B2<\/code><br>(\u0633\u067e\u0633 \u0641\u0631\u0645\u062a \u0633\u0644\u0648\u0644 \u0631\u0627 \u0628\u0647 <code>[h]:mm<\/code> \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>68.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0639\u062f\u062f \u0645\u0648\u062c\u0648\u062f \u062f\u0631 A2 \u0628\u06cc\u0646 1 \u062a\u0627 10 \u0628\u0627\u0634\u062f &#8220;\u0636\u0639\u06cc\u0641&#8221;\u060c 11 \u062a\u0627 15 &#8220;\u0645\u062a\u0648\u0633\u0637&#8221;\u060c \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 \u0622\u0646 &#8220;\u062e\u0648\u0628&#8221; \u0628\u0646\u0648\u06cc\u0633\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(A2&lt;=10,\"\u0636\u0639\u06cc\u0641\",IF(A2&lt;=15,\"\u0645\u062a\u0648\u0633\u0637\",\"\u062e\u0648\u0628\"))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>69.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u0634 \u0648 \u062f\u0631 B2 \u062f\u0631\u0635\u062f \u062a\u062e\u0641\u06cc\u0641 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u0628\u0644\u063a \u0646\u0647\u0627\u06cc\u06cc \u067e\u0633 \u0627\u0632 \u062a\u062e\u0641\u06cc\u0641 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=A2*(1-B2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>70.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631\u062e\u0627\u0644\u06cc \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A2:A20 \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTA(A2:A20)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>71.<\/strong> \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 B2:B20 \u0627\u0639\u062f\u0627\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u062a\u0639\u062f\u0627\u062f \u0627\u0639\u062f\u0627\u062f \u0645\u0646\u0641\u06cc \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIF(B2:B20,\"&lt;0\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>72.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0639\u062f\u062f \u0645\u0648\u062c\u0648\u062f \u062f\u0631 A2 \u0631\u0627 \u0628\u0647 \u0628\u0627\u0644\u0627 \u06af\u0631\u062f \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=ROUNDUP(A2,0)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>73.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0642\u06cc\u0645\u062a \u0647\u0631 \u06a9\u0627\u0644\u0627 \u0648 \u062f\u0631 D \u062a\u0639\u062f\u0627\u062f \u0641\u0631\u0648\u0634 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062f\u0631\u0622\u0645\u062f \u0647\u0631 \u0631\u062f\u06cc\u0641 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=C2*D2<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>74.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 A2 \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 B2 \u0628\u06cc\u0634\u062a\u0631 \u0628\u0648\u062f\u060c &#8220;\u062f\u0631\u0633\u062a&#8221; \u0628\u0646\u0648\u06cc\u0633\u062f\u060c \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a &#8220;\u0646\u0627\u062f\u0631\u0633\u062a&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(A2&gt;B2,\"\u062f\u0631\u0633\u062a\",\"\u0646\u0627\u062f\u0631\u0633\u062a\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>75.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0646\u0627\u0645 \u06a9\u0627\u0644\u0627\u060c \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0642\u06cc\u0645\u062a \u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 C \u062a\u062e\u0641\u06cc\u0641 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0642\u06cc\u0645\u062a \u0646\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=B2*(1-C2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>76.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 D2 \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 A2 \u0631\u0627 \u0628\u0647 \u062f\u0631\u0635\u062f \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f (\u0645\u062b\u0644\u0627\u064b 0.25 \u0631\u0627 25%).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=A2<\/code> \u0648 \u0641\u0642\u0637 \u0642\u0627\u0644\u0628 \u0633\u0644\u0648\u0644 \u0631\u0627 \u0628\u0647 Percent \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>77.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 E \u062a\u0627\u0631\u06cc\u062e \u0634\u0631\u0648\u0639 \u0648 \u062f\u0631 F \u062a\u0627\u0631\u06cc\u062e \u067e\u0627\u06cc\u0627\u0646 \u067e\u0631\u0648\u0698\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u062f\u062a \u067e\u0631\u0648\u0698\u0647 \u0631\u0627 \u0628\u0631 \u062d\u0633\u0628 \u0631\u0648\u0632 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=F2-E2<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>78.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 A2 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u062a\u0646 \u0628\u0646\u0648\u06cc\u0633\u062f (\u0645\u062b\u0644\u0627\u064b \u0639\u062f\u062f 100 \u0631\u0627 \u0628\u0647 &#8220;100&#8221;).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=TEXT(A2,\"0\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>79.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0639\u062f\u062f\u06cc A2 \u0631\u0627 \u0628\u0647 \u062a\u0648\u0645\u0627\u0646 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f (\u0645\u062b\u0644\u0627\u064b 25000 \u0628\u0647 &#8220;25,000&#8221;).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=TEXT(A2,\"#,##0\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>80.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u062e\u062a\u0644\u0627\u0641 \u0628\u06cc\u0646 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A2 \u0648 B2 \u0631\u0627 \u0628\u0647 \u0645\u0627\u0647 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=DATEDIF(A2,B2,\"m\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>81.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0633\u0627\u0644 \u0627\u0632 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 \u0633\u0644\u0648\u0644 C2 \u0631\u0627 \u062c\u062f\u0627 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=YEAR(C2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>82.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0631\u0648\u0632 \u0645\u0627\u0647 \u0631\u0627 \u0627\u0632 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 \u0633\u0644\u0648\u0644 C2 \u062c\u062f\u0627 \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=DAY(C2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>83.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0639\u062f\u062f \u0631\u0627 \u0628\u0647 \u067e\u0627\u06cc\u06cc\u0646 \u06af\u0631\u062f \u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=ROUNDDOWN(A2,0)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>84.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0633\u0644\u0648\u0644 B2 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=LEN(B2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>85.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0639\u062f\u062f \u0645\u062b\u0628\u062a \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f (\u0686\u0647 \u0645\u0646\u0641\u06cc \u0628\u0627\u0634\u062f \u0686\u0647 \u0645\u062b\u0628\u062a).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=ABS(A2)<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>86.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0646\u0645\u0631\u0627\u062a \u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0648\u0636\u0639\u06cc\u062a \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0646\u0645\u0631\u0647 \u0628\u06cc\u0634 \u0627\u0632 10 \u0628\u0648\u062f\u060c \u062f\u0631 \u0633\u062a\u0648\u0646 C \u0628\u0646\u0648\u06cc\u0633\u062f &#8220;\u0642\u0628\u0648\u0644&#8221;\u060c \u0648\u06af\u0631\u0646\u0647 &#8220;\u0631\u062f&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(B2&gt;10,\"\u0642\u0628\u0648\u0644\",\"\u0631\u062f\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>87.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 D \u0642\u06cc\u0645\u062a \u06a9\u0627\u0644\u0627\u060c \u0648 \u062f\u0631 E \u062a\u0639\u062f\u0627\u062f \u0641\u0631\u0648\u0634 \u0627\u0633\u062a. \u062f\u0631 \u0633\u062a\u0648\u0646 F \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0644 \u062f\u0631\u0622\u0645\u062f \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0631\u062f\u06cc\u0641 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=D2*E2<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>88.<\/strong> \u062f\u0631 \u0633\u0644\u0648\u0644 A2 \u06cc\u06a9 \u06a9\u062f \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f &#8220;ST-001&#8221; \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0642\u0633\u0645\u062a \u0639\u062f\u062f\u06cc \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=RIGHT(A2,LEN(A2)-FIND(\"-\",A2))<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>89.<\/strong> \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0646\u0645\u0631\u0627\u062a\u060c \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0646\u0645\u0631\u0627\u062a \u0628\u0627\u0644\u0627\u06cc 17 \u0631\u0627 \u0628\u0634\u0645\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=COUNTIF(B2:B20,\"&gt;17\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>90.<\/strong> \u0641\u0631\u0645\u0648\u0644\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 A2 \u0639\u062f\u062f \u0646\u0628\u0627\u0634\u062f\u060c \u0639\u0628\u0627\u0631\u062a &#8220;\u062e\u0637\u0627&#8221; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0627\u0633\u062e:<br><code>=IF(ISNUMBER(A2),A2,\"\u062e\u0637\u0627\")<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 90 \u0633\u0648\u0627\u0644 \u0639\u0645\u0644\u06cc \u0627\u06a9\u0633\u0644 2024 (\u0648\u06cc\u0698\u0647 \u0622\u0632\u0645\u0648\u0646 \u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc) \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u0633\u062e \u0622\u0645\u062f\u0647 \u0627\u0633\u062a. \u0628\u06cc\u0646 \u0633\u0648\u0627\u0644\u0627\u062a \u0648 \u067e\u0627\u0633\u062e\u200c\u0647\u0627 \u0641\u0627\u0635\u0644\u0647 \u06af\u0630\u0627\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a: 1. \u0642\u0641\u0644 \u06a9\u0631\u062f\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u062f\u0631 \u06cc\u06a9 \u0634\u06cc\u062a \u067e\u0627\u0633\u062e: Review &gt; Protect Sheet &gt; \u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u062c\u0627\u0632 \u0628\u0647 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0647\u0633\u062a\u0646\u062f 2. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0631\u0627\u06cc \u06cc\u0627\u0641\u062a\u0646 \u0642\u06cc\u0645\u062a \u0645\u062d\u0635\u0648\u0644&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[379],"tags":[185,22,2783,2788,2786,2787],"class_list":["post-5880","post","type-post","status-publish","format-standard","hentry","category-379","tag-185","tag-22","tag-2783","tag-2788","tag---icdl","tag-2787"],"_links":{"self":[{"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts\/5880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5880"}],"version-history":[{"count":1,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts\/5880\/revisions"}],"predecessor-version":[{"id":5881,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts\/5880\/revisions\/5881"}],"wp:attachment":[{"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}