1|ILM.irfan
G 10||Competency7
learnbyself.com
Information Communication Technology MC Plus Nintavur
Unit Test
Grade - 10
Competency - 07 gFjp I
Time: 1 hour
1k; kw;Wk; 2k; tpdhf;fs; fPNo jug;gl;;l tpujhs; gFjpia mbg;gilahff; nfhz;lit. 1) =$A$2 + A3 vDk; R+j;jpuj;jpid fyk; (Cell) A4 nfhz;Ls;sJ. ,r;R+j;jpuk; fyk; A5 w;Fg; gpujp nra;ag;gl;lhy; fhl;rpg;gLj;jg;gLk; ngWkhdk; ahJ? 1) 2 3) 6
2) 4 4) 8
2) fyk; C2 tpy; =sum(A2:B2) vDk;; R+j;jpuk; vOjg;gl;Ls;sJ. fyk; C2 ,Ys;s R+j;jpuj;jpk; fyk; C3w;Fg; gpujp nra;ag;gl;lhy; fyk; C3 ,y; vOjg;gLtJ gpd;tUtdtw;Ws; vJ? 1) =sum(A2:A3)
2) =sum(B2:B3)
3) =sum(A2:B2)
4) =sum(A3:B3)
3) fPNo jug;gl;ltw;iwf; fUJf: A – average (A1:D5) B – average(A1,D5) NkYs;stw;Ws; rupahd tpupjhs; rhu;Gfs;(function) vit? 1) A, B khj;jpuk;
2) A, C khj;jpuk;
C – average(A1:D5, F5)
3) B, C khj;jpuk;
4) A, B, C khj;jpuk;
4) fPNo jug;gl;l tpupjhs; gFjpapy; fyk; A4 ,y; =$A2+A3 vDk; R+j;jpuk; (formula) fhzg;gLfpd;wJ. ,r;R+j;jpuj;ijf; fyk; B4 ,w;F efy; nra;jhy;, fyk; B4 ,y; fhl;rpg;gLj;jg;gLk; ngWkhdk; ahJ? 1) 5 2) 7
2) 6 4) 8
5) ,yq;ifapYs;s elkhLk; njhiyj;njhlu;Gfspd; vz;zpf;ifiaAk; mjw;Fupa tiuglj;ijAk; nfhz;Ls;s fPNo fhl;lg;gl;l tpupjhisf; fUJf.
Tiuglj;jpy; (chart) X, Y mr;RfSf;Fupa rupahd fytPr;Rfisg; gpd;tUtdtw;Ws; vJ Fwpj;Jf; fhl;Lfpd;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
6) gpd;tUk; tpupjhs; $wpd; fyr; fl;Lthd;(cell pointer) jw;NghJ fyk; A1 ,y; ,Uf;fpd;wnjdf; nfhs;f. rhtpr; Nrukhdk; Ctrl+ I mOj;Jtjd; %yk; fyr; fl;Lthid Neubahff; fyk; D1 ,w;F mirf;fyhk;. fyf; fl;Lthidf; fyk; D1 ,ypUe;J fyk D6w;F Neubahf mirg;gjw;fhd rhtp my;yJ rhtpr; Nru;khdk; ahJ? 1) Ctrl +
2) Ctrl + End
3) End +
4) PgDn
2|ILM.irfan
G 10||Competency7
learnbyself.com
7). 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.
8). 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)
10). 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
11). 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;
12). ,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
gFjp I 01) 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
A
B
C
D
E
F
G
i) 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.
3|ILM.irfan
G 10||Competency7
learnbyself.com
ii) Vida Ntiyahl;fspd; mf;Nlhgu; khjj;Jf;fhd rkgsf; nfhL;g;gdTfisf; fzpg;gpLtjw;Fj; Njitahd gbKiwfs; fPNo jug;gl;Ls;sd. fyk; ……A……Ij; njupTnra;f …..B…… ,w;Fupa glTU(icon) ,d; Nky; nrhLf;Ff …..C…. ,ypUe;J ……D….. tiuahd fytPr;rpidj; 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 iii) 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. iv) 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. 2) 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.
i) 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. ii) 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: 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. iii) tpiyg;gl;baypYs;s nkhj;j ngWkhdj;ijf; fzpg;gjw;F tpupjhspYs;s jdpr; rhu;gpid (function) fyk; E9 ,y; vOJf. iv) tpupjhspy; epuy; C ,Ys;s myFg; ngWkjpf;Nfw;g kpfTk; tpiy$ba nghUisf; fz;lwptw;fhd rhugpid vOJf. v) 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;sPL nra;tjhy; jhdhfNt ,w;iwg;gLj;jg;gLk; (automatically updated) fyq;fspd; Kftupfis vOJf.
4|ILM.irfan
G 10||Competency7
learnbyself.com
3) 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 ii) 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) iii) 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;? iv) 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;.