{"id":5877,"date":"2025-04-12T12:12:01","date_gmt":"2025-04-12T08:42:01","guid":{"rendered":"https:\/\/www.softrah.ir\/?p=5877"},"modified":"2025-04-29T08:29:58","modified_gmt":"2025-04-29T04:59:58","slug":"%d8%b3%d9%88%d8%a7%d9%84%d8%a7%d8%aa-%d8%aa%d8%b3%d8%aa%db%8c-%d8%a7%da%a9%d8%b3%d9%84-2024","status":"publish","type":"post","link":"https:\/\/www.softrah.ir\/?p=5877","title":{"rendered":"\u0633\u0648\u0627\u0644\u0627\u062a \u062a\u0633\u062a\u06cc \u0627\u06a9\u0633\u0644 2024"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u062f\u0627\u0645\u0647\u060c <strong>\u06f6\u06f0 \u0633\u0648\u0627\u0644 \u062a\u0633\u062a\u06cc \u0627\u06a9\u0633\u0644 2024<\/strong> \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> \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 <strong>\u067e\u0627\u0633\u062e \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc<\/strong> \u0622\u0648\u0631\u062f\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. \u0628\u0631\u0627\u06cc \u062c\u0645\u0639\u200c\u0632\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u062a\u0627 A10 \u0627\u0632 \u06a9\u062f\u0627\u0645 \u062a\u0627\u0628\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) =SUM(A1:A10) \u2705<br>\u0628) =ADD(A1:A10)<br>\u062c) =TOTAL(A1-A10)<br>\u062f) =COUNT(A1:A10)<\/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. \u06a9\u062f\u0627\u0645 \u06a9\u0644\u06cc\u062f \u0645\u06cc\u0627\u0646\u0628\u0631 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0641\u0627\u06cc\u0644 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Ctrl + Z<br>\u0628) Ctrl + P<br>\u062c) Ctrl + S \u2705<br>\u062f) Ctrl + C<\/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. \u0641\u0631\u0645\u0648\u0644 =AVERAGE(10,20,30) \u0686\u0647 \u0645\u0642\u062f\u0627\u0631\u06cc \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) 20 \u2705<br>\u0628) 10<br>\u062c) 30<br>\u062f) 60<\/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. \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0632 \u06a9\u0648\u0686\u06a9 \u0628\u0647 \u0628\u0632\u0631\u06af \u0627\u0632 \u06a9\u062f\u0627\u0645 \u06af\u0632\u06cc\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Sort Z to A<br>\u0628) Filter<br>\u062c) Sort A to Z \u2705<br>\u062f) Flash Fill<\/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. \u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0639\u062f\u062f\u06cc \u062f\u0627\u0631\u0646\u062f \u0627\u0632 \u06a9\u062f\u0627\u0645 \u062a\u0627\u0628\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) =SUM<br>\u0628) =COUNT \u2705<br>\u062c) =COUNTA<br>\u062f) =IF<\/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. \u06a9\u062f\u0627\u0645 \u06af\u0632\u06cc\u0646\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Insert &gt; Table \u2705<br>\u0628) Data &gt; Filter<br>\u062c) View &gt; Freeze<br>\u062f) Home &gt; Sort<\/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 \u0627\u06a9\u0633\u0644\u060c \u0633\u0644\u0648\u0644 A1 \u0634\u0627\u0645\u0644 \u0645\u0642\u062f\u0627\u0631 5 \u0648 B1 \u0645\u0642\u062f\u0627\u0631 10 \u0627\u0633\u062a\u060c \u0646\u062a\u06cc\u062c\u0647 \u0641\u0631\u0645\u0648\u0644 =A1+B1 \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) 15 \u2705<br>\u0628) 5<br>\u062c) 10<br>\u062f) 50<\/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. \u062a\u0627\u0628\u0639 IF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u06cc\u0627\u0641\u062a\u0646 \u0628\u0632\u0631\u06af\u200c\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f<br>\u0628) \u0627\u06cc\u062c\u0627\u062f \u0634\u0631\u0637 \u2705<br>\u062c) \u0634\u0645\u0627\u0631\u0634 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<br>\u062f) \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627<\/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. \u06a9\u0644\u06cc\u062f \u0645\u06cc\u0627\u0646\u0628\u0631 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062e\u0637 \u062c\u062f\u06cc\u062f \u062f\u0631 \u062f\u0627\u062e\u0644 \u0633\u0644\u0648\u0644\u061f<\/strong><br>\u0627\u0644\u0641) Alt + Enter \u2705<br>\u0628) Ctrl + Enter<br>\u062c) Shift + Enter<br>\u062f) Ctrl + Shift<\/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\u0632 \u06a9\u062f\u0627\u0645 \u0627\u0628\u0632\u0627\u0631 \u0628\u0631\u0627\u06cc \u06a9\u067e\u06cc\u200c\u06a9\u0631\u062f\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u06cc\u0646\u200c\u062a\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Flash Fill<br>\u0628) Filter<br>\u062c) Fill Handle \u2705<br>\u062f) Merge<\/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. \u0641\u0631\u0645\u0648\u0644 =MAX(1,5,9,3) \u0686\u0647 \u0645\u0642\u062f\u0627\u0631\u06cc \u0645\u06cc\u200c\u062f\u0647\u062f\u061f<\/strong><br>\u0627\u0644\u0641) 1<br>\u0628) 5<br>\u062c) 9 \u2705<br>\u062f) 3<\/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. \u06a9\u062f\u0627\u0645 \u06af\u0632\u06cc\u0646\u0647 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0646\u0627\u0645 \u0634\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0631\u0627\u0633\u062a\u200c\u06a9\u0644\u06cc\u06a9 \u0631\u0648\u06cc \u0634\u06cc\u062a &gt; Rename \u2705<br>\u0628) File &gt; Rename Sheet<br>\u062c) Home &gt; Format &gt; Rename<br>\u062f) Data &gt; Rename<\/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. \u0628\u0631\u0627\u06cc \u0645\u062e\u0641\u06cc \u06a9\u0631\u062f\u0646 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0686\u0647 \u0631\u0648\u0634\u06cc \u062f\u0631\u0633\u062a \u0627\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) \u0631\u0627\u0633\u062a\u200c\u06a9\u0644\u06cc\u06a9 \u0631\u0648\u06cc \u0633\u062a\u0648\u0646 &gt; Hide \u2705<br>\u0628) File &gt; Hide Column<br>\u062c) Format &gt; Delete<br>\u062f) Data &gt; Filter<\/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. \u062e\u0631\u0648\u062c\u06cc \u062a\u0627\u0628\u0639 =ROUND(12.678, 1) \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) 12.67<br>\u0628) 12.68 \u2705<br>\u062c) 12.60<br>\u062f) 12.7<\/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. \u0628\u0631\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646 \u062f\u0648 \u0633\u0644\u0648\u0644 A1 \u0648 B1 \u0627\u0632 \u0686\u0647 \u062a\u0627\u0628\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) =JOIN(A1,B1)<br>\u0628) =CONCAT(A1,B1) \u2705<br>\u062c) =MERGE(A1,B1)<br>\u062f) =TEXT(A1,B1)<\/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. \u06a9\u062f\u0627\u0645 \u062a\u0627\u0628\u0639 \u06a9\u0648\u0686\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) MAX<br>\u0628) MIN \u2705<br>\u062c) SMALL<br>\u062f) VALUE<\/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. \u06a9\u0644\u06cc\u062f \u0645\u06cc\u0627\u0646\u0628\u0631 \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0644 \u0635\u0641\u062d\u0647\u061f<\/strong><br>\u0627\u0644\u0641) Ctrl + S<br>\u0628) Ctrl + A \u2705<br>\u062c) Ctrl + C<br>\u062f) Ctrl + E<\/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. \u062a\u0627\u0628\u0639 COUNTIF \u0628\u0631\u0627\u06cc \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0627\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) \u062c\u0645\u0639\u200c\u0632\u062f\u0646 \u0645\u0634\u0631\u0648\u0637<br>\u0628) \u0634\u0645\u0627\u0631\u0634 \u0634\u0631\u0637\u06cc \u2705<br>\u062c) \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u200c\u06af\u06cc\u0631\u06cc<br>\u062f) \u06cc\u0627\u0641\u062a\u0646 \u062d\u062f\u0627\u06a9\u062b\u0631<\/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. \u0641\u0631\u0645\u0648\u0644 =LEN(&#8220;Excel 2024&#8221;) \u062e\u0631\u0648\u062c\u06cc\u200c\u0627\u0634 \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) 9 \u2705<br>\u0628) 10<br>\u062c) 11<br>\u062f) 12<\/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. \u0627\u0632 \u0686\u0647 \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0628\u0631\u0627\u06cc \u0641\u0631\u06cc\u0632 \u06a9\u0631\u062f\u0646 \u0631\u062f\u06cc\u0641 \u0627\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) View &gt; Freeze Panes &gt; Freeze Top Row \u2705<br>\u0628) Data &gt; Freeze<br>\u062c) Insert &gt; Freeze Row<br>\u062f) Home &gt; Lock Row<\/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. \u062a\u0627\u0628\u0639 SUMIF \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0645\u062c\u0645\u0648\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0634\u0631\u0637 \u2705<br>\u0628) \u0634\u0645\u0627\u0631\u0634 \u0645\u0642\u0627\u062f\u06cc\u0631<br>\u062c) \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627<br>\u062f) \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\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>22. \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0641\u0642\u0637 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u06a9\u0647 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u060c \u0627\u0632 \u06a9\u062f\u0627\u0645 \u0627\u0628\u0632\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Sort<br>\u0628) Remove Duplicates \u2705<br>\u062c) Flash Fill<br>\u062f) CountIf<\/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. \u062a\u0627\u0628\u0639 NOW \u0686\u0647 \u0645\u0642\u062f\u0627\u0631\u06cc \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u062a\u0627\u0631\u06cc\u062e \u0648 \u0633\u0627\u0639\u062a \u0641\u0639\u0644\u06cc \u2705<br>\u0628) \u0641\u0642\u0637 \u062a\u0627\u0631\u06cc\u062e<br>\u062c) \u0641\u0642\u0637 \u0633\u0627\u0639\u062a<br>\u062f) \u062a\u0627\u0631\u06cc\u062e \u0641\u0631\u062f\u0627<\/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. \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0631\u0627\u06cc \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) \u062c\u0633\u062a\u200c\u0648\u062c\u0648 \u062f\u0631 \u0631\u062f\u06cc\u0641<br>\u0628) \u062c\u0633\u062a\u200c\u0648\u062c\u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 \u2705<br>\u062c) \u0634\u0645\u0627\u0631\u0634<br>\u062f) \u06a9\u067e\u06cc\u200c\u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627<\/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. \u0641\u0631\u0645\u0648\u0644 =INT(3.75) \u0686\u0647 \u0639\u062f\u062f\u06cc \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) 3 \u2705<br>\u0628) 4<br>\u062c) 3.7<br>\u062f) 3.75<\/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. \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u0641\u0631\u0645\u062a \u0639\u062f\u062f\u06cc Currency \u0627\u0632 \u0686\u0647 \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Home &gt; Number &gt; Currency \u2705<br>\u0628) Data &gt; Format &gt; Currency<br>\u062c) File &gt; Options &gt; Currency<br>\u062f) Insert &gt; Currency<\/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. \u0627\u0632 \u062a\u0627\u0628\u0639 TEXT \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0639\u062f\u062f \u0628\u0647 \u0645\u062a\u0646 \u2705<br>\u0628) \u0634\u0645\u0627\u0631\u0634 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631<br>\u062c) \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0639\u062f\u062f<br>\u062f) \u062e\u0644\u0627\u0635\u0647 \u06a9\u0631\u062f\u0646 \u0645\u062a\u0646<\/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. \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 \u067e\u0633\u200c\u0632\u0645\u06cc\u0646\u0647 \u0628\u0631\u0627\u06cc \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0627\u0632 \u06a9\u062f\u0627\u0645 \u0645\u0633\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Home &gt; Fill Color \u2705<br>\u0628) View &gt; Background<br>\u062c) Insert &gt; Theme<br>\u062f) Data &gt; Style<\/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. \u0641\u0631\u0645\u0648\u0644 =LEFT(&#8220;Computer&#8221;, 3) \u0686\u0647 \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc\u200c\u062f\u0647\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Com \u2705<br>\u0628) put<br>\u062c) ter<br>\u062f) Compu<\/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. \u062a\u0627\u0628\u0639 PROPER \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0647\u0645\u0647 \u062d\u0631\u0648\u0641 \u0631\u0627 \u0628\u0632\u0631\u06af \u0645\u06cc\u200c\u06a9\u0646\u062f<br>\u0628) \u0641\u0642\u0637 \u062d\u0631\u0641 \u0627\u0648\u0644 \u0647\u0631 \u0648\u0627\u0698\u0647 \u0631\u0627 \u0628\u0632\u0631\u06af \u0645\u06cc\u200c\u06a9\u0646\u062f \u2705<br>\u062c) \u062d\u0631\u0648\u0641 \u06a9\u0648\u0686\u06a9<br>\u062f) \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646<\/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\u200c\u06cc <strong>\u0633\u0624\u0627\u0644\u0627\u062a \u062a\u0633\u062a\u06cc \u0627\u06a9\u0633\u0644 2024 \u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0628\u0627 \u062c\u0648\u0627\u0628<\/strong> (\u0633\u0624\u0627\u0644\u0627\u062a 31 \u062a\u0627 60):<\/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. \u0628\u0631\u0627\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u06a9\u0627\u0645\u0646\u062a \u0628\u0647 \u06cc\u06a9 \u0633\u0644\u0648\u0644 \u0627\u0632 \u0686\u0647 \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Review &gt; New Comment \u2705<br>\u0628) Data &gt; Note<br>\u062c) Insert &gt; Comment<br>\u062f) View &gt; Comment<\/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. \u062f\u0631 \u062a\u0627\u0628\u0639 IF\u060c \u0627\u06af\u0631 \u0634\u0631\u0637 \u062f\u0631\u0633\u062a \u0646\u0628\u0627\u0634\u062f \u06a9\u062f\u0627\u0645 \u0645\u0642\u062f\u0627\u0631 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0645\u0642\u062f\u0627\u0631 \u0627\u0648\u0644<br>\u0628) \u0645\u0642\u062f\u0627\u0631 \u062f\u0648\u0645 \u2705<br>\u062c) \u0647\u06cc\u0686\u200c\u06a9\u062f\u0627\u0645<br>\u062f) \u062e\u0637\u0627<\/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. \u0627\u0632 \u062a\u0627\u0628\u0639 TRIM \u0686\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u200c\u0627\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u062a\u0628\u062f\u06cc\u0644 \u0645\u062a\u0646 \u0628\u0647 \u0639\u062f\u062f<br>\u0628) \u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u2705<br>\u062c) \u062a\u063a\u06cc\u06cc\u0631 \u0641\u0648\u0646\u062a<br>\u062f) \u0627\u0641\u0632\u0648\u062f\u0646 \u0641\u0627\u0635\u0644\u0647<\/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. \u062a\u0627\u0628\u0639 COUNTBLANK \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0634\u0645\u0627\u0631\u0634 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc<br>\u0628) \u0634\u0645\u0627\u0631\u0634 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u2705<br>\u062c) \u062d\u0630\u0641 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc<br>\u062f) \u062c\u0645\u0639\u200c\u0632\u062f\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631<\/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. \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 IF \u062a\u0648 \u062f\u0631 \u062a\u0648 \u0627\u0632 \u0686\u0647 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) IF(IF()) \u2705<br>\u0628) IF+IF<br>\u062c) IF*IF<br>\u062f) IF:IF<\/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. \u0641\u0631\u0645\u0648\u0644 =MOD(10,3) \u0686\u0647 \u0639\u062f\u062f\u06cc \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) 1 \u2705<br>\u0628) 3<br>\u062c) 10<br>\u062f) 0<\/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. \u06a9\u062f\u0627\u0645 \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) FILTER<br>\u0628) SORT \u2705<br>\u062c) IF<br>\u062f) SUM<\/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. \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0641\u0642\u0637 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u0627\u0639\u062f\u0627\u062f \u0631\u0627 \u062c\u0645\u0639 \u0628\u0632\u0646\u06cc\u0645 \u0627\u0632 \u0686\u0647 \u062a\u0627\u0628\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) =COUNTA<br>\u0628) =SUM \u2705<br>\u062c) =IF<br>\u062f) =COUNT<\/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. \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u06a9\u0633\u0644\u060c \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0644\u06cc\u0633\u062a \u06a9\u0634\u0648\u06cc\u06cc \u0627\u0632 \u0686\u0647 \u0627\u0628\u0632\u0627\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Data &gt; Data Validation \u2705<br>\u0628) Insert &gt; List<br>\u062c) Review &gt; Dropdown<br>\u062f) Home &gt; Format as Table<\/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. \u062a\u0627\u0628\u0639 CONCATENATE \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u062c\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0645\u062a\u0646<br>\u0628) \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646 \u2705<br>\u062c) \u062a\u0628\u062f\u06cc\u0644 \u0639\u062f\u062f<br>\u062f) \u0634\u0645\u0627\u0631\u0634 \u062d\u0631\u0648\u0641<\/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. \u0627\u0632 \u062a\u0627\u0628\u0639 TODAY \u0686\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u200c\u0627\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0646\u0645\u0627\u06cc\u0634 \u062a\u0627\u0631\u06cc\u062e \u0627\u0645\u0631\u0648\u0632 \u2705<br>\u0628) \u0646\u0645\u0627\u06cc\u0634 \u0632\u0645\u0627\u0646<br>\u062c) \u062a\u0627\u0631\u06cc\u062e \u062f\u06cc\u0631\u0648\u0632<br>\u062f) \u062a\u0627\u0631\u06cc\u062e \u0648 \u0633\u0627\u0639\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>42. \u062a\u0627\u0628\u0639 RANK \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0631\u062a\u0628\u0647\u200c\u0628\u0646\u062f\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u2705<br>\u0628) \u0634\u0645\u0627\u0631\u0634<br>\u062c) \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646<br>\u062f) \u062c\u0633\u062a\u200c\u0648\u062c\u0648<\/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. \u062a\u0627\u0628\u0639 LOWER \u0686\u0647 \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc\u200c\u062f\u0647\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u062a\u0628\u062f\u06cc\u0644 \u0645\u062a\u0646 \u0628\u0647 \u0628\u0632\u0631\u06af<br>\u0628) \u062a\u0628\u062f\u06cc\u0644 \u0645\u062a\u0646 \u0628\u0647 \u06a9\u0648\u0686\u06a9 \u2705<br>\u062c) \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646<br>\u062f) \u062d\u0630\u0641 \u0645\u062a\u0646<\/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. \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647\u200c\u0635\u0648\u0631\u062a PDF \u0627\u0632 \u0686\u0647 \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) File &gt; Print &gt; Save as PDF \u2705<br>\u0628) Data &gt; Export<br>\u062c) Insert &gt; PDF<br>\u062f) Home &gt; Save as<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>45. \u062f\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0646\u0648\u06cc\u0633\u06cc\u060c \u0639\u0644\u0627\u0645\u062a &#8220;$&#8221; \u0628\u0631\u0627\u06cc \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) \u0627\u0634\u0627\u0631\u0647 \u0628\u0647 \u0633\u0644\u0648\u0644<br>\u0628) \u0622\u062f\u0631\u0633\u200c\u062f\u0647\u06cc \u0645\u0637\u0644\u0642 \u2705<br>\u062c) \u062c\u0645\u0639<br>\u062f) \u062f\u0631\u0635\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>46. \u062a\u0627\u0628\u0639 IFERROR \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) \u0628\u0631\u0627\u06cc \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 \u0646\u0645\u0627\u06cc\u0634 \u062e\u0637\u0627 \u2705<br>\u0628) \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646<br>\u062c) \u0634\u0645\u0627\u0631\u0634<br>\u062f) \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\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>47. \u062a\u0627\u0628\u0639 LARGE \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u062f\u0647\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u06a9\u0648\u0686\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f<br>\u0628) \u0628\u0632\u0631\u06af\u200c\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f<br>\u062c) \u0645\u0642\u062f\u0627\u0631 n\u0627\u0645 \u0628\u0632\u0631\u06af \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u2705<br>\u062f) \u062c\u0645\u0639 \u0627\u0639\u062f\u0627\u062f \u0628\u0632\u0631\u06af<\/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. \u062a\u0627\u0628\u0639 TEXTJOIN \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646 \u0628\u0627 \u062c\u062f\u0627\u06a9\u0646\u0646\u062f\u0647 \u2705<br>\u0628) \u062c\u062f\u0627\u06a9\u0631\u062f\u0646 \u0645\u062a\u0646<br>\u062c) \u0634\u0645\u0627\u0631\u0634 \u0645\u062a\u0646<br>\u062f) \u062a\u0628\u062f\u06cc\u0644 \u0639\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>49. \u0686\u0647 \u062a\u0627\u0628\u0639\u06cc \u062a\u0627\u0631\u06cc\u062e \u062a\u0648\u0644\u062f \u0631\u0627 \u0628\u0647 \u0633\u0646 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) DATEDIF \u2705<br>\u0628) NOW<br>\u062c) AGE<br>\u062f) DATE<\/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. \u062a\u0627\u0628\u0639 ISNUMBER \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0628\u0631\u0631\u0633\u06cc \u0639\u062f\u062f \u0628\u0648\u062f\u0646 \u0645\u0642\u062f\u0627\u0631 \u2705<br>\u0628) \u0628\u0631\u0631\u0633\u06cc \u062e\u0627\u0644\u06cc \u0628\u0648\u062f\u0646<br>\u062c) \u062a\u0628\u062f\u06cc\u0644 \u0628\u0647 \u0639\u062f\u062f<br>\u062f) \u062d\u0630\u0641 \u0639\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>51. \u06a9\u0644\u06cc\u062f \u0645\u06cc\u0627\u0646\u0628\u0631 \u0628\u0631\u0627\u06cc \u062f\u0631\u062c \u0646\u0645\u0648\u062f\u0627\u0631 \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) Alt + F1 \u2705<br>\u0628) Ctrl + Shift + C<br>\u062c) F5<br>\u062f) Ctrl + F1<\/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. \u062a\u0627\u0628\u0639 MID \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u0645\u062a\u0646 \u2705<br>\u0628) \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646<br>\u062c) \u0686\u0633\u0628\u0627\u0646\u062f\u0646 \u0639\u062f\u062f<br>\u062f) \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646<\/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. \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u0631\u0627\u0628\u0637\u0647 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0627\u0632 \u0686\u0647 \u0627\u0628\u0632\u0627\u0631 \u06af\u0631\u0627\u0641\u06cc\u06a9\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Trace Precedents \u2705<br>\u0628) Conditional Formatting<br>\u062c) Goal Seek<br>\u062f) Sort<\/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. \u0628\u0631\u0627\u06cc \u062d\u0641\u0627\u0638\u062a \u0627\u0632 \u06cc\u06a9 \u0634\u06cc\u062a \u0627\u0632 \u0686\u0647 \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Review &gt; Protect Sheet \u2705<br>\u0628) File &gt; Lock<br>\u062c) Data &gt; Protect<br>\u062f) Home &gt; Security<\/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. \u062a\u0627\u0628\u0639 AND \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc True \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0648\u0642\u062a\u06cc \u062d\u062f\u0627\u0642\u0644 \u06cc\u06a9\u06cc \u062f\u0631\u0633\u062a \u0628\u0627\u0634\u062f<br>\u0628) \u0648\u0642\u062a\u06cc \u0647\u0645\u0647 \u062f\u0631\u0633\u062a \u0628\u0627\u0634\u0646\u062f \u2705<br>\u062c) \u0648\u0642\u062a\u06cc \u0647\u0645\u0647 \u063a\u0644\u0637 \u0628\u0627\u0634\u0646\u062f<br>\u062f) \u0648\u0642\u062a\u06cc \u0645\u0642\u062f\u0627\u0631 \u062e\u0627\u0644\u06cc \u0628\u0627\u0634\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>56. \u062a\u0627\u0628\u0639 OR \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc True \u0645\u06cc\u200c\u062f\u0647\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0641\u0642\u0637 \u0627\u06af\u0631 \u0647\u0645\u0647 \u062f\u0631\u0633\u062a \u0628\u0627\u0634\u0646\u062f<br>\u0628) \u0627\u06af\u0631 \u06cc\u06a9\u06cc \u062f\u0631\u0633\u062a \u0628\u0627\u0634\u062f \u2705<br>\u062c) \u0647\u06cc\u0686 \u0648\u0642\u062a<br>\u062f) \u0627\u06af\u0631 \u0647\u0645\u0647 \u063a\u0644\u0637 \u0628\u0627\u0634\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>57. \u062a\u0627\u0628\u0639 ABS \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0642\u062f\u0631 \u0645\u0637\u0644\u0642 \u0639\u062f\u062f \u2705<br>\u0628) \u062c\u0645\u0639<br>\u062c) \u0636\u0631\u0628<br>\u062f) \u062f\u0631\u0635\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>58. \u062a\u0627\u0628\u0639 COUNTIFS \u0686\u0647 \u062a\u0641\u0627\u0648\u062a\u06cc \u0628\u0627 COUNTIF \u062f\u0627\u0631\u062f\u061f<\/strong><br>\u0627\u0644\u0641) \u0634\u0631\u0637\u200c\u0647\u0627\u06cc \u0645\u062a\u0639\u062f\u062f \u2705<br>\u0628) \u0634\u0645\u0627\u0631\u0634 \u062f\u0642\u06cc\u0642<br>\u062c) \u0628\u0631\u0631\u0633\u06cc \u0631\u0634\u062a\u0647<br>\u062f) \u062c\u0645\u0639 \u0645\u0634\u0631\u0648\u0637<\/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. \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0686\u06a9\u200c\u0628\u0627\u06a9\u0633 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0632 \u0686\u0647 \u0627\u0628\u0632\u0627\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/strong><br>\u0627\u0644\u0641) Developer &gt; Insert &gt; Checkbox \u2705<br>\u0628) Insert &gt; Symbol<br>\u062c) Data &gt; Validation<br>\u062f) Home &gt; Format<\/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. \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u062a\u0627\u0628\u0639\u06cc \u06a9\u0647 TRUE \u06cc\u0627 FALSE \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f \u0686\u06cc\u0633\u062a\u061f<\/strong><br>\u0627\u0644\u0641) IF<br>\u0628) ISBLANK<br>\u062c) AND<br>\u062f) \u0647\u0645\u0647 \u0645\u0648\u0627\u0631\u062f \u0628\u0627\u0644\u0627 \u2705<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u0627\u062f\u0627\u0645\u0647\u060c \u06f6\u06f0 \u0633\u0648\u0627\u0644 \u062a\u0633\u062a\u06cc \u0627\u06a9\u0633\u0644 2024 \u0628\u0647 \u0633\u0628\u06a9 \u0622\u0632\u0645\u0648\u0646\u200c\u0647\u0627\u06cc \u0641\u0646\u06cc \u0648 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u0633\u062e \u06af\u0632\u06cc\u0646\u0647\u200c\u0627\u06cc \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. 1. \u0628\u0631\u0627\u06cc \u062c\u0645\u0639\u200c\u0632\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u062a\u0627 A10 \u0627\u0632 \u06a9\u062f\u0627\u0645 \u062a\u0627\u0628\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f\u0627\u0644\u0641) =SUM(A1:A10) \u2705\u0628) =ADD(A1:A10)\u062c) =TOTAL(A1-A10)\u062f) =COUNT(A1:A10) 2. \u06a9\u062f\u0627\u0645 \u06a9\u0644\u06cc\u062f \u0645\u06cc\u0627\u0646\u0628\u0631 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0641\u0627\u06cc\u0644 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f\u0627\u0644\u0641) Ctrl + Z\u0628) Ctrl + P\u062c)&#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":[186,780,185,22,184,2783,2784,2786,2785],"class_list":["post-5877","post","type-post","status-publish","format-standard","hentry","category-379","tag-exel","tag-icdl","tag-185","tag-22","tag-184","tag-2783","tag-2784","tag---icdl","tag-2785"],"_links":{"self":[{"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts\/5877","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=5877"}],"version-history":[{"count":1,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts\/5877\/revisions"}],"predecessor-version":[{"id":5878,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=\/wp\/v2\/posts\/5877\/revisions\/5878"}],"wp:attachment":[{"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softrah.ir\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}