NIOS Class 12 Question Paper 2021 (Jan Feb) Data Entry Operations

This Question Paper consists of 6 questions and 8 printed pages.
Bg àíZ-nÌ _| 6 àíZ VWm 8 ‘w{ÐV n¥ ð > h¢ &

Sl. No.
Roll No.
AZw H « $ _m§ H $
Code No.
H$mo S > Z§ .
60/OSS/1
DATA ENTRY OPERATIONS (Theory)
Set / go Q > A
S>mQ>m E§Q´>r Am°naoeÝg ({gÕm§V)
(336)
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. 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.

4. Answers for questions, like matching, True or False, Fill in the blanks, etc., are to be given in the Answer-
Book.

5. Write your Question Paper Code No. 60 / OSS/1, Set - A on the Answer-Book.

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. 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 Om¶oJm&

4. Eogo àíZ O¡go {‘bmZ H$aZm, ghr AWdm JbV, [aº$ ñWmZ ^amo Am{X Ho$ CÎma, CÎma-nwpñVH$m ‘| {bI|&

5. AnZr CÎma-nwpñVH$m na àíZ-nÌ H$m H$moS> Z§. 60 /OSS /1, goQ> - A {bI|&

60/OSS/1-336-A] G-649 1  [ Contd......

DATA ENTRY OPERATIONS (Theory)
S>mQ>m E§Q´>r Am°naoeÝg ({gÕm§V)
(336)
Time : 2 Hours] [Maximum Marks : 40
g_` : 2 KÊQ>o] [nyUmªH$ : 40
Note : All questions are compulsory and carry marks as indicated against each question.

{ZX}e : g^r àíZ A{Zdm¶© h¢ Am¡a à˶oH$ àíZ Ho$ A§H$ CgHo$ gm‘Zo {XE J¶o h¢&

1. Fill in the blanks of the following: [10 × ½ = 5]

{ZåZ ‘| [a³V ñWmZm| H$s ny{V© H$s{OE:

a) In Excel ______________ helps you to add the contents of a range of
adjacent cells.

Eo³gob ‘| ____________ H$s ghm¶Vm go Amn Amng ‘| gQ>o hþE g¡bmo§ Ho$ a|O Ho$ H§$Q>|Q> H$mo Omo‹S>
gH$Vo h¡&

b) The process of input, processing and storage is performed under the
supervision of a ______________ unit.

____________ ¶y{ZQ> Ho$ {ZarjU ‘| BZnwQ>, àmogoqgJ Am¡a ñQ>moaoO à{H«$¶mE± g§nÞ hmoVr h¡&

c) When files and folders are deleted from hard disk, windows places them in
the _____________.

O~ ’$mB©b Am¡a ’$moëS>a hmS>© {S>ñH$ go {S>brQ> {H$E OmVo h¢, V~ qdS>mo‹O CÝho> ____________ ‘|
O‘m aIVm h¡&

d) The horizontal lines at the end of the document is called the _____________.

S>m°³¶y‘|Q> Ho$ A§V ‘| {XIZo dmbr hm°arOm|Q>b bmBZ H$mo ____________ H$hm OmVm h¡&

e) In MS-Excel, _____________ are provided in a formula.

E‘.Eg. Eo³gob ‘| ___________ H$mo ’$m°‘y©bm ‘| {X¶m OmVm h¡&

60/OSS/1-336-A] G-649 2  [ Contd......

f) ___________ are programs that bridge the gap between the functionality of
an OS and the needs of the user.

____________ dmo àmoJ«m‘ hmoVo h¢ Omo EH$ OS H$s H$m¶©H$m[aVm Am¡a ¶yOa H$s Amdí¶H$Vm Ho$
~rM H$s Xÿar H$mo nyU© H$aVo h¡&

g) In ____________ view, the slide can be dragged to a new location.

_________ ì¶y ‘| ñbmBS>m| H$mo ZB© OJh VH$ ItM H$a bo Om¶m Om gH$Vm h¡&

h) ____________ is the key used to check spelling and grammar in a document.

____________ H$s go S>m°³¶y‘|Q> ‘| ñnoqbJ Ed§ J«m‘a H$s Om§M H$s Om gH$Vr h¡&

i) ___________ fonts option contains preset fonts that can be changed in a
presentation.

___________ ’$m±Q²>g {dH$ën ‘| àrg¡Q> ’$m±Q> hmoVo h¢ Omo àoOoÝQ>oeZ ‘| ~Xbo Om gH$Vo h¢&

j) A _____________ is used to connect your local network to the Internet.

_________ H$m à¶moJ AmnHo$ bmoH$b ZoQ>dH©$ H$mo B§Q>aZoQ> go Omo‹S>Zo Ho$ {bE hmoVm h¡&

2. State True or False: [10 × ½ = 5]

ghr ¶m JbV ~VmBE:

a) Plotter is used to enter data in a computer system.

ßbm°Q>a H$m à¶moJ H$å߶yQ>a {gñQ>>‘ ‘| S>mQ>m E§Q>a H$aZo Ho$ {bE hmoVm h¡&

60/OSS/1-336-A] G-649 3  [ Contd......

b) Control panel is used to add or remove hardware.

H§$Q´>mob n¡Zb H$m à¶moJ hmS>©do¶a EoS> ¶m [a‘yd H$aZo Ho$ {bE hmoVm h¡&

c) The scroll bars are used to set margins in a document.

ñH«$m°b ~ma H$s ‘XX go S>m°³¶y‘|Q> ‘| ‘m{O©Z goQ> H$s OmVr h¡&

d) F1 key is used to begin slide show.

F1 H$s go Amn ñbmBS> emo H$s ewê$AmV H$a gH$Vo h¡&

e) Read only feature help to protect the document.

arS> AmoÝbr ’$sMa AmnH$mo AnZm S>m°³¶y‘|Q> gwa{jV H$aZo ‘| ‘XX H$aVm h¡&

f) The Autofill feature allows you to create new formula in MS-Excel.

Am°Q>mo{µ’$b µ’$sMa go Amn E‘. Eg. Eo³gob ‘| Z¶m ’$m°‘y©bm ~Zm gH$Vo h¡&

g) TCP/IP is the glue of the Internet.

TCP/IP B§Q>aZoQ> H$m "½by' H$hbmVm h¡&

h) If you use an apostrophe('), the number can be treated as text.

¶{X Amn EonmoñQ´>m°’$s(') H$m à¶moJ H$aVo h¢ Vmo Amn Z§~am| H$mo Q>o³ñQ> H$s Vah ‘mZ gH$Vo h¢&

i) Normal view of a presentation divides the screen into four sections.

àoOoÝQ>oeZ H$m Zm°‘©b ì¶y ñH«$sZ H$mo Mma go³eZ ‘| ~m±Q> XoVm h¡&

j) MS-Access, MS-SQL Server and ORACLE are the examples of spreadsheets.

E‘. Eg. Eo³gog, E‘. Eg.-SQL gd©a Am¡a Amoa¡H$b ñàoS>erQ> Ho$ CXmhaU h¢&

60/OSS/1-336-A] G-649 4  [ Contd......

3. Define the following terms : (Any two) [2 × 1 = 2]
{ZåZ eãXm| H$mo n[a^m{fV H$s{OE: ({H$Ýht Xmo)
a) Plotter
ßbm°Q>a
b) URL
¶y Ama Eb (URL)
c) SUMIF( ) Function
g‘ Bµ’$( ) ’§$³eZ (SUMIF( ) ’§$³eZ)

4. Write the short notes on the following : [5 × 2 = 10]

{ZåZ na g§{jßV {Q>ßnUr (ZmoQ²>g) {b{IE :

a) Change case feature

M|O Ho$g µ’$sMa

b) Autocorrect feature

Am°Q>moH$ao³Q> µ’$sMa

c) IP Address

AmB©.nr. EoS´>og

d) Elements of a Text Box

Q>o³ñQ> ~m°³g Ho$ Eobr‘|Q²>g

e) Autoformat feature of MS-Excel

E‘. Eg. Eo³gob Ho$ Am°Q>mo ’$m°‘}Q> µ’$sMa

60/OSS/1-336-A] G-649 5  [ Contd......

5. Differentiate between the following : [5 × 2 = 10]

{ZåZ Ho$ ~rM A§Va ñnîQ> H$s{OE :

a) Web Browser and Web Server

do~ ~«mCµOa Ed§ do~ gd©a

b) Source Program and Object Program

gmog© àmoJ«m‘ Ed§ Am°ãOo³Q> àmoJ«m‘

c) Machine Language and Assembly Language

‘erZ b±½doO Ed§ Eog|ãbr b±½doO

d) Main Document and Data Source document

‘oZ S>m°³¶y‘|Q> Ed§ S>mQ>m gmog© S>m°³¶y‘|Q>

e) Bar chart and Area chart

~ma MmQ>© Ed§ E[a¶m MmQ>©

6. a) Answer the following : [2 × 2 = 4]

{ZåZ H$m CÎma Xr{OE :

i) Write the steps to insert page numbers at the end of each page in a
document.

S>m°³¶y‘|Q> ‘| à˶oH$ noO Ho$ A§V ‘| noO Z§~a BÝgQ>© H$aZo Ho$ ñQ>oßg {b{IE&

ii) Write the steps to protect your document using a password.

nmgdS>© H$m à¶moJ H$aHo$ S>m°³¶y‘|Q> H$mo gwa{jV H$aZo Ho$ ñQ>oßg {b{IE&

60/OSS/1-336-A] G-649 6  [ Contd......

b) On the basis of the worksheet given below, answer the questions that follow :
[4 × 1 = 4]
A B C D E F G
1 Roll No. Name Hindi English Maths Total Average
2 1 Rahul 67 87 87
3 2 Rishabh 88 95 86
4 3 Amrita 99 78 93
5 4 Kabeer 89 88 95
6 5 Shradha 87 93 92
7
i) Write the formula in cell F3 to find Rishabh's total marks in all three
subjects.
ii) Write the formula in cell G6 to find Shradha's average marks.
iii) Write the formula in cell E7 to find total marks in maths of all 5 students.
iv) Write the formula in cell F7 to find highest of total marks obtained by the
class.
ZrMo Xr JB© dH©$erQ> Ho$ AmYma na BgHo$ ZrMo {XE JE àíZm| Ho$ CÎma {b{IE :
A B C D E F G
1 amob Z§~a Zm‘ qhXr A§JO
o« r J{UV Hw$b Am¡gV
2 1 amhþb 67 87 87
3 2 [af^ 88 95 86
4 3 A‘¥Vm 99 78 93
5 4 H$~ra 89 88 95
6 5 lÕm 87 93 92
7

60/OSS/1-336-A] G-649 7  [ Contd......

i) g¡b F3 ‘| [af^ Ho$ g^r VrZ {df¶m| Ho$ {‘bmH$a Hw$b A§H$ OmZZo Ho$ {bE ’$m°‘y©bm {bI|&

ii) g¡b G6 ‘| lÕm Ho$ Am¡gV A§H$ OmZZo Ho$ {bE ’$m°‘y©bm {bI|&

iii) g¡b E7 ‘| g^r nm±Mm| N>mÌm| Ho$ J{UV Ho$ Hw$b A§H$ OmZZo Ho$ {bE ’$m°‘y©bm {bI|&

iv) g¡b F7 ‘| nyar H$jm ‘| àmßV A{YH$V‘ Hw$b A§H$ OmZZo Ho$ {bE ’$m°‘y©bm {bI|&



60/OSS/1-336-A] G-649 8 