NIOS Class 10 Question Paper 2023 Data Entry Operations

This Question Paper consists of 8 questions and 8 printed pages.
Bg àíZ-nÌ ‘| 8 àíZ VWm 8 ‘w{ÐV n¥ð> h¢& Code No.
65/AS/3
u
H$moS> Z§0
Roll No.
Set / goQ>
AZwH$« ‘m§H$

DATA ENTRY OPERATIONS
S>mQ>m E§Q´>r Am°naoeÝg
(229)
Day and Date of Examination .....................................................................................
(narjm H$m {XZ d {XZm§H$)
Signature of Invigilators 1. .....................................................................................
({ZarjH$m| Ho$ hñVmja)
2. .....................................................................................
General Instructions :
1. Candidate must write his/her Roll Number on the first page of the Question
Paper.
2. Please check the Question Paper to verify that the total pages and total
number of questions contained in the Question Paper are the same as those
printed on the top of the first page. Also check to see that the questions are
in sequential order.
3. All the questions are to be answered within the allotted time.
4. Making any identification mark in the Answer-Book or writing Roll Number
anywhere other than the specified places will lead to disqualification of the
candidate.
5. Write your Question Paper Code No. 65/AS/3, Set u on the Answer-Book.
6. (a) The Question Paper is in English/Hindi medium only. However, if you
wish, you can answer in any one of the languages listed below :
English, Hindi, Urdu, Punjabi, Bengali, Tamil, Malayalam, Kannada,
Telugu, Marathi, Odia, Gujarati, Konkani, Manipuri, Assamese, Nepali,
Kashmiri, Sanskrit and Sindhi.
You are required to indicate the language you have chosen to answer in
the box provided in the Answer-Book.
(b) If you choose to write the answer in the language other than Hindi and
English, the responsibility for any errors/mistakes in understanding the
questions will be yours only.

229/AS/3/410A [ P.T.O.

gm‘mݶ AZwXoe …
1. narjmWu àíZ-nÌ Ho$ nhbo n¥ð> na AnZm AZwH«$‘m§H$ Adí¶ {bI|&
2. H¥$n¶m àíZ-nÌ H$mo Om±M b| {H$ àíZ-nÌ Ho$ Hw$b n¥ð>m| VWm àíZm| H$s CVZr hr g§»¶m h¡ {OVZr àW‘ n¥ð> Ho$ g~go
D$na N>nr h¡& Bg ~mV H$s Om±M ^r H$a b| {H$ àíZ H«${‘H$ ê$n ‘| h¢&
3. g^r àíZm| Ho$ CÎma {ZYm©[aV Ad{Y Ho$ ^rVa hr XoZo h¢&
4. CÎma-nwpñVH$m ‘| nhMmZ-{M• ~ZmZo AWdm {Z{X©ï> ñWmZm| Ho$ A{V[aº$ H$ht ^r AZwH«$‘m§H$ {bIZo na narjmWu H$mo
A¶mo½¶ R>ham¶m OmEJm&
5. AnZr CÎma-nwpñVH$m na àíZ-nÌ H$m H$moS> Z§0 65/AS/3, goQ u {bI|&
6. (H$) n«íZ-nÌ Ho$db {hÝXr/A§J«oOr ‘| h¡& {’$a ^r, ¶{X Amn Mmh| Vmo ZrMo Xr JB© {H$gr EH$ ^mfm ‘| CÎma Xo
gH$Vo h¢ …
A§J«oOr, {hÝXr, CXÿ©, n§Om~r, ~§Jbm, V{‘b, ‘b¶mb‘, H$Þ‹S>, VobwJy, ‘amR>r, C{‹S>¶m, JwOamVr, H$m|H$Ur,
‘{Unwar, Ag{‘¶m, Zonmbr, H$í‘rar, g§ñH¥$V Am¡a {gÝYr&
H¥$n¶m CÎma-nwpñVH$m ‘| {XE JE ~m°³g ‘| {bI| {H$ Amn {H$g ^mfm ‘| CÎma {bI aho h¢&
(I) ¶{X Amn {hÝXr Ed§ A§J«oOr Ho$ A{V[aº$ {H$gr Aݶ ^mfm ‘| CÎma {bIVo h¢, Vmo àíZm| H$mo g‘PZo ‘| hmoZo dmbr
Ìw{Q>¶m|/Jb{V¶m| H$s {Oå‘oXmar Ho$db AmnH$s hmoJr&

229/AS/3/410A 2

DATA ENTRY OPERATIONS
S>mQ>m E§Q´>r Am°naoeÝg
(229)
Time : 2 Hours ] [ Maximum Marks : 40
g‘¶ … 2 KÊQ>o ] [ nyUmªH$ … 40

Note : (i) All questions are compulsory.
(ii) Marks are indicated against each question.

{ZX}e … (i) g^r àíZ A{Zdm¶© h¢&
(ii) à˶oH$ àíZ Ho$ A§H$ CgHo$ gm‘Zo Xem©E JE h¢&

1. Match the following and write your answer in the Answer-book : ½×6=3
A B
(a) Control Unit (i) Spreadsheet/Excel
(b) Restore (ii) Starts with =
(c) Set of Instructions (iii) PowerPoint
(d) Formula (iv) Central Processing Unit
(e) Data Analysis (v) Recycle Bin
(f) Handout (vi) Program

{ZåZ Omo‹S>o {‘bmBE Am¡a CÎma AnZr CÎma-nwpñVH$m ‘| {b{IE :
A B

(H$) H§$Q´>mob ¶y{ZQ> (i) ñàoS>erQ>/Eo³gob
(I) [añQ>moa (dmng nmZm) (ii) = go ewê$ hmoVm h¡

(J) {ZX}em| H$m g‘yh (iii) nm°danm°B§Q>
(K) ’$m°‘y©bm (iv) g|Q´>b àmogoqgJ ¶y{ZQ>
(L>) S>mQ>m {díbofU (v) argmBH$b {~Z
(M) h¢S>AmCQ> (vi) àmoJ«m‘

229/AS/3/410A 3 [ P.T.O.

2. Write, in your Answer-Book, True/False for the following statements :
½×6=3
(a) To copy the item instead of moving it, we should press Alt key and
hold down while dragging it.

(b) Administrative tools are part of Windows Explorer.

(c) Pivot table allows you to perform data analysis.

(d) Barcode reader is just a specific type of image plotter.

(e) Print dialog box has many options such as printer name, paper size,
orientation, etc.

(f) You can add sound and animation effects in your slides while making
presentation.

{ZåZ H$WZm| Ho$ {bE AnZr CÎma-nwpñVH$m ‘| ghr/JbV {b{IE :

(H$) AmBQ>‘ H$mo ‘yd H$aZo Ho$ ~Om¶ Bgo H$m°nr H$aZo Ho$ {bE h‘ Alt Hw§$Or X~mVo h¢ Am¡a ItMZo
Ho$ gmW ZrMo X~mE aIVo h¢&

(I) EoS>{‘{ZñQ´>o{Q>d Qy>ëg qdS>moµO E³gßbmoaa H$m {hñgm h¡&

(J) nrdQ> Q>o~b AmnH$mo S>mQ>m {díbofU H$s AZw‘{V XoVm h¡&

(K) ~maH$moS> arS>a {g’©$ EH$ {d{eï> àH$ma H$m N>{d ßbm°Q>a h¡&

(L>) qàQ> S>m¶bm°J ~m°³g ‘| H$B© {dH$ën h¢ O¡go qàQ>a H$m Zm‘, nona gmBµO, Amo[aE§Q>oeZ, Am{X&

(M) Amn àoOoÝQ>oeZ V¡¶ma H$aVo g‘¶ ñbmBS>m| ‘| Üd{Z Am¡a Eo{Z‘oeZ B’o$³Q> Omo‹S> gH$Vo h¢&

3. Define the following : 1×4=4

(a) Workbook

(b) Source Program

(c) Control Panel

(d) Computer

229/AS/3/410A 4

{ZåZ H$mo n[a^m{fV H$s{OE :
(H$) dH©$~wH$
(I) gmog© àmoJ«m‘
(J) H§$Q´>mob n¡Zb
(K) H$å߶yQ>a

4. Write short notes on the following : 2×4=8

(a) Assembly Language

(b) Font Face

(c) Duplicating Selected Slide

(d) Read Only Protection

{ZåZ na g§{já {Q>ßn{U¶m± {b{IE :
(H$) Agoå~br ^mfm
(I) µ’$mÝQ> µ’o$g
(J) M¶{ZV ñbmBS> H$mo S>çypßbHo$Q> H$aZm
(K) arS> AmoÝbr gwajm

5. Differentiate between the following : 2×2=4

(a) Design Template and Blank Presentation

(b) Save and Save As

{ZåZ Ho$ ~rM A§Va ñnï> H$s{OE :
(H$) {S>µOmBZ Q>oånboQ> Am¡a ãb¢H$ àoOoÝQ>oeZ
(I) god Am¡a god EoµO

229/AS/3/410A 5 [ P.T.O.

6. Answer the following questions : 2×5=10

(a) Write the steps to rename the folder.

(b) Explain the concept of highlight colour and text colour.

(c) What option we get when we print the PowerPoint file?

(d) Write the formula elements.

(e) Briefly explain the following :
(i) Main document
(ii) Data source

{ZåZ àíZm| Ho$ CÎma Xr{OE :
(H$) ’$moëS>a H$m Zm‘ ~XbZo Ho$ {bE ñQ>oßg {b{IE&
(I) hmB©bmBQ> H$ba Ed§ Q>o³ñQ> H$ba H$s AdYmaUm H$mo g‘PmBE&
(J) O~ h‘ nm°danm°B§Q> ’$mBb qàQ> H$aVo h¢, Vmo h‘| H$m¡Z-go {dH$ën {‘bVo h¢>?
(K) ’$m°‘y©bm E{b‘|Q²>g {b{IE&
(L>) g§jon ‘| {ZåZ{b{IV H$s ì¶m»¶m H$s{OE :
(i) ‘w»¶ XñVmdoO
(ii) S>mQ>m gmog©

7. Answer the following : 2×2=4

(a) Write the steps to copy the text to the Clipboard.

(b) In a Word document, which shortcut keys are pressed to do the
following actions?
(i) To activate Format Painter
(ii) To make a word Underlined
(iii) To insert Page Break
(iv) To apply Indent

229/AS/3/410A 6

{ZåZ Ho$ CÎma Xr{OE :
(H$) p³bn~moS>© na Q>o³ñQ> H$s H$m°nr H$aZo Ho$ {bE ñQ>oßg {b{IE :
(I) EH$ dS>© XñVmdoO ‘|, {ZåZ{b{IV H$m¶m] H$mo H$aZo Ho$ {bE X~m¶r OmZo dmbr em°Q>©H$Q> Hw§${O¶m|
H$mo {b{IE :
(i) ’$m°‘}Q> n|Q>a H$mo g{H«$¶ H$aZm
(ii) eãX Ho$ ZrMo bmBZ ItMZm
(iii) noO ~«oH$ BÝgQ>© H$aZm
(iv) B§S>|Q> AßbmB© H$aZm

8. Answer the following : 2×2=4

(a) Write the formulas to calculate the following based on the data given
in the spreadsheet as shown below :
A B C D E
1 Teacher’s Name Department Salary Tax Net Salary
2 Naveen Computer 22,000 — —
3 Chetna History 20,000 — —
4 Sandeep Maths 30,000 — —
5 Sanghmitra Science 25,000 — —
6 Rudraksh Maths 40,000 — —
7 Neeraj Computer 28,000 — —
8 — — — — —

(i) To calculate the tax which is 8% of the salary in D2 and copy it
up to D7.

(ii) To calculate the net salary which is (Salary – Tax) in cell E2 and
copy it up to E7.

(iii) To print the total net salary paid in cell E8.

(iv) To print the average salary of teachers in cell C8.

(b) Write the steps to add password to this workbook.

229/AS/3/410A 7 [ P.T.O.

{ZåZ àíZm| Ho$ CÎma Xr{OE :
(H$) Xr JB© ñàoS>erQ> Ho$ S>mQ>m Ho$ AmYma na {ZåZ H$s JUZm H$aZo Ho$ {bE ’$m°‘y©bm {b{IE :
A B C D E

1 Q>rMa H$m Zm‘ {S>nmQ>©‘|Q> doVZ Q>¡³g Hw$b doVZ
2 ZdrZ H$å߶yQ>a 22,000 — —
3 MoVZm {hñQ´>r 20,000 — —

4 g§Xrn ‘¡Ïg 30,000 — —
5 g§K{‘Ìm gmB§g 25,000 — —
6 éÐmj ‘¡Ïg 40,000 — —
7 ZraO H$å߶yQ>a 28,000 — —
8 — — — — —

(i) g¡b D2 ‘| Q>¡³g H$s JUZm H$aZo Ho$ {bE Omo doVZ H$m 8% h¡, Am¡a Bgo D7 VH$ H$m°nr
H$s{OE&
(ii) g¡b E2 ‘| Hw$b doVZ H$s JUZm H$aZo Ho$ {bE Omo (doVZ – Q>¡³g) h¡ Am¡a Bgo E7 VH$
H$m°nr H$s{OE&
(iii) g¡b E8 ‘| Hw$b doVZ H$m ¶moJ qàQ> H$s{OE&
(iv) g¡b C8 ‘| g^r Q>rMam| H$m Am¡gV doVZ qàQ> H$s{OE&

(I) Bg dH©$~wH$ ‘| nmgdS>© EoS> H$aZo Ho$ ñQ>oßg {b{IE&

  

229/AS/3/410A [V23] 8

This Question Paper consists of 8 questions and 8 printed pages.
Bg àíZ-nÌ ‘| 8 àíZ VWm 8 ‘w{ÐV n¥ð> h¢& Code No.
65/AS/3
v
H$moS> Z§0
Roll No.
Set / goQ>
AZwH$« ‘m§H$

DATA ENTRY OPERATIONS
S>mQ>m E§Q´>r Am°naoeÝg
(229)
Day and Date of Examination .....................................................................................
(narjm H$m {XZ d {XZm§H$)
Signature of Invigilators 1. .....................................................................................
({ZarjH$m| Ho$ hñVmja)
2. .....................................................................................
General Instructions :
1. Candidate must write his/her Roll Number on the first page of the Question
Paper.
2. Please check the Question Paper to verify that the total pages and total
number of questions contained in the Question Paper are the same as those
printed on the top of the first page. Also check to see that the questions are
in sequential order.
3. All the questions are to be answered within the allotted time.
4. Making any identification mark in the Answer-Book or writing Roll Number
anywhere other than the specified places will lead to disqualification of the
candidate.
5. Write your Question Paper Code No. 65/AS/3, Set v on the Answer-Book.
6. (a) The Question Paper is in English/Hindi medium only. However, if you
wish, you can answer in any one of the languages listed below :
English, Hindi, Urdu, Punjabi, Bengali, Tamil, Malayalam, Kannada,
Telugu, Marathi, Odia, Gujarati, Konkani, Manipuri, Assamese, Nepali,
Kashmiri, Sanskrit and Sindhi.
You are required to indicate the language you have chosen to answer in
the box provided in the Answer-Book.
(b) If you choose to write the answer in the language other than Hindi and
English, the responsibility for any errors/mistakes in understanding the
questions will be yours only.

229/AS/3/410B [ P.T.O.

gm‘mݶ AZwXoe …
1. narjmWu àíZ-nÌ Ho$ nhbo n¥ð> na AnZm AZwH«$‘m§H$ Adí¶ {bI|&
2. H¥$n¶m àíZ-nÌ H$mo Om±M b| {H$ àíZ-nÌ Ho$ Hw$b n¥ð>m| VWm àíZm| H$s CVZr hr g§»¶m h¡ {OVZr àW‘ n¥ð> Ho$ g~go
D$na N>nr h¡& Bg ~mV H$s Om±M ^r H$a b| {H$ àíZ H«${‘H$ ê$n ‘| h¢&
3. g^r àíZm| Ho$ CÎma {ZYm©[aV Ad{Y Ho$ ^rVa hr XoZo h¢&
4. CÎma-nwpñVH$m ‘| nhMmZ-{M• ~ZmZo AWdm {Z{X©ï> ñWmZm| Ho$ A{V[aº$ H$ht ^r AZwH«$‘m§H$ {bIZo na narjmWu H$mo
A¶mo½¶ R>ham¶m OmEJm&
5. AnZr CÎma-nwpñVH$m na àíZ-nÌ H$m H$moS> Z§0 65/AS/3, goQ v {bI|&
6. (H$) n«íZ-nÌ Ho$db {hÝXr/A§J«oOr ‘| h¡& {’$a ^r, ¶{X Amn Mmh| Vmo ZrMo Xr JB© {H$gr EH$ ^mfm ‘| CÎma Xo
gH$Vo h¢ …
A§J«oOr, {hÝXr, CXÿ©, n§Om~r, ~§Jbm, V{‘b, ‘b¶mb‘, H$Þ‹S>, VobwJy, ‘amR>r, C{‹S>¶m, JwOamVr, H$m|H$Ur,
‘{Unwar, Ag{‘¶m, Zonmbr, H$í‘rar, g§ñH¥$V Am¡a {gÝYr&
H¥$n¶m CÎma-nwpñVH$m ‘| {XE JE ~m°³g ‘| {bI| {H$ Amn {H$g ^mfm ‘| CÎma {bI aho h¢&
(I) ¶{X Amn {hÝXr Ed§ A§J«oOr Ho$ A{V[aº$ {H$gr Aݶ ^mfm ‘| CÎma {bIVo h¢, Vmo àíZm| H$mo g‘PZo ‘| hmoZo dmbr
Ìw{Q>¶m|/Jb{V¶m| H$s {Oå‘oXmar Ho$db AmnH$s hmoJr&

229/AS/3/410B 2

DATA ENTRY OPERATIONS
S>mQ>m E§Q´>r Am°naoeÝg
(229)
Time : 2 Hours ] [ Maximum Marks : 40
g‘¶ … 2 KÊQ>o ] [ nyUmªH$ … 40

Note : (i) All questions are compulsory.
(ii) Marks are indicated against each question.

{ZX}e … (i) g^r àíZ A{Zdm¶© h¢&
(ii) à˶oH$ àíZ Ho$ A§H$ CgHo$ gm‘Zo Xem©E JE h¢&

1. Match the following and write your answer in the Answer-book : ½×6=3
A B
(a) Formula (i) Central Processing Unit
(b) Restore (ii) Starts with =
(c) Set of instructions (iii) PowerPoint
(d) Data Analysis (iv) Recycle Bin
(e) Handout (v) Program
(f) Control Unit (vi) Spreadsheet/Excel

{ZåZ Omo‹S>o {‘bmBE Am¡a CÎma AnZr CÎma-nwpñVH$m ‘| {b{IE :
A B

(H$) ’$m°‘y©bm (i) g|Q´>b àmogoqgJ ¶y{ZQ>
(I) [añQ>moa (ii) = go ewê$ hmoVm h¡

(J) {ZX}em| H$m g‘yh (iii) nm°danm°B§Q>
(K) S>mQ>m {díbofU (iv) argmBH$b {~Z
(L>) h¢S>AmCQ> (v) àmoJ«m‘
(M) H§$Q´>mob ¶y{ZQ> (vi) ñàoS>erQ>/Eo³gob

229/AS/3/410B 3 [ P.T.O.

2. Write, in your Answer-Book, True/False for the following statements :
½×6=3
(a) Pivot table allows you to perform data analysis.

(b) Barcode reader is just a specific type of image plotter.

(c) To copy the item instead of moving it, we should press Alt key and
hold down while dragging it.

(d) Administrative tools are part of Windows Explorer.

(e) Print dialog box has many options such as printer name, paper size,
orientation, etc.

(f) You can add sound and animation effects in your slides while making
presentation.

{ZåZ H$WZm| Ho$ {bE AnZr CÎma-nwpñVH$m ‘| ghr/JbV {b{IE :

(H$) nrdQ> Q>o~b AmnH$mo S>mQ>m {díbofU H$s AZw‘{V XoVm h¡&

(I) ~maH$moS> arS>a {g’©$ EH$ {d{eï> àH$ma H$m N>{d ßbm°Q>a h¡&

(J) AmBQ>‘ H$mo ‘yd H$aZo Ho$ ~Om¶ Bgo H$m°nr H$aZo Ho$ {bE h‘ Alt Hw§$Or X~mVo h¢ Am¡a ItMZo
Ho$ gmW ZrMo X~mE aIVo h¢&

(K) EoS>{‘{ZñQ´>o{Q>d Qy>ëg qdS>moµO E³gßbmoaa H$m {hñgm h¡&

(L>) qàQ> S>m¶bm°J ~m°³g ‘| H$B© {dH$ën h¢ O¡go qàQ>a H$m Zm‘, nona gmBµO, Amo[aE§Q>oeZ, Am{X&

(M) Amn àoOoÝQ>oeZ V¡¶ma H$aVo g‘¶ ñbmBS>m| ‘| Üd{Z Am¡a Eo{Z‘oeZ B’o$³Q> Omo‹S> gH$Vo h¢&

3. Define the following : 1×4=4

(a) Software

(b) Laser Printer

(c) Workbook

(d) Control Panel

229/AS/3/410B 4

{ZåZ H$mo n[a^m{fV H$s{OE :
(H$) gm°âQ>do¶a
(I) boµOa qàQ>a
(J) dH©$ ~wH$
(K) H§$Q´>mob n¡Zb

4. Write short notes on the following : 2×4=8

(a) Read Only Protection

(b) Duplicating Selected Slide

(c) Highlight Colour

(d) Operating System

{ZåZ na g§{já {Q>ßn{U¶m± {b{IE :
(H$) arS> AmoÝbr gwajm
(I) M¶{ZV ñbmBS> H$mo S>çypßbHo$Q> H$aZm
(J) hmB©bmBQ> H$ba
(K) Am°naoqQ>J {gñQ>‘

5. Differentiate between the following : 2×2=4

(a) Save and Save As

(b) Sentence Case and Title Case

{ZåZ Ho$ ~rM A§Va ñnï> H$s{OE :
(H$) god Am¡a god EoµO
(I) g|Q>|g Ho$g Am¡a Q>mBQ>b Ho$g

229/AS/3/410B 5 [ P.T.O.

6. Answer the following questions : 2×5=10

(a) Briefly explain the following :
(i) Main document
(ii) Data source

(b) What option we get when we print the PowerPoint file?

(c) Write the formula elements.

(d) Write the steps to delete the file.

(e) Explain the concept of highlight colour and text colour.

{ZåZ àíZm| Ho$ CÎma Xr{OE :
(H$) g§jon ‘| {ZåZ{b{IV H$s ì¶m»¶m H$s{OE :
(i) ‘w»¶ XñVmdoO
(ii) S>mQ>m gmog©
(I) O~ h‘ nm°danm°B§Q> ’$mBb qàQ> H$aVo h¢, Vmo h‘| H$m¡Z-go {dH$ën {‘bVo h¢>?
(J) ’$m°‘y©bm E{b‘|Q²>g {b{IE&
(K) ’$mBb H$mo {S>brQ> H$aZo Ho$ ñQ>oßg {b{IE&
(L>) hmB©bmBQ> H$ba Ed§ Q>o³ñQ> H$ba H$s AdYmaUm H$mo g‘PmBE&

7. Answer the following : 2×2=4

(a) In a Word document, which shortcut keys are pressed to do the
following actions?
(i) To activate Format Painter
(ii) To make a word Underlined
(iii) To insert Page Break
(iv) To apply Indent

(b) Write the steps to copy the text to the Clipboard.

229/AS/3/410B 6

{ZåZ Ho$ CÎma Xr{OE :
(H$) EH$ dS>© XñVmdoO ‘|, {ZåZ{b{IV H$m¶m] H$mo H$aZo Ho$ {bE X~m¶r OmZo dmbr em°Q>©H$Q> Hw§${O¶m|
H$mo {b{IE :
(i) ’$m°‘}Q> n|Q>a H$mo g{H«$¶ H$aZm
(ii) eãX Ho$ ZrMo bmBZ ItMZm
(iii) noO ~«oH$ BÝgQ>© H$aZm
(iv) B§S>|Q> AßbmB© H$aZm

(I) p³bn~moS>© na Q>o³ñQ> H$s H$m°nr H$aZo Ho$ {bE ñQ>oßg {b{IE :

8. Answer the following : 2×2=4

(a) Write the formulas to calculate the following based on the data given
in the spreadsheet as shown below :
A B C D E
1 Teacher’s Name Department Salary Tax Net Salary
2 Naveen Computer 22,000 — —
3 Chetna History 20,000 — —
4 Sandeep Maths 30,000 — —
5 Sanghmitra Science 25,000 — —
6 Rudraksh Maths 40,000 — —
7 Neeraj Computer 28,000 — —
8 — — — — —

(i) To calculate the tax which is 8% of the salary in D2 and copy it
up to D7.
(ii) To calculate the net salary which is (Salary – Tax) in cell E2 and
copy it up to E7.
(iii) To print the total net salary paid in cell E8.
(iv) To print the average salary of teachers in cell C8.

(b) Write the steps to add password to this workbook.

229/AS/3/410B 7 [ P.T.O.

{ZåZ àíZm| Ho$ CÎma Xr{OE :
(H$) Xr JB© ñàoS>erQ> Ho$ S>mQ>m Ho$ AmYma na {ZåZ H$s JUZm H$aZo Ho$ {bE ’$m°‘y©bm {b{IE :
A B C D E

1 Q>rMa H$m Zm‘ {S>nmQ>©‘|Q> doVZ Q>¡³g Hw$b doVZ
2 ZdrZ H$å߶yQ>a 22,000 — —
3 MoVZm {hñQ´>r 20,000 — —

4 g§Xrn ‘¡Ïg 30,000 — —
5 g§K{‘Ìm gmB§g 25,000 — —
6 éÐmj ‘¡Ïg 40,000 — —
7 ZraO H$å߶yQ>a 28,000 — —
8 — — — — —

(i) g¡b D2 ‘| Q>¡³g H$s JUZm H$aZo Ho$ {bE Omo doVZ H$m 8% h¡, Am¡a Bgo D7 VH$ H$m°nr
H$s{OE&
(ii) g¡b E2 ‘| Hw$b doVZ H$s JUZm H$aZo Ho$ {bE Omo (doVZ – Q>¡³g) h¡ Am¡a Bgo E7 VH$
H$m°nr H$s{OE&
(iii) g¡b E8 ‘| Hw$b doVZ H$m ¶moJ qàQ> H$s{OE&
(iv) g¡b C8 ‘| g^r Q>rMam| H$m Am¡gV doVZ qàQ> H$s{OE&

(I) Bg dH©$~wH$ ‘| nmgdS>© EoS> H$aZo Ho$ ñQ>oßg {b{IE&

  

229/AS/3/410B [V23] 8

This Question Paper consists of 8 questions and 8 printed pages.
Bg àíZ-nÌ ‘| 8 àíZ VWm 8 ‘w{ÐV n¥ð> h¢& Code No.
65/AS/3
w
H$moS> Z§0
Roll No.
Set / goQ>
AZwH$« ‘m§H$

DATA ENTRY OPERATIONS
S>mQ>m E§Q´>r Am°naoeÝg
(229)
Day and Date of Examination .....................................................................................
(narjm H$m {XZ d {XZm§H$)
Signature of Invigilators 1. .....................................................................................
({ZarjH$m| Ho$ hñVmja)
2. .....................................................................................
General Instructions :
1. Candidate must write his/her Roll Number on the first page of the Question
Paper.
2. Please check the Question Paper to verify that the total pages and total
number of questions contained in the Question Paper are the same as those
printed on the top of the first page. Also check to see that the questions are
in sequential order.
3. All the questions are to be answered within the allotted time.
4. Making any identification mark in the Answer-Book or writing Roll Number
anywhere other than the specified places will lead to disqualification of the
candidate.
5. Write your Question Paper Code No. 65/AS/3, Set w on the Answer-Book.
6. (a) The Question Paper is in English/Hindi medium only. However, if you
wish, you can answer in any one of the languages listed below :
English, Hindi, Urdu, Punjabi, Bengali, Tamil, Malayalam, Kannada,
Telugu, Marathi, Odia, Gujarati, Konkani, Manipuri, Assamese, Nepali,
Kashmiri, Sanskrit and Sindhi.
You are required to indicate the language you have chosen to answer in
the box provided in the Answer-Book.
(b) If you choose to write the answer in the language other than Hindi and
English, the responsibility for any errors/mistakes in understanding the
questions will be yours only.

229/AS/3/410C [ P.T.O.

gm‘mݶ AZwXoe …
1. narjmWu àíZ-nÌ Ho$ nhbo n¥ð> na AnZm AZwH«$‘m§H$ Adí¶ {bI|&
2. H¥$n¶m àíZ-nÌ H$mo Om±M b| {H$ àíZ-nÌ Ho$ Hw$b n¥ð>m| VWm àíZm| H$s CVZr hr g§»¶m h¡ {OVZr àW‘ n¥ð> Ho$ g~go
D$na N>nr h¡& Bg ~mV H$s Om±M ^r H$a b| {H$ àíZ H«${‘H$ ê$n ‘| h¢&
3. g^r àíZm| Ho$ CÎma {ZYm©[aV Ad{Y Ho$ ^rVa hr XoZo h¢&
4. CÎma-nwpñVH$m ‘| nhMmZ-{M• ~ZmZo AWdm {Z{X©ï> ñWmZm| Ho$ A{V[aº$ H$ht ^r AZwH«$‘m§H$ {bIZo na narjmWu H$mo
A¶mo½¶ R>ham¶m OmEJm&
5. AnZr CÎma-nwpñVH$m na àíZ-nÌ H$m H$moS> Z§0 65/AS/3, goQ w {bI|&
6. (H$) n«íZ-nÌ Ho$db {hÝXr/A§J«oOr ‘| h¡& {’$a ^r, ¶{X Amn Mmh| Vmo ZrMo Xr JB© {H$gr EH$ ^mfm ‘| CÎma Xo
gH$Vo h¢ …
A§J«oOr, {hÝXr, CXÿ©, n§Om~r, ~§Jbm, V{‘b, ‘b¶mb‘, H$Þ‹S>, VobwJy, ‘amR>r, C{‹S>¶m, JwOamVr, H$m|H$Ur,
‘{Unwar, Ag{‘¶m, Zonmbr, H$í‘rar, g§ñH¥$V Am¡a {gÝYr&
H¥$n¶m CÎma-nwpñVH$m ‘| {XE JE ~m°³g ‘| {bI| {H$ Amn {H$g ^mfm ‘| CÎma {bI aho h¢&
(I) ¶{X Amn {hÝXr Ed§ A§J«oOr Ho$ A{V[aº$ {H$gr Aݶ ^mfm ‘| CÎma {bIVo h¢, Vmo àíZm| H$mo g‘PZo ‘| hmoZo dmbr
Ìw{Q>¶m|/Jb{V¶m| H$s {Oå‘oXmar Ho$db AmnH$s hmoJr&

229/AS/3/410C 2

DATA ENTRY OPERATIONS
S>mQ>m E§Q´>r Am°naoeÝg
(229)
Time : 2 Hours ] [ Maximum Marks : 40
g‘¶ … 2 KÊQ>o ] [ nyUmªH$ … 40

Note : (i) All questions are compulsory.
(ii) Marks are indicated against each question.

{ZX}e … (i) g^r àíZ A{Zdm¶© h¢&
(ii) à˶oH$ àíZ Ho$ A§H$ CgHo$ gm‘Zo Xem©E JE h¢&

1. Match the following and write your answer in the Answer-book : ½×6=3
A B
(a) System Software (i) Display Storage Contents
(b) SYNTAX (ii) Predefined Formula
(c) My Computer (iii) Normal View
(d) Function (iv) Chart Components
(e) Adding Notes to Slide (v) ROM
(f) Tick marks & Legends (vi) Rules of computer language

{ZåZ Omo‹S>o {‘bmBE Am¡a CÎma AnZr CÎma-nwpñVH$m ‘| {b{IE :
A B

(H$) {gñQ>‘ gm°âQ>do¶a (i) ñQ>moaoO H§$Q>|Q²>g {S>gßbo H$aVm h¡
(I) qgQ>¡³g (ii) nyd© {S>’$mBZ {H$¶m J¶m ’$m°‘y©bm
(J) ‘mB© H$å߶yQ>a (iii) Zm°‘©b ì¶y
(K) ’§$³eZ (iv) MmQ>© H$ånmoZ|Q²>g
(L>) ñbmBS> ‘| ZmoQ²>g Omo‹S>Zm (v) am°‘ (ROM)
(M) {Q>H$ ‘mH©$ Am¡a boO|S> (vi) H$å߶yQ>a ^mfm Ho$ {Z¶‘

229/AS/3/410C 3 [ P.T.O.

2. Write, in your Answer-Book, True/False for the following statements :
½×6=3
(a) You can add sound and animation effects in your slides while making
presentation.

(b) Pivot table allows you to perform data analysis.

(c) Barcode reader is just a specific type of image plotter.

(d) To copy the item instead of moving it, we should press Alt key and
hold down while dragging it.

(e) Administrative tools are part of Windows Explorer.

(f) Print dialog box has many options such as printer name, paper size,
orientation, etc.

{ZåZ H$WZm| Ho$ {bE AnZr CÎma-nwpñVH$m ‘| ghr/JbV {b{IE :

(H$) Amn àoOoÝQ>oeZ V¡¶ma H$aVo g‘¶ ñbmBS>m| ‘| Üd{Z Am¡a Eo{Z‘oeZ B’o$³Q> Omo‹S> gH$Vo h¢&

(I) nrdQ> Q>o~b AmnH$mo S>mQ>m {díbofU H$s AZw‘{V XoVm h¡&

(J) ~maH$moS> arS>a {g’©$ EH$ {d{eï> àH$ma H$m N>{d ßbm°Q>a h¡&

(K) AmBQ>‘ H$mo ‘yd H$aZo Ho$ ~Om¶ Bgo H$m°nr H$aZo Ho$ {bE h‘ Alt Hw§$Or X~mVo h¢ Am¡a ItMZo
Ho$ gmW ZrMo X~mE aIVo h¢&

(L>) EoS>{‘{ZñQ´>o{Q>d Qy>ëg qdS>moµO E³gßbmoaa H$m {hñgm h¡&

(M) qàQ> S>m¶bm°J ~m°³g ‘| H$B© {dH$ën h¢ O¡go qàQ>a H$m Zm‘, nona gmBµO, Amo[aE§Q>oeZ, Am{X&

3. Define the following : 1×4=4

(a) Worksheet

(b) Control Panel

(c) Computer

(d) Source Program

229/AS/3/410C 4

{ZåZ H$mo n[a^m{fV H$s{OE :
(H$) dH©$erQ>
(I) H§$Q´>mob n¡Zb
(J) H$å߶yQ>a
(K) gmog© àmoJ«m‘

4. Write short notes on the following : 2×4=8

(a) Font Style

(b) Application Software

(c) Duplicating Selected Slide

(d) Read Only Protection

{ZåZ na g§{já {Q>ßn{U¶m± {b{IE :
(H$) µ’$mÝQ> ñQ>mBb
(I) EopßbHo$eZ gm°âQ>do¶a
(J) M¶{ZV ñbmBS> H$mo S>çypßbHo$Q> H$aZm
(K) arS> AmoÝbr gwajm

5. Differentiate between the following : 2×2=4

(a) Save and Save As

(b) Design Template and Blank Presentation

{ZåZ Ho$ ~rM A§Va ñnï> H$s{OE :
(H$) god Am¡a god EoµO
(I) {S>µOmBZ Q>oånboQ> Am¡a ãb¢H$ àoOoÝQ>oeZ

229/AS/3/410C 5 [ P.T.O.

6. Answer the following questions : 2×5=10

(a) Write the steps to create a new folder.

(b) Explain the concept of highlight colour and text colour.

(c) Briefly explain the following :
(i) Main document
(ii) Data source

(d) Write the formula elements.

(e) What option we get when we print the PowerPoint file?

{ZåZ àíZm| Ho$ CÎma Xr{OE :
(H$) EH$ Z¶m ’$moëS>a ~ZmZo Ho$ ñQ>oßg {b{IE&
(I) hmB©bmBQ> H$ba Ed§ Q>o³ñQ> H$ba H$s AdYmaUm H$mo g‘PmBE&
(J) g§jon ‘| {ZåZ{b{IV H$s ì¶m»¶m H$s{OE :
(i) ‘w»¶ XñVmdoO
(ii) S>mQ>m gmog©
(K) ’$m°‘y©bm E{b‘|Q²>g {b{IE&
(L>) O~ h‘ nm°danm°B§Q> ’$mBb qàQ> H$aVo h¢, Vmo h‘| H$m¡Z-go {dH$ën {‘bVo h¢>?

7. Answer the following : 2×2=4

(a) Write the steps to copy the text to the Clipboard.

(b) In a Word document, which shortcut keys are pressed to do the
following actions?
(i) To activate Format Painter
(ii) To make a word Underlined
(iii) To insert Page Break
(iv) To apply Indent

229/AS/3/410C 6

{ZåZ Ho$ CÎma Xr{OE :
(H$) p³bn~moS>© na Q>o³ñQ> H$s H$m°nr H$aZo Ho$ {bE ñQ>oßg {b{IE :

(I) EH$ dS>© XñVmdoO ‘|, {ZåZ{b{IV H$m¶m] H$mo H$aZo Ho$ {bE X~m¶r OmZo dmbr em°Q>©H$Q> Hw§${O¶m|
H$mo {b{IE :
(i) ’$m°‘}Q> n|Q>a H$mo g{H«$¶ H$aZm
(ii) eãX Ho$ ZrMo bmBZ ItMZm
(iii) noO ~«oH$ BÝgQ>© H$aZm
(iv) B§S>|Q> AßbmB© H$aZm

8. Answer the following : 2×2=4

(a) Write the formulas to calculate the following based on the data given
in the spreadsheet as shown below :
A B C D E
1 Teacher’s Name Department Salary Tax Net Salary
2 Naveen Computer 22,000 — —
3 Chetna History 20,000 — —
4 Sandeep Maths 30,000 — —
5 Sanghmitra Science 25,000 — —
6 Rudraksh Maths 40,000 — —
7 Neeraj Computer 28,000 — —
8 — — — — —

(i) To calculate the tax which is 8% of the salary in D2 and copy it
up to D7.
(ii) To calculate the net salary which is (Salary – Tax) in cell E2 and
copy it up to E7.
(iii) To print the total net salary paid in cell E8.
(iv) To print the average salary of teachers in cell C8.

(b) Write the steps to add password to this workbook.

229/AS/3/410C 7 [ P.T.O.

{ZåZ àíZm| Ho$ CÎma Xr{OE :
(H$) Xr JB© ñàoS>erQ> Ho$ S>mQ>m Ho$ AmYma na {ZåZ H$s JUZm H$aZo Ho$ {bE ’$m°‘y©bm {b{IE :
A B C D E

1 Q>rMa H$m Zm‘ {S>nmQ>©‘|Q> doVZ Q>¡³g Hw$b doVZ
2 ZdrZ H$å߶yQ>a 22,000 — —
3 MoVZm {hñQ´>r 20,000 — —

4 g§Xrn ‘¡Ïg 30,000 — —
5 g§K{‘Ìm gmB§g 25,000 — —
6 éÐmj ‘¡Ïg 40,000 — —
7 ZraO H$å߶yQ>a 28,000 — —
8 — — — — —

(i) g¡b D2 ‘| Q>¡³g H$s JUZm H$aZo Ho$ {bE Omo doVZ H$m 8% h¡, Am¡a Bgo D7 VH$ H$m°nr
H$s{OE&
(ii) g¡b E2 ‘| Hw$b doVZ H$s JUZm H$aZo Ho$ {bE Omo (doVZ – Q>¡³g) h¡ Am¡a Bgo E7 VH$
H$m°nr H$s{OE&
(iii) g¡b E8 ‘| Hw$b doVZ H$m ¶moJ qàQ> H$s{OE&
(iv) g¡b C8 ‘| g^r Q>rMam| H$m Am¡gV doVZ qàQ> H$s{OE&

(I) Bg dH©$~wH$ ‘| nmgdS>© EoS> H$aZo Ho$ ñQ>oßg {b{IE&

  

229/AS/3/410C [V23] 8