Page 142 - Bangladesh_classwiz_BOOK2018_rev_Neat

kZvsk †ei Ki‡Z n‡j cybivq T menu ‡_‡K 1 †P‡c Fill Formula wbe©vPb Ki‡Z n‡e| Gici Form
G wM‡q D1 300% (qM) I Range G wM‡q A14 : A24 UvBc K‡i `yBevi = evUb Pvc‡j A
Kjv‡gi 14 †_‡K 24 b¤^i Ni¸‡jv‡Z cÖwZwU QvÎ KZ kZvsk b¤^i †c‡q‡Q Zv cÖ`wk©Z n‡e|

jÿYxq †h †h‡nZz Avi bZzb ‡Kv‡bv Kjvg †bB ZvB Range wn‡m‡e A Kjv‡gi wZbwU Ni ev` †i‡L 14 †_‡K 24
b¤^i †bqv n‡q‡Q †hb mn‡RB G gvb¸‡jv Avjv`v Kiv hvq| Av‡iv jÿYxq†h Qv·`i Mo b¤^i I KZ kZvsk b¤^i
†c‡q‡Q Zvi gvb GKB| †Kbbv cÖwZwU wel‡qi b¤^i 100.

B14 N‡i m‡e©v”P b¤^i †ei Kivi Rb¨ Kvm©i Kx e¨envi K‡i B14 N‡i †h‡q T ‡P‡c R Kx Pvi evi Pvc‡j
wb‡Pi w¯Œ‡bi g‡Zv w¯Œb cÖ`wk©Z n‡e|

Gici 2 †P‡c Max wbe©vPb K‡i (D1: D10) UvBc K‡i = Pvc‡j m‡e©v”P cÖvß b¤^i ( 255 ) 14 N‡i
cÖ`wk©Z n‡e|

fvj K‡i jÿ¨ Ki‡j †`Lv hv‡e †h GB b¤^iwU 7 Zg QvÎ Gi cÖvß b¤^i|

me©wb¤œ gvb †ei Kivi Rb¨ C14 N‡i †h‡q T menu Gi PZz_© cvZv †_‡K 1 †P‡c Min wbw`©ó K‡i
(D1 : D10) UvBc K‡i = Pvc‡j me©wb¤œ cÖvß b¤^i 129, C14 N‡i cÖ`wk©Z n‡e|

2. Fill Formula e¨envi K‡i Fibonacci wmwi‡Ri cÖ_g 45 wU gvb †ei Ki‡Z n‡e|

mgvavb- Avgiv Rvwb Fibonacci series n‡jv msL¨vi Ggb GKwU series hvi cÖwZwU msL¨v Zvi c~‡e©i `yBwU
msL¨vi †hvMdj| hvi ïiæ 1, 1 w`‡q| Spreadsheet Gi gva¨‡g Fibonacci wmwiR †ei Kivi Rb¨ cÖ_‡g
w8 †P‡c spread sheet mode Gi cÖ‡ek K‡i A1 I A2 Dfq N‡i 1 cÖ‡ek Kiv‡Z n‡e| Gici T
137