For Hindi Medium
See answers below
26
|
bues ls D;k isLV Lis’ky dekaM ds }kjk isLV
fd;k tk ldrk gS\
¼v½
osyhMs’ku ¼c½
QkWjesVl
¼l½
QkWjewyk ¼n½ mijksDr
lHkh
|
27
|
,Dly es MkVk dks QkbaM rFkk jhIysl djus ds
laca/k es bues ls dkSulk dFku lgh gS\
¼v½'khV
;k odZ’khV ij QkbaM rFkk jhIysl mi;ksx fd;k tk ldrk gSA
¼c½ ,Dly
es QkabM Mk;ykWx ckWDl es eSp dsl vkWi’ku ugh gksrk gSaA
¼l½
nksuks gh lgh gSA
¼n½dksbZ
Hkh lgh ugh gSA
|
28
|
'khV es fdlh MsVk fdlh vksj MsVk ls jhIysl
djus dh D;k 'kkWVZdV gS \
¼v½ Ctrl + R ¼c½ Ctrl + Shift + R
¼l½ Ctrl + H ¼n½ Ctrl + F
|
29
|
fdlh lsy es desaV bUlVZ djkus dks D;k dgrs
gS\
¼v½LekVZ
fVi ¼c½ lsy fVi
¼l½ osc
fVi ¼n½lkW¶V fVi
|
30
|
fuEu es ls dkSulk MsVk Vkbi ,Dly es ugh gS\
¼v½uEcj ¼c½ djsDVj
¼l½ yscy ¼n½MsV@Vkbe
|
31
|
vyx&vyx VsDlV dks fdlds }kjk tksMk tk
ldrk gS\
¼v½viksLVªkWQh
(‘) ¼c½ ,Dyhes’ku (!)
¼l½ gS’k
(#) ¼n½,eijlsaM (&)
|
32
|
,Dly dh foaMks ds fdl ,fj;k es osY;wl rFkk
QkWjewyk Vkbi fd;s tk ldrs gS\
¼v½VkbVy
ckj ¼c½ esU;w ckj
¼l½
QkWjewyk ckj ¼n½LVSUMZM Vwy
ckj
|
33
|
,d ls vf/kd x.kuk,¡ ,d gh QkWjewyk ls fdl
vkWi’ku ds mi;ksx }kjk dh tk ldrh gS\
¼v½LVSUMZM
QkWjewyk ¼c½ ,ssjs
QkWjewyk
¼l½
dkWEIysDl QkWjewyk ¼n½LekVZ
QkWjewyk
|
34
|
,d ,Dly odZ’khV lxzga.k
gS-------------------
¼v½odZcqDl
dk ¼c½ odZ’khV~l dk
¼l½
pkVZl dk ¼n½odZ’khV~l
vkSj pkVZl dk
|
35
|
odZLisl ls vkidk D;k rkRi;Z gS\
¼v½dkWye
dk leqg ¼c½ odZ’khV~l dk
leqg
¼l½ jkW
dk leqg ¼n½odZcqDl dk
leqg
|
36
|
,e ,l&,Dly vk/kkfjr gS------------------------------\
¼v½foaMksl
ij ¼c½ MkWl ij
¼l½
;wfuDl ij ¼n½vks,l@2 ij
|
37
|
,Dly es cMh jsat ds MkVk dks vklkuh ls ,d
cVu dks LysDV dj tksMk tk ldrk gS] ml Vwy cVu dks D;k dgrs gS\
¼v½
vkWVks fQy ¼c½ vkWVks
djsDV
¼l½
vkWVks le ¼n½ vkWVks
QkWjesV
|
38
|
,Dly es ,d lkFk iwjs dkWye dks LysDV djus ds
fy;s D;k 'kkWVZdV mi;ksx es fy;k tkrk gS\
¼v½ CTRL + C ¼c½ CTRL + Arrow key
¼l½ CTRL + S ¼n½ None of the above
|
39
|
,Dl es 'ks"kQy fudkyus ds fy;s dkSulk
QaD’ku mi;ksx es fy;k tkrk gS\
¼v½ ROUND ( ) ¼c½ FACT ( )
¼l½ MOD ( ) ¼n½ DIV ( )
|
40
|
dkWulksfyMsV Mk;ykWx ckWDl es dkSulk QaD’ku
miyC/k ugh gSA
¼v½ Pmt ¼c½ Average
¼l½ Max ¼n½ Sum
|
41
|
ekbdzkslkW¶V ,Dly ,d ikWojQqy
-------------------------\
¼v½ oMZ
izkslsflax iSdst ¼c½
LizsM’khV
¼l½
dE;wfuds’ku ,l@MCY;w iSdst ¼n½
Mhch,e,l
|
42
|
MsVk dks vlsafMx rFkk fMlsafMx vkWMZj es
dSls O;ofLFkr fd;k tk ldrk gS\
¼v½
MsVk] lksVZ ¼c½ MsVk] QkWeZ
¼l½
MsVk] Vscy ¼n½ MsVk] lcVksVy
|
43
|
dkSulk pkVZ ,Dly es cuk;k tk ldrk gS\
¼v½
,fj;k ¼c½ ykbu
¼l½ ikbZ ¼n½ mijksDr lHkh
|
44
|
COUNTA () QaD’ku
D;k dk;Z djrk gS\
¼v½ ftu
lsyl es ,sYQkcsV gksrs gS mudks dkm.V djrk gSA
¼c½ [kkyh
lsyl dks dkm.V djrk gSA
¼l½ ftu
lsyl es uEcj gksrs gS mudks dkm.V djrk gSA
¼n½ tks
lsyl [kkyh ugh gksrh gS mudks dkm.V djrk gSA
|
45
|
iwjs dkWye dks gkbykbV¼lysDV½ djus dh
'kkVZdV dh gSA
¼v½ Ctrl+C ¼c½ Ctrl+Enter
¼l½ Ctrl+Page
Up ¼n½ Ctrl+Space Bar
|
46
|
,Dly es orZeku lsy dk ,Mªsl dgk¡ fn[kkbZ
nsrk gSA
¼v½
QkWjewyk ckj ¼c½ LVsVl ckj
¼l½ use
ckWDl ¼n½ VkbVy ckj
|
47
|
,Dly es esdksZl cukuss ds fy;s dkSulh
ySXosat dk mi;ksx fd;k tkrk gS\
¼v½
fotqvy csfld ¼c½ lh
¼l½
fotqvy lh++ ¼n½ tkok
|
48
|
fuEu es ls dkSulk vkWi’ku ,e ,l ,Dly dk
fgLlk ugh gS\
¼v½ lsyl ¼c½ ifDar;k
¼l½
dkWye ¼n½ MkWD;wesaV
|
49
|
Mkbxzke cukus ds fy;s fuEu es ls fdldks
lysDV djuk gksxk\
¼v½
,fMV] pkVZ ¼c½ bUlVZ] pkVZ
¼l½
VwYl] pkVZ ¼n½ QkWjesV] pkVZ
|
50
|
fuEu es ls dkSulh 'kkVZdV dh LiSfyax pSd
Mk;ykWx dh gS\
¼v½ F3 ¼c½ F5
¼l½ F7 ¼n½ F9
|
For English Medium
26
|
Which of
the following you can paste selectively using Paste Special command?
a.
Validation b.
Formats
c. Formulas d. All of above |
27
|
While
Finding and Replacing some data in Excel, which of the following statement is
valid?
a.
You can Find and Replace within the sheet or workbook
b. Excel does not have option to match case for find c. Both are valid d. None are valid |
28
|
What is
the short cut key to replace a data with another in sheet?
a.
Ctrl + R
b. Ctrl + Shift + R
c. Ctrl + H d. Ctrl + F |
29
|
Comments
put in cells are called …..
a. Smart
Tip b. Cell
Tip
c. Web Tip d. Soft Tip |
30
|
Which of
the following is not a valid data type in Excel?
a. Number b. Character
c. Label d. Date/Time |
31
|
Concatenation
of text can be done using
a.
Apostrophe (‘) b.
Exclamation (!)
c. Hash (#) d. Ampersand (&) |
32
|
Which area
in an Excel window allows entering values and formulas?
a. Title
Bar b. Menu Bar
c. Formula Bar d. Standard Tool Bar |
33
|
Multiple
calculations can be made in a single formula using…..
a.
Standard Formulas b. Array
Formula
c. Complex Formulas d. Smart Formula |
34
|
An Excel
Workbook is a collection of …….
a.
Workbooks b.
Worksheets
c. Charts d. Worksheets and Charts |
35
|
What do
you mean by a Workspace?
a. Group
of Columns b. Group of
Worksheets
c. Group of Rows d. Group of Workbooks |
36
|
MS-EXCEL is based on ……….?
a. WINDOWS b. DOS
c. UNIX d. OS/2 |
37
|
In EXCEL, you can sum a large range of data
by simply selecting a tool button called …..?
a.
AutoFill b. Auto
correct
c. Auto sum d. Auto format |
38
|
To select
an entire column in MS-EXCEL, press?
a. CTRL +
C b. CTRL + Arrow
key
c. CTRL + S d. None of the above |
39
|
To return
the remainder after a number is divided by a divisor in EXCEL we use the
function?
a. ROUND (
) b. FACT ( )
c. MOD ( ) d. DIV ( ) |
40
|
Which function is not available in the
Consolidate dialog box?
a. Pmt b. Average
c. Max d. Sum |
41
|
Microsoft
Excel is a powerful………..
a. Word
processing package b.
Spreadsheet package
c. Communication S/W Package d. DBMS package |
42
|
How do you
rearrange the data in ascending or descending order?
a. Data,
Sort b. Data, Form
c. Data, Table d. Data Subtotals |
43
|
Which
Chart can be created in Excel?
a. Area b. Line
c. Pie d. All of the above |
44
|
What does COUNTA () function do?
a. counts
cells having alphabets
b. counts empty cells c. counts cells having number d. counts non-empty cells |
45
|
What is
the short cut key to highlight the entire column?
a. Ctrl+C b. Ctrl+Enter
c. Ctrl+Page Up d. Ctrl+Space Bar |
46
|
Excel
displays the current cell address in the ……….
a. Formula
bar b. Status Bar
c. Name Box d. Title Bar |
47
|
Which
language is used to create macros in Excel?
a. Visual
Basic b. C
c. Visual C++ d. Java |
48
|
Which of
the following is not a term of MS-Excel?
a. Cells b. Rows
c. Columns d. Document |
49
|
Which
would you choose to create a bar diagram?
a. Edit,
Chart b. Insert, Chart
c. Tools, Chart d. Format, Chart |
50
|
Which key
do you press to check spelling?
a. F3 b. F5
c. F7 d. F9 |
Answer
26-d
|
27-a
|
28-c
|
29-b
|
30- b
|
31-d
|
32-c
|
33-b
|
34-b
|
35-d
|
36-a
|
37-c
|
38- d
|
39-c
|
40- a
|
41-b
|
42-a
|
43-d
|
44-c
|
45- d
|
46-c
|
47-a
|
48-d
|
49- b
|
50-c
|
0 comments:
Post a Comment