Page 143 - Bangladesh_classwiz_BOOK2018_rev_Neat

menu †_‡K Fill Formula e¨envi K‡i Formula wn‡m‡e A1 + A2 Ges Range wn‡m‡e A3 : A45 cÖ‡ek
Kwi‡q `yBevi = Pvc‡j wb‡Pi wP‡Îi g‡Zv A Kjv‡g Fibonacci series cvIqv hv‡e|

3. 5% nvi gybvdvq 8000 UvKvi 3 eQ‡ii gybvdv I Pµe„w× gybvdvi cv_©K¨ wbY©q Ki‡Z n‡e|

mgvavb- cÖ_‡g w8 †P‡c Spreadsheet mode wbe©vPb Ki‡Z n‡e| Gici Lvwj Spreadsheet Gi A

Kjv‡gi cÖ_g PviwU N‡i eQ‡ii msL¨v 0, 1, 2, 3 cÖ‡ek Kiv‡Z n‡e|

B1 N‡i Kvm©i wb‡q T menu †_‡K 1 †P‡c Fill Formula wbe©vPb Ki‡Z n‡e| Form G Formula

wn‡m‡e 8000 × ( 5 ) × 1 UvBc Ki‡Z n‡e| Gici Range G B1: B4 UvBc K‡i `yBevi = Pvc‡Z
100
n‡e| Zvn‡j wb‡Pi g‡Zv w¯Œb cÖ`wk©Z n‡e|

‡h‡nZz mij gybvdv ZvB Fromula ‡Z 8000 g~jab wn‡m‡e wbw`©ó| T menu †_‡K 1 †P‡c

Fill Formula wbe©vPb K‡i Form G Formula wn‡m‡e 8000 + 1 I Range G C1 : C4 UvBc K‡i
`yBevi = Pvc‡j cÖwZ eQi †k‡l gybvdv Avm‡ji cwigvY cÖ`wk©Z n‡e| B1 G k~b¨ eQi †k‡l A_©vr Rgvi mgq
gybvdv Avm‡ji cwigvY 8000| wØZxq N‡i jÿ¨ Ki‡j †`Lv hv‡e A Kjv‡g eQ‡ii msL¨v hLb 1 ZLb C Kjv‡g
gybvdv Avm‡ji cwigvY 8400 Ges B Kjv‡g gybvdvi cwigvY 400 cÖ`wk©Z n‡q‡Q|

hv wb‡`©k Ki‡Q cÖ_g eQi †k‡l gybvdvi cwigvY 400 UvKv Avi gybvdv Avm‡ji cwigvY 8000 + 400 = 8400
UvKv| Avevi Z…Zxq eQi †k‡l gybvdvi cwigvY 1200 UvKv I m~`vm‡ji cwigvY 9200 UvKv|

3
Pµe„w×i gybvdv I gybvdv Avm‡ji cwigvY Spreadsheet G Pµe„w×i gybvdvi m~Î = (1 + ) e¨envi
K‡i mn‡RB †ei Kiv hvq| GRb¨ cybivq D1 N‡i †h‡q Option ‡_‡K Fill Formula wbe©vPb K‡i Formula
1
wn‡m‡e 8000(1 + .05) UvBc Ki‡Z n‡e| Gici Range wn‡m‡e D1 : D4 UvBc K‡i `yB evi = Pvc‡Z
n‡e| Zvn‡j D Kjv‡g Pµe„w×i m~`vmj cvIqv hv‡e|

138