Page 144 - Bangladesh_classwiz_BOOK2018_rev_Neat

C Kjv‡g mij my`vmj Ges D Kjv‡g Pµe„w×i my`vmj cÖ`wk©Z n‡q‡Q| C4 N‡ii gvb I D4 N‡ii gv‡bi cv_©K¨B
n‡jv gybvdvi cv_©K¨ hv 9261 − 9200 = 61UvKv| Avevi E1 N‡i †h‡q Fill Formula †Z Formula wn‡m‡e
1 − 8000 I E1: E4 UvBc K‡i = evUb `yBevi Pvc‡j E Kjv‡g cÖwZeQi †k‡l Pµe„w×i gybvdv cÖ`wk©Z
n‡e|

Avevi weKí c×wZ‡Z Pµe„w×i gybvdv I gybvdv-Avm‡ji cwigvY †ei Ki‡Z n‡j D1 N‡i ‡h‡q T menu
‡_‡K Fill formula wbe©vPb K‡i Formula wn‡m‡e 1 × 1 × (5%)[ ] UvBc Ki‡Z n‡e I Range

wn‡m‡e D1 : D1 UvBc K‡i = evUb `yBevi Pvc‡j wb‡Pi g‡Zv w¯Œb cvIqv hv‡e|

E1 N‡i g~jab 8000 cÖ‡ek Kwi‡q = evUb Pvc‡j wb‡Pi g‡Zv w¯Œb cvIqv hv‡e|

Gici D2 N‡i Fill Formula wbe©vPb K‡i Formula wn‡m‡e 1 × 1 × ( 5 ) I Range wn‡m‡e D2 : D4
100
UvBc K‡i = Pvc‡j wb‡Pi g‡Zv w¯Œb cvIqv hv‡e|

Gici E2 N‡i Formula wn‡m‡e 1 + 2 cÖ‡ek Kwi‡q Range wn‡m‡e E2 : E4 UvBc K‡i = evUb
`yBevi Pvc‡j wb‡Pi g‡Zv gybvdv I my`vm†ji ZvwjKv cvIqv hv‡e|

Spreadsheet fvjfv‡e ch©‡eÿY Ki‡j †`Lv hv‡e †h cÖ_g eQi [ = 1] mij gybvdv I Pµ e„w×i gybvdv mgvb,
wØZxq eQi [ = 2] †k‡l mij gybvdv 800 UvKv wKš‘ Pµe„w×i gybvdv 400 + 420 UvKv Ges Z…Zxq eQi †k‡l
mij gybvdv 1200 UvKv †hLv‡b Pµe„w×i gybvdv 400 + 420 + 441 = 1261 UvKv|
myZivs mij gybvdv I Pµ e„w×i gybvdvi cv_©K¨ 1261 − 1200 = 61 UvKv|
Avevi my`vm†ji cv_©K¨ †_‡K gybvdvi cv_©K¨ 9261 − 9200 = 61 UvKv|

139