For Hindi Medium
See answers below
|
Ø-l-
|
iz'u
,oa mRrj fgUnh Hkk"kk
|
|
1
|
5 & 6 uEcj dh jkW LysDV dj Insert->Row
vkWi’ku ij fDyd djus ij D;k
ifjoZru gksxk\
¼v½ 2
jkW tqMsxh jkW ua- 4 ds ckn
¼c½ 2
jkW tqMsxh jkW ua- 5 ds ckn
¼l½ 2
jkW tqMsxh jkW ua- 6 ds ckn
¼n½ 2
jkW tqMsxh jkW ua- 7 ds ckn
|
|
2
|
NOT, AND, OR rFkk XOR gS&
¼v½
ykWftdy vkWijsVjlZ ¼c½
vFkZesfVd vkWijsVjlZ
¼l½
jhys’ku vkWijsVlZ ¼n½
dksbZ ugh
|
|
3
|
vxj fdlh lsy es fcuk QkWjesfVax ,Iykb fd;s 4/6 dks ,UVj fd;k tk;sxk rks ,Dly mls fdl
rjg O;ogkj djsxk\
¼v½
ÝsD’ku ¼cV~Vs½ ¼c½ uEcj
¼l½
VsDlV ¼n½ fnukad
|
|
4
|
vxj A1
lsy es “MCQ” Vkbi
gS rFkk B1 lsy
es “Questions” Vkbi
gS rks bues ls fdl QaD’ku dk fjtYV “MCQ@Questions”
gksxk C1
lsy es
¼v½ =A1 + “@”
+ B1 ¼c½ =A1 # “@” # B1
¼l½ =A1 &
“@” & B1 ¼n½ =A1 $ “@” $ B1
|
|
5
|
,d cMk VsDlV lsUVl fofHkUuk ykbuks es ,d gh
lsy ds vanj dSls Vkbi fd;k tk ldrk gS\
¼v½ ftl
lsy es Vkbi fd;k tk jgk gS mles nwljh ykbu ds fy;s ,UVj nckus ij
¼c½ oMZ
jsi vkWi’ku dk mi;ksx djus ij
¼l½
'kzhad Vw fQV vkWi’ku dk mi;ksx djus ij
¼n½
mijksDr lHkh
|
|
6
|
vxj vkidks VkbVy ykbu ds ckn ,d [kkyh ykbu
pkfg, rks blds fy;s lcls vPNkk vkWi’ku dkSulk gksxk\
¼v½
jh&QkWjesV LiszM’khV ¼c½ ubZ
jkW tksMuk
¼l½
dkWye dh pkSMkbZ c<kuk ¼n½
Lislckj dk mi;ksx djuk
|
|
7
|
vxj vkidks fofHkUu ns’kks ds ukeks dks mudh
tuLka[;k ds fglkc ls vf/kdre ls U;wure ds dze es tekuk gks rks bues ls fdl
vkWMj es vjsat djsxsa\
¼v½
vlsafMx vkWMj ¼c½
fMlsafMx vkWMj
¼l½
,YQkcsfVdy vkWMj ¼n½ jsUMe
vkWMj
|
|
8
|
LizsM’khV esa x.kuk djus ds fy;s bues ls
fdldh vko’;drk gksxh\
¼v½ Vscy ¼c½ QkWjewyk
¼l½ f¶yM ¼n½ osfj;scy
|
|
9
|
pkVZ ij ,d ckWDl es fof’k"V fjdksZM dk
uke gksrk gS mls D;k dgrs gS
¼v½lsy ¼c½ VkbVy
¼l½
,fDll ¼n½ fytsaM
|
|
10
|
jkW dks Nwikus dh D;k 'kkWVZdV dh gS\
¼v½ CTRL + H ¼c½ CTRL + R
¼l½ CTRL + 9 ¼n½ CTRL + –
|
|
11
|
vkius xyrh ls fdlh fjdksZM dks 'khV ij ls
gVk fn;k gS] rc dkSulh dekaM mls rqjar okil yk ldrh gS\
¼v½bUlVZ ¼c½
dkWih ¼l½ vUMw ¼n½
jhIysl
|
|
12
|
tgk¡ jkW vkSj dkWye tqMrs gS] mls D;k dgrs
gS\
¼v½,d
lsy ¼c½ ,d [kaM
¼l½ ,d
ckWDl ¼n½ dksbZ ugh
|
|
13
|
lsy es u;k desaV tksMus dh 'kkWVZdV dh gS\
¼v½ F2 ¼c½ Alt + F2 ¼l½ Ctrl + F2 ¼n½ Shift + F2
|
|
14
|
lsy ,Mªsl dk mnk- gS\
¼v½ 11 25 ¼c½ 911 ¼l½ 41A ¼n½ A21
|
|
15
|
QkWjewyk dk lgh mnkgj.k gS&
¼v½ =A1+A2 ¼c½ =add(A1:A2)
¼l½ A1+A2 ¼n½ SUM(A1:A2)
|
|
16
|
QaD’ku dk lgh mnkgj.k gS&
¼v½
=add(A1:A2) ¼c½ =A1+A2
¼l½ =SUM(A1:A2) ¼n½ A1+A2
|
|
17
|
xq.kk dk fpUg dkSulk gS\
¼v½ > ¼c½ / ¼l½ ! ¼n½ *
|
|
18
|
Hkkx dk fpUg dkSulk gS\
¼v½ / ¼c½ % ¼l½ & ¼n½ #
|
|
19
|
,d QaD’ku ds vanj nwljk QaD’ku gksuk D;k
dgykrk gS\
¼v½
uslVsM QaD’ku ¼c½ jkm.M
QaD’ku
¼l½ le
QaD’ku ¼n½ VsDlV
QaD’ku
|
|
20
|
QkWjesV ls MkbykWx ckWDl es bues ls dksulk
vaMjykbu QaD’ku ugh gksrk\
¼v½ Mcy ¼c½ flaxy vdkamfVax
¼l½ Mcy vdkamfVax ¼n½ flaxy buftfu;fjax
|
|
21
|
,Dly es QkWjewyk fdlds lkFk izkjaHk gksrk
gS\
¼v½ % ¼c½ = l½ + ¼n½ –
|
|
22
|
fMQkWYV #i ls odZ’khV es gsMj gksrk gS&
¼v½ ;wtj
use ¼c½ MsV ,.M Vkbe
¼l½ 'khV
Vsc use ¼n½ dksbZ ugh
|
|
23
|
bues ls dkSulk vkWi’ku LiSfyax MkbykWx es
ugh gksrk gS&
¼v½
bxuksj ¼c½ bxuksj vkWy ¼l½ ,fMV ¼n½
psat
|
|
24
|
bues ls fdlds }kjk lsy es MsVk dks ,UVj ugh
fd;k tk ldrk gS\
¼v½
,Ldsi dh nckus ij ¼c½ ,jks dh
nckus ij
¼l½ VSc
dh nckus ij ¼n½ QkWjewyk
ckj es ,UVj cVu ij fDyd djus ij
|
|
25
|
G2 to M12 lsy jsat ds fy;s lsy jsQjsal D;k gksxk\
¼v½ G2.M12 ¼c½ G2;M12
¼l½ G2:M12 ¼n½ G2-M12
|
For English Medium
|
S.N.
|
Question
& Answer In English Language
|
|
1
|
Selecting
the Rows 5 & 6 then choose Insert->Row What will happen?
a. 2 Rows
will be inserted after Row 4
b. 2 Rows will be inserted after Row 5 c. 2 Rows will be inserted after Row 6 d. 2 Rows will be inserted after Row 7 |
|
2
|
NOT, AND, OR and XOR are
a. Logical
Operators b. Arithmetic
operators
c. Relational operators d. None of the above |
|
3
|
If 4/6 entered in a cell without applying
any formats, Excel will treat this as
a.
Fraction b. Number
c. Text d. Date |
|
4
|
If the values in A1 is “MCQ” and B1 is
“Questions”, which function will return “MCQ@Questions” in cell C1?
a. =A1 +
“@” + B1 b. =A1 # “@” #
B1
c. =A1 & “@” & B1 d. =A1 $ “@” $ B1 |
|
5
|
How to fit long texts in a single cell with
multiple lines?
a. Start
typing in the cell and press the Enter key to start another line
b. Use the Wrap Text option c. Use the Shrink to Fit option d. All of above |
|
6
|
If you want to have a blank line after the
title in a worksheet, what is the best thing for you to do?
a.
Re-format the spreadsheet b.
Insert a row
c. Increase the column width d. Use the spacebar |
|
7
|
In order to arrange the countries from those
with the highest population to those with the lowest, you need to sort on the
population field in ……………
a.
ascending order b.
descending order
c. alphabetical order d. random order |
|
8
|
In order
to perform a calculation in a spreadsheet, you need to use a:
a. table b. formula
c. field d. variable |
|
9
|
The box on
the chart that contains the name of each individual record is called the
________.
a. cell b. title
c. axis d. legend |
|
10
|
1What is
the shortcut key to hide entire row?
a. CTRL +
H b. CTRL + R
c. CTRL + 9 d. CTRL + – |
|
11
|
You
accidentally erased a record in the sheet
What command can be used to restore it immediately?
a. Insert b. Copy c. Undo d. Replace
|
|
12
|
Where a
row and a column meet, what do you call that?
a. A cell b. A block
c. A box d. None of the above |
|
13
|
What is the shortcut key to insert a new
comment in a cell?
a. F2 b. Alt + F2 c. Ctrl + F2 d. Shift + F2
|
|
14
|
Give me an example of a cell address.
a. 11 25 b. 911
c. 41A d.
A21
|
|
15
|
Which is
an example of a formula?
a. =A1+A2 b. =add(A1:A2)
c. A1+A2 d. SUM(A1:A2) |
|
16
|
Which is
an example of a function?
a.
=add(A1:A2) b. =A1+A2
c. =SUM(A1:A2) d. A1+A2 |
|
17
|
What is
the symbol for multiplying?
a. > b. / c. ! d. *
|
|
18
|
What is the symbol for dividing?
a. A ./ b. % c. & d. #
|
|
19
|
A function
inside another function is called _______
a. Nested
function b. Round
function
c. Sum function d. Text function |
|
20
|
Which of
the following is not an underline option in the format cells dialog box?
a. Double b. Single
Accounting
c. Double Accounting d. Single Engineering |
|
21
|
Formulas
in Excel start with
a. %
b. = c. + d. –
|
|
22
|
The
default header for a worksheet is
a.
Username b. Date and
Time
c. Sheet tab Name d. None |
|
23
|
Which of
the following is not an option of the spelling dialog box?
a. Ignore b. Ignore all c. Edit d. Change
|
|
24
|
Which of the following methods will not
enter data in a cell?
a.
Pressing the Esc key b.
Pressing an arrow key
c. Pressing the tab key d. Clicking the enter button to the formula bar |
|
25
|
The cell
reference for cell range of G2 to M12 is _______
a. G2.M12 b. G2;M12
c. G2:M12 d. G2-M12 |
Answers
|
1 – a
|
2 – a
|
3 – d
|
4 – c
|
5 – b
|
6 – b
|
7 – b
|
8 – b
|
9 – d
|
10 – c
|
|
11 – c
|
12 – a
|
13 – d
|
14 – d
|
15 – a
|
16 – c
|
17 – d
|
18 – a
|
19 – a
|
20 – d
|
|
21 – b
|
22 – d
|
23 – c
|
24 – a
|
25 – c
|
0 comments:
Post a Comment