1|ILM.irfan
G 10||Competency7
Grade - 10
learnbyself.com
Competency - 07
Time: 1 hour
I
1k; kw; kw;Wk; Wk; 2k; 2k; tpdhf; tpdhf;fs; fs; fP fPNo No jug;gl; gl; ;l tpujhs; gFjpia gFjpia mbg;gilahff; gilahff; nfhz; nfhz;lit. lit.
=$A$2 + A3 vDk; R+j;jpuj; jpuj;jpid jpid fyk; ( (Cell) A4 nfhz;Ls; Ls;sJ. sJ. ,r;R+j; R+j;jpuk; jpuk; fyk; fyk; A5 w;Fg; Fg; gpujp gpujp nra;ag; ag;gl; gl;lhy; lhy; fhl; fhl;rpg; rpg;gLj; gLj;jg; jg;gLk; gLk; ngWkhdk; ahJ? ahJ? 1) 2 3) 6
2) 4 4) 8
fyk; C2 tpy; =sum(A2:B2) vDk; ; R+j; R+j;jpuk; jpuk; vOjg; vOjg;gl; gl;Ls; Ls;sJ. sJ. fyk; C2 ,Ys;s R+j;jpuj; jpuj;jpk; jpk; fyk; fyk; C3w;Fg; Fg; gpujp nra;ag; ag;gl; gl;lhy; lhy; fyk; fyk; C3 ,y; vOjg; vOjg;gLtJ gLtJ gpd;tUtdtw; tUtdtw;Ws; Ws; vJ? vJ? 1) =sum(A2:A3)
2) =sum(B2:B3)
3) =sum(A2:B2)
4) =sum(A3:B3)
fPNo No jug;gl; gl;ltw; ltw;iwf; iwf; fUJf: fUJf:
A
B average(A1,D5) NkYs;stw; stw;Ws; Ws; rupahd rupahd tpupjhs; rhu; rhu;Gfs; Gfs;(function) vit? –
average (A1:D5)
1) A, B khj;jpuk; jpuk;
C average(A1:D5, average(A1:D5, F5)
–
2) A, C khj;jpuk; jpuk;
–
3) B, C khj;jpuk; jpuk;
4) A, B, C khj;jpuk; jpuk;
fPNo No jug;gl; gl;l tpupjhs; gFjpapy; gFjpapy; fyk; fyk; A4 ,y; =$A2+A3 vDk; R+j;jpuk; jpuk; ( (formula) fhzg;gLfpd; gLfpd;wJ. ,r;R+j; R+j;jpuj; jpuj;ijf; ijf; fyk; fyk; B4 ,w;F efy; nra; nra;jhy; jhy;, fyk; B4 ,y; fhl;rpg; rpg;gLj; gLj;jg;gLk; gLk; ngWkhdk; ngWkhdk; ahJ? 1) 5 2) 7
2) 6 4) 8
,yq;ifapYs; ifapYs;s elkhLk; njhiyj; njhiyj;njhlu; njhlu;Gfspd; Gfspd; vz; vz;zpf;ifiaAk; ifiaAk; mjw; mjw;Fupa tiuglj;ijAk; ijAk; nfhz;Ls; s fPNo No fhl;lg; lg;gl; gl;l tpupjhisf; fUJf. fUJf.
Tiuglj;jpy; ( (chart) X, Y mr;RfSf; RfSf;Fupa Fupa rupahd fytPrRfisg; R ; fisg; gpd; gpd;tUtdtw; tUtdtw;Ws; Ws; vJ vJ Fwpj;Jf; Jf; fhl;Lfpd; Lfpd;wJ? wJ? 1) X=B1:B7, Y=C1:C7
2) X=B3:B6, Y=C3:C6
3) X=B2:C7, Y=C2:B7
4) X=C3:C6, Y=B3:B6
gpd;tUk; tUk; tpupjhs; tpupjhs; $wpd; $wpd; fyr; fyr; fl; fl;Lthd;(cell pointer ) jw;NghJ NghJ fyk; A1 ,y; ,Uf; ,Uf;fpd; fpd;wnjdf; wnjdf; nfhs; nfhs;f. f. rhtpr; Nrukhdk; Nrukhdk; Ctrl+ I mOj;Jtjd; Jtjd; %yk; %yk; fyr; fyr; fl; fl;Lthid Lthid Neubahff; fyk; fyk; D1 ,w;F mirf;fyhk; fyhk;. fyf; fl; fl;Lthidf; Lthidf; fyk; fyk; D1 ,ypUe;J fyk D6w;F Neubahf mirg;gjw; gjw;fhd fhd rhtp my;yJ yJ rhtpr; Nru; Nru;khdk; ahJ? 1) Ctrl +
2) Ctrl + End
3) End +
4) PgDn
2|ILM.irfan
G 10||Competency7
learnbyself.com
xU tpupjhspy; R+j;jpuk; =B2*C2 I tptupf;Fk; kpfg; nghUj;jkhd $w;iwj; njupe;njLf;f 1) 2) 3) 4)
fyk; B2 ,d; cs;slf;fk; fyk; C2 ,d; cs;slf;fj;Jld; $l;lg;gLfpd;wJ fyk; B2 ,d; cs;slf;fk; fyk; C2 ,d; cs;slf;fj;jpdhy tFf;fg;gLfpd;wJ fyk; B2 ,d; cs;slf;fk; fyk; C2 ,d; cs;slf;fj;jpdhy; ngUf;fg;gLfpd; wJ. fyk; C2 ,d; cs;slf;fk; fyk; C2 ,d; cs;slf;fj;jpypUe;J fopf;fg;gLfpd; wJ.
A1 njhlf;fk; A7 tiuAs;s tPr;rpy; vz;rhu; ngWkhdq;fisf; nfhz;l fyq;fspd; nkhj;j vz;zpf;ifia toq;Ftjw;Fj; jug;gl;Ls;s tpupjhs; $wpy; ,Uf;Fk; fyk; A8 ,y; gpd;tUk; ve;jr; R+j;jpuj;ij (formula) Eioj;jy; Ntz;Lk;? 1) =count (A1:A7) 3) =min(A1:A7)
2) =max(A1:A7) 4) =sum(A1:A7)
gpd;tUtdtw;iwf; fUJf
A
–
E$S$
B - $E$5
C - $5E$
D E$5 –
Nkw;Fwpj;jtw;wpy; vit xU tpupjhspy;(spreadsheet) cs;s fy(cell) Kftupfspd; rupahd tbtk;/tbtq;fs; 1) B khj;jpuk;
2) A, C Mfpad
3) B, D Mfpad
4) Nkw;Fwpj;jtw;wpy; vJTkd;W
tpupjhspd; xU epiuapdJk; xU epuypdJk; ,ilntl;Lf;F toq;Fk; ngau; 1) gzpj;jhs;(worksheet)
2) milahs Kfg;G(label)
3) fyk;
4) r+j;jpuk;
. ,t;TUtpy; fyk; D2 ,y; cs;s R+j;jpuk; =$B$2+C2 Mf mike;Jk; mJ fyk; D3 apDs;Ns gpujp nra;ag;gl;Lk; ,Ug;gpd;, tU tpisT ahJ? 1) 2) 3) 4)
9 10 11 12 I
fk;gdpnahd;wpYs;s mikaj;jpw;Fupa Ntiyahl;fspd; mf;Nlhgu; khjf; nfhLg;gdTfisj; jahu; nra;tjw;fhd rk;gs tptug;gl;baypd; khjpup fPNoAs;s tpupjhs;(spreadsheet) nkd;nghUspd; gzpj;jhspy; jug;gl;Ls;sJ
Ntiyahs; xUtupd; khjhe;jf; nfhLg;gdit(monthly payment) mk;khjj;jpd; tuit(attendance) ehshe;jf; nfhLg;gdtpdhy; (daily rates) ngUf;Ftjd; %yk; fzpf;fg;gLk;. Employee Number E0001I cila Ntiyahspd; mf;Nlhgu; khjj;jpw;fhd khjf; nfhLg;gditf; fhl;rpg;gLj;Jtjw;F fyk; E2 ,y; vOjg;glNtz;ba R+j;juj;ij vOJf. i
3|ILM.irfan
G 10||Competency7
learnbyself.com
ii
Vida Ntiyahl;fspd; mf;Nlhgu; khjj;Jf;fhd rkgsf; nfhL;gg ; dTfisf; fzpg;gpLtjw;Fj; Njitahd gbKiwfs; fPNo jug;gl;Ls;sd. fyk; ..B ..C
A
Ij; njupTnra;f ,w;Fupa glTU(icon) ,d; Nky; nrhLf;Ff . ,ypUe;J D .. tiuahd fytPrr ; pidj; njupT nra;f E ..,w;Fupa glTUtpd; Nky; nrhLf;Ff. A E tiu Kfg;G milahskplg;gw;wpw;Fr; rupahd gjq;fis fPNo jug;gl;l gl;baypypUe;J njupT nra;f. Gjq;fspd; gl;bay; xl;Ljy;(Paste), ntl;Ljy;(cut), gpujp vLj;jy; (copy), E3, E2, E151 ……
…
……
…
…
…
……
……
…
…
–
midj;J Ntiyahl;fSf;Fk; khjhe;j cgfhuf; nfhLg;gdT ( bonus) toq;fg;gLfpd; wJ. mf;Nlhgu; khjj;jpw;fhd cghuf; nfhLg;gdTr; rjtPjk;(Bonus Rate) fyk; G2 tpy; jug;gl;Ls;sJ. Monthly Payment I Bonus Rate ,dhy; ngUf;Ftjd; %yk; cgfhuf; nfhLg;gdT msT fzpf;fg;gLk;. Vida Ntiyahl;fSf;Fupa cgfhuf; nfhLg;gdTfs; ,r;R+j;jpuj;ij Vida fyq;fSf;F gpujpnra;tjd; %yk; fzpf;fg; gLk; vdf; fUj;jpw; nfhz;L Employee Number E001 I cila Ntiyahspd; cgfhuf; nfhLg;gdit fyk; F2 ,y; fhl;rpg;gLj;Jtjw;Fupa R+j;jpuj;ij vOJf. iii
NkNy (iii) ,y; vOjg;gl;l R+j;jpuj;ij fyk; F3 ,y; gpujpnra;J Employee Number E002 ,d; cgfhuf; nfhLg;gditf; fzpg;gjw;fhd R+j;jpuj;ij vOJf. iv
fPNo fhl;lg;gl;Ls;s tpupjhs;, mfpyhtpdhy; Gj;jff; filnahd;wpypUe;J nfhs;tdT nra;ag;gl;l nghUl;fspd; tpiyg;gl;baiyf; fhl;Lfpd;wJ.
nfhs;tdT nra;ag;gl;l ePyg;Ngidfspd; (Blue Pen) ngWkjpiaf; fzpg;gjw;Ff; fyk; E3 ,y; gad;gLj;jpa rupahd R+j;jpuj;ij vOJf. i
fyk; E3 ,Ys;s Rj;jpuj;jidf; fyq;fs; E4 ,ypUe;J E8 tiu efy; nra;tw;fhd gbKiwfs; fPNo fhl;lg;gl;Ls;sd: ii
fyr;Rl;Lthid (cell pointer ) fyk; .A ,w;Ff; nfhz;L nry;f Rl;bapid (mouse pointer ) fyj;jpd; mbapy; .B %iyf;F mjd; FwpaPL + Mf khWk; tiu efu;j;Jf Rl; ;bapd; ,lJ nghj;jhid (left mouse button) mOj;jpagb Rl;Lthid fy Kftup C .tiu ,Of;fTk; (drag) Kfg;G milahsq;fs; A, b, C ,w;Fupa rupahd gjq;fis vOJf. ……
……
……
……
……
…
tpiyg;gl;baypYs;s nkhj;j ngWkhdj;ijf; fzpg;gjw;F tpupjhspYs;s jdpr; rhu;gpid ( function) fyk; E9 ,y; vOJf. iii
tpupjhspy; epuy; C ,Ys;s myFg; ngWkjpf;Nfw;g kpfTk; tpiy$ba nghUisf; fz;lwptw;fhd rhugpid vOJf. iv
mfpyh ,uz;L Nfhg;G ml;ilfisf;(file cover ) nfhs;tdT nra;jhs;. fyk; D7 ,y; jtWjyhf 0 vd vOjg;gl;Ls;sJ. rupahd ngWkjpiaf; fyk; D7 ,y; cs;sL P nra;tjhy; jhdhfNt ,w;iwg;gLj;jg;gLk; (automatically updated) fyq;fspd; Kftupfis vOJf. v
4|ILM.irfan
G 10||Competency7
learnbyself.com
kUe;J tpiy njhlughf ntspaplg;gl;l xU nra;jpj;jhs; tpsk;guj;jpw;Nfw;gj; jahupf;fg;gl;l gpd;tUk; gzpj;jhisf; fUJf.
i
Ie;J tif kUe;Jfspy; ,U tpiyfis kUe;jpd; ngaUld; fhl;Ltjw;F tpupjhs; nkd;nghUspy; fpilf;Fk; kpfTk; nghUj;jkhd Nfhl;Lg;gl (chart type) tifiaj; njuptpf;f gurpw;wNkhypd; tpiy NtWghl;ilf; fyk; D4 ,y; fhl;lj; Njitahd R+j;jpuj;ij vOJf. (tpiy NtWghL = tuj;jfg; ngaupd; tpiy kUe;Jg; ngaupd; tpiy) ii
–
fyk; D4 ,y; Eiof;fg;gl;l R+j;jpuj;ij fyk; D5 ,y; gpujpnra;jhy;, mr;R+j;jpuk; fyk; D5 ,y; vq;qdk; Njhd;Wk;? iii)
D4, D5, D6, D7, D8 Mfpa fyq;fspy; tpiy NtWghLfsp Fwpf;fgl;bUf;fpd;wdntdf; nfz;L. Ie;J tif kUe;JfspdJk; tpiy NtWghLfspd; nkhj;jj;ijf; fzpg;gjw;fhd R+j;jpuj;ijf; fyk; D9 ,y; vOJf. ckJ tpilapy; rhu;G SUM Ig; gad;gLj;jyhk;. iv