WorksheetsMS Excel - Day 04
Total questions: 10
Worksheet time: 5mins
Which of the following is the default numbers of worksheet in MS Excel?
2
3
4
5
What is the output of the following?
=INT(-23.6)
-24
-23
-22
-25
What is the output of the following?
=MOD(-14, 5)
2
-1
1
None of the mentioned
Which of the following formula is used to create a random number between 34 and 50
=RANDBETWEEN(34,51)
=RANDBETWEEN(35,51)
=RANDBETWEEN(35,50)
=RANDBETWEEN(34,50)
What is the output of the following?
=ROUND(23.3, -3)
1
0
2
None of the mentioned
What is the output of the following? Assume B1 has a value 8
=SUM("23",13, B1, FALSE)
21
13
44
ERROR
Which among the following is an absolute referencing?
A1
D5
$C$2
None of the mentioned
What will be the output of the following?
=23&2
25
21
ERROR
232
What is the correct order of precedence of the following operators?
=, *, ^, &
=, *, ^, &
^, *, &, =
+, &, *, ^
&, ^, *, =
What will the output of the following formula if A2=9?
=IF(A2>10, "RIGHT", "WRONG")
WRONG
RIGHT
ERROR
None of the mentioned
