More Related Content
What's hot (20)
Viewers also liked (20)
Similar to §µ§â§à§Ü 53. §±§â§Ú§Ù§ß§Ñ§é§Ö§ß§ß§ñ §ä§Ñ §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ §Ý§à§Ô?§é§ß§Ú§ç §æ§å§ß§Ü§è?§Û §ä§Ñ§Ò§Ý§Ú§é§ß§à§Ô§à §á§â§à§è§Ö§ã§à§â§Ñ (20)
Recently uploaded (13)
§µ§â§à§Ü 53. §±§â§Ú§Ù§ß§Ñ§é§Ö§ß§ß§ñ §ä§Ñ §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ §Ý§à§Ô?§é§ß§Ú§ç §æ§å§ß§Ü§è?§Û §ä§Ñ§Ò§Ý§Ú§é§ß§à§Ô§à §á§â§à§è§Ö§ã§à§â§Ñ
- 1. §²§à§Ù§Õ?§Ý 7. §µ §è§î§à§Þ§å §â§à§Ù§Õ?§Ý? §Ó§Ú §Õ?§Ù§ß§Ñ?§ä§Ö§ã§î §á§â§à: §¡§Ò§ã§à§Ý§ð§ä§ß?, §Ó?§Õ§ß§à§ã§ß? §Û §Þ?§ê§Ñ§ß? §á§à§ã§Ú§Ý§Ñ§ß§ß§ñ §ß§Ñ §Ü§à§Þ?§â§Ü§Ú §ä§Ñ §Õ?§Ñ§á§Ñ§Ù§à§ß§Ú §Ü§à§Þ?§â§à§Ü §³§ä§Ó§à§â§Ö§ß§ß§ñ §ä§Ñ §ß§Ñ§Ý§Ñ§Ô§à§Õ§Ø§Ö§ß§ß§ñ §Õ?§Ñ§Ô§â§Ñ§Þ §â?§Ù§ß§à§Ô§à §ä§Ú§á§å, §Ó§Ú§Ò?§â §ä§Ú§á§å §Õ?§Ñ§Ô§â§Ñ§Þ §µ§á§à§â§ñ§Õ§Ü§å§Ó§Ñ§ß§ß§ñ §Õ§Ñ§ß§Ú§ç §å §ä§Ñ§Ò§Ý§Ú§è§ñ§ç §¡§Ó§ä§à§Þ§Ñ§ä§Ú§é§ß? §ä§Ñ §â§à§Ù§ê§Ú§â§Ö§ß? §æ?§Ý§î§ä§â§Ú, §á§â§à§Þ?§Ø§ß? §á?§Õ§ã§å§Þ§Ü§Ú §£§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§ß§ñ §á§Ñ§â§Ñ§Þ§Ö§ä§â?§Ó §ã§ä§à§â?§ß§Ü§Ú §ä§Ñ §Õ§â§å§Ü§å§Ó§Ñ§ß§ß§ñ §Ö§Ý§Ö§Ü§ä§â§à§ß§ß§à? §ä§Ñ§Ò§Ý§Ú§è? §±§â§Ú§Ù§ß§Ñ§é§Ö§ß§ß§ñ §Û §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ §Þ§Ñ§ä§Ö§Þ§Ñ§ä§Ú§é§ß§Ú§ç, §ã§ä§Ñ§ä§Ú§ã§ä§Ú§é§ß§Ú§ç, §Ý§à§Ô?§é§ß§Ú§ç §æ§å§ß§Ü§è?§Û §ä§Ñ§Ò§Ý§Ú§é§ß§à§Ô§à §á§â§à§è§Ö§ã§à§â§Ñ §µ§Þ§à§Ó§ß§Ö §æ§à§â§Þ§Ñ§ä§å§Ó§Ñ§ß§ß§ñ
- 2. §µ§â§à§Ü 53. 1. §Á§Ü §Ù§Ñ§á§Ú§ã§å?§ä§î§ã§ñ §Ü§à§Þ§Ñ§ß§Õ§Ñ §â§à§Ù§Ô§Ñ§Ý§å§Ø§Ö§ß§ß§ñ §Ó §Þ§à§Ó? Lasarus? §Á§Ü §Ó§à§ß§Ñ §Ó§Ú§Ü§à§ß§å?§ä§î§ã§ñ?
- 3. §¬§â?§Þ §æ§à§â§Þ§å§Ý, §ë§à §Þ?§ã§ä§ñ§ä§î §é§Ú§ã§Ý§Ñ, §Ù§ß§Ñ§Ü§Ú §Õ?§Û, §æ§å§ß§Ü§è?? ?§ç §à§á§â§Ñ§è§ð§Ó§Ñ§ß§ß§ñ, §Ó Excel §Þ§à§Ø§å§ä§î §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§Ó§Ñ§ä§Ú§ã§ñ §Ý§à§Ô?§é§ß? §Ó§Ú§â§Ñ§Ù§Ú. §§à§Ô?§é§ß§Ú§Û §Ó§Ú§â§Ñ§Ù - §è§Ö §Ó§Ú§â§Ñ§Ù, §ñ§Ü§Ú§Û §ß§Ñ§Ò§å§Ó§Ñ? §à§Õ§ß§à§Ô§à §Ù §Õ§Ó§à§ç §Ù§ß§Ñ§é§Ö§ß§î: True ¨C ?§ã§ä§Ú§ß§Ñ §Ñ§Ò§à False - §ç§Ú§Ò§ß?§ã§ä§î
- 4. §±§â§à§ã§ä? §Ý§à§Ô?§é§ß? §Ó§Ú§â§Ñ§Ù§Ú §ã§Ü§Ý§Ñ§Õ§Ñ§ð§ä§î§ã§ñ §Ù §Õ§Ó§à§ç §Ó§Ú§â§Ñ§Ù?§Ó, §á§à§Ó¡¯§ñ§Ù§Ñ§ß§Ú§ç §à§á§Ö§â§Ñ§è??§ð §Ó?§Õ§ß§à§ê§Ö§ß§ß§ñ: ? §Ò?§Ý§î§ê§Ö > ? §Þ§Ö§ß§ê§Ö < ? §Õ§à§â?§Ó§ß§ð? = ? §ß§Ö §Þ§Ö§ß§ê§Ö (§Ò?§Ý§î§ê§Ö §Ñ§Ò§à §Õ§à§â?§Ó§ß§ð?) >= ? §ß§Ö §Ò?§Ý§î§ê§Ö (§Þ§Ö§ß§ê§Ö §Ñ§Ò§à §Õ§à§â?§Ó§ß§ð?) <= ? §ß§Ö §Õ§à§â?§Ó§ß§ð? < > 2 > 1 ¨C ?§ã§ä§Ú§ß§Ñ, 2 < 1 - §ç§Ú§Ò§ß?§ã§ä§î
- 5. §§à§Ô?§é§ß§Ñ §æ§å§ß§Ü§è?§ñ - §è§Ö §æ§å§ß§Ü§è?§ñ, §à§Õ§Ú§ß §Ñ§Ò§à §Ü?§Ý§î§Ü§Ñ §Ñ§â§Ô§å§Þ§Ö§ß§ä?§Ó §ñ§Ü§à? §Ý§à§Ô?§é§ß? §Ó§Ú§â§Ñ§Ù§Ú. §²§à§Ù§Ô§Ý§ñ§ß§Ö§Þ§à §à§Õ§ß§å §Ù §à§ã§ß§à§Ó§ß§Ú§ç §Ý§à§Ô?§é§ß§Ú§ç §æ§å§ß§Ü§è?§Û IF, §á§â§Ú§Ù§ß§Ñ§é§Ö§ß§å §Õ§Ý§ñ §à§Ò§é§Ú§ã§Ý§Ö§ß§ß§ñ §â?§Ù§ß§Ú§ç §Ó§Ú§â§Ñ§Ù?§Ó §Ù§Ñ§Ý§Ö§Ø§ß§à §Ó?§Õ §å§Þ§à§Ó§Ú:
- 6. IF ( §å§Þ§à§Ó§Ñ; §£§Ú§â§Ñ§Ù1; §£§Ú§â§Ñ§Ù2). §£§Ú§â§Ñ§Ù1 - §à§Ò§é§Ú§ã§Ý§ð?§ä§î§ã§ñ, §ñ§Ü§ë§à §å§Þ§à§Ó§Ñ ?§ã§ä§Ú§ß§ß§Ñ). §£§Ú§â§Ñ§Ù2 - §à§Ò§é§Ú§ã§Ý§ð?§ä§î§ã§ñ, §ñ§Ü§ë§à §å§Þ§à§Ó§Ñ §ç§Ú§Ò§ß§Ñ).
- 7. §µ §Ó?§Õ§à§Þ§à§ã§ä? §ß§Ñ§Ó§é§Ñ§Ý§î§ß§Ú§ç §Õ§à§ã§ñ§Ô§ß§Ö§ß§î §å§é§ß?§Ó §Ò?§Ý§ñ §à§è?§ß§Ü§Ú §á§à§ä§â?§Ò§ß§à §Ó§Ó§Ö§ã§ä§Ú §ã§Ý§à§Ó§à ¡°§¥§à§Ò§â§Ö¡±, §ñ§Ü§ë§à §å§é§Ö§ß§î §Ú§Ñ? §à§è?§ß§Ü§å, §Ó§Ú§ë§å §Ó?§Õ 6 §Ò§Ñ§Ý?§Ó, ? §ã§Ý§à§Ó§à ¡°§©§Ñ§Õ§à§Ó?§Ý§î§ß§à¡±, §ñ§Ü§ë§à §å§é§Ö§ß§î §Þ§Ñ? ?§ß§ê§å §à§è?§ß§Ü§å §¶§â§Ñ§Ô§Þ§Ö§ß§ä §Ñ§Ý§Ô§à§â§Ú§ä§Þ§å §â§à§Ù§Ó¡¯§ñ§Ù§Ñ§ß§ß§ñ §è??? §Ù§Ñ§Õ§Ñ§é? §á§à§Õ§Ñ§ß§à §å §Ó§Ú§Ô§Ý§ñ§Õ? §Ò§Ý§à§Ü-§ã§ç§Ö§Þ§Ú.
- 8. §µ §á§â§à§Ô§â§Ñ§Þ? Excel §è§Ö§Û §Ñ§Ý§Ô§à§â§Ú§ä§Þ §â§Ö§Ñ§Ý?§Ù§å?§ä§î§ã§ñ §Ù§Ñ §Õ§à§á§à§Þ§à§Ô§à§ð §æ§å§ß§Ü§è?? IF (B1>6; ¡°§¥§à§Ò§â§Ö¡±; ¡°§©§Ñ§Õ§à§Ó?§Ý§î§ß§à¡±
- 9. §µ §Ó?§Õ§à§Þ§à§ã§ä? §ß§Ñ§Ó§é§Ñ§Ý§î§ß§Ú§ç §Õ§à§ã§ñ§Ô§ß§Ö§ß§î §Ò?§Ý§ñ §à§è?§ß§Ü§Ú §á§à§ä§â?§Ò§ß§à §Ó§Ó§Ö§ã§ä§Ú §ã§Ý§à§Ó§à ¡°§±§à§ã§Ö§â§Ö§Õ§ß§î§à¡± §Õ§Ý§ñ §ä§Ú§ç §å§é§ß?§Ó, §ñ§Ü? §Þ§Ñ§ð§ä§î §à§è?§ß§Ü§Ú, §Ó§Ú§ë? §Ó?§Õ 6 §Ò§Ñ§Ý?§Ó, §Ñ§Ý§Ö §ß§Ú§Ø§é? §Ù§Ñ 10, §Õ§Ý§ñ §â§Ö§ê§ä§Ú §å§é§ß?§Ó ¨C §ß?§é§à§Ô§à §ß§Ö §á§Ú§ã§Ñ§ä§Ú. §³§Ü§à§â§Ú§ã§ä§Ñ?§Þ§à§ã§ñ §Ý§à§Ô?§é§ß§Ú§Þ§Ú §æ§å§ß§Ü§è?§ñ§Þ§Ú IF §ä§Ñ AND.
- 10. §µ §Õ§Ñ§ß§à§Þ§å §Ó§Ú§á§Ñ§Õ§Ü§å §Þ§Ñ?§Þ§à: =IF(AND(B1>6;B1<10); ¡°§±§à§ã§Ö§â§Ö§Õ§ß§î§à¡±, ¡°¡±) §°§ã§ä§Ñ§ß§ß?§Û §Ñ§â§Ô§å§Þ§Ö§ß§ä §æ§å§ß§Ü§è?? IF- §è§Ö §Ý§Ñ§á§Ü§Ú §Ò§Ö§Ù §ã§Ú§Þ§Ó§à§Ý?§Ó §Þ?§Ø §ß§Ú§Þ§Ú, §ä§à§Ò§ä§à §á§à§â§à§Ø§ß?§Û §â§ñ§Õ§à§Ü. ?§ß§à§Õ? §Ò§å§Ó§Ñ? §Õ§à§è?§Ý§î§ß§à §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ä§Ú §Ó§Ü§Ý§Ñ§Õ§Ö§ß? §Ý§à§Ô?§é§ß? §æ§å§ß§Ü§è?? IF. §¯§Ö§ç§Ñ§Û §á§à§ä§â?§Ò§ß§à §à§ç§Ñ§â§Ñ§Ü§ä§Ö§â§Ú§Ù§å§Ó§Ñ§ä§Ú §â?§Ó§Ö§ß§î §ß§Ñ§Ó§é§Ñ§Ý§î§ß§Ú§ç §Õ§à§ã§ñ§Ô§ß§Ö§ß§î §å§é§ß?§Ó §Ù§Ñ §ä§â§î§à§Þ§Ñ §å§Þ§à§Ó§ß§Ú§Þ§Ú §â?§Ù§ß§Ú§è§ñ§Þ§Ú: ¡°§±§à§é§Ñ§ä§Ü§à§Ó§Ú§Û¡± - (1-4 §Ò§Ñ§Ý§Ú) ¡°§³§Ö§â§Ö§Õ§ß?§Û¡± - (5-8 §Ò§Ñ§Ý?§Ó) ¡°§£§Ú§ã§à§Ü§Ú§Û¡± - (9-12 §Ò§Ñ§Ý?§Ó)
- 11. §£ Excel §è§ð §Ù§Ñ§Õ§Ñ§é§å §Þ§à§Ø§ß§Ñ §â§à§Ù§Ó¡¯§ñ§Ù§Ñ§ä§Ú §ä§Ñ§Ü§Ú§Þ §é§Ú§ß§à§Þ: =IF(B1<5;¡±§±§à§é§Ñ§ä§Ü§à§Ó§Ú§Û¡±;IF(B1<9;¡±§³§Ö§â§Ö§Õ§ß?§Û¡±; ¡±§£§Ú§ã§à§Ü§Ú§Û¡±)) §£ Excel §Õ§à§á§å§ã§Ü§Ñ?§ä§î§ã§ñ §Ó§Ü§Ý§Ñ§Õ§Ñ§ä§Ú §à§Õ§ß§Ñ §Ó §à§Õ§ß§å §Ü?§Ý§î§Ü§Ñ §æ§å§ß§Ü§è?§Û IF
- 12. §§à§Ô?§é§ß? §æ§å§ß§Ü§è?? AND, OR, NOT
- 13. §¯§Ñ§Û§é§Ñ§ã§ä?§ê§Ö §ä? §æ§å§ß§Ü§è?? §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§ð§ä§î§ã§ñ §ñ§Ü §Ñ§â§Ô§å§Þ§Ö§ß§ä§Ú §æ§å§ß§Ü§è?? IF, §Ñ §ã§Ñ§Þ§à§ã§ä?§Û§ß§à - §Õ§å§Ø§Ö §â?§Õ§Ü§à. §µ §ä§Ñ§Ò§Ý§Ú§è? §á§â§Ö§Õ§ã§ä§Ñ§Ó§Ý§Ö§ß§à §Ù§ß§Ñ§é§Ö§ß§ß§ñ §æ§å§ß§Ü§è?§Û AND, OR, NOT §Ù§Ñ§Ý§Ö§Ø§ß§à §Ó?§Õ §Ó§Þ?§ã§ä§å §Ü§Ý?§ä§Ú§ß§à§Ü A1 i B1
- 14. §§à§Ô?§é§ß§å §æ§å§ß§Ü§è?§ð AND §ë§Ö §ß§Ñ§Ù§Ú§Ó§Ñ§ð§ä§î §Ý§à§Ô?§é§ß§à§ð §æ§å§ß§Ü§è??§ð ? (§Ü§à§ß¡¯§ð§ß§Ü§è?§ñ), §Ý§à§Ô?§é§ß§å §æ§å§ß§Ü§è?§ð OR ¨C §Ý§à§Ô?§é§ß§à§ð §æ§å§ß§Ü§è??§ð §¡§¢§° (§Õ§Ú§Ù¡¯§ð§ß§Ü§è?§ñ), §Ñ §Ý§à§Ô?§é§ß§å §æ§å§ß§Ü§è?§ð NOT - §Ý§à§Ô?§é§ß§à§ð §æ§å§ß§Ü§è??§ð §¯§¦ (§Ù§Ñ§á§Ö§â§Ö§é§Ö§ß§ß§ñ). §§à§Ô?§é§ß? §æ§å§ß§Ü§è?? AND, OR, NOT §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§ð§ä§î §Õ§Ý§ñ §Ù§Ñ§á§Ú§ã§å §Ò?§Ý§î§ê §ã§Ü§Ý§Ñ§Õ§ß§Ú§ç §Ý§à§Ô?§é§ß§Ú§ç §Ó§Ú§â§Ñ§Ù?§Ó, §ß?§Ø §á§â§à§ã§ä§à §â?§Ó§ß?§ã§ä§î §Ñ§Ò§à §ß§Ö§â?§Ó§ß?§ã§ä§î.
- 15. §¯§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ, §å §æ§å§ß§Ü§è?? IF §ß§Ö §Þ§à§Ø§ß§Ñ §Ù§Ñ§á§Ú§ã§å§Ó§Ñ§ä§Ú §á§à§Õ§Ó?§Û§ß§å §ß§Ö§â?§Ó§ß?§ã§ä§î. §´§à§Þ§å §Ù§Ñ§Þ?§ã§ä§î §á§à§Õ§Ó?§Û§ß§à? §ß§Ö§â?§Ó§ß§à§ã§ä? 10<§¡§©<20 §á§à§ä§â?§Ò§ß§à §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§Ó§Ñ§ä§Ú §Ý§à§Ô?§é§ß§Ú§Û §Ó§Ú§â§Ñ§Ù AND(A3>10;A3<20). §¡§Ò§à, §ß§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ, §æ§å§ß§Ü§è?§ð §Ù§Ñ§Õ§Ñ§ß§à §ä§Ñ§Ü: y = ? §Ù§ß§Ñ§é§Ö§ß§ß§ñ §ç §Ù§ß§Ñ§ç§à§Õ§Ú§ä§î§ã§ñ §Ó §Ü§Ý?§ä§Ú§ß§è? §¡5, §ä§à §æ§à§â§Þ§å§Ý§Ñ §Õ§Ý§ñ §à§Ò§é§Ú§ã§Ý§Ö§ß§ß§ñ §Ù§ß§Ñ§é§Ö§ß§ß§ñ §æ§å§ß§Ü§è?? §å §Ù§Ñ§á§Ú§ã§å?§ä§î§ã§ñ §ä§Ñ§Ü: =IF(OR(A5<-2;A5>10);2*A5-5; "§æ§å§ß§Ü§è?§ñ §ß§Ö §Ó§Ú§Ù§ß§Ñ§é§Ö§ß§Ñ")
- 16. §µ§Ó§Ñ§Ô§Ñ! §±?§Õ §é§Ñ§ã §â§à§Ò§à§ä§Ú §Ù §Ü§à§Þ§á¡¯§ð§ä§Ö§â§à§Þ §Õ§à§ä§â§Ú§Þ§å§Û§ä§Ö§ã§ñ §á§â§Ñ§Ó§Ú§Ý §Ò§Ö§Ù§á§Ö§Ü§Ú §ä§Ñ §ã§Ñ§ß?§ä§Ñ§â§ß§à-§Ô?§Ô??§ß?§é§ß§Ú§ç §ß§à§â§Þ.
- 18. 1. §»§à §ä§Ñ§Ü§Ö §Ý§à§Ô?§é§ß? §Ó§Ú§â§Ñ§Ù§Ú? §Á§Ü? §Ù§ß§Ñ§Ü§Ú §Ó§à§ß§Ú §Þ§à§Ø§å§ä§î §Þ?§ã§ä§Ú§ä§Ú? 2. §Á§Ü§Ú§ç §Ù§ß§Ñ§é§Ö§ß§î §Þ§à§Ø§Ö §ß§Ñ§Ò§å§Ó§Ñ§ä§Ú §Ý§à§Ô?§é§ß§Ú§Û §Ó§Ú§â§Ñ§Ù? 3. §Á§Ü§Ú§Û §Ù§Ñ§Ô§Ñ§Ý§î§ß§Ú§Û §Ó§Ú§Ô§Ý§ñ§Õ, §Ü?§Ý§î§Ü?§ã§ä§î §Ñ§â§Ô§å§Þ§Ö§ß§ä?§Ó, §â§Ö§Ù§å§Ý§î§ä§Ñ§ä §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ §Ý§à§Ô?§é§ß§à? §æ§å§ß§Ü§è?? IF? 4. §Á§Ü §Ó§Ú§Ù§ß§Ñ§é§Ñ?§ä§î§ã§ñ §Ù§ß§Ñ§é§Ö§ß§ß§ñ §Ý§à§Ô?§é§ß§à? §æ§å§ß§Ü§è?? IF?