MS Excel - Day 04

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