4-3Formulas-and-Functions

Document Sample
4-3Formulas-and-Functions Powered By Docstoc
					        <sp>         :Deleted
                                                           ‫)4-3( اﻟﺼﯿﻎ واﻟﺪوال‬




Formatted: Centered,
Right-to-left
Formatted: Font: 22 pt,
Complex Script Font: 18 pt

                                ‫ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬ ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ‬
                                 http://www.al-jeel.net
                                                                         ‫)4-3-1( اﻟﺼﯿﻎ اﻟﺤﺴﺎﺑﯿﺔ واﻟﻤﻨﻄﻘﯿﺔ‬
                               ‫)4-3-1-1( اﺳﺘﺨﺪام اﻟﺼﯿﻎ اﻟﺤﺴﺎﺑﯿﺔ واﻟﻤﻨﻄﻘﯿﺔ اﻷﺳﺎﺳﯿﺔ ﻓﻲ ورﻗﺔ اﻟﻌﻤﻞ:‬
                                                                    ‫اﻟﺠﻤﻊ واﻟﻄﺮح واﻟﻀﺮب واﻟﻘﺴﻤﺔ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                             ‫• ﺿﻊ اﻟﻤﺆﺷﺮ ﻓﻲ اﻟﺨﻠﯿﺔ اﻟﺘﻲ ﺗﻮد أن ﺗﻈﮭﺮ ﻓﯿﮭﺎ اﻟﺼﯿﻐﺔ.‬           ‫إدﺧﺎل اﻟﺼﯿﻎ ﻓﻲ‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
                                                                         ‫• اﻛﺘﺐ ﻋﻼﻣﺔ اﻟﺘﺴﺎوي )=(.‬          ‫اﻟﺨﻠﯿﺔ اﻟﺨﺎﺻﺔ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                                                                                            ‫ﺑﻮرﻗﺔ اﻟﻌﻤﻞ‬
                               ‫• اﻛﺘ ﺐ اﻟﺘﻌﺒﯿ ﺮ اﻟ ﺬي ﺳ ﯿﺆدي إﻟ ﻰ ﺣ ﺼﻮﻟﻚ ﻋﻠ ﻰ اﻟﻨﺘﯿﺠ ﺔ اﻟﺘ ﻲ ﺗﺮﯾ ﺪھﺎ.‬
                                                                ‫ﯾ‬
                               ‫وﯾﻤﻜﻦ أن ﯾﻜﻮن ھﺬا اﻟﺘﻌﺒﯿﺮ ﻣﺤﺘﻮ ًﺎ ﻋﻠﻰ اﻟﻤﻌﺎﻣﻼت واﻟﻘﯿﻢ واﻟﻤﺘﻐﯿ ﺮات‬
                                                                            ‫ﺗ‬
                                           ‫واﻟﺮﻣﻮز واﻟﺘﻲ ُﻤﺜﻞ اﻹﺟﺮاءات اﻟﺤﺴﺎﺑﯿﺔ، ﻣﺜﻞ 5‪.A5+E‬‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                                                        ‫ﯾﻤﻜﻨﻚ اﺳﺘﺨﺪام اﻟﺮﻣﻮز اﻟﺘﺎﻟﯿﺔ:‬

                                                                               ‫+ ﻟﻺﺿﺎﻓﺔ‬

                                                                                 ‫- ﻟﻠﻄﺮح‬

                                                                                ‫* ﻟﻠﻀﺮب‬

                                                                                  ‫/ ﻟﻠﻘﺴﻤﺔ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                          ‫• ﻋﻨ ﺪ اﻻﻧﺘﮭ ﺎء ﻣ ﻦ ﻛﺘﺎﺑ ﺔ اﻟ ﺼﯿﻐﺔ، اﺿ ﻐﻂ ﻋﻠ ﻰ ﻣﻔﺘ ﺎح ‪ .Enter‬وﺳ ﯿﺘﻢ‬
                                                                                       ‫ﺬ‬
                                             ‫ﻋﻨﺪﺋ ٍ ﺣﺴﺎب ﻧﺘﯿﺠﺔ اﻟﺼﯿﻐﺔ وﻣﻦ ﺛﻢ ﻋﺮﺿﮭﺎ ﻓﻲ اﻟﺨﻠﯿﺔ.‬

                               ‫• ﯾﻤﻜﻨﻚ أن ﺗﻘﻮم ﺑﻌﺮض اﻟﺼﯿﻐﺔ ﻧﻔﺴﮭﺎ ﻓﻲ ﺷﺮﯾﻂ اﻟ ﺼﯿﻐﺔ أﻋﻠ ﻰ اﻟ ﺸﺎﺷﺔ‬
                                                                     ‫ﻋﻦ ﻃﺮﯾﻖ اﻟﻀﻐﻂ ﻋﻠﻰ اﻟﺨﻠﯿﺔ.‬

                               ‫• إذا ورد ﺧﻄﺄ ﻣﺎ ﻓﻲ اﻟﺼﯿﻐﺔ، ﻓﺴﺘﻈﮭﺮ ﻟﻚ رﺳﺎﻟﺔ اﻹﻋﻼم ﺑﺎﻟﺨﻄ ﺄ واﻟﺘ ﻲ‬
                                                                                    ‫ﺳﺘﺒﺪأ ﺑﻌﻼﻣﺔ #.‬
‫‪Formatted: Font: 12 pt, Not‬‬
‫:‪Bold, Complex Script Font‬‬                                            ‫ر‬
                               ‫ﻣﻠﺤﻮﻇ ﺔ: إذا ﻛﻨ ﺖ ﻏﯿ ﺮ ﻗ ﺎد ٍ ﻋﻠ ﻰ اﻛﺘ ﺸﺎف اﻟﺨﻄ ﺄ اﻟﻤﻮﺟ ﻮد ﺑﺎﻟﺪاﻟ ﺔ،‬    ‫•‬
‫‪Arial, 14 pt, Bold‬‬
‫‪Formatted: Complex Script‬‬                         ‫ﺪ‬
                               ‫ﻓﺎﺳﺘﺨﺪم ﻟﺼﻖ اﻟﺪاﻟﺔ ﻟﯿﺘﻢ اﻛﺘﺸﺎﻓﮫ واﻟﺘﻌﺎﻣﻞ ﻣﻌ ﮫ. ﺣ ﱢد اﻟﺨﻠﯿ ﺔ اﻟﻤﺤﺘﻮﯾ ﺔ‬
‫‪Font: Arial‬‬
                               ‫ﻋﻠ ﻰ اﻟﺨﻄ ﺄ واﺿ ﻐﻂ ﻋﻠ ﻰ أﯾﻘﻮﻧ ﺔ ﻟ ﺼﻖ اﻟﺪاﻟ ﺔ اﻟﻤﻮﺟ ﻮدة ﻋﻠ ﻰ ﺷ ﺮﯾﻂ‬
‫)‪Formatted: Font: (Default‬‬
‫:‪Arial, Complex Script Font‬‬
‫‪Arial‬‬
                                                                   ‫اﻟﺼﯿﻎ أو ﺷﺮﯾﻂ اﻷدوات ﻗﯿﺎﺳﻲ.‬
‫,‪Formatted: Centered‬‬
‫‪Right-to-left‬‬
‫,‪Formatted: Font: 22 pt‬‬
‫‪Complex Script Font: 18 pt‬‬

                                                         ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ ‪‬ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬
                                                          ‫‪http://www.al-jeel.net‬‬
Formatted: Font: Not Bold,
Complex Script Font: Not Bold         ‫)4-3-1-2( اﻟﺘﻌﺮف ﻋﻠﻰ رﺳﺎﺋﻞ اﻹﻋﻼم ﺑﺎﻟﺨﻄﺄ اﻟﻘﯿﺎﺳﯿﺔ )اﻟﻌﺎﻣﺔ( اﻟﻤﺘﻌﻠﻘﺔ‬
             ‫: اﻟﻤﺮﺗﺒﻄﺔ‬Deleted                                                                     ‫ﺑﺎﻟﺼﯿﻎ‬
Formatted: Line spacing: 1.5
lines                                                  ‫ﻋ‬
                                          -:‫ﺗﻮﺿﺢ اﻟﻘﺎﺋﻤﺔ اﻟﺘﺎﻟﯿﺔ أﻛﺜﺮ رﺳﺎﺋﻞ اﻹﻋﻼم ﺑﺎﻟﺨﻄﺄ ﺷﯿﻮ ًﺎ ﻓﻲ اﻟﻈﮭﻮر‬   ‫رﺳﺎﺋﻞ اﻹﻋﻼم‬
Formatted: Complex Script
Font: Arial                                                                                                 ‫ﺑﺎﻟﺨﻄﺄ اﻟﻤﺘﻌﻠﻘﺔ‬
Formatted: Line spacing: 1.5
                                                                                    
lines                                                                                                   ‫ﺑﺎﻟﺼﯿﻎ‬
Formatted: Complex Script
Font: Arial                                                                           ‫ﺗ‬
                                     ‫ُ ﺸﯿﺮ ھ ﺬه اﻟﺮﺳ ﺎﻟﺔ إﻟ ﻰ أﻧ ﮫ ﻻ ﯾﻤﻜ ﻦ أن ﯾ ﺘﻢ ﻋ ﺮض‬           #####
Formatted: Line spacing:
Multiple 1.2 li                          ‫ﺮ‬                   ‫ة‬
                                     ‫ﻣﺤﺘﻮﯾ ﺎت اﻟﺨﻠﯿ ﺔ ﺑ ﺼﻮر ٍ ﺻ ﺤﯿﺤﺔ، وذﻟ ﻚ ﻧﻈ ًا ﻷن‬
    ‫: اﻟﻌﻤﻮد ﺻﻐﯿﺮ ﻣﻦ ﺣﯿﺚ‬Deleted                                    .‫ﺣﺠﻢ اﻟﻌﻤﻮد ﺻﻐﯿﺮ‬
                           . ‫اﻟﺤﺠﻢ‬
Formatted: Complex Script            .‫ُﺸﯿﺮ ھﺬه اﻟﺮﺳﺎﻟﺔ إﻟﻰ أن ﻣﺮﺟﻊ اﻟﺨﻠﯿ ﺔ ﻏﯿ ﺮ ﺻ ﺤﯿﺢ‬‫ﺗ‬             #REF!
Font: Arial
Formatted: Line spacing:                                                   ‫ة‬
                                     ‫وﯾ ﺘﻢ ﻋ ﺎد ً ﻋ ﺮض ﺗﻠ ﻚ اﻟﺮﺳ ﺎﻟﺔ ﺣ ﺎل ﻗﯿﺎﻣ ﻚ ﺑﺤ ﺬف‬
Multiple 1.2 li
                                            .‫ﺧﻼﯾﺎ ﻣﺪرﺟﺔ ﺿﻤﻦ اﻟﺼﯿﻐﺔ اﻟﺘﻲ ﺗﻢ ﻛﺘﺎﺑﺘﮭﺎ‬
Formatted: Complex Script
Font: Arial                                                                             ‫ﺗ‬
                                     ‫ُ ﺸﯿﺮ ھ ﺬه اﻟﺮﺳ ﺎﻟﺔ إﻟ ﻰ أن ﺑﺮﻧ ﺎﻣﺞ إﻛ ﺴﯿﻞ ﻻ ﯾ ﺴﺘﻄﯿﻊ‬       #NAME?
Formatted: Line spacing:
Multiple 1.2 li                                .‫اﻟﺘﻌﺮف ﻋﻠﻰ اﻟﻨﺺ اﻟﻤﻜﺘﻮب ﻓﻲ اﻟﺼﯿﻐﺔ‬




Formatted: Centered,
Right-to-left
Formatted: Font: 22 pt,
Complex Script Font: 18 pt

                                                                 ‫ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬ ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ‬
                                                                  http://www.al-jeel.net
Formatted: Font: (Default)
Arial, Complex Script Font:          ‫ﺪ‬                                                            ‫اﺳﺘﺨﺪام ﻧﻈﺎم‬
                                ‫ﯾﻤﻜﻨﻚ أن ﺗﻘﻮم ﺑﺎﺳﺘﺨﺪام ﻧﻈﺎم اﻟﺘﻌﻠﯿﻤ ﺎت اﻟﻔﻮرﯾ ﺔ ﻟﻠﺤ ﺼﻮل ﻋﻠ ﻰ ﻣﺰﯾ ٍ ﻣ ﻦ‬
Arial
Formatted: Complex Script                   ‫ﻀ‬                                                   ‫اﻟﺘﻌﻠﯿﻤﺎت اﻟﻔﻮرﯾﺔ‬
                                ‫اﻟﻤﻌﻠﻮﻣ ﺎت ﻋ ﻦ اﻷﺧﻄ ﺎء اﻟﻤﻮﺟ ﻮدة ﻓ ﻲ اﻟ ﺼﯿﻎ واﻟﻮﻗ ﻮف أﯾ ًﺎ ﻋﻠ ﻰ ﻣﻔ ﺎد‬
Font: Arial
Formatted: Line spacing:
                                                                                 .‫رﺳﺎﺋﻞ اﻹﻋﻼم ﺑﺎﻟﺨﻄﺄ‬‫ﻣﻊ رﺳﺎﺋﻞ‬
Multiple 1.2 li
                                                     .Microsoft Excel ‫• اﺿﻐﻂ ﻋﻠﻰ أﯾﻘﻮﻧﺔ ﺗﻌﻠﯿﻤﺎت‬  ‫اﻹﻋﻼم ﺑﺎﻟﺨﻄﺄ‬
Formatted: Line spacing:
Multiple 1.2 li
Formatted: Line spacing:
                                                            ‫، أدﺧ ﻞ‬Office ‫• ﺣ ﺎل ﻋ ﺮض ﻣ ﺴﺎﻋﺪ‬
Multiple 1.2 li
                                                            ‫اﻟﻜﻠﻤ ﺔ "ﺧﻄ ﺄ" ﺛ ﻢ اﺿ ﻐﻂ ﺑﻌ ﺪ ذﻟ ﻚ ﻋﻠ ﻰ‬
Formatted: Line spacing:
Multiple 1.2 li                                                                          .‫زر ﺑﺤﺚ‬
                   ‫: ا‬Deleted
                 ‫: دﺧﻞ‬Deleted
                                                            ‫• ﻗﻢ ﺑﺘﺤﺪﯾﺪ اﺳﺘﻜ ﺸﺎف أﺧﻄ ﺎء اﻟ ﺼﯿﻎ وﻗ ﯿﻢ‬
                                                                                 .‫اﻟﺨﻄﺄ وإﺻﻼﺣﮭﺎ‬
Formatted: Line spacing:
Multiple 1.2 li




Formatted: Line spacing:
Multiple 1.2 li




Formatted: Centered,
Right-to-left
Formatted: Font: 22 pt,
Complex Script Font: 18 pt

                                                          ‫ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬ ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ‬
                                                           http://www.al-jeel.net
‫)‪Formatted: Font: (Default‬‬
‫:‪Arial, Complex Script Font‬‬
‫‪Arial‬‬                             ‫ﺳ ﯿﺘﻢ ﺑﻌ ﺪ ذﻟ ﻚ ﻋ ﺮض اﻟ ﺸﺎﺷﺔ اﻟﺘﺎﻟﯿ ﺔ، ﺣﯿ ﺚ ﯾﻤﻜﻨ ﻚ ﻣ ﻦ ﺧﻼﻟﮭ ﺎ اﻟﺤ ﺼﻮل‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
                                                           ‫ع‬
                                  ‫ﻋﻠ ﻰ اﻟﻤﻌﻠﻮﻣ ﺎت اﻟﺘﻔ ﺼﯿﻠﯿﺔ اﻟﻤﺘﻌﻠﻘ ﺔ ﺑﻜ ﻞ ﻧ ﻮ ٍ ﻣ ﻦ أﻧ ﻮاع رﺳ ﺎﺋﻞ اﻹﻋ ﻼم‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                                                           ‫ﺑﺎﻟﺨﻄﺄ اﻟﺘﻲ ﯾﻤﻜﻦ أن ﺗﻈﮭﺮ ﻟﻚ.‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬




                    ‫‪¶ :Deleted‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial, (Complex) Arabic‬‬
‫‪Saudi Arabia‬‬




                                   ‫)4-3-1-3( اﺳﺘﺨﺪام أداة اﻟﺘﻌﺒﺌﺔ اﻟﺘﻠﻘﺎﺋﯿﺔ ﻟﻨﺴﺦ أو إدراج اﻟﻘﯿﻢ اﻟﻤﺘﺰاﯾﺪة ﻓﻲ‬
                                                                                                       ‫اﻟﺨﻼﯾﺎ‬
                  ‫‪ :Deleted‬ادﺧﻞ‬
‫:‪Formatted: Line spacing‬‬                          ‫• أدﺧﻞ اﻟﻘﯿﻤﺔ اﻷوﻟﻰ ﻟﻠﺴﻠﺴﻠﺔ اﻟﺘﻲ ﺗﺮﯾﺪ أن ﺗﻘﻮم ﺑﺈﻧﺸﺎﺋﮭﺎ.‬       ‫اﺳﺘﺨﺪام ﻣﯿﺰة‬
‫‪Multiple 1.2 li‬‬
‫‪Formatted: Complex Script‬‬                                            ‫"اﻟﺘﻌﺒﺌﺔ اﻟﺘﻠﻘﺎﺋﯿﺔ" • أدﺧﻞ اﻟﻘﯿﻤﺔ اﻟﺜﺎﻧﯿﺔ ﻓﻲ اﻟﺨﻠﯿﺔ اﻟﺘﺎﻟﯿﺔ.‬
‫‪Font: Arial‬‬
‫:‪Formatted: Line spacing‬‬                                                                              ‫ﻠ‬
                                                                                 ‫• ﻇﱢﻞ اﻟﺨﻠﯿﺘﯿﻦ اﻟﺴﺎﺑﻘﺘﯿﻦ.‬
‫‪Multiple 1.2 li‬‬
                  ‫‪ :Deleted‬ادﺧﻞ‬                                                                    ‫ﺮ‬
                                   ‫• ﺣ ﱢك ﻣﺆﺷﺮ اﻟﻔ ﺄرة إﻟ ﻰ ﻣﻘ ﺒﺾ اﻟﺘﻌﺒﺌ ﺔ ـ وھ ﻮ اﻟﻤﺮﺑ ﻊ اﻷﺳ ﻮد ﺻ ﻐﯿﺮ‬
                                      ‫ﺪ‬
                                   ‫اﻟﺤﺠﻢ اﻟﻤﻮﺟﻮد ﻓ ﻲ اﻷﺳ ﻔﻞ ﻋﻠ ﻰ اﻟﺠﺎﻧ ﺐ اﻷﯾﻤ ﻦ ﻣ ﻦ اﻟﻤﻨﻄﻘ ﺔ اﻟﻤﺤ ﱠدة.‬
                                   ‫ﺣﺎل وﺿﻊ ﻣﺆﺷﺮ اﻟﻔﺄرة ﻋﻠﻰ ﻣﻘﺒﺾ اﻟﺘﻌﺒﺌﺔ، ﺳ ﯿﺘﻐﯿﺮ ﺷ ﻜﻠﮫ ﻣ ﻦ ﻋﻼﻣ ﺔ‬
‫:‪Formatted: Line spacing‬‬           ‫اﻟﺠﻤ ﻊ اﻟﻜﺒﯿ ﺮة ذات اﻟﻠ ﻮن اﻷﺑ ﯿﺾ إﻟ ﻰ ﻋﻼﻣ ﺔ اﻟﺠﻤ ﻊ اﻟ ﺼﻐﯿﺮة ذات‬
‫‪Multiple 1.2 li‬‬
                                                                                          ‫اﻟﻠﻮن اﻷﺳﻮد.‬
                  ‫‪ :Deleted‬ﻓﻮق‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
                                   ‫• اﺿﻐﻂ ﻋﻠﻰ ﻣﻘﺒﺾ اﻟﺘﻌﺒﺌﺔ واﺳﺘﻤﺮ ﻓﻲ اﻟﻀﻐﻂ ﻋﻠﻰ اﻟﻔ ﺄرة ﻣ ﻊ اﻟ ﺴﺤﺐ‬
‫:‪Formatted: Line spacing‬‬              ‫ﻋﺒﺮ اﻟﺨﻼﯾﺎ اﻟﺘﻲ ﺗﺮﯾﺪ أن ﯾﺘﻢ ﻓﯿﮭﺎ إدراج اﻟﻘﯿﻢ اﻟﻤﺘﺒﻘﯿﺔ ﻣﻦ اﻟﺴﻠﺴﻠﺔ.‬
‫‪Multiple 1.2 li‬‬
‫,‪Formatted: Centered‬‬               ‫• ﻋﻨﺪﻣﺎ ﺗﺮﻓﻊ ﯾﺪك ﻣ ﻦ ﻋﻠ ﻰ زر اﻟﻔ ﺄرة، ﺳ ﺘﻼﺣﻆ أن اﻟﻤ ﺴﺎﺣﺔ اﻟﺘ ﻲ ﻗﻤ ﺖ‬
‫‪Right-to-left‬‬
                                                      ‫ﺑﺴﺤﺐ اﻟﻔﺄرة ﻋﻠﯿﮭﺎ ﻗﺪ ﺗﻢ وﺿﻊ اﻟﻘﯿﻢ اﻟﻤﺘﺰاﯾﺪة ﻓﯿﮭﺎ.‬
‫,‪Formatted: Font: 22 pt‬‬
‫‪Complex Script Font: 18 pt‬‬

                                                             ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ ‪‬ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬
                                                              ‫‪http://www.al-jeel.net‬‬
Formatted: Font: (Default)
Arial, Complex Script Font:
Arial                              ‫ﯾﻤﻜﻨ ﻚ اﺳ ﺘﺨﺪام ﻣﯿ ﺰة اﻟﺘﻌﺒﺌ ﺔ اﻟﺘﻠﻘﺎﺋﯿ ﺔ ﻟﻜﺘﺎﺑ ﺔ اﻷرﻗ ﺎم اﻟﻤﺴﻠ ﺴﻠﺔ أو أﯾ ﺎم‬
Formatted: Line spacing: 1.5
lines
                                                                                     .‫اﻷﺳﺒﻮع أو ﺷﮭﻮر اﻟﺴﻨﺔ‬
Formatted: Complex Script
Font: Arial
Formatted: Line spacing: 1.5
                                     ‫ﺑﻌﺪ اﺳﺘﺨﺪام ﻣﯿﺰة اﻟﺘﻌﺒﺌﺔ اﻟﺘﻠﻘﺎﺋﯿﺔ‬       ‫ﻗﺒﻞ اﺳﺘﺨﺪام ﻣﯿﺰة اﻟﺘﻌﺒﺌﺔ اﻟﺘﻠﻘﺎﺋﯿﺔ‬
lines




                  ‫: وﺣ ﱢد‬Deleted
                   ‫ﺪ‬
Formatted: Font: (Default)
Arial, Complex Script Font:
                                   ‫• اﺿ ﻐﻂ ﻋﻠ ﻰ ﻗﺎﺋﻤ ﺔ أدوات اﻟﻤﻨ ﺴﺪﻟﺔ واﺧﺘ ﺮ أﻣ ﺮ ﺧﯿ ﺎرات. وﻋﻨ ﺪﻣﺎ ﯾ ﺘﻢ‬            ‫ﻋﺮض ﺧﯿﺎرات‬
Arial
Formatted: Line spacing: 1.5
lines
                                   ‫ﻋﺮض ﻣﺮﺑﻊ اﻟﺤﻮار اﻟﺬي ﯾﺤﻤﻞ اﻻﺳﻢ ﻧﻔﺴﮫ، ﻗ ﻢ ﺑﺘﺤﺪﯾ ﺪ ﻋﻼﻣ ﺔ ﺗﺒﻮﯾ ﺐ‬                   "‫"اﻟﺘﻌﺒﺌﺔ اﻟﺘﻠﻘﺎﺋﯿﺔ‬
Formatted: Complex Script
Font: Arial
                                           .‫ﻗﻮاﺋﻢ ﻣﺨﺼﺼﺔ، ﻓﯿﻈﮭﺮ أﻣﺎﻣﻚ ﻋﺪد ﻣﻦ اﻟﻘﻮاﺋﻢ اﻟﻤﻌﺪة ﻣﻦ ﻗﺒﻞ‬                       ‫اﻟﻤﺘﺎﺣﺔ‬
Formatted: Complex Script
Font: Arial                        ‫ﻣﻠﺤﻮﻇ ﺔ: ﯾﻤﻜﻨ ﻚ أن ﺗﻘ ﻮم ﺑﺈﺿ ﺎﻓﺔ اﻟﻘ ﻮاﺋﻢ اﻟﻤﺨﺼ ﺼﺔ اﻟﺠﺪﯾ ﺪة ﺑﺎﺳ ﺘﺨﺪام‬
Formatted: Line spacing: 1.5
lines                                                                            .‫ﻣﺮﺑﻊ اﻟﺤﻮار اﻟﻤﻮﺿﺢ أدﻧﺎه‬
Formatted: Font: (Default)
Arial, Complex Script Font:
Arial
Formatted: Font: 12 pt, Not
Bold, Complex Script Font:
Arial, 14 pt, Bold
Formatted: Font: 12 pt,
Complex Script Font: Arial, 14
pt
Formatted: Complex Script
Font: Arial
Formatted: Line spacing: 1.5
lines
                    ¶ :Deleted
                             ¶
Formatted: Complex Script
Font: Arial
Formatted: Centered,
Right-to-left
Formatted: Font: 22 pt,
Complex Script Font: 18 pt

                                                               ‫ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬ ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ‬
                                                                http://www.al-jeel.net
‫,‪Formatted: Font: Not Bold‬‬
‫‪Complex Script Font: Not Bold‬‬         ‫)4-3-1-4( اﻟﺘﻌﺮف ﻋﻠﻰ ﻣﺮاﺟﻊ اﻟﺨﻼﯾ ﺎ اﻟﻨ ﺴﺒﯿﺔ واﺳ ﺘﺨﺪاﻣﮭﺎ ﻓ ﻲ اﻟ ﺼﯿﻎ‬
                                                                                                  ‫أو اﻟﺪوال‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬                                                                       ‫ة‬
                                     ‫ﯾﻘ ﻮم ﺑﺮﻧ ﺎﻣﺞ إﻛ ﺴﯿﻞ ﺑ ﺼﻮر ٍ اﻓﺘﺮاﺿ ﯿﺔ ﺑﺎﺳ ﺘﺨﺪام اﻟﻤﺮاﺟ ﻊ اﻟﻨ ﺴﺒﯿﺔ. وھ ﺬا‬      ‫اﻟﺘﻌﺮف ﻋﻠﻰ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                                ‫ﯾﻌﻨ ﻰ أﻧ ﻚ ﻋﻨ ﺪﻣﺎ ﺗﻘ ﻮم ﺑﺎﺳ ﺘﺨﺪام إﺣ ﺪى اﻟ ﺼﯿﻎ، ﻓ ﺈن ﻣﻜﻮﻧ ﺎت )ﻋﻮاﻣ ﻞ(‬         ‫اﻟﻤﺮاﺟﻊ اﻟﻨﺴﺒﯿﺔ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                                             ‫ﻧ‬                                                 ‫ﺗ ﺪ‬
                                     ‫اﻟﺼﯿﻐﺔ ُﺤ ﱢد ﺑﺎﻟﻨﺴﺒﺔ ﻟﻠﺨﻠﯿﺔ اﻟﺘﻲ ﺗﺤﺘ ﻮي ﻋﻠ ﻰ اﻟ ﺼﯿﻐﺔ. وإﻣﻌﺎ ً ﺎ ﻓ ﻲ ﺗﯿ ﺴﯿﺮ‬
                       ‫‪:Deleted‬‬
                                                                                    ‫اﻷﻣﻮر، إﻟﯿﻚ اﻟﻤﺜﺎل اﻟﺘﺎﻟﻲ:‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
‫)‪Formatted: Font: (Default‬‬
‫:‪Arial, Complex Script Font‬‬
‫‪Arial‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬




                                                                                ‫ﺪ‬
                                                               ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 1‪ E‬ﻋﻠﻰ ﻣﻌ ﱠل ﺿﺮﯾﺒﺔ اﻟﻤﺒﯿﻌﺎت.‬

                                                                    ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 6‪ B‬ﻋﻠﻰ ﺳﻌﺮ ﻃﺎﺑﻌﺔ اﻟﻠﯿﺰر.‬

                                                           ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 6‪ C‬ﻋﻠﻰ اﻟﺼﯿﻐﺔ اﻟﺘﺎﻟﯿﺔ %1‪=B6*E‬‬

                                                                ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 6‪ D‬ﻋﻠﻰ ھﺬه اﻟﺼﯿﻐﺔ 6‪B6+C‬‬

                                     ‫إذا ﻗﻤﺖ ﺑﺎﺳﺘﺨﺪام ﺗﻘﻨﯿ ﺔ اﻟ ﺴﺤﺐ واﻹﻓ ﻼت )ﻛﻤ ﺎ ھ ﻮ ﻣﻮﺿ ﺢ أدﻧ ﺎه( ﻟﺘﻈﻠﯿ ﻞ‬
                                     ‫اﻟﺨﻠﯿﺘ ﯿﻦ 6‪ C‬و6‪ D‬وﻣ ﺪ اﻟ ﺼﯿﻎ إﻟ ﻰ أﺳ ﻔﻞ اﻟ ﺼﻔﺤﺔ، ﻓﻠ ﻦ ﺗﺤ ﺼﻞ ﻋﻠ ﻰ‬
                                                                                            ‫اﻟﻨﺘﯿﺠﺔ اﻟﺘﻲ ﺗﺒﻐﯿﮭﺎ.‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                                ‫• وﻟﺘﻨﻔﯿ ﺬ ذﻟ ﻚ اﺿ ﻐﻂ ﻋﻠ ﻰ اﻟﺨﻠﯿ ﺔ 6‪ .C‬وﻓ ﻲ أﺛﻨ ﺎء اﻟ ﻀﻐﻂ ﻋﻠ ﻰ ﻣﻔﺘ ﺎح‬
                                     ‫‪ ،Ctrl‬اﺿ ﻐﻂ ﻋﻠ ﻰ اﻟﺨﻠﯿ ﺔ 6‪ .D‬ارﻓ ﻊ ﯾ ﺪك ﻣ ﻦ ﻋﻠ ﻰ ﻣﻔﺘ ﺎح ‪Ctrl‬‬

                                                               ‫وﺳﺘﻼﺣﻆ أﻧﮫ ﻣﺎ ﺗﺰال ھﺎﺗﺎن اﻟﺨﻠﯿﺘﺎن ﻣﻈﻠﻠﺘﯿﻦ.‬

                                                                                                   ‫ﺮ‬
                                     ‫• ﺣ ﱢك ﻣﺆﺷﺮ اﻟﻔﺄرة ﺣﺘﻰ ﺗﺼﻞ إﻟﻰ ﻣﻘ ﺒﺾ اﻟﺘﻌﺒﺌ ﺔ ـ وھ ﻮ اﻟﻤﺮﺑ ﻊ اﻷﺳ ﻮد‬
                                              ‫ﺪ‬
                                            ‫ﺻﻐﯿﺮ اﻟﺤﺠﻢ اﻟﻤﻮﺟﻮد ﻓﻲ أﺳﻔﻞ اﻟﺮﻛﻦ اﻷﯾﻤﻦ ﻣﻦ اﻟﻨﻄﺎق اﻟﻤﺤ ﱢد.‬
  ‫‪ :Deleted‬ارﻓﻊ ﯾﺪك ﺑﻌﺪ ذﻟﻚ ﻣﻦ ﻋﻠﻰ‬
                                     ‫• اﺿ ﻐﻂ ﻋﻠ ﻰ زر اﻟﻔ ﺄرة واﺳ ﺤﺒﮫ ﻋﻠ ﻰ اﺛﻨ ﯿﻦ ﻣ ﻦ اﻟ ﺼﻔﻮف، ﺛ ﻢ ﺣ ﺮر زر‬
                                                                                                      ‫اﻟﻔﺄرة.‬
‫,‪Formatted: Centered‬‬
‫‪Right-to-left‬‬
‫,‪Formatted: Font: 22 pt‬‬
‫‪Complex Script Font: 18 pt‬‬

                                                                 ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ ‪‬ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬
                                                                  ‫‪http://www.al-jeel.net‬‬
                ‫‪<sp> :Deleted‬‬
‫)‪Formatted: Font: (Default‬‬                            ‫ﺿ‬
                                 ‫ﺳﺘﻜﻮن اﻟﻨﺘﯿﺠﺔ اﻟﺘﻲ ﺳﺘﺤﺼﻞ ﻋﻠﯿﮭﺎ ﻋﻠ ﻰ اﻟﻨﺤ ﻮ اﻟﻤﻮ ﱠ ﺢ ﻓ ﻲ اﻟ ﺸﻜﻞ أدﻧ ﺎه.‬
‫:‪Arial, Complex Script Font‬‬
‫‪Arial‬‬
‫5.1 :‪Formatted: Line spacing‬‬     ‫وﻋﻨﺪ اﻃﻼﻋﻚ ﻋﻠ ﻰ ھ ﺬا اﻟ ﺸﻜﻞ، ﺳ ﺘﻼﺣﻆ أﻧ ﮫ ﻟ ﻢ ﯾ ﺘﻢ ﺣ ﺴﺎب ﻗﯿﻤ ﺔ ﺿ ﺮﯾﺒﺔ‬
‫‪lines‬‬
‫‪Formatted: Complex Script‬‬                                               ‫اﻟﻤﺒﯿﻌﺎت ﻓﻲ اﻟﺨﻠﯿﺘﯿﻦ 7‪ C‬و8‪.C‬‬
‫‪Font: Arial‬‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial, (Complex) Arabic‬‬
‫‪Saudi Arabia‬‬
                                 ‫اﺿﻐﻂ ﻋﻠﻰ اﻟﺨﻠﯿﺔ 7‪ C‬ﻟﻠﺘﻌ ﺮف ﻋﻠ ﻰ اﻟ ﺴﺒﺐ اﻟ ﺬي ﺣ ﺎل دون ﺗﻨﻔﯿ ﺬ اﻟﻤﮭﻤ ﺔ‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
                                 ‫ﻋﻠ ﻰ أﻛﻤ ﻞ وﺟ ﮫ. ﻻﺣ ﻆ أن ھ ﺬه اﻟﺨﻠﯿ ﺔ ﻣﺤﺘﻮﯾ ﺔ ﻋﻠ ﻰ اﻟ ﺼﯿﻐﺔ اﻟﺘﺎﻟﯿ ﺔ:‬
                                                                                          ‫%2‪=B7*E‬‬
‫6 :‪Formatted: Space After‬‬
‫‪pt, Line spacing: 1.5 lines‬‬      ‫ھﻞ ﺗﺴﺘﻄﯿﻊ اﻵن ﺗﻔﺴﯿﺮاﻟﺴﺒﺐ اﻟﺤﻘﯿﻘ ﻲ وراء ﻋ ﺪم ﺗﻨﻔﯿ ﺬ اﻟﻤﮭﻤ ﺔ ؟ إن اﻟﺨﻄ ﺄ‬
                                                                ‫ﺗ‬
                                 ‫ھﻨﺎ ﯾﻜﻤﻦ ﻓﻲ أن اﻟﺼﯿﻐﺔ اﻟﻤﻜﺘﻮﺑﺔ أﻋﻼه ُﺸﯿﺮ إﻟﻰ اﻟﺨﻠﯿ ﺔ 2‪ E‬ـ وھ ﻲ ﺧﻠﯿ ﺔ‬
                                                                ‫ﺗ‬       ‫ﻻ‬
                                 ‫ﻏﯿﺮ ﻣﺤﺘﻮﯾﺔ ﻋﻠﻰ أﯾﺔ ﻗﯿﻤﺔ ـ ﺑﺪ ً ﻣﻦ أن ُﺸﯿﺮ إﻟﻰ ﺧﻠﯿ ﺔ 1‪ E‬اﻟﻤﺤﺘﻮﯾ ﺔ ﻋﻠ ﻰ‬
                    ‫‪¶ :Deleted‬‬
‫‪Formatted: Complex Script‬‬                                                        ‫ﻧﺴﺒﺔ ﺿﺮﯾﺒﺔ اﻟﻤﺒﯿﻌﺎت.‬
‫‪Font: Arial‬‬




                                 ‫)4-3-1-5( اﻟﺘﻌﺮف ﻋﻠﻰ ﻣﺮاﺟﻊ اﻟﺨﻼﯾﺎ اﻟﻤﻄﻠﻘ ﺔ واﺳ ﺘﺨﺪاﻣﮭﺎ ﻓ ﻲ اﻟ ﺼﯿﻎ‬
                                                                                             ‫واﻟﺪوال‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬                                       ‫ﺮ‬
                                 ‫ﻟﻢ ﺗﺤﺼﻞ ﻓﻲ اﻟﻤﺜﺎل اﻟﺴﺎﺑﻖ ﻋﻠﻰ اﻟﻨﺘﯿﺠﺔ اﻟﻤﻄﻠﻮﺑﺔ ﻧﻈ ًا ﻻﺳﺘﺨﺪام اﻟﻤﺮاﺟﻊ‬       ‫اﻟﺘﻌﺮف ﻋﻠﻰ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                            ‫اﻟﻨﺴﺒﯿﺔ. ﻓﻘﺪ ﺗﻢ إدراج ﻧﺴﺒﺔ ﺿﺮﯾﺒﺔ اﻟﻤﺒﯿﻌﺎت ﻓﻲ أﺣﺪ اﻟﺨﻼﯾﺎ وﻋﻨﺪﻣﺎ ﺗﻢ‬        ‫اﻟﻤﺮاﺟﻊ اﻟﻤﻄﻠﻘﺔ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                            ‫اﻹﺷﺎرة إﻟﻰ ھﺬه اﻟﺨﻠﯿﺔ ﺑﺎﺳﺘﺨﺪام اﻟﻤﺮﺟﻊ اﻟﻨﺴﺒﻲ ﻓﻲ أﺛﻨﺎء ﺳﺤﺐ اﻟﻘﯿﻢ‬
                                 ‫وإﻓﻼﺗﮭﺎ، ﻓﺈﻧﮫ ﻟﻢ ﯾﺘﻢ ﺣﺴﺎب ﺿﺮﯾﺒﺔ اﻟﻤﺒﯿﻌﺎت ﻛﻤﺎ ﻛﻨﺎ ﻧﺮﯾﺪ. وﻣﻦ ﺛﻢ، ﯾﻨﺒﻐﻲ‬
                                               ‫اﺳﺘﺨﺪام اﻟﻤﺮاﺟﻊ اﻟﻤﻄﻠﻘﺔ ﻛﻤﺎ ھﻮ ﻣﻮﺿﺢ ﻓﻲ اﻟﻤﺜﺎل اﻟﺘﺎﻟﻲ:‬
‫)‪Formatted: Font: (Default‬‬
‫:‪Arial, Complex Script Font‬‬
‫‪Arial‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬




‫,‪Formatted: Centered‬‬
‫‪Right-to-left‬‬
‫,‪Formatted: Font: 22 pt‬‬
‫‪Complex Script Font: 18 pt‬‬

                                                           ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ ‪‬ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬
                                                            ‫‪http://www.al-jeel.net‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬                                                   ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 1‪ E‬ﻋﻠﻰ ﻧﺴﺒﺔ ﺿﺮﯾﺒﺔ اﻟﻤﺒﯿﻌﺎت.‬
                                                                  ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 6‪ B‬ﻋﻠﻰ ﺳﻌﺮ ﻃﺎﺑﻌﺔ اﻟﻠﯿﺰر.‬
                                                     ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 6‪ C‬ﻋﻠﻰ اﻟﺼﯿﻐﺔ اﻟﺘﺎﻟﯿﺔ %1$‪=B6*$E‬‬
                                                             ‫ﺗﺤﺘﻮي اﻟﺨﻠﯿﺔ 6‪ D‬ﻋﻠﻰ ھﺬه اﻟﺼﯿﻐﺔ 6‪=B6+C‬‬
                                                                                     ‫ﻲ‬
                                   ‫إذا ﺗ ﻢ اﺳ ﺘﺨﺪام ﺗﻘﻨﯿﺘ ّ اﻟ ﺴﺤﺐ واﻹﻓ ﻼت ﻟﺘﻈﻠﯿ ﻞ اﻟﺨﻠﯿﺘ ﯿﻦ 6‪ C‬و6‪ D‬وﻣ ﺪ‬
                                   ‫اﻟﺼﯿﻐﺔ أﺳﻔﻞ اﻟﺼﻔﺤﺔ، ﻓﺴﯿﺘﻢ ﺣﺴﺎب ﻗﯿﻤﺔ ﺿﺮﯾﺒﺔ اﻟﻤﺒﯿﻌﺎت ﻟﯿﺘﻢ ﺑ ﺬﻟﻚ ﺗﻨﻔﯿ ﺬ‬
                                                                                   ‫اﻟﻌﻤﻠﯿﺔ ﻋﻠﻰ أﻛﻤﻞ وﺟﮫ.‬
                                   ‫• اﺿ ﻐﻂ ﻋﻠ ﻰ اﻟﺨﻠﯿ ﺔ 6‪ .C‬وﻓ ﻲ أﺛﻨ ﺎء اﻟ ﻀﻐﻂ ﻋﻠ ﻰ ﻣﻔﺘ ﺎح ‪ ،Ctrl‬اﺿ ﻐﻂ‬
                                   ‫ﻋﻠﻰ اﻟﺨﻠﯿﺔ 6‪ .D‬ارﻓ ﻊ ﯾ ﺪك ﻣ ﻦ ﻋﻠ ﻰ ﻣﻔﺘ ﺎح ‪ Ctrl‬وﺳ ﺘﻼﺣﻆ ﺑﻘ ﺎء ھ ﺎﺗﯿﻦ‬
                                                                                       ‫اﻟﺨﻠﯿﺘﯿﻦ ﻣﻈﻠﻠﺘﯿﻦ.‬
                                                                                                     ‫ﺮ‬
                                   ‫• ﺣ ﱢك ﻣﺆﺷﺮ اﻟﻔﺄرة ﺣﺘﻰ ﺗﺼﻞ إﻟﻰ ﻣﻘ ﺒﺾ اﻟﺘﻌﺒﺌ ﺔ ـ وھ ﻮ اﻟﻤﺮﺑ ﻊ اﻷﺳ ﻮد‬
                                             ‫ﺪ‬
                                           ‫ﺻﻐﯿﺮ اﻟﺤﺠﻢ اﻟﻤﻮﺟﻮد ﻓﻲ أﺳﻔﻞ اﻟﺮﻛﻦ اﻷﯾﻤﻦ ﻣﻦ اﻟﻨﻄﺎق اﻟﻤﺤ ﱢد.‬
                     ‫‪ :Deleted‬ا‬    ‫• اﺿ ﻐﻂ ﻋﻠ ﻰ زر اﻟﻔ ﺄرة واﺳ ﺤﺐ ﻋﻠ ﻰ اﺛﻨ ﯿﻦ ﻣ ﻦ اﻟ ﺼﻔﻮف، ﺛ ﻢ أﻓﻠ ﺖ زر‬
                                                                                                 ‫اﻟﻔﺄرة.‬
                                   ‫• ﻻﺣ ﻆ أن اﻟﻘﯿﻤ ﺔ ﻓ ﻲ اﻟﺨﻠﯿﺘ ﯿﻦ 7‪ C‬و7‪ D‬ﻗ ﺪ ﺗ ﻢ ﺣ ﺴﺎﺑﮭﺎ ﻋﻠ ﻰ اﻟﻨﺤ ﻮ‬
                                                                                              ‫اﻟﻤﻄﻠﻮب.‬
                                   ‫وﻟﺘ ﺘﻤﻜﻦ ﻣ ﻦ اﺳ ﺘﺨﺪام اﻟﻤﺮاﺟ ﻊ اﻟﻤﻄﻠﻘ ﺔ، ﯾﻨﺒﻐ ﻲ أن ﺗﻘ ﻮم ﺑ ﺈدراج رﻣ ﺰ‬
                    ‫‪ :Deleted‬ئ‬
                                                          ‫اﻟﺪوﻻر )$( ﻓﻲ اﻟﺠﺰأﯾﻦ اﻟﻤﻜﻮﻧﯿﻦ ﻟﻤﺮﺟﻊ اﻟﺨﻠﯿﺔ.‬
              ‫‪ :Deleted‬ﯾﻤﻜﻨﻚ ﻓﻰ‬    ‫ﻣﻠﺤﻮﻇﺔ: ﻓﻲ أﺛﻨﺎء إدﺧﺎل اﻟﺼﯿﻐﺔ ﻓﻲ ورﻗ ﺔ اﻟﻌﻤ ﻞ، ﯾﻤﻜﻨ ﻚ اﻟﻘﯿ ﺎم ﺑﺎﺳ ﺘﺨﺪام‬
               ‫‪ :Deleted‬ﺑﺈﺳﺘﺨﺪام‬   ‫ﻣﻔﺘ ﺎح 4‪ F‬ﻟﺘﺤﻮﯾ ﻞ ﻣﺮﺟ ﻊ اﻟﺨﻠﯿ ﺔ اﻟﻨ ﺴﺒﻲ إﻟ ﻰ ﻣﺮﺟ ﻊ ﻣﻄﻠ ﻖ. ﻓﻌﻠ ﻰ ﺳ ﺒﯿﻞ‬
‫,‪Formatted: Font: Not Bold‬‬
‫‪Complex Script Font: Arial, Bold‬‬
                                                                                                  ‫ﺪ‬
                                   ‫اﻟﻤﺜ ﺎل، ﺣ ﱢد إﺣ ﺪى اﻟﺨﻼﯾ ﺎ واﻛﺘ ﺐ 4‪ =B‬ﺛ ﻢ اﺿ ﻐﻂ ﻋﻠ ﻰ ﻣﻔﺘ ﺎح 4‪.F‬‬
‫‪Formatted: Complex Script‬‬
                                   ‫ﺔ‬                                    ‫ة‬
                                   ‫وﻋﻨﺪھﺎ، ﺳ ﯿﻘﻮم ﺑﺮﻧ ﺎﻣﺞ إﻛ ﺴﯿﻞ ﺑ ﺼﻮر ٍ ﺗﻠﻘﺎﺋﯿ ﺔ ﺑ ﺈدراج رﻣ ﺰ اﻟ ﺪوﻻر ﻧﯿﺎﺑ ً‬
‫‪Font: Arial‬‬                                                                                              ‫ﻋﻨﻚ.‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬




‫,‪Formatted: Centered‬‬
‫‪Right-to-left‬‬
‫,‪Formatted: Font: 22 pt‬‬
‫‪Complex Script Font: 18 pt‬‬

                                                               ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ ‪‬ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬
                                                                ‫‪http://www.al-jeel.net‬‬
‫:‪Formatted: Line spacing‬‬
‫‪Multiple 1.2 li‬‬
‫‪Formatted: Complex Script‬‬                                                                     ‫)4-3-2( اﺳﺘﺨﺪام اﻟﺪوال‬
‫‪Font: Arial‬‬
‫:‪Formatted: Line spacing‬‬
‫‪Multiple 1.2 li‬‬                                                                       ‫)4-3-2-1( اﺳﺘﺨﺪام داﻟﺔ اﻟﺠﻤﻊ‬
‫:‪Formatted: Line spacing‬‬
‫‪Multiple 1.2 li‬‬
                                                                                                 ‫ﺪ‬     ‫ة‬
                                                 ‫ﺟﻤﻊ اﻷرﻗﺎم ﺑﺼﻮر ٍ • ﺣ ﱢد اﻟﺨﻠﯿﺔ اﻟﺘﻲ ﺗﺮﯾﺪ أن ﯾﺘﻢ ﻓﯿﮭﺎ إدراج ﺻﯿﻐﺔ اﻟﺠﻤﻊ.‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
                               ‫• اﺿﻐﻂ ﻋﻠﻰ أﯾﻘﻮﻧﺔ ﺟﻤ ﻊ ﺗﻠﻘ ﺎﺋﻲ اﻟﻤﺪرﺟ ﺔ ﻋﻠ ﻰ ﺷ ﺮﯾﻂ اﻷدوات ﻗﯿﺎﺳ ﻲ.‬            ‫ﺗﻠﻘﺎﺋﯿﺔ‬
‫:‪Formatted: Line spacing‬‬
‫‪Multiple 1.2 li‬‬                                                                        ‫ﺬ‬
                               ‫ﺳﯿﻘﻮم ﺑﻌﺪﺋ ٍ ﺑﺮﻧﺎﻣﺞ إﻛﺴﯿﻞ ﺑﺈﻧﺸﺎء ﺻﯿﻐﺔ اﻟﺠﻤﻊ ﺑﺎﺳ ﺘﺨﺪام ﻧﻄ ﺎق اﻟﺨﻼﯾ ﺎ‬
‫:‪Formatted: Line spacing‬‬
‫‪Multiple 1.2 li‬‬
                                                                 ‫اﻟﺬي ﯾﻌﺘﻘﺪ أﻧﻚ ﺗﺮﯾﺪ أن ﺗﻘﻮم ﺑﺠﻤﻌﮫ.‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                                                      ‫ﺤ‬
                               ‫• إذا ﻛﺎن ﻧﻄﺎق اﻟﺨﻼﯾﺎ ﺻﺤﯿ ًﺎ، اﺿﻐﻂ ﻋﻠﻰ ﻣﻔﺘ ﺎح ‪ .Enter‬وإذا ﻟ ﻢ ﯾﻜ ﻦ‬
‫‪Formatted: Complex Script‬‬      ‫ھﻮ اﻟﻨﻄﺎق اﻟﺬي ﺗﺮﯾﺪ ﺟﻤﻌﮫ، ﻓﻘﻢ ﺑﺘﺤﺪﯾﺪ اﻟﻨﻄ ﺎق اﻟ ﺼﺤﯿﺢ واﺿ ﻐﻂ ﻋﻠ ﻰ‬
‫‪Font: Arial‬‬
‫5.1 :‪Formatted: Line spacing‬‬
                                                                                  ‫ﻣﻔﺘﺎح ‪.Enter‬‬
‫‪lines‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬                                            ‫اﺳﺘﺨﺪام داﻟﺔ ‪ • SUM‬ﺣ ﱢد اﻟﺨﻠﯿﺔ اﻟﺘﻲ ﺗﺮﯾﺪ أن ﯾﺘﻢ ﻓﯿﮭﺎ إدراج اﻟﺼﯿﻐﺔ.‬
                                                                                                   ‫ﺪ‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                                                                                   ‫• اﻛﺘﺐ (‪=SUM‬‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                                                                                           ‫ﻠ‬
                                                          ‫• ﻇﱢﻞ ﻧﻄﺎق اﻟﺨﻼﯾﺎ اﻟﺬي ﺗﺮﯾﺪ أن ﺗﻘﻮم ﺑﺠﻤﻌﮫ.‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                                                                       ‫• اﺿﻐﻂ ﻋﻠﻰ ﻣﻔﺘﺎح ‪.Enter‬‬
‫‪Formatted: Complex Script‬‬
‫‪Font: Arial‬‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                                      ‫‪ ‬‬                              ‫‪ ‬‬   ‫اﻟﺪوال ﺷﺎﺋﻌﺔ‬
‫‪Formatted: Complex Script‬‬
                               ‫ﯾﺘﻢ اﺳﺘﺨﺪاﻣﮭﺎ ﻟﺤ ﺴﺎب اﻟﻮﺳ ﻂ اﻟﺤ ﺴﺎﺑﻲ ﻟﻘ ﯿﻢ اﻷرﻗ ﺎم ﻓ ﻲ ﻧﻄ ﺎق‬       ‫داﻟﺔ‬         ‫اﻻﺳﺘﺨﺪام‬
‫‪Font: Arial‬‬
‫5.1 :‪Formatted: Line spacing‬‬                         ‫‪ AVERAGE‬اﻟﺨﻼﯾﺎ اﻟﻤﺤﺪدة ﻓﻲ اﻟﺼﯿﻐﺔ ) اﻟﻤﺮﺟﻊ(.‬
‫‪lines‬‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬
                                  ‫ﯾﺘﻢ اﺳﺘﺨﺪاﻣﮭﺎ ﻟﺤﺴﺎب ﻋﺪد اﻷﻋﻤﺪة اﻟﻤﺪرﺟﺔ داﺧﻞ اﻟﻤﺮﺟﻊ.‬             ‫داﻟﺔ‬
‫‪Formatted: Complex Script‬‬                                                                     ‫‪COLUMNS‬‬
‫‪Font: Arial‬‬
‫5.1 :‪Formatted: Line spacing‬‬   ‫ﯾﺘﻢ اﺳﺘﺨﺪاﻣﮭﺎ ﻟﺤﺴﺎب ﻋﺪد اﻷرﻗ ﺎم اﻟﻤﺪرﺟ ﺔ ﻓ ﻲ ﻧﻄ ﺎق اﻟﺨﻼﯾ ﺎ‬         ‫داﻟﺔ‬
‫‪lines‬‬
‫5.1 :‪Formatted: Line spacing‬‬                                                        ‫ّ‬
                                                                                    ‫ﺪ‬
                                                                       ‫اﻟﻤﺤ ﱠدة ﻓﻲ اﻟﺼﯿﻐﺔ.‬      ‫‪COUNT‬‬
‫‪lines‬‬
‫‪Formatted: Complex Script‬‬                                                                      ‫داﻟﺔ ‪MAX‬‬
‫‪Font: Arial‬‬
                                 ‫ﯾﺘﻢ اﺳﺘﺨﺪاﻣﮭﺎ ﻹرﺟﺎع أﻛﺒﺮ ﻗﯿﻤﺔ ﻓﻲ ﻧﻄﺎق اﻟﺨﻼﯾﺎ )اﻟﻤﺮﺟﻊ(.‬
‫5.1 :‪Formatted: Line spacing‬‬
‫‪lines‬‬                             ‫ﯾﺘﻢ اﺳﺘﺨﺪاﻣﮭﺎ ﻹرﺟﺎع أﻗﻞ ﻗﯿﻤﺔ ﻓﻲ ﻧﻄﺎق اﻟﺨﻼﯾﺎ )اﻟﻤﺮﺟﻊ(.‬         ‫داﻟﺔ ‪MIN‬‬
‫‪Formatted‬‬
‫]1[ ...‬
‫‪Formatted‬‬
‫]2[ ...‬
                                        ‫ﯾﺘﻢ اﺳﺘﺨﺪاﻣﮭﺎ ﻟﺘﻘﺮﯾﺐ اﻷرﻗﺎم إﻟﻰ أﻗﺮب ﻋﺪد ﺻﺤﯿﺢ.‬             ‫داﻟﺔ‬
‫‪Formatted‬‬
‫]3[ ...‬                                                                                        ‫‪ROUND‬‬
‫‪Formatted‬‬
‫]4[ ...‬
‫‪Formatted‬‬
‫]5[ ...‬                                      ‫ﺩ‬
                                          ‫ﻴﺘﻡ ﺍﺴﺘﺨﺩﺍﻤﻬﺎ ﻟﺠﻤﻊ ﻗﻴﻡ ﻤﺤﺘﻭﻴﺎﺕ ﺍﻟﺨﻼﻴﺎ ﺍﻟﻤﺤ ‪‬ﺩﺓ.‬      ‫ﺩﺍﻟﺔ ‪SUM‬‬
‫‪Formatted‬‬
‫]6[ ...‬

                                                           ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ ‪‬ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬
                                                            ‫‪http://www.al-jeel.net‬‬
Formatted: Complex Script
Font: Arial
                               ‫وﻣ ﻦ أﻣﺜﻠ ﺔ اﻟ ﺪوال ﺷ ﺎﺋﻌﺔ اﻻﺳ ﺘﺨﺪام، ﺗﻠ ﻚ اﻟ ﺪوال اﻟﻤﻌﺮوﺿ ﺔ ﻓ ﻲ اﻟ ﺸﻜﻞ‬
Formatted: Line spacing: 1.5
lines
                                                                                              ‫ﺿ‬
                                                                                            :‫اﻟﻤﻮ ﱠﺢ‬
Formatted: Font: (Default)
Arial, Complex Script Font:
Arial
Formatted: Complex Script
Font: Arial




                                                 ‫)4-3-2-2( اﺳﺘﺨﺪام اﻟﺪاﻟﺔ اﻟﺨﺎﺻﺔ ﺑﺤﺴﺎب ﻣﺘﻮﺳﻂ اﻷرﻗﺎم‬
Formatted: Line spacing:

                                                                                               ‫ﺩ‬
                                                   .‫ﺩ ﺍﻟﺨﻠﻴﺔ ﺍﻟﺘﻲ ﺘﺭﻴﺩ ﺃﻥ ﻴﺘﻡ ﻓﻴﻬﺎ ﺇﺩﺭﺍﺝ ﺍﻟﺼﻴﻐﺔ‬ ‫• ﺤ‬     ‫ﺍﺴﺘﺨﺩﺍﻡ ﺍﻟﺩﺍﻟﺔ‬
Multiple 1.2 li
Formatted: Line spacing:
Multiple 1.2 li
                                                                             =AVERAGE( ‫• ﺍﻜﺘﺏ‬            ‫ﺍﻟﺨﺎﺼﺔ ﺒﺤﺴﺎﺏ‬

                                                                                                         ‫ﻤﺘﻭﺴﻁ ﺍﻷﺭﻗﺎﻡ‬
                                                                                         ‫ﻠ‬
                               ‫• ﻅﱢل ﻨﻁﺎﻕ ﺍﻟﺨﻼﻴﺎ ﺍﻟﺘﻲ ﺘﺭﻴﺩ ﺃﻥ ﺘﻘﻭﻡ ﺒﺤﺴﺎﺏ ﻤﺘﻭﺴﻁ ﺍﻟﻘﻴﻡ ﺍﻟﻤﺩﺭﺠـﺔ‬

                                                                                               .‫ﻓﻴﻬﺎ‬

                                                                        .Enter ‫• ﺍﻀﻐﻁ ﻋﻠﻰ ﻤﻔﺘﺎﺡ‬
Formatted: Line spacing:
Multiple 1.2 li




Formatted: Centered,
Right-to-left
Formatted: Font: 22 pt,
Complex Script Font: 18 pt

                                                         ‫ﻠﺔ ﺍﳉﻴﻞ ﺍﻟﻮﺍﻋﺪ‬ ‫ﲨﻴﻊ ﺍﳊﻘﻮﻕ ﳏﻔﻮﻇﺔ‬
                                                          http://www.al-jeel.net
 Page 50: [1] Formatted                   Hassan Awad   ‫41/11/2002 00:70:11 ص‬
Line spacing: 1.5 lines
 Page 50: [2] Formatted                   Hassan Awad   ‫41/11/2002 00:70:11 ص‬
Line spacing: 1.5 lines
 Page 50: [3] Formatted                   Hassan Awad   ‫41/11/2002 00:70:11 ص‬
Complex Script Font: Arial
 Page 50: [4] Formatted                   Hassan Awad   ‫41/11/2002 00:70:11 ص‬
Line spacing: 1.5 lines
 Page 41: [5] Formatted                      Mr.M       ‫21/11/6002 00:02:40 ص‬
Centered, Right-to-left
 Page 41: [6] Formatted                      Mr.M       ‫21/11/6002 00:02:40 ص‬
Font: 22 pt, Complex Script Font: 18 pt

				
DOCUMENT INFO
Shared By:
Categories:
Tags: this, books, learn, icdl
Stats:
views:5
posted:9/30/2012
language:Latin
pages:12
Description: this books how to learn icdl