Upper Sec Functions #1

Which of the following cannot be the output:

=randbetween(0,5)

• 10

• 1

• 0

• 3

Which of the following is correct output:

=left("Success", 2)

• ss

• su

• Su

• Success

Which of the following is correct output:

=right("Functions", 3)

• ons

• sno

• Fun

• ns"

Which of the following is correct output:

=Mid("Singapore", 6, 4)

• Singap

• inga

• pore

• apor

Which of the following is correct output:

=len("Resilience")

• 8

• 9

• 10

• 11

Which of the following is correct output:

=left("Median", -1)

• M

• n

• 0

• #value

• Empty

Which of the following is correct output:

=MODE.SNGL(0, 1, 2, 3, 4, 5, 4, 2, 0, 4, 1)

• 0

• 1

• 2

• 3

• 4

Which of the following is correct output:

=right("CANCEL")

• 0

• #value

• CANCEL

• C

• L

Which of the following is correct output:

=Min(1, 2, 0, 4, 3, 4, 0, -1, 3, 0)

• 0

• 1

• -1

• 3

• 4

Which of the following is correct output:

=Max(1, 2, 0, 4, 3, 4, 0, -1, 3, 0)

• 0

• 1

• -1

• 3

• 4