For Hindi Medium
See answers below
Ø-l-
|
iz'u
,oa mRrj fgUnh Hkk"kk
|
1
|
,Dly 'khV es fdz;k’khy lsy
------------------- ds #i es fn[kkbZ nsrh gSA
¼v½
MkWVsM cksMZj ¼c½ xgjh eksVh
cksMZj
¼l½
fVefVekrh cksMZj ¼n½ bVsfyd
VsDLV
|
2
|
fuEu es ls dkSulk vkWi’ku LiSfyax Mk;ykWx
ckWDl dk fgLlk ugh gS\
¼v½
,fMV ¼c½ bxuksj
¼l½
bxuksj vkWy ¼n½ psat
|
3
|
fuEu ls dkSulk QaD’ku jkW ds MsVk dks dkWye
es rFkk dkWye ds MsVk dks jkW fn[kkrk gSA
¼v½
Vªklaikst ¼c½ bUMsDl
¼l½
ifDar;k ¼n½ gkbijfyad
|
4
|
fuEUk es ls dkSulk twe dk lgh izfr’kr ugh
gS\
¼v½ 10 ¼c½ 100
¼l½ 300 ¼n½ 500
|
5
|
LizsM’khV es MkVk dSls O;ofLFkr gksrk gS\
¼v½ jkW
rFkk dkWye es ¼c½ ys;j rFkk Iykul es
¼l½ ykbu
rFkk Lisl es ¼n½ yEckbZ rFkk
pkSMkbZ es
|
6
|
fdl ij ,Iykb dh xbZ daMh’ku QkWjesfVax dks
ge daMh’ku ds vdksZfMax psd dj ldrs gS\
¼v½ lsy
osY;w ¼c½ QkWjewyk
¼l½
mijksDr nksuks ¼n½ dksbZ ugh
|
7
|
,Dly es fuEu es ls dkSulk Hkkx dk fpUg gksrk
gS\
¼v½ /
¼c½ D
¼l½ Div ¼n½ \
|
8
|
fuEu es ls dkSulk QaD’ku djsDVlZ dks fxuus
dk dk;Z djrk gS\
¼v½ LENGTH ¼c½ LGT
¼l½ LT ¼n½ LEN
|
9
|
lysDVsM lsy es ifjorZu djus dk 'kkVZdV
gS&
¼v½ F3
¼c½ F8
¼l½ F4
¼n½ F2
|
10
|
fuEu es ls fdl 'kkVZdV ds }kjk [kqyh gq;h
odZcqDl dks Lohp ¼cnyuk½ fd;k tk ldrk gSA
¼v½ Ctrl + F2 ¼c½ Ctrl + F6
¼l½ Ctrl + F8 ¼n½ Ctrl + F10
|
11
|
fdlh lsy dks uke nsus ds fy;s dkSulk Mk;ykWx
ckWDl mi;ksx es fy;k tk ldrk gS\
¼v½
fdz;sV use ¼c½ fMQkbu use
¼l½ xsV
use ¼n½ fdz;sV dkWUlVsUV
|
12
|
odZ’khV es vki LkysDV dj ldrs gS&
¼v½ iwjh
odZ’khV ¼c½ jkW
¼l½
dkWye ¼n½ ,] ch rFkk
lh lHkh dks
|
13
|
QkWjewyk ckj ds nk;h rjQ fLFkr use ckWDl D;k
iznf’kZr djrk gS\
¼v½
oRkZeku es ftl odZcqd ij dke dj jgs gS mldk uke 'kkW djrk gSA
¼c½
oRkZeku es ftl odZ’khV ij dke dj jgs gS mldk uke 'kkW djrk gSA
¼l½
oRkZeku es ftl lsy ;k jsat ij dke dj jgs gS mldk uke 'kkW djrk gSA
¼n½
dksbZ ugh
|
14
|
izR;sd ,Dly Qkby es odZcqd gksrh gS ftles
vyx&vyx 'khV gksrh gSA bues ls fdl rjg dh 'khV ,Dly odZcqd es ugh gksrh \
¼v½
odZ’khV ¼c½ pkVZ’khV
¼l½
ekWM~;wy 'khV ¼n½ MkVk
'khV
|
15
|
fdlh lsy es ifjoZru djus dk bues ls dkSulk
rjhdk lgh ugh gS\
¼v½ Alt key ¼c½ F2 key
¼l½
QkWjewyk ckj ij fDyd ¼n½ lsy ij
Mcy fDyd
|
16
|
xq.k djus dk fpUg dkSulk gksrk gs ,Dly 'khV
esA
¼v½ ^ ¼c½ *
¼l½ / ¼n½ X
|
17
|
;fn ,Dly es vkWVks dsydqys’ku vkWi’ku fMlscy
gS rks QkWjewyk yxh gq;h lsy dks dSls viMsV djsxsaA
¼v½ F8 ¼c½ F9
¼l½ F10 ¼n½ F11
|
18
|
xks Vw Lis’ky fQpj dk mi;ksx djus ds fy;s
D;k 'kkWVZdV dh gksxh\
¼v½ Ctrl + G ¼c½ Ctrl + O
¼l½ Ctrl + Shift + G ¼n½ Ctrl + 1
|
19
|
“Qtr 1, Qtr 2, Qtr 3” mnkgj.k gS&
¼v½
QkWjewyk ¼c½ QaD’ku
¼l½
lhjht ¼n½ flUVsDl
|
20
|
dqN lsyl dks lysDV dj Ctrl + X nckus
ij D;k izfrfdz;k gksxh\
¼v½ lysDV fd;s x;s lsy ds daVsUV gV tk;sxs rFkk fDyicksMZ es
tkdj LVksj gks tk;sxsA
¼c½ lysDVsM lsyl dV gksus ds fpfUgr gks
tk;sxhaA
¼l½ lysDVsM lsyl fMfyV gks tk;sxha rFkk nk;h
rjQ f’k¶V gks tk;sxhaA
¼n½ lysDVsM lsyl fMfyV gks tk;sxha rFkk Åij
dh rjQ f’k¶V gks tk;sxhaA
|
21
|
bues ls fdlds }kjk dkWye dks vkWVks fQV fd;k
tk ldrk gS\
¼v½
dkWye gsMj ij dkWye use ds Åij Mcy fDyd djus ijA
¼c½
odZ’khV es lsy ikWbUVj ij Mcy fDyd djus ijA
¼l½
dkWye gsMj ij dkWye ds jkbV ckWMZj ij Mcy fDyd djus ijA
¼n½
dkWye gsMj ij dkWye ds ys¶V ckWMZj ij Mcy fDyd djus ijA
|
22
|
,e ,l ,Dly es fMQkWYV #i ls fQy lhjht
Mk;ykWx ckWDl es fdruh LVsil gksrh gS\
¼v½ 0 ¼c½ 1
¼l½ 5 ¼n½ 10
|
23
|
Ctrl + D 'kkWVZdV
dh D;k dk;Z djrh gS\
¼v½
QkWUV Mk;ykWx ckWDl vksiu djus ds fy;sA
¼c½
fdz;k’khy lsy ij Mcy vaMj ykbu yxkus ds fy;sA
¼l½ lsy
dh osY;w dks uhps okyh lsy es dkWih djus ds fy;sA
¼n½
dksbZ ughA
|
24
|
Ctrl + R 'kkWVZdV
dh ,Dly es D;k dk;Z djrh gS\
¼v½ lsy ds dWsUVsUVl jkbV vykbuesaV lsV djrh gSA
¼c½ lysDVsM lsy ds dkWUVsUVl dks gVkrh gSA
¼l½ fdlh lsy dh osY;w dks mldh nk;h rjQ dh
lsy es dkWih djrh gSA
¼n½ dksbZ ughA
|
25
|
bues ls dkSulh lhjht dk Vkbi fQy lhjht
Mk;ykWx ckWDl es ugh gksrk\
¼v½ yhuh;j ¼c½ xzksFk
¼l½
vkWVks fQy ¼n½ Vkbe
|
For English Medium
S.N.
|
Question
& Answer In English Language
|
1
|
On an excel sheet the active cell in
indicated by ?
A A dotted border B.A dark wide border
C.
A blinking border D. By italic text
|
2
|
Which among following is not associated with spelling dialogue box ?
A.Edit B.Ignore
A. C.Ignore All
D. Change
|
3
|
What
function displays row data in a column or column data in a row ?
A. Transpose B. Index
C. Rows
D.Hyperlinks
|
4
|
Which of the following is not a valid Zoom percentage in Excel ?
A. 10
B.100
C.300 D.500
|
5
|
How is data organized in a spreadsheet ?
A.Rows and columns B.Layers and planes
C.Lines and spaces
D.Height and width
|
6
|
You can check the conditions against
__________ when applying conditional formatting
a. Cell value b. Formula
c. Both of above d. None of above |
7
|
Which among following is
divide symbol in excel ?
A . / B. D
C. Div D. \
|
8
|
Which function in excel counts the numbers
of characters in a cell ?
A. LENGTH B. LGT
C. LT D. LEN
|
9
|
Shortcut to edit the selected
cell ?
A. F3 B. F8
C. F4 D. F2
|
10
|
Which
shortcut can be used to Switch between open workbooks ?
A. Ctrl + F2 B. Ctrl + F6
C. Ctrl + F8 D. Ctrl + F10
|
11
|
Which dialogue box we can use to name a
constant ?
A. Create Name B. Define Name
C. Get Name D. Create Constant
|
12
|
In a worksheet you can select?
a. The entire worksheet b. Rows
c. Columns d. a,
b, and c
|
13
|
The Name box on to the left of formula
bar
a. shows the name of workbook
currently working on
b. shows the name of worksheet currently working on c. shows the name of cell or range currently working on d. None of above |
14
|
Each excel file is a workbook that
contains different sheets. Which of the following can not be a sheet in
workbook?
a. work sheet b. chart sheet
c. module sheet d. data sheet |
15
|
Which of the following is not the
correct method of editing the cell content?
a. Press the Alt key b. Press the F2 key
c. Click the formula bar d. Double click the cell |
16
|
The multiplication arithmetic operator is represented by which
of the following symbols?
a. ^ b. *
c. / d. X
|
17
|
How can you update the values of
formula cells if Auto Calculate mode of Excel is disabled?
a. F8 b. F9
c. F10 d. F11 |
18
|
To
access the Go To Special feature, you can press
a. Ctrl + G b. Ctrl + O
c. Ctrl + Shift + G d. Ctrl + 1
|
19
|
“Qtr
1, Qtr 2, Qtr 3” is an example of a
a. Formula b. Function c. Series d. Syntax |
20
|
What happens when you press after selecting
some cells in Excel?
a. The cell content of selected
cells disappear from cell and stored in clipboard
b. The cells selected are marked for cutting c. The selected cells are deleted and the cells are shifted left d. The selected cells are deleted and cells are shifted up |
21
|
You can auto fit the width of column
by
a. Double clicking on the column
name on column header
b. Double click on the cell pointer in worksheet c. Double clicking on column right border on column header d. Double clicking on the column left border of column header |
22
|
MS Excel provides the default
value for step in Fill Series dialog box
a. 0 b. 1
c. 5 d. 10 |
23
|
Ctrl + D shortcut key in Excel will
a. Open the font dialog box
b. Apply double underline for the active cell c. Fill down in the selection d. None of above |
24
|
The short cut key Ctrl + R is used in
Excel to
a. Right align the content of
cell
b. Remove the cell contents of selected cells c. Fill the selection with active cells to the right d. None of above |
25
|
Which of the following series type is
not valid for Fill Series dialog box?
a. Linear b. Growth
c. Autofill d. Time |
Answers
1-b
|
2-a
|
3-a
|
4-d
|
5-a
|
6-c
|
7-a
|
8-d
|
9-d
|
10-b
|
11-b
|
12-d
|
13-c
|
14-d
|
15-a
|
16-b
|
17-b
|
18-a
|
19-c
|
20-a
|
21-c
|
22-b
|
23-c
|
24-c
|
25-d
|
0 comments:
Post a Comment