9-11
ﺔﻐﻴﺼﻟﺍ ﻝﺎﺧﺩﺇ ﻝﺎﺜﻣ u
A B C
1
PRICE QUANTITY TOTAL
2 35 15 525
3 52 15 780
4 78 20 1560
ﺕﺍﺀﺍﺮﺟﺇ
.
B4 ﻰﻟﺍ A2 ﺔﻴﻠﳋﺍ ﻲﻓ ﺔﻘﺒﻄﳌﺍ ﻢﻴﻘﻟﺍ ﻭ ،1 ﺮﻄﺴﻟ ﺺﻨﻟﺍ ﻞﺧﺩﺍ .1
.
A2 × B2 ـﻟ ﺔﻐﻴﺼﻟﺍ ﻞﺧﺩﺍ ﻭ ،C2 ﺔﻴﻠﳋﺍ ﻰﻟﺍ ﺮﺷﺆﳌﺍ ﻙﺮﺣ .2
!.(=) av(A) c*al(B) cw
ﻢﻗ ﻢﺛ ﻦﻣ ﻭ
C2 ﺔﻴﻠﳋﺍ ﻰﻟﺍ ﺔﻴﻠﳋﺍ ﺮﺷﺆﻣ ﻙﺮﺣ ﻭ .C4 ﻭ C3 ﺔﻴﻠﺧ ﻰﻟﺍ ﻪﻘﺼﻟﺍ ﻭ C2 ﺔﻴﻠﳋﺍ ﻲﻓ ﺔﻐﻴﺼﻟﺍ ﺦﺴﻨﺑ ﻢﻗ .3
.ﺔﻴﻟﺎﺘﻟﺍ ﺔﻴﻠﻤﻌﻟﺍ ﺀﺍﺩﺄﺑ
2(EDIT) 2(COPY) c1(PASTE) c1(PASTE) J
ﺕﺎﻳﻮﺘﺤﻣ ﻖﺼﻟ ﻭ ﺦﺴﻧ" ﺮﻈﻧﺍ ،ﻖﺼﻠﻟﺍﻭ ﺦﺴﻨﻟﺍ ﺕﺎﻴﻠﻤﻋ ﻦﻋ ﻞﻴﺻﺎﻔﺘﻠﻟ •
.(
9-14 ﺔﺤﻔﺻ) "ﺔﻴﻠﳋﺍ
ﺔﻴﻠﺧ ﻊﺟﺮﻣ ﻢﺳﺍ ﻝﺎﺧﺩﺇ k
ﻢﺳﺍ ﻊﻣ (Z ﻰﻟﺍ A ﻦﻣ) ﻩﺩﻮﻤﻋ ﻢﺳ ﻊﻤﺟ ﻝﻼﺧ ﻦﻣ ﻖﺘﺸﳌﺍ ﻭ ،"ﻊﺟﺮﳌﺍ ﻢﺳﺍ" ﻰﻤﺴﻳ ﺎﻣ ﻚﻠﲤ ﻝﻭﺪﳉﺍ ﻰﻠﻋ ﺔﻴﻠﺧ ﻞﻛ
ﺔﻴﻠﺧ ﻦﻣ ﻲﻋﺪﺘﺴﳌﺍ ﺀﺰﳉﺍ ﺔﻤﻴﻗ ﻞﻌﲡ ﻲﺘﻟﺍﻭ ،ﺔﻐﻴﺼﻟﺍ ﻞﺧﺍﺩ ﺔﻴﻠﳋﺍ ﻊﺟﺮﻣ ﻢﺳﺍ ﻡﺍﺪﺨﺘﺳﺍ ﻦﻜﳝ .(
999 ﻰﻟﺍ 1 ﻦﻣ) ﻪﻔﺻ
ﺎﻤﻬﻣﺍﺪﺨﺘﺳﺍ ﻚﻨﻜﳝ ﻥﺎﺘﻘﻳﺮﻃ ﻙﺎﻨﻫ .ﺕﺎﻣﻮﻠﻌﳌﺍ ﺓﺩﺎﻳﺯ ﻰﻠﻋ ﻝﻮﺼﺤﻠﻟ ﺎﻘﺑﺎﺳ "ﺔﻴﻠﺧ ﻰﻟﺍ ﺔﻐﻴﺻ ﻝﺎﺧﺩﺍ" ﻲﻓ ﺮﻈﻧﺍ .ﺔﻐﻴﺼﻟﺍ
ﻑﻮﺳ ﻲﺘﻟﺍ ﺔﻘﻳﺮﻄﻟﺍ ﻲﻠﻳ ﺎﻣ ﺮ
ﹼ
ﺴﻔﻳ .
GRAB ﺮﻣﻷﺍ ﻡﺍﺪﺨﺘﺳﺎﺑ ﻝﺎﺧﺩﺍ ﻭ ﺓﺮﺷﺎﺒﻣ ﻢﺳﻻﺍ ﻝﺎﺧﺩﺍ :ﺔﻴﻠﳋﺍ ﻊﺟﺮﻣ ﻢﺳﺍ ﻝﺎﺧﺩﻹ
.
B1 ﺔﻴﻠﺧ ﻰﻟﺍ =A1+5 ﻝﺎﺧﺩﻹ ﻕﺮﻄﻟﺍ ﻩﺬﻫ ﻦﻣ ﻞﻛ ﻡﺪﺨﺘﺴﺗ
ﺮﺷﺎﺒﳌﺍ ﻝﺎﺧﺩﻻﺍ ﻡﺍﺪﺨﺘﺳﺎﺑ ﺔﻴﻠﳋﺍ ﻊﺟﺮﻣ ﻢﺳﺍ ﻝﺎﺧﺩﺇ u
.ﺔﻴﻟﺎﺘﻟﺍ ﺔﻴﻠﻤﻌﻟﺍ ﺀﺍﺩﺄﺑ ﻢﻗ ﻢﺛ ﻦﻣ ﻭ B1 ﺔﻴﻠﳋﺍ ﻰﻟﺍ ﺔﻴﻠﳋﺍ ﺮﺷﺆﻣ ﻙﺮﺣ
!.(=) av(A) b+fw
Comments to this Manuals