Page 141 - Bangladesh_classwiz_BOOK2018_rev_Neat

D`vniYgvjv

1. ‡Kv‡bv GKwU ¯‹z‡ji beg †kÖYxi 10 Rb Qv‡Îi wZbwU we‡l‡q cÖvß b¤^i †`qv Av‡Q, Qv·`i GB b¤^i¸‡jvi
†hvMdj, Mo, kZvsk, m‡e©v”P b¤^i, me©wb¤œ b¤^i †ei Ki‡Z n‡e|

cÖvß b¤^i¸‡jv n‡jv

c`v_© we`¨v MwYZ imvqb
93 78 65
37 54 38
82 84 79
54 57 67
64 72 86
72 65 91
91 87 77
78 69 84
68 65 72
27 34 69

mgvavb- Qv·`i b¤^icÎ ˆZwii Rb¨ cÖ_‡g w8 †P‡c Spreadsheet mode G †h‡Z n‡e| Spreadsheet

mode G †M‡j cÖ_‡g GKwU Lvwj Spreadsheet Gi cvZv Avm‡e| GB Lvwj Spreadsheet Gi A, B I C
Kjv‡g h_vµ‡g Qv·`i c`v_©we`¨v, MwYZ I imvqb Gi b¤^i¸‡jv µgvbyhvqx cÖ‡ek Kiv‡Z n‡e|

Gici b¤^i¸‡jvi †hvMdj D Kjv‡g †ei Kivi Rb¨ T menu ‡_‡K 1 †P‡c Fill Formula wbw`©ó Ki‡Z
n‡e| Gici Form G Kvm©i wb‡q cybivq T menu ‡Z wM‡q R †P‡c wØZxq †cR †_‡K 4 †P‡c sum

wbw`©ó K‡i A1 : C1 UvBc K‡i = Pvc‡Z n‡e| Gici Range G wM‡q D1 : D10 UvBc K‡i = Pvc‡j
me¸‡jv wel‡qi b¤^‡ii †hvMdj D Kjv‡g cvIqv hv‡e|

D‡jøL¨ †h Formula wn‡m‡e sum e¨envi bv K‡i A1 + B1 + C1 e¨envi Ki‡jI GKB djvdj cvIqv †hZ|

b¤^‡ii Mo †ei Kivi Rb¨ T menu †_‡K Fill Formula wbw`©ó K‡i Form G wM‡q cybivq T †P‡c
R evUb Pvcvi ci 3 †P‡c Mean wbe©vPb Ki‡Z n‡e| AZtci A1: C1 UvBc K‡i eÜbx ()) eÜ Ki‡Z
n‡e| Gici = †P‡c Range G wM‡q E1: E10 UvBc K‡i = evUb `yBevi Pvc‡j E Kjv‡g b¤^i¸‡jvi Mo
cÖ`wk©Z n‡e|

136