Page 145 - Bangladesh_classwiz_BOOK2018_rev_Neat
P. 145
y
Abkxjbx-13
1. wb‡Pi gvb¸‡jv GKwU bZzb Spreadsheet G cÖ‡ek KivI-
(K) 1 N‡i 1 I 2 †hvM Kivi Rb¨ GKwU wb‡`©kbv (Formula bq) cÖ‡ek KivI|
(L) 2 N‡i 2 + 2 + 2 wbY©q Kivi Rb¨ GKwU Formula cÖ‡ek KivI| Gic‡i 2 N‡i 7 cÖ‡ek
Kwi‡q cixÿv Ki|
(M) I Kjv‡gi QqwU N‡ii Mo †ei Kivi Rb¨ 3 N‡i GKwU Formula wjL| 2 N‡i 3 cÖ‡ek Kwi‡q
cixÿv Ki|
(N) , I Kjv‡gi cÖ‡Z¨KwUi m‡e©v”P gvb †ei Kivi Rb¨ 4 N‡i GKwU Formula wjL| Gici 1 N‡i
37 cÖ‡ek cixÿv Ki|
2. GKwU bZzb Spreadsheet G Fill value wb‡`©kbv e¨envi K‡i Kjv‡gi cÖ_g 15wU N‡i 3 †_‡K ïiæ K‡i
cÖwZevi 10 e„w×i Rb¨ evwK Ni¸‡jv c~Y© Ki| Gici 1 Gi gvb cwieZ©b K‡i †`L †h GwU Kjv‡gi evwK
As‡k ‡Kv‡bv cwieZ©b K‡i bv|
3. (K) GKwU bZzb Spreadsheet G 1 N‡i 5 Ges 1 N‡i 7 cÖ‡ek KivI|
(L) Fill Formula e¨envi K‡i 7 K‡i e„w×i Rb¨ 30 ch©šÍ Ni c~iY Ki|
(M) 1 †K cwieZ©b K‡i 5 K‡i e„w× Rb¨ 150 ch©šÍ MYbv Ki|
2
4. Spreadsheet e¨envi K‡i ( ) = + dvskbwUi GKwU gv‡bi ZvwjKv ˆZwi Ki| ïiæi Rb¨ Kjv‡g Gi
wewfbœ gvb bvI Ges Gici Fill Formula e¨envi K‡i Kjv‡g wewfbœ gv‡bi Rb¨ dvsk‡bi gvb †ei Ki|
5. wb‡Pi Spreadsheet Ges Fill Formula fv‡jvfv‡e jÿ¨ K‡iv-
(a) Dc‡ii Fill Formula cÖ‡ek Kiv‡j Kx n‡e Zv e¨vL¨v Ki|
(b) Fill Formula †K cwieZ©b K‡i Mean (A1 : A3) wjL‡j Kx n‡e? SETUP G wM‡q Show cell
‡_‡K Formula †Z cwieZ©b K‡i cixÿv Ki|
140