# 4-3Formulas-and-Functions by mohamedheba

VIEWS: 5 PAGES: 12

• pg 1
<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

To top