For Hindi Medium
See answers below
|
26
|
lsy jsat dks lysDV dj pkVZ cukus dk 'kkWVZdV
D;k gS\
¼v½ F2 ¼c½ F4
¼l½ F8 ¼n½ F11
|
|
27
|
ftl lkW¶Vos;j es jkW vkSj dkWye 'kkfey gksrs
gS mls D;k dgrs gS\
¼v½
MsVkcsl ¼c½ MªkWbax
¼l½
LizsM’khV ¼n½ oMZ
izkslsflax
|
|
28
|
fdl vkWi’ku ds }kjk usxsfVo osY;wl cksYM dh
tk ldrh gS lysDVsM lsy jsat es ls\
¼v½
thjks QkWjesfVax ¼c½ daMh’kuy
QkWjesfVax
¼l½
dEis;j QkWjesfVax ¼n½ usxsfVo
QkWjesfVax
|
|
29
|
orZeku odZ’khV es ubZ 'khV tksMus dh D;k
'kkWVZdV dh gS\
¼v½ F11 ¼c½ Alt + F11
¼l½ Ctrl + F11 ¼n½ Shift + F11
|
|
30
|
fuEu ls dkSulk lgh gS\
¼v½ =AVERAGE(4,
5, 6, 7) ¼c½ =AVERAGE(A1, B1, C1)
¼l½ =AVERAGE(A1:A9,
B1:B9) ¼n½ mijksDr lHkh
|
|
31
|
fuEu es ls dkSulk QaD’ku dk fjtYV 8 gksxk
gksxk\
¼v½ =
ROUNDUP(8.4999, 0)
¼c½ =
ROUNDDOWN(8.4999, 0)
¼l½ =
ROUND(8.4999, 0)
¼n½ ch o
lh nksuks
|
|
32
|
bues ls dkSulk vkWi’ku ,Dly 2007 es vaafre
dkWye dk gsMj gksrk gS\
¼v½ XFD ¼c½ XFX
¼l½ XFL ¼n½ XFT
|
|
33
|
U;w desaV vkWi’ku fdl VSc ds vanj gksrk gS\
¼v½
bUlVZ ¼c½ MkVk
¼l½
fjO;w ¼n½ O;w
|
|
34
|
cV~Vk Vkbi djus ls igys D;k tksMk tkuk
pkfg;s rkfd og fdlh MsV es psat uk gks tk;s\
¼v½ // ¼c½ FR
¼l½ Zero ¼n½ Zero Space
|
|
35
|
bues ls dkSulk QaD’ku fdlh lhjht es ls lcls
cMk uEcj fudkyus ds mi;ksx es vkrk gS\
¼v½ MAX(B1:B3) ¼c½ MAXIMUM (B1:B3)
¼l½ HIGH
(B1:B3) ¼n½ HIGHEST(B1:B3)
|
|
36
|
NOW() QaD’ku dk fjtYV D;k gksrk gS\
¼v½ orZeku MsV rFkk VkbZe crkus ds fy;s
¼c½
orZeku MsV crkus ds fy;s
¼l½
orZeku VkbZe crkus ds fy;s
¼n½
dksbZ ugh
|
|
37
|
= “$55.00″+5 bl Qkjewyk dks lsy es ,UVj djus ij D;k fjtYV vk;sxk\
¼v½ $60 ¼c½ 60
¼l½ “$55.00″+5 ¼n½ $60.00
|
|
38
|
odZ’khV es orZeku MsV ,.M VkbZe tksMus dh
D;k 'kkWVZdV dh gksrh gS\
¼v½ CTRL + D ¼c½ CTRL + T
¼l½ CTRL + ; ¼n½ CTRL + /
|
|
39
|
SUM QaD’ku ds laca/k es bues ls dkSulk flUVsDl lgh gS\
¼v½ =SUM (A1,
B1) ¼c½ =SUM (A1:B9)
¼l½ =SUM
(A1:A9, B1:B9) ¼n½ mijksDr
lHkh
|
|
40
|
dkWye dks Nqikus dh D;k 'kkWVZdV dh gksrh
gS\
¼v½ CTRL + − ¼c½ CTRL + 0
¼l½ CTRL + H ¼n½ CTRL + C
|
|
41
|
A9 to A99 lsy jsat dks ,Dlsy es dSls fu/kkZfjr ¼lysDV½ djsxsa\
¼v½ (A9, A99) ¼c½ (A9 to A99)
¼l½ (A9 : A99) ¼n½ (A9 – A99)
|
|
42
|
G & H dkWye dks lysDV djus ds ckn bUlVZ > dkWye dk pquko djus ij bues ls
D;k gksx\
¼v½ 2
dkWye tqMsxsa dkWye ,Q ds ckn
¼c½ 2
dkWye tqMsxsa dkWye th ds ckn
¼l½ 2
dkWye tqMsxsa dkWye ,p ds ckn
¼n½ 2
dkWye tqMsxsa dkWye vkbZ ds ckn
|
|
43
|
,Dly es fMQkWYV #i ls U;wesfjd osY;w fdl
vykbuesaV es fn[kkbZ nsrh gS\
¼v½ ys¶V
vykbuesaV ¼c½ jkbV vykbuesaV
¼l½
lsaVj vykbuesaV ¼n½ tLVhQkbZ
vykbuesaV
|
|
44
|
dh&cksMZ ls fMfyV dh izsl djus ij D;k
Dyh;j ¼gVsxk½ gksxk\
¼v½
VsDlV ¼c½ QkWjesV
¼l½
daVsUV ¼n½ daVsUV
rFkk QkWjesV nksuks
|
|
45
|
,d gh lsy es ugh ykbu tksMus ds fy;s bues ls
dkSulk 'kkWVdV mi;ksx es fy;k tk;sxk\
¼v½ Enter ¼c½ Alt + Enter
¼l½ Ctrl +
Enter ¼n½ Shift + Enter
|
|
46
|
vxj vki C1lsy
esa =A1=B1 Vkbi
djrs gS rks es D;k fjtYV fn[kkbZ nsxk\
¼v½ Yes or No ¼c½ True or False
¼l½ Value of
A1 ¼n½ Value of B1
|
|
47
|
,Dly es bues es fdl rjg dk QkWjewyk ugh gS\
¼v½
VsDlV dkWUlVsUV ¼c½ uEcj
dkWUlVsUV
¼l½
ldZ;wYkj jsQjsUl ¼n½ mijksDr lHkh
|
|
48
|
fdl QaD’ku ds }kjk ,e ,l ,Dly es orZeku
fnukad rFkk le; dks iznf’kZr fd;k tk ldrk gS\
¼v½ date () ¼c½ Today ()
¼l½ now () ¼n½ time ()
|
|
49
|
,Dly es
bues ls dkSulk lgh flUVsDl gS\
¼v½ =IF(LogicalTest,
TrueResult, FalseResult)
¼c½ =IF(LogicalTest, (TrueResult, FalseResult))
¼l½ =IF(LogicalTest,
TrueResult) (LogicalTest, FalseResult)
¼n½ =IF(LogicalTest,
TrueResult), IF(LogicalTest, FalseResult)
|
|
50
|
bues ls dkSulk QkWjewyk lgh gS\
¼v½ =POWER(2^3) ¼c½ =POWER(2,3)
¼l½ =POWER(2#3) ¼n½ =POWER(2*3)
|
For English Medium
|
26
|
What is
the keyboard shortcut for creating a chart from the selected cell range?
a. F2 b. F4
c. F8 d. F11 |
|
27
|
The Software which contains rows and columns
is called ______
a.
Database b.
Drawing
c. Spreadsheet d. Word processing |
|
28
|
Which option allows you to Bold all the
negative values within the selected cell range:
a. Zero Formatting b. Conditional
Formatting
c. Compare Formatting d. Negative Formatting |
|
29
|
What is the shortcut key to insert new sheet
in current workbook?
a. F11 b. Alt + F11
c. Ctrl + F11 d. Shift + F11 |
|
30
|
Which of the following is correct?
a.
=AVERAGE(4, 5, 6, 7) b.
=AVERAGE(A1, B1, C1)
c. =AVERAGE(A1:A9, B1:B9) d. =All of the above |
|
31
|
Which of the following function will return
a value of 8?
a.
ROUNDUP(8.4999, 0)
b. ROUNDDOWN(8.4999, 0) c. ROUND(8.4999, 0) d. Only B and C |
|
32
|
Which one is the last column header in Excel
2007?
a. XFD b. XFX
c. XFL d. XFT |
|
33
|
“New Comment” option can be found under
_________ tab
a. Insert b. Data
c. Review d. View |
|
34
|
What should be add before a fraction to
avoid entering it as a date?
a. // b. FR
c. Zero d. Zero Space |
|
35
|
Which of the following function will use to
find the highest number in a series of number?
a.
MAX(B1:B3) b. MAXIMUM
(B1:B3)
c. HIGH (B1:B3) d. HIGHEST(B1:B3) |
|
36
|
What does the NOW() function return?
a. It
returns the serial number of the current date and time
b. It returns the serial number of the current date c. It returns the serial number of the current time d. None of the above |
|
37
|
What value will display if the formula =
“$55.00″+5 is entered into a cell?
a. $60 b. 60
c. “$55.00″+5 d. $60.00 |
|
38
|
What is the shortcut key to insert current
date in a cell?
a. CTRL +
D b. CTRL + T
c. CTRL + ; d. CTRL + / |
|
39
|
Which
of the following syntax is correct regarding to SUM function in Excel?
a. =SUM
(A1, B1) b. =SUM
(A1:B9)
c. =SUM (A1:A9, B1:B9) d. All of the above |
|
40
|
What is the shortcut key to hide entire
column?
a. CTRL +
− b. CTRL +
0
c. CTRL + H d. CTRL + C |
|
41
|
How to specify cell range from A9 to A99 in
Excel?
a. (A9,
A99) b. (A9 to A99)
c. (A9 : A99) d. (A9 – A99) |
|
42
|
Selecting
the Column G & H then choose Insert->ColumnWhat will happen?
a. 2
Columns will be inserted after Column F
b. 2 Columns will be inserted after Column G c. 2 Columns will be inserted after Column H d. 2 Columns will be inserted after Column I |
|
43
|
In Excel,
by default Numeric Values appears in
a. Left
aligned b. Right aligned
c. Center aligned d. Justify aligned |
|
44
|
Clear the contents by pressing “DELETE” key
from a keyboard will clear
a. Text
Only b. Format
Only
c. Contents Only d. Both Contents and Format |
|
45
|
Which of
the following shortcuts can be used to insert a new line in the same cell?
a. Enter b. Alt +
Enter
c. Ctrl + Enter d. Shift + Enter |
|
46
|
What will be the result if you type =A1=B1
in cell C1?
a. Yes or
No b. True or
False
c. Value of A1 d. Value of B1 |
|
47
|
In Excel _______ may not contain in Formula
a. Text
Constant b. Number
Constant
c. Circular Reference d. All of them |
|
48
|
How do you
display current date only in MS Excel?
a. date () b. Today ()
c. now () d. time () |
|
49
|
Which of the following is correct syntax in
Excel?
a.
=IF(LogicalTest, TrueResult, FalseResult)
b. =IF(LogicalTest, (TrueResult, FalseResult)) c. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) d. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult) |
|
50
|
Which of
the following is correct?
a.
=POWER(2^3) b.
=POWER(2,3)
c. =POWER(2#3) d. =POWER(2*3) |
Answers
|
26 – d
|
27 – c
|
28 – b
|
29 – d
|
30 – d
|
|
31 – d
|
32 – a
|
33 – c
|
34 – d
|
35 – a
|
36 – d
|
37 – b
|
38 – c
|
39 – d
|
40 – b
|
|
41 – c
|
42 – a
|
43 – b
|
44 – c
|
45 – b
|
46 – b
|
47 – c
|
48 – c
|
49 – a
|
50 – b
|
0 comments:
Post a Comment