User Manual

9-16
ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺍ k
ﺔﻴﻠﳋﺍ ﻢﺳﺍ ﻊﺟﺍﺮﻣ ﻢﻜﲢ ﻲﺘﻟﺍ ﻡﺎﻜﺣﻷﺍ .ﺎﻳﻼﳋﺍ ﻦﻣ ﺩﺪﺤﻣ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺍ ﺪﻳﺮﺗ ﺎﻣﺪﻨﻋ ﺀﻞﳌﺍ ﺮﻣﺃ ﻡﺪﺨﺘﺳﺍ
.ﻖﺼﻠﻟﺍ ﻭ ﺦﺴﻨﻠﻟ ﺔﻠﺛﺎﳑ ﻥﻮﻜﺗ ﺔﻴﺒﺴﻨﻟﺍ ﻭ ﺔﻘﻠﻄﳌﺍ
ﺔﻐﻴﺼﻟﺍ ﻝﺎﺧﺩﺈﺑ ﺍﺬﻫ ﻞﻤﻌﺑ ﺀﻞﳌﺍ ﺮﻣﺃ ﻚﻟ ﺢﻤﺴﻳ ،ﻼﺜﻣ
B1, B2 ،B3 ﺎﻳﻼﳋﺍ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺇ ﻰﻟﺍ ﺝﺎﺘﲢ ﺎﻣﺪﻨﻋ
.ﺔﻟﺎﳊﺍ ﻩﺬﻫ ﻲﻓ ﺔﻴﻠﳋﺍ ﻢﺳﺍ ﻊﺟﺍﺮﳌ ﺀﻞﳌﺍ ﺮﻣﺃ ﺔﻠﻣﺎﻌﻣ ﺔﻴﻔﻴﻛ ﻦﻋ ﻲﻠﻳ ﺎﻣ ﻆﺣﻻ .
B1 ﺔﻴﻠﳋﺍ ﻰﻟﺍ ،ﺓﺮﻣ
: ﺍﺬﻫ ﻰﻠﻋ B1 ﺔﻴﻠﳋﺍ ﻱﻮﺘﲢ ﺎﻣﺪﻨﻋ : ﺍﺬﻬﺑ ﻞﻤﻌﺑ ﺀﻞﳌﺍ ﺮﻣﺃ ﻡﻮﻘﻳ ﻑﻮﺳ
=A1 × 2
A B
1
=A1 × 2
2
=A2 × 2
3
=A3 × 2
ﺎﻳﻼﺨﻠﻟ ﺔﻴﻠﻜﻟﺍ ﺔﺳﺭﺎﻤﳌﺍ ﻥﺃ ﻆﺣﻻ *
ﺞﺋﺎﺘﻧ ﺮﻬﻈﺗ ﻑﻮﺳ
B1, B2, B3
ﺔﻐﻴﺼﻟﺍ ﻆﺣﻻ ،ﺔﻴﺑﺎﺴﳊﺍ ﺔﻴﻠﻤﻌﻟﺍ
.ﺎﻨﻫ ﺔﻨ
ﹼ
ﻴﺒﻣ ﻲﻫ ﺎﻤﻛ
=$A$2 × 2
A B
1
=$A$2 × 2
2
=$A$2 × 2
3
=$A$2 × 2
ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺇ u
.ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺍ ﺪﻳﺮﺗ ﺚﻴﺣ ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﺮﺘﺧﺍ .1
.(
9-7 ﺔﺤﻔﺻ) "ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﺭﺎﻴﺘﺧﻻ" ﺮﻈﻧﺍ .B1:B3 ﺭﺎﻴﺘﺧﺍ ﻦﻣ ﺪﻛﺄﺘﻧ ﻑﻮﺳ ﻝﺎﺜﳌﺍ ﺍﺬﻫ ﻲﻓ •
.
2(EDIT) 6( g) 1(FILL) ﻰﻠﻋ ﻂﻐﺿﺍ .2
.ﺎﻬﻟﺎﺧﺩﺍ ﺪﻳﺮﺗ ﻲﺘﻟﺍ ﺔﻐﻴﺼﻟﺍ ﻞﺧﺩﺍ ،ﺔﺿﻭﺮﻌﳌﺍ ﺀﻞﳌﺍ ﺔﺷﺎﺷ ﻰﻠﻋ .
3
ﺽﺮﻋ ﻢﺘﻴﺴﻓ ،ﻩﻼﻋﺃ 1 ﺓﻮﻄﳋﺍ ﻲﻓ ﺩﺪﶈﺍ ﻕﺎﻄﻨﻟﺍ ﻦﻣ ﻯﺮﺴﻴﻟﺍ ﺔﻳﻮﻠﻌﻟﺍ ﺔﻴﻠﳋﺍ ﻲﻓ ﺎﻬﻟﺎﺧﺩﺇ ﰎ ﺕﺎﻧﺎﻴﺑ ﻙﺎﻨﻫ ﺖﻧﺎﻛ ﺍﺫﺇ •
."
Formula" ﺮﻄﺴﻟﺍ ﻲﻓ ﺔﻐﻴﺼﻟﺍ
ﻂﻐﻀﻟﺍ ﺐ
ﹼ
ﺒﺴﺘﻳ ﻑﻮﺳ .(
!.(=) av(A) b*cw) =A1 × 2 ﻞﺧﺩﺍ ،"Formula" ﺮﻄﺴﻟﺍ ﻲﻓ •
."
Cell Range" ﺮﻄﺴﻟﺍ ﻰﻟﺍ ﺔﻴﻠﳋﺍ ﺮﺷﺆﻣ ﻚﻳﺮﺤﺘﺑ w ﻰﻠﻋ
ﻝﺍﺪﺒﺘﺳﺍ ﻰﻟﺍ ﺐ
ﹼ
ﺒﺴﺘﻳ ﻑﻮﺳ ﺔﻴﻟﺎﺘﻟﺍ ﺓﻮﻄﳋﺍ ﺀﺍﺮﺟﺍ ،ﻞﻌﻔﻟﺎﺑ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻰﻠﻋ ﻱﻮﺘﲢ ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ ﻲﻓ ﺔﻴﻠﺧ ﺔﻳﺃ ﺖﻧﺎﻛ ﺍﺫﺍ •
.(ﺔﻐﻴﺻ) ﺓﺪﻳﺪﳉﺍ ﺀﻞﳌﺍ ﺕﺎﻧﺎﻴﺒﺑ ﺓﺩﻮﺟﻮﳌﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ
.
w ﺡﺎﺘﻔﳌﺍ ﻭﺍ 6(EXE) ﻰﻠﻋ ﻂﻐﺿﺍ .4
.ﺓﺩﺪﶈﺍ ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺍﺬﻫ ﻞﺧﺪﻳ ﻑﻮﺳ •
.1 ﺓﻮﻄﳋﺍ ﻲﻓ ﻪﺗﺮﺘﺧﺍ ﻲﺘﻟﺍ ﺍﺬﻫ ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ
ﺎﻬﻠﻴﻠﻈﺗ ﻢﺘﻳ ﻲﺘﻟﺍ ﺩﻮﻨﺒﻟﺍ ﺕﺎﻧﺎﻴﺑ ﻝﺎﺧﺩﺍ ﻚﻨﻜﳝ
.ﺔﺷﺎﺸﻟﺍ ﻰﻠﻋ