NIOS Class 12 Question Paper Apr 2019 - 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¢&
Sl. No.
Roll No.
AZw H « $ _m§ H $
Code No.
H$mo S > Z§ .
58/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. 58 / OSS/1, Set - A on the Answer-Book.

gm_mÝ` AZw Xo e :
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§. 58 /OSS /1, goQ> - A {bI|&

58/OSS/1/336-A] G-249 1 *58/OSS/1/336-A* [ 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 for the following: [10 × ½ = 5]

{ZåZ Ho$ {bE [a³V ñWmZm| H$s ny{V© H$s{OE:
a) __________ translates the high level program to machine language.

__________ hmB© bodb àmoJ«m‘ H$m ‘erZ ^mfm ‘| AZwdmX H$aVm h¡&

b) The expanded form of GUI is __________________.

Or.¶y.AmB© (GUI) H$m {dñV¥V ê$n __________________ h¡&
c) The command to insert a page break is present on the _________ tab.

noO ~«oH$ BÝgQ>© H$aZo H$m H$‘m§S> _________ Q>¡~ na pñWV hmoVm h¡&
d) The ___________ option in the Recycle Bin is used to retrieve a deleted file.

argm¶H$b {~Z Ho$ ___________ {dH$ën H$m à¶moJ EH$ {S>brQ> H$s JB© ’$mBb H$mo nwZ… àmßV
H$aZo Ho$ {bE hmoVm h¡&
e) ___________ feature of MS Word ensures the authenticity of your document.

E‘.Eg. dS>© H$s ___________ {deofVm Ûmam Amn AnZo XñVmdoO H$s dmñV{dH$Vm gw{ZpíMV H$a
gH$Vo h¢&
f) The speed of a Dot matrix printer is measured in _______________.

EH$ S>m°Q> ‘¡{Q´>³g qàQ>a H$s ñnrS> H$mo _______________ ‘| ‘mnm OmVm h¡&

58/OSS/1/336-A] G-249 2 *58/OSS/1/336-A* [ Contd......

g) By using the __________ tab in the Format Cells dialog box, you can change
the orientation of the text.

’$m°‘}Q> g¡b S>m¶bm°J ~m°³g ‘| {XE JE __________ Q>¡~ Ho$ à¶moJ go Amn Q>o³gQ> (nmR²>¶) H$s {Xem
(Amo[aE§Q>oeZ) ~Xb gH$Vo h¢&

h) There are ______________ different slide layouts to choose from in MS
PowerPoint 2007.

E‘.Eg. nm°da nm°B§Q> 2007 ‘| Amn ______________ AbJ AbJ ñbmBS> bo AmCQ> ‘| go H$moB©
^r MwZ gH$Vo h¢&

i) ______________ type of Internet connection provides high bandwidth of
128 kbps and good speed internet connection.

______________ àH$ma H$m B§Q>aZoQ> H$Zo³eZ 128 Ho$.~r.nr.Eg. H$s Cƒ ~¢S>{dS²>W Ho$ gmW
AÀN>r ñnrS> H$m B§Q>aZoQ> H$Zo³eZ àXmZ H$aVm h¡&

j) The ________ function is used to add the cells with respect to the given
criteria.

________ ’§$³eZ H$m à¶moJ Xr JB© eV© Ho$ AZwgma g¡ëg H$mo Omo‹S>Zo Ho$ {bE {H$¶m OmVm h¡&

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

ghr ¶m JbV ~VmBE:

a) You cannot change the width of columns in an Excel worksheet.

EH$ E³gob dH©$erQ> ‘| Amn H$m°b‘ H$s Mm¡‹S>mB© ~Xb Zht gH$Vo h¢&

b) BASIC is a machine dependent language.

~o{gH$ (BASIC) EH$ ‘erZ {Z^©a ^mfm h¡&

c) A taskbar disappears when you open a document in a word processor.

O~ Amn EH$ XñVmdoµO H$mo dS>© àmogoga ‘| ImobVo h¢ V~ Q>mñH$~ma Jm¶~ hmo OmVm h¡&

58/OSS/1/336-A] G-249 3 *58/OSS/1/336-A* [ Contd......

d) You can print multiple pages of a document on a single page.

Amn EH$ XñVmdoµO Ho$ H$B© nÊUm| H$mo EH$ hr noO na {à§Q> H$a gH$Vo h¢&

e) Student Management System is an example of Customized application
software.

ñQy>S>|Q> ‘¡ZoO‘|Q> {gñQ>‘, H$ñQ>‘mBµÁS> EoßbrHo$eZ gm°âQ>do¶a H$m EH$ CXmhaU h¡&

f) You cannot edit the data source once it is created.

Amn S>mQ>m gmog© H$mo ~ZmZo Ho$ ~mX Cg‘| g§emoYZ Zht H$a gH$Vo h¢&

g) In Excel, all styles are cell styles.

Eo³gob ‘|, g^r ñQ>mBb| g¡b ñQ>mBb| hmoVr h¢&

h) You cannot hide a slide in a presentation.

Amn EH$ àoOoÝQ>oeZ ‘| {H$gr ^r ñbmBS> H$mo {N>nm Zht gH$Vo h¢&

i) You can even share software on Internet.

Amn gm°âQ>do¶a H$mo ^r B§Q>aZoQ> na eo¶a H$a gH$Vo h¢&

j) You cannot view the size of the file in Windows Explorer.

Amn qdS>moO E³gßbmoaa ‘| ’$mBb H$s gmBO H$mo XoI Zht gH$Vo h¢&

3. Define the following terms: [2 × 1 = 2]

{ZåZ H$mo n[a^m{fV H$s{OE:

a) Web Server

do~ gd©a

b) Title Case

Q>mBQ>b Ho$g

58/OSS/1/336-A] G-249 4 *58/OSS/1/336-A* [ Contd......

4. Write short notes on the following: [3 × 2 = 6]

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

¶y{Q>{bQ>r gm°âQ>do¶a
b) Mark as Final feature of MS Word 2007

E‘.Eg. dS>© 2007 H$m "‘mH©$ EoµO ’$mBZb' µ’$sMa
c) Freeze Panes feature of MS Excel 2007

E‘.Eg. E³gob 2007 H$m ’«$sµO noÝg µ’$sMa

5. Answer the following questions:

{ZåZ àíZmo§ Ho$ CÎma Xr{OE:
a) Identify the domain name from the following URL: [1]
https://swayam.gov.in/courses/public.htm

ZrMo {XE JE URL ‘| go S>mo‘oZ Zo‘ H$mo nhMm{ZE:
https://swayam.gov.in/courses/public.htm

b) Ritika wants to create a document using mail merge feature of MS Word. She
has created the main document but she does not know how to create a data
source. Write the steps to create a data source using Word Table for Ritika.[2]

[a{VH$m E‘.Eg.dS>© Ho$ ‘ob ‘O© µ’$sMa H$m à¶moJ H$aHo$ EH$ XñVmdoO V¡¶ma H$aZm MmhVr h¡& CgZo ‘oZ
S>m°³¶y‘|Q> (‘w»¶ XñVmdoO) ~Zm {b¶m h¡ bo{H$Z Cgo ¶h Zht nVm {H$ dmo S>mQ>m gmog© H¡$go V¡¶ma H$ao& dS>©
Q>o~b H$m Cn¶moJ H$aVo hþE S>mQ>m gmog© V¡¶ma H$aZo Ho$ ñQ>oßg {b{IE Am¡a [a{VH$m H$s ‘XX H$s{OE&
c) What happens if you select Handouts option while printing a presentation?[1]

EH$ àoOoÝQ>oeZ qàQ> H$aVo g‘¶ ¶{X Amn "h¢S>AmCQ²>g' {dH$ën MwZVo h¢ Vmo ³¶m hmoJm?

58/OSS/1/336-A] G-249 5 *58/OSS/1/336-A* [ Contd......

d) Name any two functions that you can perform by using the control panel.[1]

H$§Q´>mob n¡Zb H$m à¶moJ H$aHo$ Amn H$m¡Z go Xmo H$m¶© H$a gH$Vo h¢, CZHo$ Zm‘ {bI|&
e) Expand SMTP. [1]

SMTP H$m {dñV¥V ñdê$n {b{IE&

6. Differentiate between the following: [4 × 2 = 8]

{ZåZ Ho$ ~rM A§Va ñnîQ> H$s{OE:
a) Machine Language and Assembly language.

‘erZ ^mfm Ed§ Eogoå~br ^mfm&
b) List AutoFill and AutoFill feature of MS Excel 2007?

E‘. Eg. Eo³gob 2007 Ho$ "{bñQ> Am°Q>mo{µ’$b' Ed§ "Am°Q>mo{µ’$b' µ’$sMa?
c) Pie chart and Doughnut chart.

nmB© MmQ>© Ed§ S>moZQ> MmQ>©&
d) Normal View and Slide Sorter view of a presentation.

àoµOoÝQ>oeZ ‘| "Zm°‘©b ì¶y' Ed§ ñbmBS> gm°Q>©a ì¶y&

7. Shiksha has created a report in MS Word. She wants to format text in her report
using only the keyboard. What will be the shortcut keys for performing the following
tasks: [4 × 1 = 4]

{ejm Zo E‘.Eg. dS>© ‘| EH$ [anmoQ>© V¡¶ma H$s h¡& dh AnZr [anmoQ>© ‘| Q>o³gQ> ’$m°‘}qQ>J Ho$ {bE Ho$db H$s~moS>© H$m
à¶moJ H$aZo MmhVr h¡& Cgo {ZåZ H$m¶m] H$mo H$aZo Ho$ {bE {H$Z emoQ>©H$Q> H$s H$m BñVo‘mb H$aZm hmoJm:
a) Making the text italic.

Q>o³gQ> H$mo BQ>m{b³g ~ZmZm&

58/OSS/1/336-A] G-249 6 *58/OSS/1/336-A* [ Contd......

b) Redo the last task.
{nN>bo H$m¶© H$mo dmng bmZm (arSy>)&
c) Format Painter.
’$m°‘}Q> n|Q>a&
d) Pasting the text.
Q>o³ñQ> H$mo noñQ> H$aZm&

8. Trish has created the following Excel sheet. [1 + 1 + 2 = 4]

The formula to calculate discount in Rs. for the item Pen is written in cell
F3 as = E3/100*D3

Write the formula/steps to do the following tasks

a) To display the total price of pen as (Price-Discount in Rs.) in cell G3.

b) To display the highest price of all items.

c) Steps to copy the formula of cell G3 to cells G4....G6.

d) To display the sum of total price of all items in cell G8.

58/OSS/1/336-A] G-249 7 *58/OSS/1/336-A* [ Contd......

{Ìe Zo {ZåZ E³gob erQ> ~ZmB© h¡:
1 A B C D E F G
2 AmBQ>‘ H$moS AmBQ>‘ Zo‘ H$s‘V {S>ñH$mC§Q> (%) {S>ñH$mC§Q> (ê$. ‘|) Hw$b H$s‘V
3 S001 noZ 15 0
4 T102 S>m°b 250 2
5 S104 ZmoQ> ~wH$ 40 5
6 S110 noñQ>b H$ba 55 0
g¡b F3 ‘| AmBQ>‘ noZ Ho$ {bE {S>ñH$mC§Q> H$mo ê$nE ‘| {ZH$mbZo Ho$ {bE ’$m°‘y©bm Bg àH$ma {X¶m J¶m h¡:
F3 = E3/100*D3

{ZåZ H$m¶m] H$mo H$aZo Ho$ {bE ’$m°‘y©bm/ñQ>oßg {b{IE:

H$) g¡b G3 ‘| noZ H$s Hw$b H$s‘V (H$s‘V-{S>ñH$mC§Q> (ê$. ‘|)) {XImE|&

I) g^r AmBQ>‘m| ‘| go g~go Á¶mXm H$s‘V {ZH$mb|&

J) g¡b G3 Ho$ ’$m°‘y©bm H$mo g¡b G4 go G6 VH$ H$m°nr H$aZo Ho$ ñQ>oßg {bI|&

K) g¡b G8 ‘| g^r AmBQ>‘m| H$s Hw$b H$s‘V H$m ¶moJ {XImE±&



58/OSS/1/336-A] G-249 8 *58/OSS/1/336-A*