Using
Function and formula
Excel ‡cÖvMªv‡g A‡bK dvskb weìAvc Kiv Av‡Q | GB dvskb KgvÛ mg~n
Øviv Abvqv‡B A‡bK RwUj MvwYwZK Kvh©v`xi m¤úbœ Kiv hvq | †hgb Avcwb hw` A1 †_‡K A5
ch©š— †hvM Ki‡Z Pvb Zvn‡j m~ÎwU n‡e A1+ A2+
A3 +A4 +A5b Gfv‡e
| wKš‘ dvskb KvgvÛ Øviv =SUM(A1: A5) wjL‡jB †hvMdj wbb©q Kiv hvq |
‡Kvb dvskb KvgvÛ cÖ‡qvM Ki‡Z Dnvi wm‡›UK Abyqvqx KvgÛwU
cÖ‡qvM Ki‡Z nq | dvskb KvgvÛ cÖ‡qv‡Mi wb‡qvg¸‡jv wb‡gœiƒc t
1| cÖwZwU
dvskb = mvBb w`‡q ïiæ Ki‡Z nq |
2| mKj
AvM©y‡g›U ( ) eªv‡K‡Ui g‡a¨ ivL‡Z nq |
3| †Kvb
dvskb Ges AvM©y‡g›U Gi gvSL‡b ‡¯úm _vK‡e bv | †hgb =AVERAGE(A1: A5)
4| †Kvb
dvskb Kvgv‡Û GKvwaK AvM©y‡g›U _vK‡j Dnv‡K Kgv (,) ev ‡mwg‡Kvjb (;) w`‡q Avjv`v
Ki‡Z nq |
†hgb AVERAGE(A1, A3,A5)
5| †Kvb
dvskv‡b wbDg¨vwiK f¨vjyi †¶‡Î †iÄ bvg e¨envi Kiv hvq | †hgb =SUM(Sales)
6| mvivmwi w¯‹‡b dvskb KvgvÛ wj‡L cÖ‡qvM Kiv
hvq wKsev Insert Menu ‡_‡K dvskb KgvÛ e¨envi K‡iI KvR Kiv hvq |
‡Uwej-1
A
|
B
|
C
|
1
|
Jan
|
1200
|
2
|
Feb
|
1225
|
3
|
Mar
|
1250
|
4
|
Apr
|
1275
|
5
|
May
|
1300
|
6
|
Jun
|
1325
|
7
|
Jul
|
1350
|
8
|
Aug
|
1375
|
9
|
Sep
|
1400
|
10
|
Oct
|
1425
|
11
|
Nov
|
1450
|
12
|
Dec
|
1475
|
13
|
|
=AVERAGE(C1:
C12
|
aiv hvK †Uwej-1 Gi C1†_‡K
C12 msL¨v¸wji
†hvM Ki‡Z Pvb Zvn‡j
C Insert
‡gby †_‡K Function Ackb
wbe©vPb Kiæb | wb‡gœi (wPÎ-1) e·wU w¯‹‡b Avm‡e | Select a function ‡_‡K SUM wbe©vPb
K‡i OKKiæb|
Gevi w¯‹‡b (wPÎ-2) bs e·wU Avm‡e | Number1
Box Gi g‡a¨ †mj †iÄ UvBc K‡i G›Uvi Kiæb djvdj cÖ`wk©Z
n‡e |
(wPÎ-1) (wPÎ-2)
m~θwj n‡jv t (1) =AVERAGE(C1:C12), =COUNT(C1:C12),
=AMX(C1:C12), =MIN(C1:C12), =SUM(A1:
A5), =(C1*C2), =(C1/C2), =(C1-C2)
TO CALCULATE A RESULT SHEET
g‡b Kwi †fovgviv g‡Wj miKvwi cÖv_wgK we`¨vj‡qi 5g †kªbxi
g‡Wj †Uó cix¶vq Qv·`i cÖvß b¤^‡ii wfwˇZ wbgœewb©Z kZ© †gvZv‡eK †iRvë mxU ˆZix
Ki‡Z Pvb |
kZ© 1| Total
marks >= 300 (300 A_ev 300 Gi †ewk) n‡j †MÖW "A"
2| Total marks >= 250 (250 A_ev 300 Gi †ewk)
n‡j †MÖW "B"
3| Total
marks >= 200 (200 A_ev 300 Gi †ewk) n‡j †MÖW "C"
4| Total
marks < 200 (200 A_ev 300 Gi Kg ) n‡j †MÖW "F"
G Rb¨ wb‡`©kbv wbgœiy„c t
1| WorkSheet G wbgœiæc WvUv Gw›Uª K‡i Total
Marks wnmve
m¤úbœ Kiæb |
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
1
|
Name
|
Ben
|
Eng
|
Math
|
S.Sci
|
Sci
|
Rel.
|
Total
|
Result
|
2
|
Sagor
|
98
|
89
|
99
|
88
|
96
|
95
|
=sum(B2:G2)
|
=if(H2>=300,"A",
if(H2>=250,"B", if(H2>=200<"C",if(H2<200,"F"))))
|
3
|
Helena
|
98
|
89
|
99
|
88
|
96
|
95
|
c/
(pest)
|
|
4
|
Rashid
|
90
|
86
|
95
|
81
|
95
|
92
|
|
C/p
|
5
|
Kollol
|
89
|
98
|
90
|
78
|
90
|
65
|
|
|
6
|
Ananto
|
75
|
45
|
66
|
80
|
74
|
79
|
|
|
7
|
Digonto
|
98
|
79
|
75
|
68
|
88
|
74
|
|
|
8
|
Simanto
|
98
|
89
|
99
|
88
|
96
|
95
|
|
|
2| H2 ‡m‡j UvBc Kiæb =sum(B2:G2), Zvn‡j
†gvU cÖvß b¤^i †ei n‡e |
digyjv Kwc K‡i Ab¨ †m‡j †có Kiæb
3| I2 ‡m‡j UvBc
Kiæb =if(H2>=300,"A",
if(H2>=250,"B", if(H2>=200<"C",if(H2<200,"F")))),
Zvn‡j †gvU cÖvß djvdj †ei n‡e |
digyjv Kwc K‡i Ab¨ †m‡j †có Kiæb