Page 138 - Bangladesh_classwiz_BOOK2018_rev_Neat

mean (A1: B4) wb‡`©kbv 1 †_‡K ïiæ K‡i 4 ch©šÍ AvUwU N‡ii gv‡bi Mo †ei Ki‡e| GB wb‡`©kbv 4

N‡i e¨envi Kivi Rb¨ Kvm©iwU 4 N‡i wb‡q 3 ‡P‡c Mean wbw`©ó K‡i (A1: B4) wb‡`©kbv e¨envi K‡i
= Pvc‡jB wb‡Pi g‡Zv djvdj cvIqv hv‡e|

Kjv‡gi †hvMdj †ei Kivi Rb¨ 2 N‡i ( 1: 4) wb‡`©kbv e¨envi Ki‡Z n‡e| 3 N‡i m‡e©v”P gvb
†ei Kivi Rb¨ H N‡i Max (A1 : B4) wb‡`©kbv e¨envi Ki‡Z n‡e|

13.2 Formula Gi e¨envi

Spreadsheet Gi Kvh©KvwiZv Formula Gi e¨env‡ii Dc‡iB g~jZ wbf©ikxj| MwY‡Z Formula n‡jv wbw`©ó
Dcv‡q PjK¸‡jv m¤úwK©Z Kiv| G‡ÿ‡Î Spreadsheet G cÖwZwU N‡ii Dcv`vb¸‡jv PjK wn‡m‡e we‡ewPZ nq|

Spreadsheet Gi ‡Kv‡bv N‡i Formula Gi m~Pbv Kivi Rb¨ Qr e¨envi K‡i mgvb wPý w`‡q ïiæ Ki‡Z
nq| (G‡ÿ‡Î = Kx e¨envi Kiv hv‡e bv) GwU wKfv‡e KvR K‡i Zv †evSvi Rb¨ B Kjv‡gi Mo ‡ei Kivi
Formula B5 N‡i UvBc Ki‡Z n‡e| GRb¨ mgvb wPý w`‡q ïiæ Ki‡Z n‡e hv wb‡Pi cÖ_g w¯Œ‡b †`Lv‡bv n‡q‡Q|

Formula ‡kl Kivi Rb¨ = evUb Pvc‡j NiwUi c~‡e©i gvb 2.75 Øviv cÖwZ¯’vwcZ n‡e| 2.75 n‡jv Kjv‡gi
gv‡bi Mo| Kvm©iwU Ab¨ N‡i wb‡q †M‡j 5 N‡i 2.75 cÖ`wk©Z n‡e wKš‘ cybivq H N‡i wb‡q †M‡j Dc‡ii me©‡kl
w¯Œ‡bi g‡Zv wb‡Pi w`‡K Formula wU cÖ`wk©Z n‡e|

5 N‡i GKwU Formula i‡q‡Q hvi GKwU gvbI i‡q‡Q| gvbwU memgq Spreadsheet Gi H N‡i cÖ`wk©Z n‡e|
†h‡nZz SET UP menu e¨envi K‡i Show cell ‡_‡K Formula wbe©vPb Kiv n‡qwQj ZvB Kv©miwU H N‡i
wb‡q †M‡j Formula wU cÖ`wk©Z n‡e| hw` Show cell ‡_‡K value wbe©vPb Kiv nq Zvn‡j Formula wU H N‡i
_vK‡jI cÖ`wk©Z bv n‡q eis gvb cÖ`wk©Z n‡e|

Formula e¨envi Kivi myweav n‡jv hw` ‡Kv‡bv N‡ii gvb cwieZ©b Kiv nq Zvn‡j bZzb K‡i Formula wnmve
Kivi cÖ‡qvRb c‡ibv eis ¯^qswµqfv‡e bZzb Mo 5 N‡i cÖ`wk©Z n‡e| GwU ch©‡eÿY Kivi Rb¨ 2, 3 I 4

133